我也刚学会的,希望能给你帮助:)<Script language="c#" runat="Server">
void Button_Click(Object send, EventArgs e ) {
SqlConnection conn;
SqlCommand cmd;
conn=new SqlConnection("Server=localhost;UID=sa;pwd=;database=pubs");
cmd = new SqlCommand( "Insert student ( stu_no, name ) values ( @stu_no, @name )", conn ) ;
cmd.Parameters.Add( "@stu_no", txtCustomerName.Text ) ;
cmd.Parameters.Add( "@name", txtCustomerPhone.Text ) ;
conn.Open() ;
cmd.ExecuteNonQuery() ;
conn.Close() ;
}
</Script>
void Button_Click(Object send, EventArgs e ) {
SqlConnection conn;
SqlCommand cmd;
conn=new SqlConnection("Server=localhost;UID=sa;pwd=;database=pubs");
cmd = new SqlCommand( "Insert student ( stu_no, name ) values ( @stu_no, @name )", conn ) ;
cmd.Parameters.Add( "@stu_no", txtCustomerName.Text ) ;
cmd.Parameters.Add( "@name", txtCustomerPhone.Text ) ;
conn.Open() ;
cmd.ExecuteNonQuery() ;
conn.Close() ;
}
</Script>
我装的是bata2,最好用vb.
<Script language="VB" runat="Server">
Sub Page_Load
Dim conn As SqlConnection
Dim cmd As SqlCommand
Dim SqlReaderBook As SqlDataReader
conn = New SqlConnection( "Server=localhost;UID=sa;PWD=;Database=mydeb" )
cmd = New SqlCommand( "Select * from book", conn )
conn.Open()
DataGridBook.DataSource = cmd.ExecuteReader()
DataGridBook.DataBind()
conn.Close
End Sub
</Script>
<html>
<head><title>DataGrid.aspx</title></head>
<body>
<asp:DataGrid
id="DataGridBook"
Runat="Server" />
</body>
</html>
<Script language="VB" runat="Server">
Private Sub Page_Load
Dim Con As SqlConnection
Dim Adp As SqlDataAdapter
Con = New SqlConnection("server=服务器名或IP地址;uid=sa;pwd=;database=数据库名" )
Dst = New SqlDataAdapter("Select * from 数据表名", Con)
Dim Dst As New DataSet
Adp.Fill(Dst,表名)
MyDataGrid.DataSource = Dst.Tables(表名).DefaultView
MyDataGrid.DataBind()
Con.Close
Adp=Nothing
Con=Nothing
End Sub
</Script>
<html>
<head><title>DataGrid.aspx</title></head>
<body>
<asp:DataGrid id="MyDataGrid" Runat="Server" />
</body>
</html>