dataset11为Dataset1.xsd的对象,请问Dataset1.xsd是属于什么类型的?
//Dataset1 dataset11 = new Dataset1();
dataset11只包含数据表与字段结构的描述,没有实际的数据。如何填充数据呢?
private void button1_Click(object sender, System.EventArgs e)
{
SqlConnection cn =new SqlConnection();
cn.ConnectionString="Persist Security Info=False;uid=sa;password=;Server=127.0.0.1;database=bank";
try
{
SqlDataAdapter da =new SqlDataAdapter("select top 1500 * from proEmployee",cn);
da.Fill(this.dataset11,"proEmployee");
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
}
成功了,可以通过与this.dataset11邦定的控件显示数据。
private void button2_Click(object sender, System.EventArgs e)
{
SqlConnection cn =new SqlConnection();
cn.ConnectionString="Persist Security Info=False;uid=sa;password=;Server=127.0.0.1;database=bank";
try
{
DataSet ds = new DataSet();
SqlDataAdapter da =new SqlDataAdapter("select top 1500 * from proEmployee",cn);
da.Fill(ds,"proEmployee");
this.dataset11 = ds;//出错了提示类类型不一样。DataSet类开不能隐式转成dataset11类型?如何做呀?
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
}
单用Fill的方法填充数据并不满足要求呀!!!如果把已有的DataSet数据赋给Dataset1.xsd的对象(dataset11)如何做呀???
//Dataset1 dataset11 = new Dataset1();
dataset11只包含数据表与字段结构的描述,没有实际的数据。如何填充数据呢?
private void button1_Click(object sender, System.EventArgs e)
{
SqlConnection cn =new SqlConnection();
cn.ConnectionString="Persist Security Info=False;uid=sa;password=;Server=127.0.0.1;database=bank";
try
{
SqlDataAdapter da =new SqlDataAdapter("select top 1500 * from proEmployee",cn);
da.Fill(this.dataset11,"proEmployee");
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
}
成功了,可以通过与this.dataset11邦定的控件显示数据。
private void button2_Click(object sender, System.EventArgs e)
{
SqlConnection cn =new SqlConnection();
cn.ConnectionString="Persist Security Info=False;uid=sa;password=;Server=127.0.0.1;database=bank";
try
{
DataSet ds = new DataSet();
SqlDataAdapter da =new SqlDataAdapter("select top 1500 * from proEmployee",cn);
da.Fill(ds,"proEmployee");
this.dataset11 = ds;//出错了提示类类型不一样。DataSet类开不能隐式转成dataset11类型?如何做呀?
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
}
单用Fill的方法填充数据并不满足要求呀!!!如果把已有的DataSet数据赋给Dataset1.xsd的对象(dataset11)如何做呀???
-----------------------------------------------------------------------------------
肯定不行啊,左边是Dataset1类型,右边是Dataset类型,怎么能赋值呢?
试试
this.dataset11 = (Dataset1)ds;
-----------------------------------------------------------------------------------
肯定不行啊,左边是Dataset1类型,右边是Dataset类型,怎么能赋值呢?
试试
this.dataset11 = (Dataset1)ds;
这也不行呀。