How to pass data to DataGrid
I am new to C#, I create a WinApp with FormMain.cs & userControl.cs. userControl add to left panel of FormMain, and dataGrid1 add to right. When I click on btn_search and I get a run time error "Null Reference Exception was unhandled". How can I pass the search result to right side dataGrid1?
in userControl.cs
...
void btn_search_Click(object sender, System.EventArgs e)
{
...
ora_Connect(sql);
}
void ora_Connect(string strSql)
{
// Create and open a new connection
m_connection = new OracleConnection("Host=vmtestxport=1521;SID=xe;User ID=abcassword=abc");
m_connection.Open();
adapter = new OracleDataAdapter(strSql, m_connection);
cb = new OracleCommandBuilder(adapter);
dataSet = new DataSet("DS");
adapter.Fill(dataSet, "TABLE");
_dataGrid1.SetDataBinding(dataSet,"TABLE");
}
private System.Windows.Forms.DataGrid _dataGrid1;
public DataGrid dataGrid1_Temp
{
get
{
return _dataGrid1;
}
set
{
_dataGrid1 = value;
}
}
....
in FormMain.cs
usercontrol dc = new usercontrol();
void frmMain_Load(object sender, System.EventArgs e)
{
dc.dataGrid1_Temp = this.dataGrid1;
}
