how to check the values in the table which is avail or not in sql?

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

for login.... i entered the values as rollno in the registration table. how could i chek the input for login, entering rollno with the values present in the registration table?

Posted 25-Dec-11 23:11pm

riodejenris

Add a Solution

5 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)

Rethinaprasath · Answer 1 · 2011-12-25T23:58:00

C#

private void txtCourseName_Leave(object sender, EventArgs e)
        {
            SqlCon = DBCon.DBOpenConnection();
            Query = "Select distinct Name from tblDepartmentMaster";
            SqlCmd = new SqlCommand(Query, SqlCon);
            SqlDr = SqlCmd.ExecuteReader();
            while (SqlDr.Read())
            {
                txtName.Text = SqlDr.GetString(0).ToString();
            }
            MessageBox.Show("Already Exist the Name!", "Already Exist", MessageBoxButtons.OK, MessageBoxIcon.Information);
            txtCourseName.Clear();
            ActiveControl = txtCourseName;

            SqlDr.Close();

        }

Anil Honey 206 · Answer 2 · 2011-12-26T00:14:00

C#

if (btnSave.Text == "Save")
        {
            SqlCommandBuilder cmdbSection;
            DataRow newrow;
            ds = new DataSet();
            ad = new SqlDataAdapter("select strTestName from PEHMstTest where strTestName='" + txttestname.Text + "'", SqlCon);
            ad.Fill(ds);
            if (ds.Tables[0].Rows.Count == 0)
            {
                DataSet ds1 = new DataSet();
                SqlDataAdapter ad1 = new SqlDataAdapter("select * from PEHMstTest", SqlCon);
                ad1.Fill(ds1);
                newrow = ds1.Tables[0].NewRow();
                newrow[0] = new_num();
                newrow[1] = txttestname.Text;
                newrow[2] = txtcharges.Text;

                ds1.Tables[0].Rows.Add(newrow);
                cmdbSection = new SqlCommandBuilder(ad1);
                ad1.Update(ds1);

                lblMsg.ForeColor = Color.Green;
                lblMsg.Text = "Records saved successfully";
            }
            else
            {
                lblMsg.ForeColor = Color.Red;
                lblMsg.Text = "Test Detail Already Exists, Give a different name.";
            }
           
        }

[edit]added pre tag[/edit]

Anil Honey 206 · Answer 3 · 2011-12-26T00:19:00

C#

DataSet ds = new DataSet();
            SqlDataAdapter ad = new SqlDataAdapter("select * from technicalregistration where strloginname='" + txtusername.Text + "' and strloginpwd='" + txtpassword.Text + "'", sqlcon);
            ad.Fill(ds);
            if (ds.Tables[0].Rows.Count > 0)
            {
                Response.Redirect("Somepage.aspx");
            }
            else
                lblmessage.Text = "Invalid UserName and Password";

            txtusername.Text = "";
            txtpassword.Text = "";

You can go for this

[Edit]added pre tag[/Edit]

Abhinav S · Answer 4 · 2011-12-25T23:19:00

Solution 1

write a simple query with a where clause for the roll no.
If the query returns a result, there is a row for that roll number in the table.

e.g.
select * from registration where rollno = ??

Posted 25-Dec-11 23:19pm

Abhinav S

Comments

riodejenris 26-Dec-11 5:21am

poi savu da....

AmitGajjar 26-Dec-11 7:42am

please avoid non-english language...

chetan virkar · Answer 5 · 2011-12-26T01:36:00

Solution 5

if exists (select rollno from register table where condition)

it will return true if roll exists in table for that login

return false if not.

Posted 26-Dec-11 1:36am

chetan virkar

how to check the values in the table which is avail or not in sql?

5 solutions

Solution 2

Solution 3

Solution 4

Solution 1

Solution 5

Add your solution here

Preview 0