Ad:

ASP.NET Discussion Thread
Unsolved
Views: 7102

Nov 14th, 2008

error

Expand Post »

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

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.

krany18

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

19 posts
since Nov 2008

Permalink

Nov 14th, 2008

Re: error

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

Thanks,

Kusno

Reputation Points: 11

Solved Threads: 17

Junior Poster

Offline

191 posts
since Aug 2007

Permalink

Nov 14th, 2008

Re: error

please tell me the exact code,,

krany18

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

19 posts
since Nov 2008

Permalink

Nov 14th, 2008

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

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

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

krany18

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

19 posts
since Nov 2008

Permalink

Nov 14th, 2008

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

use "+" instead of "&"
like

cmd.CommandText = "insert into kumar values( " + TextBox1.Text + " ,' " + TextBox2.Text + " ')";

sierrainfo

Reputation Points: 10

Solved Threads: 9

Junior Poster

Offline

144 posts
since May 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP.NET Forum Timeline: Page.RegisterClientScriptBlock

Next Thread in ASP.NET Forum Timeline: need to populate the single column out of mulitple colums,

DaniWeb Message

Cancel Changes

User Name
Password