below i copied the whole code. (i cut down some irrelevant code to save the space)


================================================== ====================================


<%@ Page Language="C#" ContentType="text/html" debug="true" ResponseEncoding="utf-8" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>

<script language="C#" runat="server" >
SqlConnection objConnection = null;
SqlCommand objCmd = null;
int Identity;

void Page_Load()
{
// make connection string

String strSQL;
String strConnection = "user id=XXX;password=YYY;";
strConnection += "initial catalog=ZZZ;server=XYZ;";

objConnection = new SqlConnection(strConnection);
objConnection.Open();

DataSet ds = new DataSet();
SqlDataAdapter daStates = new SqlDataAdapter("SELECT * FROM states ORDER BY stateName;", objConnection);
daStates.Fill(ds, "states");
stateList.DataSource = ds.Tables["states"];
stateList.DataBind();

}


private void Insert1(object sender, EventArgs e)
{

// set the SQL string
string strSQL = "INSERT INTO DCConfPerson ( " +
                         "firstName, middleName, lastName, " +
                         "address1, address2, city, state, zip, " +
                         "homePhone, mobilePhone, otherPhone) " +
                "VALUES (" +
                          firstName.Text + "', '" +
                          middleName.Text + "', '" +
                          lastName.Text + "', '" +
                          title.Text + "', '" +
                          address1.Text + "', '" +
                          address2.Text + "', '" +
                          city.Text + "', '" +
                          stateList.SelectedItem + "', '" +
                          zip.Text + "', '" +
                          homePhone.Text + "', '" +
                          mobilePhone.Text + "', '" +
                          otherPhone.Text + ");" +
                "SELECT @@IDENTITY AS 'Identity';";

// Create the Command and set its properties
SqlCommand objCmd = new SqlCommand(strSQL, objConnection);

// save Identity in a cookie
HttpCookie RegCookie = new HttpCookie("NewId");
RegCookie.Value = Convert.ToString(Identity);
Response.Cookies.Add(RegCookie);

// execute the command
objCmd.ExecuteNonQuery();

if (objConnection.State == ConnectionState.Open);
objConnection.Close();

Response.Redirect("register2.aspx");

}


</script>

ok, well now I know why I am so confused... Your doing c# and I am thinking vb.net..

You have a line

convert.tostring(identity);

However, you never populate identity. You execute the sql command.. but you never take the results of the select and use it.. Imagine when you do a select from a database- you need to look at the result set and pull the data. Sicne I am not good at c# I can't tell you the exact code you need- but you need to get identity after you do you SqlCommand.

Hal Levy
Daddyshome, LLC

instead of using
   "SELECT @@IDENTITY AS 'Identity';";

i used

=================================================

    "SELECT @Identity = @@IDENTITY;";


        // Create the Command and set its properties
        SqlCommand objCmd = new SqlCommand(strSQL, objConnection);

        SqlParameter objOutputParameter =
            new SqlParameter ("@Identity", SqlDbType.Int);
        objCmd.Parameters.Add(objOutputParameter);
        objOutputParameter.Direction = ParameterDirection.Output;
        objCmd.ExecuteReader();
================================================== ===

but i was still unable to get the @@IDENTITY

can anyone help?

Hi gumgak,

Your code was almost correct:

strSQL = "SELECT @@IDENTITY AS 'Identity';";
SqlCommand objCmd = new SqlCommand(strSQL, objConnection);
SqlDataReader dr = objCmd.ExecuteReader();
dr.Read();
int id = Int32.Parse(dr.GetValue(0).ToString());
dr.Close();

Regards,
Khoa Nguyen