不支持关键字:'pdata source"
本文关键字:pdata source quot 关键字 不支持 | 更新日期: 2023-09-27 18:11:46
"Keyword not supported:'pdata source"是什么意思?我正在努力找出问题到底是什么?
InitializeComponent();
connString = "PData Source=.''SQLEXPRESS;AttachDbFilename=C:''Users'andrew''Documents''Vinyl0.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
query = "SELECT * FROM Record";
dAdapter = new SqlDataAdapter(query, connString);
dTable = new DataTable();
cBuilder = new SqlCommandBuilder(dAdapter);
cBuilder.QuotePrefix = "[";
cBuilder.QuoteSuffix = "]";
myDataView = dTable.DefaultView;
dAdapter.Fill(dTable);
BindingSource bndSource = new BindingSource();
bndSource.DataSource = dTable;
this.dataGridView1.DataSource = bndSource;
for (int q = 0; q <= dataGridView1.ColumnCount - 1; q++)
{
您的连接字符串不正确。
将PData Source
改为Data Source
或Server
,应该没问题。
请参阅构建连接字符串文章和本文,以了解基于版本/数据适配器的连接字符串的构造。
您的连接字符串有打字错误。应该是
connString = "Data Source=.''SQLEXPRESS;AttachDbFilename=C:''Users''andrew''Documents''Vinyl0.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
^----- not "PData Source"
看起来您的SqlDataAdapter
不识别PData
字段。
我也不认识它,你有没有试过去掉写着PData
的部分?