Transaction processing: Creating the transaction object: string connectString = "data source =; SqlConnection objConn = new SqlConnection (connectString); SqlTransaction objTransaction = objConn.BeginTransaction (); SqlCommand objCommand = new SqlCommand (); objCommand.Transaction = objTransaction; objConn. Begintransaction (); try {objtransaction.commit ();} catch {objtransaction.rollback ();
Data Binding: ArrayList Objlist = New ArrayList (); Objlist.Add ("A"); Objlist.Add ("B"); ObjList.Add ("C"); DropDownList1.DataSource = Objlist; DropdownList1.DATABIND () ; string connectString = "data source = .; initial catalog = XXX; user id = sa; password =; Pooling = true; max pool size = 100" SqlConnection objConn = new SqlConnection (connectString); objConn.Open (); SqlCommand objCommand = new SqlCommand ( "Select * from Sys_users", objConn); SqlDataReader objReader = objCommand.ExecuteReader (); DropDownList1.DataSource = objReader; DropDownList1.DataTextField = "Name"; DropDownList1.DataValueField = "ID"; DropDownList1.DataBind () Objconn.close ();
