How to compare column values in database with textbox value

Question

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

Anupam Singh · 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++; } }

Sagar Pardeshi · Answer

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

leathu raj · Answer

very thanks sir it will work perfectly... thanks a lot

leathu raj · Answer

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...

leathu raj · Answer

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(); ..

sudipta sanyal · Answer

string str_query = SELECT * FROM dbo.tbl_your_table AS u WHERE column_name > ' + text.text + ';

Anupam Singh · Answer

Have you tried anything if yes then share your code.

Anupam Singh · Answer

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.