I am using this code to insert a record in my table where i have assigned a guid datatype field to generate an automatic guid for each record. but now i need to retrieve the guid to use it to send a confirmation email to the user.
SqlConnection sql_connection = new SqlConnection("Server=xxx.xxx.xx.xxx;uid=xxxxxxxx;password=xxxxxxx;database=xxxxxxx;");
SqlCommand sql_command = new SqlCommand("INSERT INTO members (member_sex, member_cpr, member_nationality, member_block, member_gov, member_daaera, member_email, member_mobile, member_created_ip) Values (@member_sex, @member_cpr, @member_nationality, @member_block, @member_gov, @member_daaera, @member_email, @member_mobile, @member_created_ip)", sql_connection);
sql_command.Parameters.Add(new SqlParameter("@member_sex", Session["member_sex"].ToString()));
sql_command.Parameters.Add(new SqlParameter("@member_cpr", Session["member_cpr"]));
sql_command.Parameters.Add(new SqlParameter("@member_nationality", Session["member_nationality"].ToString()));
sql_command.Parameters.Add(new SqlParameter("@member_block", Session["member_block"].ToString()));
sql_command.Parameters.Add(new SqlParameter("@member_gov", "GOV"));
sql_command.Parameters.Add(new SqlParameter("@member_daaera", 6));
sql_command.Parameters.Add(new SqlParameter("@member_email", Session["member_email"].ToString().ToLower()));
sql_command.Parameters.Add(new SqlParameter("@member_mobile", Session["member_mobile"].ToString()));
sql_command.Parameters.Add(new SqlParameter("@member_created_ip", Request.UserHostAddress.ToString()));
sql_connection.Open();
sql_command.ExecuteNonQuery();
sql_connection.Close();