need to retreave data

Question

chathuD -7 Junior Poster

15 Years Ago

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace stp
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection("Data Source=.\\SQLEXPRESS;Initial Catalog=ex;Integrated Security=True;Pooling=False");

            SqlCommand sqlcmd = new SqlCommand("dbo.AddUser", con);
            sqlcmd.CommandType = CommandType.StoredProcedure;
            sqlcmd.Parameters.AddWithValue("@Username", textBox1.Text);
            sqlcmd.Parameters.AddWithValue("@Password", textBox2.Text);
            try
            {
                con.Open();
                sqlcmd.ExecuteNonQuery();
            }
            catch (Exception ee)
            {
                MessageBox.Show(ee.Message.ToString());
            }
            finally
            {
                con.Close();
                /*
                 ochcharai neda?
                 * 
                 
                 */
            }
        }
    }
}

this is the code that i have made using stored procedure to add to text box values to a database.And now i need to retreav them one by one .(it means in a another form if i enter the user name and pres a button i must get the user name and the password to another new 2 texboxes)thanx

5 Contributors
23 Replies
406 Views
3 Days Discussion Span
Latest Post 15 Years Ago Latest Post by chathuD

jbisono 51 Posting Pro in Training

15 Years Ago

First you do not need to retrieve the username because is given as parameter. base on what you said.
Under the button search click event you will have a code like this.

SqlConnection con = new SqlConnection("Data Source=.\\SQLEXPRESS;Initial Catalog=ex;Integrated Security=True;Pooling=False");
/*This only work if you are going to retrieve just the password otherwise you will need a dataset or datareader.*/
SqlCommand sqlcmd = new SqlCommand("Select Password from YourTable Where UserName = '"+textBox1.Text+"'", con);
con.Open();
textBox2.Text = Convert.ToString(sqlcmd.ExecuteScalar());
con.Close();

sknake 1,622 Senior Poster

15 Years Ago

More or less, but you should be using parameterized queries.

Ramesh S 129 Posting Pro

15 Years Ago

if i need to retreave mor than one valu (lets say pasword and the first name ) is this code correct.
SqlCommand sqlcmd = new SqlCommand("Select Password,firstname from <Table name> Where UserName = '"+textBox1.Text+"' first name = '"+textBox2.Text+", con);

You are fetching password and first name based on user name. Therefore the WHERE condition need not to have first name.

It should look like SqlCommand sqlcmd = new SqlCommand("Select Password,firstname from <Table name> Where UserName = '"+textBox1.Text+"' , con);

jbisono 51 Posting Pro in Training

15 Years Ago

Yes the above select statement is correct, but remember you will need a dataset or datareader to fetch more than one column as follow.

SqlCommand sqlcmd = new SqlCommand("Select Password,firstname from <Table name> Where UserName = '"+textBox1.Text+"'", con);
con.Open();
SqlDataReader dr = sqlcmd.ExecuteReader();
While(dr.Read())
{
TextBox2.Text = dr.GetString(0);
TextBox3.Text = dr.GetString(1);
}
dr.Close();
con.Close();

Regards

jbisono 51 Posting Pro in Training

15 Years Ago

Check this thread http://www.daniweb.com/forums/thread190964.html and let me know.

regards.

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

chathuD -7 Junior Poster · Answer 1 · 2009-07-14T21:46:42+00:00

chathuD -7 Junior Poster

15 Years Ago

thanxxxxxx

chathuD -7 Junior Poster · Answer 2 · 2009-07-15T03:12:47+00:00

First you do not need to retrieve the username because is given as parameter. base on what you said.
Under the button search click event you will have a code like this.

SqlConnection con = new SqlConnection("Data Source=.\\SQLEXPRESS;Initial Catalog=ex;Integrated Security=True;Pooling=False");
/*This only work if you are going to retrieve just the password otherwise you will need a dataset or datareader.*/
SqlCommand sqlcmd = new SqlCommand("Select Password from YourTable Where UserName = '"+textBox1.Text+"'", con);
con.Open();
textBox2.Text = Convert.ToString(sqlcmd.ExecuteScalar());
con.Close();

if i need to retreave mor than one valu (lets say pasword and the first name ) is this code correct.

SqlCommand sqlcmd = new SqlCommand("Select Password,firstname from <Table name> Where UserName = '"+textBox1.Text+"' first name = '"+textBox2.Text+", con);

chathuD -7 Junior Poster · Answer 3 · 2009-07-15T22:45:25+00:00

thanxx

and now i need to create a simple login form from these detail.

In a buttton click i need to check whether textbox1's(user name) value is in the data base 's user name field.
and text box2's valu (password) is in the same database's password field.

if the user name and password are maching textbx.show().

so how can i do this

chathuD -7 Junior Poster · Answer 4 · 2009-07-16T02:08:49+00:00

private void button3_Click(object sender, EventArgs e)
        {

            SqlConnection con = new SqlConnection("Data Source=.\\SQLEXPRESS;Initial Catalog=ex;Integrated Security=True;Pooling=False");
            
               
                   SqlCommand sqlcmd = new SqlCommand("select * from Users", con);
                 
                   con.Open();

                   SqlDataReader reader = sqlcmd.ExecuteReader();

                   reader.Read();

                   if ((reader(0) = textBox7.Text) && (reader(1) = textBox8.Text))
                   {
                       Form2 fr2 = new Form2();
                       fr2.Show();
                   }

                   else
                       MessageBox.Show("a");

by looking at the postes topic i tryed for this kind of method.but it gives me errors

sknake 1,622 Senior Poster Featured Poster · Answer 5 · 2009-07-16T02:11:09+00:00

Please use code tags when posting code -- and what errors are you getting?

jbisono 51 Posting Pro in Training · Answer 6 · 2009-07-16T18:12:00+00:00

Something like this.

OleDbDataReader dr;
OleDbCommand cmd = New OleDbCommand("select * from login where id= '"+txtUser.Text+"' and pass='"+txtPwd.Text+"'", conn);
        dr = cmd.ExecuteReader();
        if(dr.HasRows)
            Form2.Show();
        Else
{
            txtUser.Clear();
            txtPwd.Clear();
            txtUser.Focus();
}

regards

lighthead 55 Junior Poster in Training · Answer 7 · 2009-07-16T20:15:27+00:00

I suppose this is your problem.

if ((reader(0) = textBox7.Text) && (reader(1) = textBox8.Text))
                   {
                       Form2 fr2 = new Form2();
                       fr2.Show();
                   }

Which should have been.

if ((reader[0].ToString().Equals(textBox7.Text) && (reader[1].ToString().Equals(textBox8.Text)))
                   {
                       Form2 fr2 = new Form2();
                       fr2.Show();
                   }

And you might want to use

if(reader.Read())
{
//code to read here.
}

chathuD -7 Junior Poster · Answer 8 · 2009-07-16T22:24:00+00:00

private void button3_Click(object sender, EventArgs e)
        {

            SqlConnection con = new SqlConnection("Data Source=.\\SQLEXPRESS;Initial Catalog=ex;Integrated Security=True;Pooling=False");
            
               
                   SqlCommand sqlcmd = new SqlCommand("select * from Users", con);
                 
                   con.Open();

                   SqlDataReader reader = sqlcmd.ExecuteReader();

                   reader.Read();

                   if ((reader(0) = textBox7.Text) && (reader(1) = textBox8.Text))
                   {
                       Form2 fr2 = new Form2();
                       fr2.Show();
                   }

                   else
                       MessageBox.Show("a");

by looking at the postes topic i tryed for this kind of method.but it gives me errors

NO ANY comments..

chathuD -7 Junior Poster · Answer 9 · 2009-07-16T23:17:04+00:00

private void button3_Click(object sender, EventArgs e)
        {

            SqlConnection con = new SqlConnection("Data Source=.\\SQLEXPRESS;Initial Catalog=ex;Integrated Security=True;Pooling=False");
            SqlCommand sqlcmd = new SqlCommand("select * from Users", con);
                 
            con.Open();
            SqlDataReader reader = sqlcmd.ExecuteReader();
            reader.Read();

 
              if ((reader[0].ToString().Equals(textBox7.Text) && (reader[1].ToString().Equals(textBox8.Text))))
                    {
                Form2 fr2 = new Form2();
                fr2.Show();
                    }
              else
              {
                  MessageBox.Show("QAW");
              }
       
            
        }

I TRYED for this ,,,,but not workin.and when de bug the if condition i ckek that the texbox values are catch by the if condition.but the fr2.show() is not working

lighthead 55 Junior Poster in Training · Answer 10 · 2009-07-16T23:22:00+00:00

Are you getting error or are you getting a different result. Post some details so that we can help.

chathuD -7 Junior Poster · Answer 11 · 2009-07-16T23:29:43+00:00

no i didnt get errors.only thing hapen is wen i click the button the form is doing nothing..
i wll upload the application to some place and publish the link

chathuD -7 Junior Poster · Answer 12 · 2009-07-16T23:50:00+00:00

http://www.mediafire.com/?sharekey=0d482638ea4b7c6edd8b33b5aa27078d

lighthead 55 Junior Poster in Training · Answer 13 · 2009-07-17T00:33:59+00:00

Your code is working fine. When you login the second form is being shown.
Make the uid unique in the database. As you have have two entries in your database for same uid it might be producing problems.

chathuD -7 Junior Poster · Answer 14 · 2009-07-17T01:52:34+00:00

NOOP...this code is not working.i need to do is when i press the log in buttton on the bottom a new form 2 window must be open.
but always i get the "QAW" message box.that mesage box is on the else part of the if condition.

lighthead 55 Junior Poster in Training · Answer 15 · 2009-07-17T01:59:09+00:00

Ya, its is working . Use a break in else part see the values of the data returned. And did you correct the problem mentioned in my earlier post.

jbisono 51 Posting Pro in Training · Answer 16 · 2009-07-17T02:00:47+00:00

why dont you pass the login parameters in the select statement and if datareader has any rows it means that user exist.

chathuD -7 Junior Poster · Answer 17 · 2009-07-17T16:26:25+00:00

YOU PPL ARE TELING THE LOGIN BUTTON SHOWS THE 2nd formm..????let me rebuild againn

chathuD -7 Junior Poster · Answer 18 · 2009-07-17T17:19:10+00:00

that is not eorking guys.......the form2 is not shown to me when i click the login button.only i can see is the message box saying "QAW"

..........what must i do