How to compare column values in database with textbox value

leathu raj

Hi,
In my code i want to get values from database based on my textbox value which is greater than that textbox values and display it to another three label
For example in my database
I have fields like,
amount          name
    1000 bag

2000 watch
3000 mobile

From this if my textbox value is 1000 it will get 2000 and 3000 and display it to two labels respectively.....

Please help.....
Thanks in advance

8 Replies

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

Anupam Singh12y ago
Accepted answer
Yes why not;
and its no need to use datatable if there are only 2 values.
you can try :

using (SqlCommand cmd = new SqlCommand("select gift_points from gift_entry where gift_points >'" + Convert.ToInt32(txt_rewardpoints.Text.Trim()) + "'", con))
{
int i=0;
SqlDataReader reader = cmd .ExecuteReader();
while (reader.Read())
{
if(i==0)
lbl1.Text = reader.GetInt32(0);
else
lbl2.Text = reader.GetInt32(0);

i++;

}
}
0
Sagar Pardeshi12y ago
SqlDataAdapter dap = new SqlDataAdapter();

DataTable tbl; cmd.CommandText = "SELECT * FROM YourTable WHERE [user id]='@a'"; cmd.Parameters.AddWithValue("@a", YourTextBox.Text);

dap.SelectCommand = cmd; dap.Fill(tbl);

if( tbl.Rows.Count > 0 ) //user id is already exist
0
leathu raj12y ago
very thanks sir it will work perfectly... thanks a lot
0
leathu raj12y ago
ok sir,
but i want to get another two value to two labels.
In my example database like if i give 1000 in my textbox one label will display 2000 and another lable will display 3000 if is possible ... or not...
I am in confusion to solve this...
0
Anupam Singh12y ago
a little mistake you did in this code. Try :

SqlCommand cmd = new SqlCommand("select gift_points from gift_entry where gift_points >'" + Convert.ToInt32(txt_rewardpoints.Text.Trim()) + "'", con);

By default the value of text box is string type and you might be using int in SQL.

Try this will work.

0
leathu raj12y ago
hi sir,
i tried like this..
for next time i give this same coding based on textbox1... But i works and does not get right value..

SqlCommand cmd = new SqlCommand("select gift_points from gift_entry where gift_points >'" + txt_rewardpoints.Text + "'", con);
cmd.CommandType = CommandType.Text;
adpt.SelectCommand = cmd;
DataTable dt = new DataTable();
adpt.Fill(dt);

double pnt1 = Convert.ToDouble(dt.Rows[0][0]);
point1.Text = pnt1.ToString();
textBox1.Text = pnt1.ToString();
..
0
sudipta sanyal12y ago
string str_query = "SELECT * FROM dbo.tbl_your_table AS u WHERE column_name > '" + text.text + "'";
0
Anupam Singh12y ago
Have you tried anything if yes then share your code.
0