Operators in C#

Question

if (dr["username"].ToString = TextBox1.Text&& dr["uid"].ToString =TextBox2.Text) Error"Operator '&&' cannot be applied to operands of type 'string' and 'method group'"

Nilanka Dharmadasa · Answer

Hi Kiran, Write this way. if ((dr["username"].ToString() == TextBox1.Text) && (dr["uid"].ToString() ==TextBox2.Text)) { } Or write this way. if ((dr["username"].ToString().Equals(TextBox1.Text)) && (dr["username"].ToString().Equals(TextBox2.Text))) { } If you find any other problem pls ask. If this is helpful to you, please check Do you like this answer' checkbox.

kiran kumar · Answer

using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; public partial class Default2 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void Button1_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection("Data Source=KIRAN\SQLEXPRESS;Initial Catalog=kiran;Integrated Security=True"); con.Open(); string querystring; querystring ="select * from reg"; SqlCommand cmd = new SqlCommand(querystring, con); SqlDataReader dr = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection); while (dr.Read()) { if ((dr["username"].ToString() == TextBox2.Text) && (dr["userid"].ToString() == TextBox1.Text)) { Response.Redirect("login.aspx"); } else { Label3.Text = "you must have entered wrong userid or activation code please check your mail for further details"; } } dr.Close(); } } when i run this it is not redirecting to login.aspx though i have entered correct details into textboxes......instead it is showing my error message

kiran kumar · Answer

protected void Button1_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection("Data Source=KIRAN\SQLEXPRESS;Initial Catalog=kiran;Integrated Security=True"); con.Open(); string querystring; querystring = "select userid from reg where username=" + TextBox1.Text + ""; SqlCommand cmd = new SqlCommand(querystring, con); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { if ((dr["username"].ToString() == TextBox1.Text) && (dr["uid"].ToString() == TextBox2.Text)) { Response.Redirect("login.aspx"); } else { Label3.Text = "you must have entered wrong userid or activation code please check your name for further details"; } } dr.Close(); con.Close(); } } error:"+ $exception {"Incorrect syntax near 'a12157'."} System.Exception {System.Data.SqlClient.SqlException}"

kiran kumar · Answer

SqlCommand cmd = new SqlCommand(querystring, con); SqlDataReader dr; dr=cmd.ExecuteReader(); it raises an error"incorrect syntax" am i correct with datareader??

kiran kumar · Answer

thank you very much niki.....you are very helpful to me...im very new to asp.net

Operators in C#

Answers (5)