I've got a MS SQL (Express) database. its quite complex and uses a lot of tables. Is there a way to generate a SQL script for creating the complete database, but not the content of it.
I like to copy the database. Right now i copy the database. After that i need manually to clear all fields. There are also some relationships, so its a lot of work to clear all of it manually.
I am having a field called Semester, i will enter it as 1 initially. Then it should automatically increase 1 semester every six months till sixth semester in the database (sql server 2005) is it possible?
View 5 RepliesI am generating a unique Ref number using this sql statement: SELECT REPLACE(STR(CAST(CAST(NEWID() AS binary(5)) AS bigint),12),0,0) as REF Subsequently, I need to insert this REF into sql database table in stored procedure. Here is what I did in my stored procedure:
USE [iBankRecords]
GO
/****** Object: StoredProcedure [dbo].[stp_addPayee] Script Date: 07/05/2010 21:57:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[stp_addPayee]
(
@CUSTID char(10),
@PAYEEACCNUM nvarchar(20),
@PAYEEACCTYPE char(10) ,
@PAYEENAME char(20),
@PAYERINITIAL char(20),
)
AS
DECLARE
@ReturnValue int
INSERT INTO PAYEE (CUSTID, PAYEEACCNUM,PAYEEACCTYPE,PAYEENAME,PAYERINITIAL, REF)
VALUES (@CUSTID,@PAYEEACCNUM,@PAYEEACCTYPE,@PAYEENAME,@PAYERINITIAL, REF)
IF @@ERROR<>0
BEGIN
PRINT 'ERROR'
SET @ReturnValue=1
RETURN @RETURNVALUE
END
ELSE
BEGIN
SET @ReturnValue=0
RETURN @RETURNVALUE
END
May I know how do I have generating a unique ref num and inserting the REF into the above statement?
Never really worked with the asp tables but for this project it makes more sense, I am having trouble addding rows dynamically from the sql datatable i am pulling. In hte datatable it has 12 rows with 14 columns, I need to make this into a table, with a dtagrid I would be done but I have to pull other data that they could add columns, so a table I am told is easier.
This gets my data and I can see it
mydataTable = new DataTable
mydataTable = GetData(sql)
mydataTable.add.row(myDataTable.rows(0)(0))
I get nothing but errors trying to do this, what is the correct way to add rows to an asp.net table
Can I add this all to a datagrid and then add the extra columns I need if they are there with out using a table.
If I have a DataTable (in-memory) read by my C# program from a flat file, and I want to create it as a new table in a SQL Server database... what is the simplest way to do that?
It seems like something like SqlBulkCopy with an option to create a new destination SQL server table would be on my line of thinking, but I dont see a way.
Ok, I have some experience, but I have always started with something and moved on from there.
I want to create a ASP.net Project in MSVC 2008 with the following...
- SQL 2005 database that I can use MSQL Server Management Studio with
- Forms authentication
- Authentication/roles etc is stored in the above database
So far every attempt has resulted in a database that when I attach with MSQL Management Studio I am logged in as guest, and thus can't do much.
I have a stored procedure returned a row of data which are written in business layer logics in ASP .net C#. If I bind the data in grid view, I can read the specific cell values from the grid. However, I don't want the grid view visible to the users.
If possible, no data display at all. I only need to save two cell values into variables. how to complete the getProfileValues() function?
[code]....
I am trying to get a complete list of users and display them in a dropdownlist from two groupos,
[Code]...
Actually I'm not a professional in ASP.NET. I'm going a project that needs to support two languages (Russian and English).I've already completed the main parts and the site is now 95% functional.However, now I need to enable language selection on the site.
I'm going to do it with DropDownList, where a user chooses one language from DropDownList, the content must change to particular language.
All texts are displayed using server controls like Labels and Literals. Links are in Hyperlink or LinkButton.
I did some research to handle with my condition, but no-one suits on my condition, because I've almost completed the application. How to generate Global Recourse files for controls on the page?
This is my first time using autocomplete. I have everything up and running, but I want to return a list of more relevent keywords or phrases from my full text catalog, or the table that I search against. I have no idea where to start as far as my getcompletionlist goes.
So If I type in knee
a list appears
kneepads
here's my getCompletionList
Public Function GetCompletionList(ByVal prefixText As String, ByVal count As Integer) As String()
Dim items As New List(Of String)
Dim myConnectionString As String
myConnectionString = GetSQLConnString()
Dim mySelectQuery As String = "SELECT ShortDescription FROM ProductInfo WHERE FREETEXT(ShortDescription, @prefixText) OR FREETEXT(LongDescription, @prefixText) OR FREETEXT(ProductHTML, @prefixText) OR FREETEXT(PartNumber, @prefixText) ORDER BY RANK()
OVER (Order BY PartNumber, ShortDescription, LongDescription)"
[Code]....
I am trying to generate a Grid view from database, in one of my database columns the values are 'y' and 'N'. and i need to show this values in a check box .I tried to keep a check box in item template and tried to bind it, but could get much success.
[Code]....
i am trying to create connection using OLEDB connection in my app. but i am not able to create the connection as in datasource i want to use Server.mappath, but cudn't find the right method to use it. i am trying to make connection with Access database file. following is code i have tried:
string path = Server.MapPath("~/uploadaccess/Production.mdb");
string ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("~/uploadaccess/Production.mdb")&";";
and also
OleDbConnection myConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & path&";");
and tried this
OleDbConnection myConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("~/uploadaccess/Production.mdb"));
and this is the error i am getting:
Operator '&' cannot be applied to operands of type 'string' and 'string'
I have this query to generate sql row to XML Mode.
[Code]....
I want the result is like this:
[Code]....
i have a need to generate JSONP using MVC 2 for a 3rd party App...It seems there is no actionresult for this OOTB in MVC 2 so i need to create a custom one..i found the following article on such here; [URL] My first question is...Where do i put the custom actionresult code? Secondly...How can i use this to new JSONP actionresult to return data from my data model? Currently , my current JSON actionresult (remember..i need JSONP) looks like this;
[Code]....
How can i use the new JSONP Actionresult to return db.GetTopGainers()?
I really need to create ID like this. But I don't know how use this Procedure .If you don't mind can you explain to me step by step how to use to procedure for create auto ID in database. (Should I call to this Procedure from somewhere else, like webpage button or something)
View 4 RepliesI am working with a set of data that looks something like the following.
[Code]....
The name and number of assignments, I need to get results simlilar to the following.
[Code]....
How to generate script from a database with its data? I tried it, but it was not generated with data.
View 13 RepliesI am using xsd /c book.xsd to generate the a cs file. THe default cs file will be book.cs. I am wondering what swtich I can add so that i can name the generated cs file as document.cs instead of the default one. I attached the book/xsd and book.cs file, I am wondering why it generated two partial class? Should i name the generated file to match one of the partial class like BookForm.cs?
book.xsd:
[Code]....
Book.cs:
[Code]....
i have a table called attedance, where employee's daily attendance status is maintained.. they need to login and enter the checkin for their presence.. I finished all these task but what the need is, if the employee didnt checkin for all the whole day, i have to generate absent in the database at the end of day or while next login of the employee..
Is it possible to generate absence status if he not login for whole day? At the end of the day around 6.00 pm it have to generate absence in the db..
How can I generate a script which contains all database tables, stored procedures, data, and etc. ? So that I can
use this script to create a database on the new server.
I am using MS SQL 2005.
object og = GridView_EmployeeTimeSheet.DataSource;
System.Data.DataTable dt = new System.Data.DataTable();
dt = (System.Data.DataTable)og;
But getting null in og(object) and at run time Gridview is showing its required data...
I am creating a attendance database table in sql server2005.. i just want to generate the gridview as follows in form.aspx.. i am using vb.net generate the report in gridview..
Attendance table
employee name(varchar)- Its contain all the employees name
date(datetime)-Its contain dates
status(varchar)-Its contain the status of employee whether they are Present or Absent
I just need all the employee name (data) in one rows and dates in columns.. also i need the status of the employees inside this.. whether they are absent or present.
I have decided to use the Ajax Auto complete extender with a database, i found some cool articles on google to do this, but i cannot get it to work, I am trying a simple example where i have 1 textbox and i am trying to obtain products from the products table in the northwind database, heres my code (its not working)
[Code]....
WEBSERVICE
[Code]....
in generate the Stored Procedures when using Create TableAdapter configuration Wizard in VS.it can not generate the Stored Procedures for Delete and Update Commands, but it generated for Select and Insert. i tried many times, but still get the same problem.
View 2 RepliesI'm having some issues trying to create and setup a database to use for a project. I have SQLExpress running in the background, but I figure that's from my old Visual Web Developer 2008 Express. I have MS SQL Server 2008, but it doesn't look like it's installed. I'm guessing I need to manually install it before trying to add databases/tables.
View 1 Replies