<input id="sydx" type="text" size="50" value='<%# DataBinder.Eval(Container.DataItem, "sydx") %>' runat="server" NAME="sydx"/>
解决方案 »
- 请教大师,为什么我写的这个Repeater浏览之后什么也不显示呢
- .net生成静态页面
- 没办法,问题没解决还得发贴,谢谢了先,我的问题是“GridView导出Excel没有数据的区域为空白,是怎么回事啊,怎么解决,重谢”
- 如何用asp.net生成静态新闻列表
- 请问怎样可以动态设置页导航的字体大小啊?
- asp.net gridview如何局部刷新
- 关于asp.net ftp下载保存文件问题
- 请问在国内除了csdn的外包频道外,还有那些比较好的外包网站?(信誉好)
- 用c#、asp.net来开发一个人事管理系统的一个问题
- datagird问题!
- 请高手指教,如何使用xml存取图片?
- 在dbgrid中显示sqlserver中的datatime类型时,显示为2003-8-20 00:00:00,我只想要日期,不想要时间,因该如何解决?
前一页的连接地址为:http://xxx.com/xxx.aspx?id=5本页是
Dim userid As String = Request("id")
Dim strsql As String = "select * from news where id='" & userid & "'"然后就不知道怎么把数据绑到TEXTBOX上了;我是在后台准备做一个新闻修改的页面,从一系列的新闻列表中找到要修改的新闻,点进去后就把标题,内容放在TEXTBOX控件里,修改完后用UPDATE语句更新数据库。
请帮帮我啊,写个简单的原码给我看看好吗?请用VB.NET写,谢谢!
dim dr as SqlDataReader
cn.open()
dr=cmd.ExecuteNonQuery()
if dr.Read() then
TextBox1.Text=dr.GetString(1)
end ifcn.Close()
dim dr as SqlDataReaderconn.Open()
dr = cmd.ExecuteReader()if dr.Read() then
TextBox1.Text = dr.GetString(1)
end if
dr.Close()cn.Close()
这句dr=cmd.ExecuteNonQuery() 应改为dr=cmd.ExecuteReader()
我上传的是三个数据bt.text,tp.text,lr.text
谢谢了
public void MyDataGrid_Update(Object sender, DataGridCommandEventArgs e)
{
String updateCmd = "UPDATE Authors SET au_id = @Id, au_lname = @LName, au_fname = @FName, phone = @Phone, "
+ "address = @Address, city = @City, state = @State, zip = @Zip, contract = @Contract where au_id = @Id"; SqlCommand myCommand = new SqlCommand(updateCmd, myConnection); myCommand.Parameters.Add(new SqlParameter("@Id", SqlDbType.NVarChar, 11));
myCommand.Parameters.Add(new SqlParameter("@LName", SqlDbType.NVarChar, 40));
myCommand.Parameters.Add(new SqlParameter("@FName", SqlDbType.NVarChar, 20));
myCommand.Parameters.Add(new SqlParameter("@Phone", SqlDbType.NChar, 12));
myCommand.Parameters.Add(new SqlParameter("@Address", SqlDbType.NVarChar, 40));
myCommand.Parameters.Add(new SqlParameter("@City", SqlDbType.NVarChar, 20));
myCommand.Parameters.Add(new SqlParameter("@State", SqlDbType.NChar, 2));
myCommand.Parameters.Add(new SqlParameter("@Zip", SqlDbType.NChar, 5));
myCommand.Parameters.Add(new SqlParameter("@Contract", SqlDbType.NVarChar,1)); myCommand.Parameters["@Id"].Value = MyDataGrid.DataKeys[(int)e.Item.ItemIndex]; String[] cols = {"@Id","@LName","@FName","@Phone","@Address","@City","@State","@Zip","@Contract"};
Message.InnerHtml = ""; int numCols = e.Item.Cells.Count;
for (int i=2; i<numCols-1; i++) //skip first, second and last column
{
String colvalue =((System.Web.UI.WebControls.TextBox)
e.Item.Cells[i].Controls[0]).Text;
// check for invalid values
switch (cols[i-1])
{
case "@LName":
if ( !InputValidator.IsValidAnsiName(colvalue) )
{
Message.InnerHtml += "ERROR: Last Name - " + InputValidator.AnsiNameErrorString + "<br>";
}
break;
case "@FName":
if ( !InputValidator.IsValidAnsiName(colvalue) )
{
Message.InnerHtml += "ERROR: First Name - " + InputValidator.AnsiNameErrorString + "<br>";
}
break;
case "@Phone":
if ( !InputValidator.IsValidAnsiPhoneNumber(colvalue) )
{
Message.InnerHtml += "ERROR: Phone - " + InputValidator.AnsiPhoneErrorString + "<br>";
}
break;
case "@Address":
if ( !InputValidator.IsValidAnsiAddress(colvalue) )
{
Message.InnerHtml += "ERROR: Address - " + InputValidator.AnsiAddressErrorString + "<br>";
}
break;
case "@City":
if ( !InputValidator.IsValidAnsiCityOrState(colvalue) )
{
Message.InnerHtml += "ERROR: City - " + InputValidator.AnsiCityStateErrorString + "<br>";
}
break;
case "@State":
if ( !InputValidator.IsValidAnsiTwoCharacterState(colvalue) )
{
Message.InnerHtml += "ERROR: State - " + InputValidator.AnsiTwoCharacterStateErrorString + "<br>";
}
break;
case "@Zip":
if ( !InputValidator.IsValidFiveDigitZipCode(colvalue) )
{
Message.InnerHtml += "ERROR: Zip Code - " + InputValidator.AnsiBasicZipCodeErrorString + "<br>";
}
break;
} // check for null values in required fields
if (i<6 && colvalue == "")
{
Message.InnerHtml += "ERROR: Null values not allowed for " + cols[i-1] + "<br>";
} myCommand.Parameters[cols[i-1]].Value = colvalue;
}
if ( Message.InnerHtml != "" )
{
Message.Style["color"] = "red";
return;
} //append last row, converting true/false values to 0/1
if (String.Compare(((System.Web.UI.WebControls.TextBox)
e.Item.Cells[numCols-1].Controls[0]).Text, "true", true, CultureInfo.InvariantCulture)==0)
myCommand.Parameters["@Contract"].Value = "1";
else
myCommand.Parameters["@Contract"].Value = "0"; myCommand.Connection.Open(); try
{
myCommand.ExecuteNonQuery();
Message.InnerHtml = "<b>Record Updated</b><br>" + updateCmd;
MyDataGrid.EditItemIndex = -1;
}
catch (SqlException exc)
{
if (exc.Number == 2627)
Message.InnerHtml = "ERROR: A record already exists with the same primary key";
else
Message.InnerHtml = "ERROR: Could not update record, please ensure the fields are correctly filled out";
Message.Style["color"] = "red";
} myCommand.Connection.Close(); BindGrid();
}