删除代码如下:
SqlConnection sqlcon;
SqlCommand sqlcom;
string strCon = "server=.;uid=sa;pwd=;database=ASPNET配置";
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
// SqlConnection cn = new SqlConnection("server=.;uid=sa;pwd=;database=ASPNET配置"); string sqlstr = "delete from 表 where UserId='" + GridView1.DataKeys[e.RowIndex].Value.ToString()+ "'";
sqlcon = new SqlConnection(strCon);
sqlcom = new SqlCommand(sqlstr, sqlcon);
sqlcon.Open();
sqlcom.ExecuteNonQuery();
sqlcon.Close();
this.DataBind();
}
SqlConnection sqlcon;
SqlCommand sqlcom;
string strCon = "server=.;uid=sa;pwd=;database=ASPNET配置";
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
// SqlConnection cn = new SqlConnection("server=.;uid=sa;pwd=;database=ASPNET配置"); string sqlstr = "delete from 表 where UserId='" + GridView1.DataKeys[e.RowIndex].Value.ToString()+ "'";
sqlcon = new SqlConnection(strCon);
sqlcom = new SqlCommand(sqlstr, sqlcon);
sqlcon.Open();
sqlcom.ExecuteNonQuery();
sqlcon.Close();
this.DataBind();
}
将字符串转换为 uniqueidentifier 时失败。 : System.Data.SqlClient.SqlException: 将字符串转换为 uniqueidentifier 时失败。
最好代码贴全点
ConnectionString="<%$ ConnectionStrings:ASPNET配置ConnectionString %>"
SelectCommand="SELECT [UserId], [UserName] FROM [vw_aspnet_Users]">
</asp:SqlDataSource>
这个是配置原文件,UserId是主键。这个是微软提供的数据库。
没有设置从哪儿读取?
/// 删除一条数据
/// </summary>
public void Delete(int KID)
{ StringBuilder strSql = new StringBuilder();
strSql.Append("delete from SYS_CYLB ");
strSql.Append(" where KID=@KID ");
SqlParameter[] parameters = {
new SqlParameter("@KID", SqlDbType.Int,4)};
parameters[0].Value = KID; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}/// <summary>
/// 执行带一个存储过程参数的的SQL语句。
/// </summary>
/// <param name="SQLString">SQL语句</param>
/// <param name="content">参数内容,比如一个字段是格式复杂的文章,有特殊符号,可以通过这个方式添加</param>
/// <returns>影响的记录数</returns>
public static int ExecuteSql(string SQLString, string content)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand(SQLString, connection);
System.Data.SqlClient.SqlParameter myParameter = new System.Data.SqlClient.SqlParameter("@content", SqlDbType.NText);
myParameter.Value = content;
cmd.Parameters.Add(myParameter);
try
{
connection.Open();
int rows = cmd.ExecuteNonQuery();
return rows;
}
catch (System.Data.SqlClient.SqlException e)
{
throw e;
}
finally
{
cmd.Dispose();
connection.Close();
}
}
}
http://dotnet.aspx.cc/file/Add-Delete-Update-Edit-Data-With-Paging-in-GridView.aspx
SELECT [UserId], [UserName] FROM [vw_aspnet_Users]
这个是sql查询语句 查询这个表的2个字段
DataSourceID="SqlDataSource1" AllowPaging="True" CellPadding="4"
ForeColor="#333333" GridLines="None" onrowdeleting="GridView1_RowDeleting"
RowHeaderColumn="UserName" style="text-align: left" Width="493px"
onrowupdating="GridView1_RowUpdating" AllowSorting="True" DataKeyNames="UserId">
<RowStyle BackColor="#EFF3FB" />
<Columns>
<asp:BoundField DataField="UserName" HeaderText="UserName"
SortExpression="UserName" />
<asp:CommandField ShowEditButton="True" />
<asp:CommandField ShowSelectButton="True" />
<asp:CommandField ShowDeleteButton="True" />
</Columns>
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<EditRowStyle BackColor="#2461BF" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ASPNET配置ConnectionString %>"
SelectCommand="SELECT [UserId], [UserName] FROM [vw_aspnet_Users]">
</asp:SqlDataSource>