private void btnGetData_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Server=(local);Integrated Security=SSPI;Initial Catalog=Northwind");
conn.Open();
DataSet da = new DataSet();
SqlDataAdapter custDa = new SqlDataAdapter("select * from Customers", conn);
SqlDataAdapter ordersdAa = new SqlDataAdapter("select * from Orders", conn);
custDa.Fill(da, "Customers");
ordersdAa.Fill(da, "Orders");
DataRelation dr = new DataRelation("CustOrders", da.Tables["Customers"].Columns["CustomerID"], da.Tables["Orders"].Columns["CustomerID"]);
da.Relations.Add(dr);
dgCustomers.DataSource = da;
dgCustomers.DataMember = "Customers";
dgOrders.DataSource = da;
dgOrders.DataMember = "Customers.CustOrders";
BindingContext [dgCustomers .DataSource ,"Customers"].CurrentChanged+=new EventHandler(frmAdvGridBinding_CurrentChanged);
} private void frmAdvGridBinding_CurrentChanged(object sender, EventArgs e)
{
CurrencyManager cm = (CurrencyManager)BindingContext[dgCustomers.DataSource, "Customers"];
DataRowView drv = (DataRowView)cm.Current;
//dgOrders.CaptionText = string.Format("{0}is order history", drv["ContactName"]);
}
问题1:CurrencyManager cm = (CurrencyManager)BindingContext[dgCustomers.DataSource, "Customers"];系统提示值不能为空??使用new创建新的实例??
问题2:在vs2005ZO中DataGridView的CaptionText在窗体属性中怎么找不到??或者还是如何设置?
{
SqlConnection conn = new SqlConnection("Server=(local);Integrated Security=SSPI;Initial Catalog=Northwind");
conn.Open();
DataSet da = new DataSet();
SqlDataAdapter custDa = new SqlDataAdapter("select * from Customers", conn);
SqlDataAdapter ordersdAa = new SqlDataAdapter("select * from Orders", conn);
custDa.Fill(da, "Customers");
ordersdAa.Fill(da, "Orders");
DataRelation dr = new DataRelation("CustOrders", da.Tables["Customers"].Columns["CustomerID"], da.Tables["Orders"].Columns["CustomerID"]);
da.Relations.Add(dr);
dgCustomers.DataSource = da;
dgCustomers.DataMember = "Customers";
dgOrders.DataSource = da;
dgOrders.DataMember = "Customers.CustOrders";
BindingContext [dgCustomers .DataSource ,"Customers"].CurrentChanged+=new EventHandler(frmAdvGridBinding_CurrentChanged);
} private void frmAdvGridBinding_CurrentChanged(object sender, EventArgs e)
{
CurrencyManager cm = (CurrencyManager)BindingContext[dgCustomers.DataSource, "Customers"];
DataRowView drv = (DataRowView)cm.Current;
//dgOrders.CaptionText = string.Format("{0}is order history", drv["ContactName"]);
}
问题1:CurrencyManager cm = (CurrencyManager)BindingContext[dgCustomers.DataSource, "Customers"];系统提示值不能为空??使用new创建新的实例??
问题2:在vs2005ZO中DataGridView的CaptionText在窗体属性中怎么找不到??或者还是如何设置?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货