. aspx interface
. CS interface
public partial class _default:system.web.ui.page
{
Get the connection in the Web.config and put it in the variable
SqlConnection con = new SqlConnection (configurationmanager.connectionstrings["ConnStr"). ConnectionString);
protected void Page_Load (object sender, EventArgs e)
{
if (! IsPostBack)
{
Calling custom methods to bind data to controls (lay the groundwork for future MVC)
Binddatalist ();
}
}
Data binding to Datelist
private void Binddatalist ()
{
Define the query statement, it is better to write SQL statements in SQL and verify that the correct copy paste over (in the query to the data, it is best to check only some of the required data do not take out, which can improve the efficiency of the operation)
String strSQL = "SELECT * from Bg_spatial";//define an SQL statement
SqlDataAdapter SDA = new SqlDataAdapter (strSQL, con);
DataSet ds = new DataSet ();
Sda. Fill (DS);//Put the executed data in the dataset
Datalist1.datasource = ds;
Datalist1.databind ();
}
protected void Datalist1_itemcommand (object source, DataListCommandEventArgs e)
{
Switch (e.commandname)
{
Single Data delete operation
Case "Delete":
Get the current DataList control column
int id = Int. Parse (Datalist1.datakeys[e.item.itemindex]. ToString ());
String strSQL = "Delete from bg_spatial where id=" + ID + "'";
if (Con. State.equals (connectionstate.closed))
{
Con. Open ()//Opens the database
}
SqlCommand cmd = new SqlCommand (strSQL, con);
if (Convert.ToInt32 (cmd). ExecuteNonQuery ()) >0)
{
Response.Write (' <script>alert (' delete success! ') </script> ");
Binddatalist ();
}
Else
{
Response.Write (' <script>alert (' delete failed! Please find the reason ') </script> ');
}
Con. Close ();//Turn off connection
Break
Bulk Data deletion operations
Case "Pldelete":
if (Con. State.equals (connectionstate.closed))
{
Con. Open ()//Opens the database
}
Datalistitemcollection dlic = datalist1.items;//Create a DataList list item collection Object
Performs a circular deletion of the selected information
for (int i = 0; i < Dlic. Count; i++)
{
if (dlic[i). ItemType = = Listitemtype.alternatingitem| | Dlic[i]. ItemType = = ListItemType.Item)
{
CheckBox Cbox = (checkbox) Dlic[i]. FindControl ("CheckBox2");
if (Cbox. Checked)
{
int p_id = Int. Parse (Datalist1.datakeys[dlic[i]. ItemIndex]. ToString ());
SqlCommand p_cmd = new SqlCommand ("Delete from bg_spatial where id=" + p_id, con);
P_cmd. ExecuteNonQuery ();
}
}
}
Con. Close ();
Binddatalist ();
Break
}
}
}
Run Effect chart:
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
