麻烦大家了!我现在用了三种方法对数据进行操作!第一种就是用GridView然后手写所有事件,对数据进么增,添,删,改,分页操作!(已解决)
第二种用绑定button事件方法,现在,增,添,删,改,写好了!就是不知道如何分页显示?
第三种有Http原理的方法操作数据,增,添,删,改写好了,也是不知道如何分页显示?
注:JS还不会,存储过程也还看不怎么明白!
先解决第二种再说,部分代码如下:前台:(有人说可以用)
<asp:Label ID="lab1" text="Name:" runat="server"></asp:Label>
<asp:TextBox ID="name2" runat="server"></asp:TextBox>
<asp:label ID="lab2" Text="price" runat="server" ></asp:label>
<asp:TextBox ID="price2" runat="server"></asp:TextBox>
<asp:Button ID="btnAdd2" runat="server" Text="添加" onclick="btnAdd2_Click" />
<p>
<asp:Button ID="btnSelect" runat="server" Text="查询" onclick="btnSelect_Click" />后台查询:protected void btnSelect_Click(object serder, EventArgs e)
{ string str = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Fom1.mdf;Integrated Security=True;User Instance=True";
SqlConnection conn = new SqlConnection(str);
conn.Open();
string sQl = "select * from menu";
SqlCommand thiscommand = new SqlCommand(sQl, conn);
SqlDataReader da = thiscommand.ExecuteReader();
if (da.HasRows)
{
Response.Write("<table><tr><td>Id</td><td>Name</td><td>Sellprice</td></tr>"); while (da.Read())
{
Response.Write("<tr><td>" + da[0] + "</td><td>" + da[1] + "</td><td>" + da[2] + "</td></tr>");
}
Response.Write("</table>");
}
}
后台添加:
public void insert(string name, int price)
{
string str = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Fom1.mdf;Integrated Security=True;User Instance=True";
SqlConnection conn = new SqlConnection(str);
conn.Open();
string SQL = "insert into menu(Name,SellPrice) values ('" + name + "'," + price + ");";//inset into records
SqlCommand comm = new SqlCommand(SQL, conn);
comm.ExecuteNonQuery();
Response.Write("<h2 style=\"color:red\">添加成功</h2>");
Response.Write("名称:" + name);
Response.Write("<br/>");
Response.Write("价格:" + price); }
其它方法省略。
麻烦大家帮帮我!谢谢了!
第二种用绑定button事件方法,现在,增,添,删,改,写好了!就是不知道如何分页显示?
第三种有Http原理的方法操作数据,增,添,删,改写好了,也是不知道如何分页显示?
注:JS还不会,存储过程也还看不怎么明白!
先解决第二种再说,部分代码如下:前台:(有人说可以用)
<asp:Label ID="lab1" text="Name:" runat="server"></asp:Label>
<asp:TextBox ID="name2" runat="server"></asp:TextBox>
<asp:label ID="lab2" Text="price" runat="server" ></asp:label>
<asp:TextBox ID="price2" runat="server"></asp:TextBox>
<asp:Button ID="btnAdd2" runat="server" Text="添加" onclick="btnAdd2_Click" />
<p>
<asp:Button ID="btnSelect" runat="server" Text="查询" onclick="btnSelect_Click" />后台查询:protected void btnSelect_Click(object serder, EventArgs e)
{ string str = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Fom1.mdf;Integrated Security=True;User Instance=True";
SqlConnection conn = new SqlConnection(str);
conn.Open();
string sQl = "select * from menu";
SqlCommand thiscommand = new SqlCommand(sQl, conn);
SqlDataReader da = thiscommand.ExecuteReader();
if (da.HasRows)
{
Response.Write("<table><tr><td>Id</td><td>Name</td><td>Sellprice</td></tr>"); while (da.Read())
{
Response.Write("<tr><td>" + da[0] + "</td><td>" + da[1] + "</td><td>" + da[2] + "</td></tr>");
}
Response.Write("</table>");
}
}
后台添加:
public void insert(string name, int price)
{
string str = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Fom1.mdf;Integrated Security=True;User Instance=True";
SqlConnection conn = new SqlConnection(str);
conn.Open();
string SQL = "insert into menu(Name,SellPrice) values ('" + name + "'," + price + ");";//inset into records
SqlCommand comm = new SqlCommand(SQL, conn);
comm.ExecuteNonQuery();
Response.Write("<h2 style=\"color:red\">添加成功</h2>");
Response.Write("名称:" + name);
Response.Write("<br/>");
Response.Write("价格:" + price); }
其它方法省略。
麻烦大家帮帮我!谢谢了!
三种选择
aspnetpager
用存储过程
pagedatasource
GridView真的可以做事吗??
不灵活,,二次发差,外观难以美化
用repeater 写一个分页控件出来多好啊,,
aspnetpager分页控件