Need help in this

Question

con.Open();

dr = null;

SqlCommand cmd = new SqlCommand("SELECT @@IDENTITY", con);

dr = cmd.ExecuteReader();

while (dr.Read())

try

{

LBL.Text = (dr["ID"].ToString());

}

I have an error in the red line say
System.IndexOutOfRangeException: DeliveryID
I want to get the new database that just add in on to this page

Tan Kai Kai · Answer

can you give me a exp for it?

Iftikar Hussain · Answer

Yes you can create one new stored procedure instead of using normal sql query. You can read the id the value in your page as like string id=Request.QueryString[Id] read this article for calling stored procedure from your VS http://stackoverflow.com/questions/7836766/calling-a-stored-procedure-with-asp-net http://support.microsoft.com/kb/306574 Regards Iftikar

Tan Kai Kai · Answer

Need some tip for SQL in VS

Tan Kai Kai · Answer

So I have to remove the old table and remake? Plus I using SQL IN the VS so got other way then how to take the id from here Response.Redirect(YourNextPage.aspx?Id= + id.ToString());

Iftikar Hussain · Answer

First you create one stored procedure like this CREATE PROCEDURE [dbo].[usp_InsertDeliveryDetails] ( @Name varchar(40) @Email varchar(100) @Handphone varchar(40) ) AS SET NOCOUNT ON DECLARE @Id datetime INSERT INTO Delivery (NameEmailHandphone) VALUES (@Name @Email @Handphone) SET @Id=@@IDENTITY SELECT @Id as Id SET NOCOUNT OFF Then in your code do like this cmd = new SqlCommand( usp_InsertDeliveryDetails ) cmd.CommandType= CommandType.StoredProcedure cmd.Connection = con; cmd.Parameters.AddWithValue(@Name TxtBoxFName.Text); cmd.Parameters.AddWithValue(@Email TxtBoxEmail.Text); cmd.Parameters.AddWithValue(@ Handphone  TxtBoxHandphone.Text); int id=Convert.ToIn32(cmd.ExecuteScalar()); use this id in next page as query string like Response.Redirect(YourNextPage.aspx?Id= + id.ToString()); Regards Iftikar

Tan Kai Kai · Answer

cmd = new SqlCommand(INSERT INTO [Delivery] (NameEmailHandphone) VALUES (@Name @Email @Handphone) cmd.Connection = con; cmd.Parameters.AddWithValue(@Name TxtBoxFName.Text); cmd.Parameters.AddWithValue(@Email TxtBoxEmail.Text); cmd.Parameters.AddWithValue(@ Handphone  TxtBoxHandphone.Text); I want to get all this plus I want to get ID for the new insert into the table in other page

Iftikar Hussain · Answer

Yes you can do this in your insert sp. can you share your insert sp? Regards Iftikar

Tan Kai Kai · Answer

Is there any way to take the id from the data that just insert in database as I have do a insert and go to next page I want to session or take the ID of the data that just add in to the table

Riyaz Akhtar · Answer

use below code before assigning itno label if (dr[ID] != DBNull.Value) LBL.Text = dr[ ID ].ToString();

Riyaz Akhtar · Answer

Give alias in ur select statement: SqlCommand cmd = new SqlCommand(SELECT @@IDENTITY as ID  con);

Kunal Vaishya · Answer

Try this also if (dr[0] != DBNull.Value) LBL.Text = dr[0].ToString(); else LBL.Text = ;

Vulpes · Answer

In your original code try replacing: LBL.Text = (dr[ID].ToString()); with: if (!dr.IsDBNull(0)) LBL.Text = dr[0].ToString(); else LBL.Text = ;

Iftikar Hussain · Answer

what error you are getting? before that when you are trying to call this query. I believe you have insert query before that. Regards Iftikar

Tan Kai Kai · Answer

I have an error on this int result=Convert.ToInt32(data);

Iftikar Hussain · Answer

Hi You should try like this con.Open(); SqlCommand cmd = new SqlCommand(SELECT @@IDENTITY con); object data= cmd.ExecuteScalar(); con.Close(); if( data!=null) int result=Convert.ToInt32( data); } Let me know if you need any more help. Regards Iftikar