Passing Value between forms

Question

2.09/5 (4 votes)

See more:

Hello Experts .

Login Form Code :

C#

con.Open();
OleDbCommand cmd = new OleDbCommand("SELECT * From Admin Where EmployeeID = '" + LogId.Text.Trim() + "' AND Category = '" + CbCat.SelectedItem.ToString() + "' AND Designation = '" + CbDesignationAdmin.SelectedItem.ToString() + "' AND FinYear1 = '" + CbFinYr1.SelectedItem.ToString() + "' AND FinYear2 = '" + CbFinYr2.SelectedItem.ToString() + "' AND Emp_Password = '" + Password.Text.Trim() + "'  ", con);

OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
con.Close();
if (dt.Rows.Count == 0)
{
   MessageBox.Show("Wrong Login Id And Password ?");
   return;
}
else
{
   MessageBox.Show("Mr " + dt.Rows[0][4].ToString() + " :: You are Successfully Login ");
   MasterAdminForm maf = new MasterAdminForm();
   maf.Show();
   this.Hide();
}

New Form Open Code :

C#

con.Open();
OleDbCommand cmd = new OleDbCommand("SELECT * From Admin ", con);
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
con.Close();
if (dt.Rows.Count != 0)
{
   label1.Text = "Welcom Mr :  " + dt.Rows[0][3].ToString();
   label1.BackColor = Color.Black;
   label1.ForeColor = Color.White;
}

Here is problem in AdminMasterForm I Show Value In For hard core value

But in New Form It Show problem For fatching table Value Onthe basic of specific Id Like Admin .

C#

query = "SELECT * From Admin Where EmployeeID = '"+ LoginId.Text.ToString()+"' "

Like This

[edit]Code block added and indexation reduced[/edit]

Posted 18-Feb-14 0:46am

Rohit85

Updated 18-Feb-14 5:12am

agent_kruger

v5

Add a Solution

Comments

ZurdoDev 18-Feb-14 7:00am

How can we help?

Rohit85 18-Feb-14 7:05am

Dear problem i m doing with window forms ............two different window i m unable to display table information in specific forms whic will be open

ZurdoDev 18-Feb-14 7:11am

Why can't you display it?

Rohit85 18-Feb-14 9:29am

problem to fatch table information according to login id but i m unable to find login id in New form which is opened

ZurdoDev 18-Feb-14 9:32am

You did a select * from admin without any where clause. You need to be much more clear as to where you are stuck.

BillWoodruff 18-Feb-14 9:28am

The code you posted does not show any presentation of some TextBox where a user would enter their username, and password. Without knowing where that code is, and seeing what happens after the user tries to log-in, I don't see any way we can help you.

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Killer Coder · Answer 1 · 2014-02-18T01:02:00

Solution 1

Hi Rohit,

As per your above question here it is not too much clear point that what you are exactly doing and what happened?

Ok but up to my understanding On the LOG in form just put the entered log in ID in session var and use that var to load further pages or respective data.

and here put your error what you are facing with stack trace.

Warm Regards,
Coder.

Posted 18-Feb-14 1:02am

Killer Coder

Comments

Krunal Rohit 18-Feb-14 10:28am

How come Session works in Forms Applications ?
-KR

Killer Coder 19-Feb-14 8:50am

Yap sure, I haven't noticed that you are talking about windows form!!!
I mean you have to use the properties as like of application level variable.
e.g.
Just create a static class which contains the required properties to store your logged in user ID & use this property on other page to fetch the value.

public static class MyGlobals
{
public static string LoggedUserId = "A00123";
}

public class YourClass
{

private void Method1()
{
//in below UserId you will get logged in user ID.
string UserId = MyGlobals.Global1;
//etc
}
}

Try it...:)

bunzitop · Answer 2 · 2014-02-18T03:51:00

You can save the username in a static variable, so that you can access it from next form easily.

in the second form declare static Property

public static string LoginName {get; set;}

then in login form On button Ok /Login Click Event

form2.LoginName= LoginId.Text;

Now you can write your query in second form as

query = "SELECT * From Admin Where EmployeeID = '"+ LoginName +"' "

Krunal Rohit · Answer 3 · 2014-02-18T04:15:00

As you have not described your problem correctly, I came to this conclusion from your subject that you're passing the data between forms.

Regardless of your problem, there are 2 ways of doing that (basics of C#):
1.) Pass the values through constructor
2.) Make a property (get; set;) and call that by instance of the particular form

Here I'm showing you how to pass the data using ctor.
First Form

C#

button_click(...)  // Button Click Event
{
    string userName = "admin";
    SecondForm sf = new SecondForm(userName);
    sf.Show();
}

Second Form

C#

string userName;
public SecondForm(string userName)   // Ctor of second form
{
    this.userName = userName;
    lbl.Text = userName;
}

-KR

Passing Value between forms

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0