Need help in this

Tan Kai Kai

13y1.6k.NET

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

15 Replies

Know the answer? Post it — somebody with the same question will find it here.

Tan Kai Kai13y ago
can you give me a exp for it?
Iftikar Hussain13y ago
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 Kai13y ago
Need some tip for SQL in VS
Tan Kai Kai13y ago
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 Hussain13y ago
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 (Name,Email,Handphone) 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 Kai13y ago
cmd = new SqlCommand("INSERT INTO [Delivery] (Name,Email,Handphone) 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 Hussain13y ago
Yes, you can do this in your insert sp. can you share your insert sp?

Regards,
Iftikar
Tan Kai Kai13y ago
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 Akhtar13y ago
use below code before assigning itno label

if (dr["ID"] != DBNull.Value)
LBL.Text = dr["ID"].ToString();
Riyaz Akhtar13y ago
Give alias in ur select statement:

SqlCommand cmd = new SqlCommand("SELECT @@IDENTITY as ID", con);
Kunal Vaishya13y ago
Try this also

if (dr[0] != DBNull.Value)
LBL.Text = dr[0].ToString();
else
LBL.Text = "";
Vulpes13y ago
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 Hussain13y ago
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 Kai13y ago
I have an error on this int result=Convert.ToInt32(data);
Iftikar Hussain13y ago
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