Ad:

ASP.NET Discussion Thread
Unsolved
Views: 2780

Page 1
2
Next

You are currently viewing page 1 of this multi-page discussion thread

Jun 17th, 2009

Update from Asp.net to Sql server db

Expand Post »

...hope some body can help me resolve the problem....where i have to update a particular data ,
the datas are retreived from the db using a dropdownlist,selected data are updated inside a textbox...........
.....where there are constraints set by validators
for space and !^#$%&*^----charaecters:

My problm is data is not updated,please help me

Code

Asp.net C#---Sql server db)

c# Syntax (Toggle Plain Text)
private void btedit_Click(object sender, System.EventArgs e)
		{
			LabErr.Text="";
			if(Page.IsValid==true)
			{
				SqlConnection con1=new SqlConnection(@"Server=sqloledb.1;User ID=sa;password=;Data Source=IRID_BDC1;Initial Catalog=newbie");
				con1.Open();
				SqlCommand cmd=new SqlCommand("Update Loc_mast Set Loc =('"+ txtrnme.Text+"') Where Loc =('"+ Droploc.SelectedItem.Text+"')",con1);
				cmd.ExecuteNonQuery();
			}
			else
			{
			//txtrnme.Text="";
             LabErr.Text="Please try Again";
			}
private void btedit_Click(object sender, System.EventArgs e)
		{
			LabErr.Text="";
			if(Page.IsValid==true)
			{
				SqlConnection con1=new SqlConnection(@"Server=sqloledb.1;User ID=sa;password=;Data Source=IRID_BDC1;Initial Catalog=newbie");
				con1.Open();
				SqlCommand cmd=new SqlCommand("Update Loc_mast Set Loc =('"+ txtrnme.Text+"') Where Loc =('"+ Droploc.SelectedItem.Text+"')",con1);
				cmd.ExecuteNonQuery();
			}
			else
			{
			//txtrnme.Text="";
             LabErr.Text="Please try Again";
			}

..please suggest a soln..........

ICHU

Last edited by peter_budo; Jun 19th, 2009 at 4:22 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

Similar Threads

ASP.NET SQL Server Setup Wizard: Failure in ASP.NET

nikichu

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

14 posts
since Jun 2009

Permalink

Jun 17th, 2009

Re: Update from Asp.net to Sql server db

Change your query to be set to a string and break the debugger in there. Your drop down list might have an empty string value which would cause the update to not work. You are also not closing your SQL connection and you will run the connection pool out of available connections if your site has many users.

c# Syntax (Toggle Plain Text)
private void btedit_Click(object sender, System.EventArgs e)
{
  LabErr.Text=string.Empty;
  if(Page.IsValid)
  {
    using (SqlConnection con1=new SqlConnection(@"Server=sqloledb.1;User ID=sa;password=;Data Source=IRID_BDC1;Initial Catalog=newbie"))
    {
      con1.Open();
      string query = "Update Loc_mast Set Loc =('"+ txtrnme.Text+"') Where Loc =('"+ Droploc.SelectedItem.Text+"')";
      if (string.IsNullOrEmpty(Droploc.SelectedItem.Text))
        throw new Exception();
      int iTest = Convert.ToInt32(Droploc.SelectedItem.Text);
      using (SqlCommand cmd=new SqlCommand(query,con1))
      {
        cmd.ExecuteNonQuery();
      }
      con1.Close();
    }
  }
  else
  {
  //txtrnme.Text="";
    LabErr.Text="Please try Again";
  }
}
private void btedit_Click(object sender, System.EventArgs e)
{
  LabErr.Text=string.Empty;
  if(Page.IsValid)
  {
    using (SqlConnection con1=new SqlConnection(@"Server=sqloledb.1;User ID=sa;password=;Data Source=IRID_BDC1;Initial Catalog=newbie"))
    {
      con1.Open();
      string query = "Update Loc_mast Set Loc =('"+ txtrnme.Text+"') Where Loc =('"+ Droploc.SelectedItem.Text+"')";
      if (string.IsNullOrEmpty(Droploc.SelectedItem.Text))
        throw new Exception();
      int iTest = Convert.ToInt32(Droploc.SelectedItem.Text);
      using (SqlCommand cmd=new SqlCommand(query,con1))
      {
        cmd.ExecuteNonQuery();
      }
      con1.Close();
    }
  }
  else
  {
  //txtrnme.Text="";
    LabErr.Text="Please try Again";
  }
}

Try something like that and see if you get an exception. That should get you pointed in the right direction.

sknake

Featured Poster

Reputation Points: 1749

Solved Threads: 735

Senior Poster

Offline

3,948 posts
since Feb 2009

Permalink

Jun 18th, 2009

Re: Update from Asp.net to Sql server db

try debugging the code.perhaps the empty values are passed in the query

carobee

Reputation Points: 10

Solved Threads: 12

Posting Whiz in Training

Offline

209 posts
since Dec 2007

Permalink

Jun 22nd, 2009

Re: Update from Asp.net to Sql server db

..Still not working

.....Im using 2 radio buttons one to add and nther to edit

if i switch from one button to another,the datas are not gettng inserted to sql db

......the same the case as edit....
errors still........

ICHU

nikichu

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

14 posts
since Jun 2009

Permalink

Jun 22nd, 2009

Re: Update from Asp.net to Sql server db

add a watch in the values at this point

ASP.NET Syntax (Toggle Plain Text)
SqlCommand cmd=new SqlCommand("Update Loc_mast Set Loc =('"+ txtrnme.Text+"') Where Loc =('"+ Droploc.SelectedItem.Text+"')",con1);
SqlCommand cmd=new SqlCommand("Update Loc_mast Set Loc =('"+ txtrnme.Text+"') Where Loc =('"+ Droploc.SelectedItem.Text+"')",con1);

carobee

Reputation Points: 10

Solved Threads: 12

Posting Whiz in Training

Offline

209 posts
since Dec 2007

Permalink

Jun 23rd, 2009

Re: Update from Asp.net to Sql server db

Could you please post the table structure of Loc_mast?

mail2saion

Reputation Points: 26

Solved Threads: 44

Posting Whiz in Training

Offline

247 posts
since Apr 2009

Permalink

Jun 24th, 2009

Re: Update from Asp.net to Sql server db

Click to Expand / Collapse Quote originally posted by mail2saion ...

Could you please post the table structure of Loc_mast?

structure of Loc_mast(SQL SERVER)

Colname Datatype length
Slno int 4(generated automatically-(*identity)
Loc_no nvarchar 50

ICHU

nikichu

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

14 posts
since Jun 2009

Permalink

Jun 24th, 2009

Re: Update from Asp.net to Sql server db

Use Slno for update operation rather than loc_no. Where clause shoud be Where Slno =('"+ Droploc.SelectedItem.Value+"')",con1)
When you bind text properties of dropdown list must bind also Value properties by Slno.

mail2saion

Reputation Points: 26

Solved Threads: 44

Posting Whiz in Training

Offline

247 posts
since Apr 2009

Permalink

Jun 24th, 2009

Re: Update from Asp.net to Sql server db

Click to Expand / Collapse Quote originally posted by mail2saion ...

Use Slno for update operation rather than loc_no. Where clause shoud be Where Slno =('"+ Droploc.SelectedItem.Value+"')",con1)
When you bind text properties of dropdown list must bind also Value properties by Slno.

"...updates only the first record in db"

nikichu

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

14 posts
since Jun 2009

Permalink

Jun 24th, 2009

Re: Update from Asp.net to Sql server db

Please post your bind code & the qurey that you use to update.

mail2saion

Reputation Points: 26

Solved Threads: 44

Posting Whiz in Training

Offline

247 posts
since Apr 2009

Page 1
2
Next

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: If my ASP.net not inculde the database what should write in Web.config

Next Thread in ASP.NET Forum Timeline: Get data from database and display in the appropriate format.

DaniWeb Message

Cancel Changes

User Name
Password