UC知道asp1.1中的.FillDataSet() 在2.0应是什么?
来源：百度知道 编辑：UC知道 时间：2024/09/28 13:52:58
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.Sql" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Collections" %>
<html>
<script language="C#" runat="server" >
SqlConnection myConnection;
protected void Page_Load(Object Src,EventArgs E)
{
myConnection=new SqlConnection("Server=localhost;uid=sa;pwd=;database=pubs");
if(!IsPostBack)
BindGrid();
}
public void AddAuthor_Click(Object sender,EventArgs E)
{
if(Page.IsValid)
{
String insertCmd="insert into Authors values(@ID,@LName,@FName,@Phone,@Address,@City,@State,@Zip,@Contract)";
SqlCommand myCommand=new SqlCommand(insertCmd,myConnection);
myCommand.Parame
<%@ Import Namespace="System.Data.Sql" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Collections" %>
<html>
<script language="C#" runat="server" >
SqlConnection myConnection;
protected void Page_Load(Object Src,EventArgs E)
{
myConnection=new SqlConnection("Server=localhost;uid=sa;pwd=;database=pubs");
if(!IsPostBack)
BindGrid();
}
public void AddAuthor_Click(Object sender,EventArgs E)
{
if(Page.IsValid)
{
String insertCmd="insert into Authors values(@ID,@LName,@FName,@Phone,@Address,@City,@State,@Zip,@Contract)";
SqlCommand myCommand=new SqlCommand(insertCmd,myConnection);
myCommand.Parame
SqlCommand myCommand=new SqlCommand("select*from Authors",myConnection);
DataSet ds=new DataSet();
SqlDataAdapter da= new SqlDataAdapter();
da.Fill(ds,"Authors");
MyDataGrid.DataSource=ds.Tables["Authors"].DefaultView;
myDataGrid.DataBind();
这样就可以了。
还有你不觉得使用存储过程很麻烦吗？直接用sql语句不是很好吗？
改成dataadapter.fill了