c# 提示表没有主键
刚学c# 遇到这个问题搜都搜不到 希望各位路过的大虾能解答
using System;
using System.Data;
using System.Text;
using System.Windows.Forms;
using System.Data.Odbc;
namespace Test
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
OdbcConnection conn;
DataSet ds;
OdbcDataAdapter sda;
private void Form1_Load(object sender, EventArgs e)
{
conn = new OdbcConnection("dsn=shushu");
OdbcCommand cmd = new OdbcCommand("select * from stu", conn);
sda = new OdbcDataAdapter();
sda.SelectCommand = cmd;
ds = new DataSet();
sda.Fill(ds, "stu");
dataGridView1.DataSource = ds.Tables[0];
}
private void button1_Click(object sender, EventArgs e)
{
DataTable dt = ds.Tables["stu"];
sda.FillSchema(dt, SchemaType.Mapped);
DataRow dr = dt.Rows.Find(txtNo.Text); //提示没有主键
dr["sname"] = this.txtName.Text.Trim();
dr["grade"] = this.txtAge.Text.Trim();
OdbcCommandBuilder cmdbuider = new OdbcCommandBuilder(sda);
sda.Update(dt);
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
txtNo.Text = dataGridView1.SelectedCells[0].Value.ToString();
txtName.Text = dataGridView1.SelectedCells[1].Value.ToString();
txtgrade.Text = dataGridView1.SelectedCells[2].Value.ToString();
}
}
}
[解决办法]
看看你建的表有没有主键嘛~最近也是正在学习c#，这么好的贴，可不能沉了啊！
[解决办法]
[code=C#]
DataTable dt = GetDataSource();
dt.PrimaryKey=new DataColumn[] {dt.Columns[0]};//设置第一列为主键
DataRow row = dt.Rows.Find( "101 ");//获取DataTable中主键值为101的一行数据
JScript.Alert(this, row[0].ToString());//弹出获取行的第一列的值
[/code]
