hai, when i working with windows apllication i got following runtime error:
Object reference is not to set an instance of object :
at cmb_eno.Items.A dd(dr[0]).can any one help me?
Object reference is not to set an instance of object :
at cmb_eno.Items.A dd(dr[0]).can any one help me?
Code:
namespace WindowsApplication1
{
public partial class Form1 : Form
{
SqlConnection con;
SqlDataAdapter da;
DataSet ds;
DataTable dt;
public Form1()
{
con = new SqlConnection();
con.ConnectionString = " Data Source=SIVA-496EA1B239\\SQLEXPRESS;Initial Catalog=Inventory;Persist Security Info=True;User ID=sa;Password=abcd1234";
da = new SqlDataAdapter("select * from emp", con);
ds = new DataSet();
da.Fill(ds, "emp");
dt = ds.Tables[0];
fillcombobox();
InitializeComponent();
}
void fillcombobox()
{
DataRow[] drs = dt.Select(null);
foreach (DataRow dr in drs)
{
cmb_eno.Items.Add(dr[0].ToString());
}
}
public void bt_get_Click(object sender, EventArgs e)
{
DataRow[] drs = dt.Select(null);
string str = " ";
foreach (DataRow dr in drs)
{
str += dr[0] + "\t";
str += dr[1] + "\t";
str += dr[2] + "\n";
}
MessageBox.Show(str);
}
private void eno_cmb_SelectedIndexChanged(object sender, EventArgs e)
{
DataRow[] drs = dt.Select("Empno = " + eno_cmb.Text);
DataRow dr = drs[0];
ename_txt.Text= dr["empname"].ToString();
esalary_txt.Text = dr["empsalary"].ToString();
}
}
}
Comment