c# - Retrieving data from SQL server 2008r2 using winforms -

i creating c# windows form app, retrieve data db created in sql server2008r2. there 2 win forms in app, 1st 1 getting login details, 2nd 1 display data relevant given userid & password. can't data 2nd form. code:

*******1st form****

 public partial class formlog_in : form  {     sqlconnection con = new sqlconnection("data source=chinthak-pc ; initial catalog=flintectest; integrated security = yes;");     sqldataadapter da = new sqldataadapter();     sqlcommand cmd = new sqlcommand();      public formlog_in()     {         initializecomponent();     }      private void btnlogin_click(object sender, eventargs e)     {         if (!(string.isnullorempty(txtusername.text)) && !(string.isnullorempty(txtpassword.text)))         {             con.open();             string query = "select count(*) login  uesrname=@1 , password=@2 ";             cmd = new sqlcommand(query, con);             cmd.parameters.add("@1", sqldbtype.nvarchar).value = txtusername.text;             cmd.parameters.add("@2", sqldbtype.nvarchar).value = txtpassword.text;             int count = convert.toint32(cmd.executescalar());             con.close();              if (count > 0)             {                 messagebox.show("valid username , password");                 welcome f1 = new welcome();                 f1.show();              }             else                 messagebox.show("invalid username or password try again");         } 

*****2nd form**

public partial class welcome : form {     string query = null;      sqlconnection con = new sqlconnection("data source=chinthak-pc ; initial catalog=flintectest; integrated security = yes;");     sqldataadapter da = new sqldataadapter();     bindingsource usertable = new bindingsource();     dataset ds = new dataset();      public welcome()     {         initializecomponent();      }      private void welcome_load(object sender, eventargs e)     {         query = "select *  users username=@x , users.password=@y ";//x should given username current login         da.selectcommand = new sqlcommand(query, con);                          //y should given password current login         ds.clear();         da.fill(ds, "usr");         usertable.datasource = ds.tables["usr"];          txtfristname.databindings.add(new binding("text", usertable, "firstname"));         txtlastname.databindings.add(new binding("text", usertable, "lastname"));         txtaddress.databindings.add(new binding("text", usertable, "address"));         txttelephone.databindings.add(new binding("text", usertable, "telephone"));         txtemail.databindings.add(new binding("text", usertable, "email"));         txtfax.databindings.add(new binding("text", usertable, "fax"));         txtsection.databindings.add(new binding("text", usertable, "section"));         txtposition.databindings.add(new binding("text", usertable, "position"));     } } 

why not not change constructor in welcome form receive parameters.

 public welcome(string usr, string pword) {     initializecomponent();     this.username=usr;     this.password=pword; // should have form of encryption password } 

so, when call, do:

welcome f1 = new welcome(txtusername.text,txtpassword.text); 

and add properties in welcome form like:

private string username { get; set; } private string password { get; set; } 

then add 2 parameters in welcome form load:

cmd.parameters.add("@x", sqldbtype.nvarchar).value = username; cmd.parameters.add("@y", sqldbtype.nvarchar).value = password;