帮你UP,大不了写两个select 语句吧。
解决方案 »
- Asp.net的CheckBoxList控件多个Demo演示
- 服务器端按钮快速跳转
- VS2005调试问题,关闭调试页面后VS2005仍然处在运行状态!
- 一个DataGrid绑定数据的问题
- 每次覆盖服务器上的dll文件,服务器的application,session都消失了 .net难道不如asp
- 请问Microsoft Visual Studio .NET 2003 能否装在 Windows XP sp2 上海政府版上面?
- 后退或者刷新,以前已经关闭的open窗口,再次打开。
- 怎样替换txt文件中的字符串
- 数据库连接
- 难道datagrid的onitemcommand事件真的不能触发么?
- 请教vs.net中框架的用法,急!
- 请高手指教!用DropDownList控件显示数据库的内容,调试程序时内容无法显示!
{
int id=DataGrid1.SelectedIndex;
Session["strbm"]=DataGrid1.Items[id].Cells[1].Text.ToString();
//这样就可以取出选中行中的每一列的值,然后再更新到另一个表中就可以了
………………………………
}前提是有一个选择列
If Not Page.IsPostBack Then
Dim strCn As String = "Data Source=.;uid=develop;pwd=12345;Initial Catalog=new_ks"
Dim strSQL As String = " SELECT id,val,dd " & _
" FROM dbo.tabA "
Dim sadTest As New SqlDataAdapter(strSQL, strCn)
Dim dsTest As New DataSet
sadTest.Fill(dsTest)
Session("Table") = dsTest.Tables(0)
DataGrid1.DataSource = dsTest.Tables(0).DefaultView
DataGrid1.DataBind()
End If
End Sub Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim tblOld As DataTable = CType(Session("Table"), DataTable)
Dim tblNew As New DataTable
Dim intI As Integer
Dim rowNew, rowTemp As DataRow tblNew.Columns.Add("val")
tblNew.Columns.Add("dd")
For intI = 0 To tblOld.Rows.Count - 1
rowTemp = tblOld.Rows(intI)
rowNew = tblNew.NewRow()
rowNew.Item(0) = rowTemp.Item(1)
rowNew.Item(1) = rowTemp.Item(2)
tblNew.Rows.Add(rowNew)
Next
DataGrid1.DataSource = tblNew.DefaultView
DataGrid1.DataBind()
End Sub
{
DataTable tblOld=(DataTable)Session["Table"];
DataTable tblNew=new DataTable();
int intI;
DataRow rowNew,rowTemp;
tblNew.Columns.Add("val");
tblNew.Columns.Add("dd");
object[] arrTest = new object[2];
for(intI=0;intI<tblOld.Rows.Count;intI++)
{
rowTemp=tblOld.Rows[intI];
rowNew=tblNew.NewRow();
arrTest[0]=rowTemp.ItemArray[1];
arrTest[1]=rowTemp.ItemArray[2];
rowNew.ItemArray=arrTest;
tblNew.Rows.Add(rowNew);
}
DataGrid1.DataSource=tblNew.DefaultView;
DataGrid1.DataBind();
} private void Page_Load(object sender, System.EventArgs e)
{
if(!Page.IsPostBack)
{
string strCn="Data Source=.;uid=develop;pwd=12345;Initial Catalog=new_ks";
string strSQL=" SELECT id,val,dd "
+" FROM dbo.tabA ";
SqlDataAdapter sadTest=new SqlDataAdapter(strSQL,strCn);
DataSet dsTest=new DataSet();
sadTest.Fill(dsTest);
Session["Table"]=dsTest.Tables[0];
DataGrid1.DataSource=dsTest.Tables[0].DefaultView;
DataGrid1.DataBind();
}
}