<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %><html>
<script language="VB" runat="server"> Sub Page_Load(Sender As Object, E As EventArgs) Dim DS As DataSet
Dim MyConnection As SqlConnection
Dim MyCommand As SqlDataAdapter MyConnection = New SqlConnection("server=(local)\NetSDK;database=pubs;Trusted_Connection=yes")
MyCommand = New SqlDataAdapter("select * from Authors", MyConnection) DS = new DataSet()
MyCommand.Fill(ds, "作者") MyDataGrid.DataSource=ds.Tables("作者").DefaultView
MyDataGrid.DataBind()
End Sub</script><body> <h3><font face="宋体">DataGrid 控件的简单选择</font></h3> <ASP:DataGrid id="MyDataGrid" runat="server"
Width="700"
BackColor="#ccccff"
BorderColor="black"
ShowFooter="false"
CellPadding=3
CellSpacing="0"
Font-Name="宋体"
Font-Size="8pt"
HeaderStyle-BackColor="#aaaadd"
EnableViewState="false"
/></body>
</html>
<%@ Import Namespace="System.Data.SqlClient" %><html>
<script language="VB" runat="server"> Sub Page_Load(Sender As Object, E As EventArgs) Dim DS As DataSet
Dim MyConnection As SqlConnection
Dim MyCommand As SqlDataAdapter MyConnection = New SqlConnection("server=(local)\NetSDK;database=pubs;Trusted_Connection=yes")
MyCommand = New SqlDataAdapter("select * from Authors", MyConnection) DS = new DataSet()
MyCommand.Fill(ds, "作者") MyDataGrid.DataSource=ds.Tables("作者").DefaultView
MyDataGrid.DataBind()
End Sub</script><body> <h3><font face="宋体">DataGrid 控件的简单选择</font></h3> <ASP:DataGrid id="MyDataGrid" runat="server"
Width="700"
BackColor="#ccccff"
BorderColor="black"
ShowFooter="false"
CellPadding=3
CellSpacing="0"
Font-Name="宋体"
Font-Size="8pt"
HeaderStyle-BackColor="#aaaadd"
EnableViewState="false"
/></body>
</html>
IDbConnection conn = new SqlConnection(fConnectionString);
try
{
conn.open();
IDbCommand comm = conn.CreateCommand();
comm.CommandText = "Insert into Table1(...) values(...)";
comm.CommandType = CommandType.Text;
comm.ExecuteNoQuery();
....
}
finally
{
conn.close();
}
到上面去看看吧!会有帮助的!
===弯弯的月亮小小的船,小小的船,两头尖,我在小小的船里坐,只看见闪闪
的星星蓝蓝的天.
===本贴子以“现状”提供且没有任何担保,同时也没有授予任何权利
string sqlstr="insert into tablename(Field1,Field2) values('"+var1+"','"+var2+"')";
SqlConnection myconn=new SqlConnection(connstr);
SqlCommand mycmd=new SqlCommand(sqlstr,myconn);
mycmd.ExecuteNonQuery();
<appSettings>
<add key="connectionString" value="Server=localhost;Database=Prodct;uid=sa;pwd=;" />
</appSettings>
然后在调用页面:
imports system.configuration
sub page_load()
dim strCon as string=system.configuration.configurationsettings.Appsettings("connectionString")
dim con as sqlconnection
con.connectionstring=strCon
dim cmd as new sqlcommand("select * from product",con)
con.open
dim adp as new sqldataadpter
adp.commandselect =cmd
dim sqldataset as dataset
adp.fill(sqldataset)
datagrid.datasource=sqldatset.table(0).defultview
datagrid.databindend sub
SqlConnection sc=new SqlConnection("server=yourIp;database=pubs;uid=sa;pwd=sa");
sc.Open();
//插入数据
SqlCommand sd=new SqlCommand("procedure_test",sc);
sd.CommandType=CommandType.StoredProcedure;
sd.Parameters.Add(New SqlParameter("@name", SqlDbType.NVarChar, 40)).Value="张三";
MyCommand.ExecuteNonQuery();
sc.Close();