Asp tutorial. net C # query the date field type and query data in the database tutorial
Private void button#click (object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection (@"");
// Create a database connection object and database connection string
SqlCommand cmd = conn. CreateCommand ();
Cmd. CommandText = "select * from thing where date = '" + dateTimPicker1.Value + "'";
SqlDataReader reader = cmd. ExecuteReader ();
While (reader. Read ())
{
String xierushijian = reader. GetString (1 );
String dotime = reader. GetString (2 );
String thingscontent = reader. GetString (3 );
TextBox3.Text = ("write time:" + xierushijian + "when doing this:" + dotime + "content:" + thingscontent );
}
}
%>
Another simple example of the asp.net tutorial to query the database content
<% @ Import Namespace = "System. Data" %>
<% @ Import Namespace = "System. Data. SqlClient" %>
<Script runat = "server" language = "c #">
Void Page_Load ()
{
SqlConnection conn = new SqlConnection ("Server = localhost; uid = sa; pwd = sa; database = student ");
SqlCommand SQL = new SqlCommand ("select * from stu where sno = '000000'", conn );
Conn. Open ();
SqlDataReader DReader = SQL. ExecuteReader ();
If (DReader. Read ())
{
Sno. Text = Convert. ToString (DReader ["sno"]);
Sname. Text = Convert. ToString (DReader ["sname"]);
}
}
</Script>
<Html>
<Head>
<Title> Hello World.www.111cn.net </title>
</Head>
<Body>
<Form runat = "server">
<Asp: Label id = "sno" runat = "server"/>
<Asp: Label id = "sname" runat = "server"/>
</Form>