AUTOGENARATE

Question

if the identity is set to true then it autogenarate the field value. how to get that value in a dropdownlist in c#.net. plz help me.

Jignesh Trivedi · Answer

hi try following code. SqlConnection con = new SqlConnection(your connectionstring); SqlCommand command = new SqlCommand(); command.CommandType = CommandType.Text; // write your query instead of my department master query. command.CommandText = Insert into DepartmentMaster values('newName''new decription');select @id = SCOPE_IDENTITY(); command.Connection = con; con.Open(); command.Parameters.Add(@id DbType.Int32).Direction = ParameterDirection.Output; int res = command.ExecuteNonQuery(); var newValue = command.Parameters[@id].Value; con.Close(); hope this will help you.

Jignesh Trivedi · Answer

hi yes to avoid SQL injection use stored procedure or parameterized query.

ipsita pani · Answer

well it works finebut in the insert button we have tto pass the parameterized queriesbcz concatenation introduces sql injection. thanks.

Sreejesh SP · Answer

Dear Pani try following code. SqlConnection con = new SqlConnection(your connectionstring); SqlCommand command = new SqlCommand(); command.CommandType = CommandType.Text; command.CommandText = Insert into DepartmentMaster values('newName''new decription');set @id = @@IDENTITY; command.Connection = con; con.Open(); command.Parameters.Add(@id DbType.Int32).Direction = ParameterDirection.Output; int res = command.ExecuteNonQuery(); var newValue = command.Parameters[@id].Value; con.Close(); thanks Sreejesh

Satyapriya Nayak · Answer

Untitled Page Width=100px> Text=Insert Data /> using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; namespace Dynamic_increment_using_Dropdown { public partial class _Default : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; string str; SqlCommand com; int count; protected void Page_Load(object sender EventArgs e) { if (!IsPostBack) { DropDownList1.Items.Add(Select); SqlConnection con = new SqlConnection(strConnString); str = select count(*) from employee; com = new SqlCommand(str con); con.Open(); count = Convert.ToInt16(com.ExecuteScalar()) + 1; DropDownList1.Items.Add(count); con.Close(); } } protected void btn_insert_Click(object sender EventArgs e) { SqlConnection con = new SqlConnection(strConnString); con.Open(); str = insert into employee values(' + DropDownList1.SelectedItem.Text.Trim() + '' + txt_empname.Text.Trim() + ' + txt_sal.Text.Trim() + ); com = new SqlCommand(str con); com.ExecuteNonQuery(); con.Close(); Label4.Text = Records successfully Inserted; } } }