Solved

C# update

Posted on 2014-04-11
5
104 Views
Last Modified: 2014-04-14
Hi guys ,

I'm trying to update just one column and I got error see screenshot (app) and also see attachment of my table.

here is my code:

string Query = "update rmsmasterdbtest.dbo.serial set serialnumber='" + this.txtsn.Text + "' ,serialnumber3='" + this.txtstatus + "' where serialnumber='" + this.txtsn.Text + "' ;";

Open in new window

database.JPG
app.JPG
0
Comment
Question by:Moti Mashiah
  • 4
5 Comments
 
LVL 52

Accepted Solution

by:
Carl Tawn earned 500 total points
ID: 39994409
I suspect this:
this.txtstatus

Open in new window

Should say:
this.txtstatus.Text

Open in new window

Otherwise it will spit out the object type information, which will exceed the 10 characters that your field will accept.
0
 
LVL 1

Author Comment

by:Moti Mashiah
ID: 39994456
that's is right carl thank you very much and also I just figured that I forgot to add the Reader in my code now all work fine:

Carl , it seems that any time I'm trying to update I got some issue I think that I'm not really understand the concept updating database columns can you give my some explanation also I would like to now what is the difference between these two update methods

1.
string Query = "update RMSCRM.dbo.sales set Status=@Status, note=@note where ID=@id";
            
           

            SqlConnection Myconn = new SqlConnection(conn);
            SqlCommand cmd = new SqlCommand(Query, Myconn);

            int SalesID = int.Parse(this.txtid.Text);

            cmd.Parameters.AddWithValue("@id", SalesID);
            cmd.Parameters.AddWithValue("@status", this.txtStatus.Text);
            cmd.Parameters.AddWithValue("@note", this.txtNote.Text);

Open in new window


2.
string Query = "update rmsmasterdbtest.dbo.serial set serialnumber='" + this.txtsn.Text + "' ,serialnumber3='" + this.txtstatus.Text + "' where serialnumber='" + this.txtsn.Text + "' ;";

           
            SqlConnection Myconn = new SqlConnection(conn);
            SqlCommand cmd = new SqlCommand(Query, Myconn);
            SqlDataReader Reader;
           

            try
            {
                Myconn.Open();
                Reader = cmd.ExecuteReader();
                MessageBox.Show("Updated Status");
                while (Reader.Read())
                {

                }

Thank you soo much
0
 
LVL 1

Author Comment

by:Moti Mashiah
ID: 39994534
I read some material but still get complicated when I'm trying to write update code.
0
 
LVL 1

Author Comment

by:Moti Mashiah
ID: 39999819
I've requested that this question be closed as follows:

Accepted answer: 0 points for motimash's comment #a39994534
Assisted answer: 500 points for carl_tawn's comment #a39994409

for the following reason:

Thanks
0
 
LVL 1

Author Closing Comment

by:Moti Mashiah
ID: 39999820
Excellent as usual
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In order to hide the "ugly" records selectors (triangles) in the rowheaders, here are some suggestions. Microsoft doesn't have a direct method/property to do it. You can only hide the rowheader column. First solution, the easy way The first sol…
Performance in games development is paramount: every microsecond counts to be able to do everything in less than 33ms (aiming at 16ms). C# foreach statement is one of the worst performance killers, and here I explain why.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now