以下C#代码转为VB代码出错..
for (int i = 0; i < GridView1.Rows.Count; i++)
{
StringBuilder query = new StringBuilder();
GridViewRow row = GridView1.Rows[i];
string ID = ((TextBox)row.Cells[0].FindControl("txtID")).Text.Replace("'", "");
string Name = ((TextBox)row.Cells[0].FindControl("txtRealName")).Text.Replace("'", "");
string Sex = ((DropDownList)row.Cells[0].FindControl("ddlSex")).SelectedValue;
string Address = ((TextBox)row.Cells[0].FindControl("txtAddress")).Text.Replace("'", "");
query.Append("update Employee set ID='" + ID + "',Name='" + Name + "',Sex='" + Sex + "',Address='" + Address + "' where ID=" + GridView1.DataKeys[i].Value + "");
Common.ExecuteSql(query.ToString());
Response.Write(GridView1.DataKeys[i].Value);
}转换成 For i As Integer = 0 To GridView1.Rows.Count - 1
Dim query As New StringBuilder()
Dim row As GridViewRow = GridView1.Rows(i)
Dim ID As Integer = DirectCast(row.Cells(0).FindControl("txtID"), TextBox).Text.Replace("'", "")
Dim Name As String = DirectCast(row.Cells(0).FindControl("txtRealName"), TextBox).Text.Replace("'", "")
Dim Sex As String = DirectCast(row.Cells(0).FindControl("ddlSex"), DropDownList).SelectedValue
Dim Address As String = DirectCast(row.Cells(0).FindControl("txtAddress"), TextBox).Text.Replace("'", "")
query.Append((((("update Employee set ID='" & ID & "',Name='") + Name & "',Sex='") + Sex & "',Address='") + Address & "' where ID=") + GridView1.DataKeys(i).Value + "")
Common.ExecuteSql(query.ToString())
Response.Write(GridView1.DataKeys(i).Value)
Next转换后vb.net提示“输入字符串的格式不正确”,估计是“ID=") + GridView1.DataKeys(i).Value + "")”这个出错了,因为把它删了就可以,请大家帮帮忙
for (int i = 0; i < GridView1.Rows.Count; i++)
{
StringBuilder query = new StringBuilder();
GridViewRow row = GridView1.Rows[i];
string ID = ((TextBox)row.Cells[0].FindControl("txtID")).Text.Replace("'", "");
string Name = ((TextBox)row.Cells[0].FindControl("txtRealName")).Text.Replace("'", "");
string Sex = ((DropDownList)row.Cells[0].FindControl("ddlSex")).SelectedValue;
string Address = ((TextBox)row.Cells[0].FindControl("txtAddress")).Text.Replace("'", "");
query.Append("update Employee set ID='" + ID + "',Name='" + Name + "',Sex='" + Sex + "',Address='" + Address + "' where ID=" + GridView1.DataKeys[i].Value + "");
Common.ExecuteSql(query.ToString());
Response.Write(GridView1.DataKeys[i].Value);
}转换成 For i As Integer = 0 To GridView1.Rows.Count - 1
Dim query As New StringBuilder()
Dim row As GridViewRow = GridView1.Rows(i)
Dim ID As Integer = DirectCast(row.Cells(0).FindControl("txtID"), TextBox).Text.Replace("'", "")
Dim Name As String = DirectCast(row.Cells(0).FindControl("txtRealName"), TextBox).Text.Replace("'", "")
Dim Sex As String = DirectCast(row.Cells(0).FindControl("ddlSex"), DropDownList).SelectedValue
Dim Address As String = DirectCast(row.Cells(0).FindControl("txtAddress"), TextBox).Text.Replace("'", "")
query.Append((((("update Employee set ID='" & ID & "',Name='") + Name & "',Sex='") + Sex & "',Address='") + Address & "' where ID=") + GridView1.DataKeys(i).Value + "")
Common.ExecuteSql(query.ToString())
Response.Write(GridView1.DataKeys(i).Value)
Next转换后vb.net提示“输入字符串的格式不正确”,估计是“ID=") + GridView1.DataKeys(i).Value + "")”这个出错了,因为把它删了就可以,请大家帮帮忙
解决方案 »
- 求救,错误类型“scout._Default”已经包含“DataGrid1”的定义
- 如果写需求分析 酒店预定系统
- 用人单位说我没有经验,找了半年了没有人用增么才能有经验呢
- asp.net中利用vsreport打印报表?
- Access数据库中怎么分页?
- $$$$$$$$$$$$$$出现“IE无法开启网际网路网站http://localhost/project/form/aaa.asp.操作已终止”窗口。求原因$$$$$$$$
- Dropdownlist问题,能否绑定多个数据字段
- 请问SubString怎么用?
- 请问哪位有ASP.NET生成HTML页的新闻系统解决方案或代码
- 在用form验证的程序中,如何让已登录的用户在关闭网页后,下次登录必须重新验证?
- 转换HTML危险字符的方法
- 帮我看断代码 关于ViewState 100相送~
我一般用这种方法StringBuilder query = New StringBuilder();query.Append(string.format("update Employee set ID={0},Name='{1}',Sex='{2}',Address='{3}' where ID={4}",ID,Name,Sex,Address,GridView1.DataKeys(i).Value );
不知道VB是咋整的..
Dim query As New StringBuilder()
Dim row As GridViewRow = GridView1.Rows(i)
Dim ID As String = DirectCast(row.Cells(0).FindControl("txtID"), TextBox).Text.Replace("'", "")
Dim Name As String = DirectCast(row.Cells(0).FindControl("txtRealName"), TextBox).Text.Replace("'", "")
Dim Sex As String = DirectCast(row.Cells(0).FindControl("ddlSex"), DropDownList).SelectedValue
Dim Address As String = DirectCast(row.Cells(0).FindControl("txtAddress"), TextBox).Text.Replace("'", "")
query.Append("update Employee set ID='" & ID & "',Name='" & Name & "',Sex='" & Sex & "',Address='" & Address & "' where ID=" & GridView1.DataKeys(i).Value & "")
Response.Write(GridView1.DataKeys(i).Value)
dim query As New StringBuilder()
query.AppendFormat("update Employee set ID={0},Name='{1}',Sex='{2}',Address='{3}' where ID={4}",ID,Name,Sex,Address,GridView1.DataKeys(i).Value)