Sql Data Srouce Control Inserting Data Into Database

Apr 30, 2008 in ADO.NET • ASP.NET • C#
1 min read

hey guyz how are you ??

Me back with my sqldatasource series. Today i will show you how to fire insert query using sqldatasource control into code behind i am using c#.

Below is the sample code UserID is the parameter passing into a function as an argument.

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13


    DateTime Entrydate = DateTime.Today;
    SqlDataSource myDbSource = new SqlDataSource();
    myDbSource.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
    myDbSource.InsertCommand = "insert into tbl_invoices (user,Entrydate) values (" + UserID + ",'" + Entrydate + "')";
    myDbSource.ProviderName = "System.Data.SqlClient";
    myDbSource.Insert();

    myDbSource.SelectCommand = "SELECT IDENT_CURRENT('tbl_invoices')";
    DataView dv = (DataView)myDbSource.Select(new DataSourceSelectArguments());
    DataTable dt = dv.Table;
    string invNumber = dt.Rows[0][0].ToString();
    return invNumber.ToString();
    //return string.Empty;

Code above is very simple what it does simple take UserID as an argument and then insert a new record into tbl_invoices table and then after it i am firing a select statement that returns the latest ID into tbl_invoices table. SELECT IDENT_CURRENT(‘table name’) return the id of the last record inserted into the table.

Happy coding bye