通过dataGrid绑定的dataSet操作即可
或者用下面的方法(但也用到dataGrid绑定的dataSet)
private void button1_Click(object sender, System.EventArgs e)
{
string strContent = null;
//datSet11是dataGrid绑定的dataSet
int iRow = this.dataSet11.Tables[0].Rows.Count;
int iCol = this.dataSet11.Tables[0].Columns.Count;
for(int i=0;i<iRow;i++)
{
for(int j=0;j<iCol;j++)
{
strContent += this.dataGrid1[i,j].ToString() + ",";
}
}
Debug.WriteLine(strContent);
}
或者用下面的方法(但也用到dataGrid绑定的dataSet)
private void button1_Click(object sender, System.EventArgs e)
{
string strContent = null;
//datSet11是dataGrid绑定的dataSet
int iRow = this.dataSet11.Tables[0].Rows.Count;
int iCol = this.dataSet11.Tables[0].Columns.Count;
for(int i=0;i<iRow;i++)
{
for(int j=0;j<iCol;j++)
{
strContent += this.dataGrid1[i,j].ToString() + ",";
}
}
Debug.WriteLine(strContent);
}
DataTable dtTemp = (DataTable)dataGrid1.DataSource;
string strCellsText = "";
for(int i = 0; i < dtTemp.Rows.Count; i++)
{
for(int j = 0; j < dtTemp.Columns.Count; j++)
{
strCellsText += dataGrid1[i,j] + ",";
}
}
if(strCellsText.Length > 0)
{
strCellsText = strCellsText.Substring(0,strCellsText.Length - 1);
}
MessageBox.Show(strCellsText);
其它的自己改变一下代码即可
private void button2_Click(object sender, System.EventArgs e)
{
string strConn="Password=;Persist Security Info=True;User ID=sa;Initial Catalog=XSCJ;Data Source=(local)";
SqlConnection objConn=new SqlConnection(strConn);
string sql="select * from xs";
objConn.Open();
SqlCommand objComm=new SqlCommand(sql,objConn);
SqlDataAdapter objAd=new SqlDataAdapter();
objAd.SelectCommand=objComm;
DataSet data=new DataSet();
objAd.Fill(data,"xs"); for(int i=0;i<data.Tables["xs"].Rows.Count;i++)
{
for(int u=0;u<data.Tables["xs"].Columns.Count;u++)
{
textBox1.Text=data.Tables["xs"].Rows[i][u].ToString()+","+textBox1.Text.ToString();
}
}
}
这样去取出来的记录是反的 你只要改一哈 就 可以了