Referencing Event

mahmud_uk

Hi Guys I have two Forms. In form1 there are two textBoxes, i'm trying to refrence these two textBoxes in Form2. I'm having problem refrencing them. I need to call these two textBoxes inorder to authenticate users. Both these textBoxes have been made public. Also i have tabPages in form2,from tabPage2, by a click of a button i'm trying to pen tabPage3, but having problem with this too. This is mainly due to authentication problem. Heres the code: private void button1_Click(object sender, System.EventArgs e) { SqlConnection da = new SqlConnection( @"Data Source= xxxxxx;"+ "Initial Catalog = xxxx;" + "Network Library=DBMSSOCN;"+ "user id =xx;"+ "Password=xxxx"); da.Open(); SqlCommand thisCommand = da.CreateCommand(); tabPage3.Show(); String sQuery = "SELECT Name, LicenseID FROM License WHERE Name = '"+ Form1.textBox1.Text +"' AND LicenseID = '"+ Form1.textBox2.Text +"'"; SqlCommand cmd = new SqlCommand(sQuery, da); SqlDataReader dr = cmd.ExecuteReader(); if(dr.Read()){ tabPage3.Show(); label3.Text = dr[ "Name" ].ToString();} da.Close(); } What do i need to do inorder to solve this scenario. Thanks,

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

mahmud_uk22y ago
With the above code, your putting a value in to textBox (hello), but in form2 to i'm trying to retrive the value already inserted in textBoxes from form1, in order to us ethe values to authenticate users in form2. Thanks, Anyway.
0
moshea22y ago
IT WORKS! FORM1 private void button1_Click(object sender, System.EventArgs e) { TextBox text=textBox1; WindowsApplication5.Form2 f; f= new Form2(); f.func(text); } FORM2 public void func(TextBox sender1) { sender1.Text="Hello"; }
0
mahmud_uk22y ago
Tried this still, cannot refrence the textBoxes in form2. There's nothing wrong with the SQL command, as the SQL functions perfectly somewhere else. Any other solutions. Thanks
0
moshea22y ago
friend pass the two text boxes as object to a custom function in form2.cs.where u can do any thing you like form1 private void button1_Click(object sender, System.EventArgs e) { form2.funcky(textbox1,textbox2) --- - - - } form2 funky(Textbox x,textbox y ) { }
0
madinewala22y ago
Hi, I guess you are not using 'thisCommand' variable you created. Revisit the logic. HTH irfan
0