ASP.NET

Error 1 Operator '&' cannot be applied to operands of type 'string' and 'string'

Please support our ASP.NET advertiser: Intel Parallel Studio Home

•

Join Date: Nov 2008

Posts: 19

Reputation: krany18 is an unknown quantity at this point

Solved Threads: 0

krany18

Offline

Newbie Poster

error

Nov 14th, 2008

i taken the three textboxes and one button to store the data in sqlserver .but the it giving the error.
the code is as follows...

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
    using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
 
public partial class Default3 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection("user id=sa;password=vikram;database=kran");
        SqlCommand cmd = new SqlCommand("select * from dr", con);
        SqlDataReader dr;
    //    cmd.CommandText = "select * from dr";
        cmd.Connection = con;
        con.Open();
        dr = cmd.ExecuteReader();
      cmd.CommandText="insert into dr values("&TextBox1.Text&", ' " &TextBox2.Text&" ', ' " &TextBox3.Text&" ')";
        TextBox1.Text=" ";
        TextBox2.Text= " ";
        TextBox3.Text=" ";
         dr.Close();
        con.Close();
 
 
 
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
 
    }
}
    using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class Default3 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection("user id=sa;password=vikram;database=kran");
        SqlCommand cmd = new SqlCommand("select * from dr", con);
        SqlDataReader dr;
    //    cmd.CommandText = "select * from dr";
        cmd.Connection = con;
        con.Open();
        dr = cmd.ExecuteReader();
      cmd.CommandText="insert into dr values("&TextBox1.Text&", ' " &TextBox2.Text&" ', ' " &TextBox3.Text&" ')";
        TextBox1.Text=" ";
        TextBox2.Text= " ";
        TextBox3.Text=" ";
         dr.Close();
        con.Close();
                  
       

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        
    }
}

i written the code like that .please clarify my application..
if it is not correct please tel me the correct...

Last edited by peter_budo; Nov 14th, 2008 at 8:09 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

•

Join Date: Aug 2007

Posts: 182

Reputation: Kusno is an unknown quantity at this point

Solved Threads: 15

Kusno

Offline

Junior Poster

Re: error

Nov 14th, 2008

Hi, You use the same SqlCommand variable to read and execute query.
Please create new SqlCommand variable to execute query...

Thanks,

NEVER NEVER NEVER GIVE UP

•

Join Date: Nov 2008

Posts: 19

Reputation: krany18 is an unknown quantity at this point

Solved Threads: 0

krany18

Offline

Newbie Poster

Re: error

Nov 14th, 2008

please tell me the exact code,,

•

Join Date: Nov 2008

Posts: 19

Reputation: krany18 is an unknown quantity at this point

Solved Threads: 0

krany18

Offline

Newbie Poster

Error 1 Operator '&' cannot be applied to operands of type 'string' and 'string'

Nov 14th, 2008

hai to all,,
once again i am sending the same code.but it giving same problem.please rectify my problem .it is urgent to me...

Help with Code Tags

(Toggle Plain Text)

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {

        SqlConnection con = new SqlConnection("user id=sa;password=vikram;database=kum");
        SqlCommand cmd = new SqlCommand(" ", con);
        con.Open();
        con.Close();
        



    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        SqlConnection con=new SqlConnection("user id=sa;password=vikram;database=kum");
        SqlCommand cmd=new SqlCommand();
        cmd.CommandText = "insert into kumar values( " & TextBox1.Text & " ,' " & TextBox2.Text & " ')";
        con.Open();
        cmd.ExecuteNonQuery();
        con.Close();
        TextBox1.Text = " ";
        TextBox2.Text=" ";


    }
}

Error comes at bold line code..
please forward me a correct code..

Last edited by peter_budo; Nov 14th, 2008 at 8:11 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.