ASP.NET

ASP.NET RSS

Update from Asp.net to Sql server db

Please support our ASP.NET advertiser: $4.95 a Month - ASP.NET Web Hosting – Click Here!

•

Join Date: Jun 2009

Posts: 14

Reputation: nikichu is an unknown quantity at this point

Solved Threads: 0

nikichu

Offline

Newbie Poster

Update from Asp.net to Sql server db

Jun 17th, 2009

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

 Help with Code Tags 
 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.

•

Join Date: Feb 2009

Posts: 3,141

Reputation: sknake has much to be proud of

Solved Threads: 555

sknake

Offline

.NET Enthusiast

Re: Update from Asp.net to Sql server db

Jun 17th, 2009

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.

 Help with Code Tags 
 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.

Scott Knake
Custom Software Development
Apex Software, Inc.

•

Join Date: Dec 2007

Posts: 200

Reputation: carobee is an unknown quantity at this point

Solved Threads: 11

carobee

Offline

Posting Whiz in Training

Re: Update from Asp.net to Sql server db

Jun 18th, 2009

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

•

Join Date: Jun 2009

Posts: 14

Reputation: nikichu is an unknown quantity at this point

Solved Threads: 0

nikichu

Offline

Newbie Poster

Re: Update from Asp.net to Sql server db

Jun 22nd, 2009

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

•

Join Date: Dec 2007

Posts: 200

Reputation: carobee is an unknown quantity at this point

Solved Threads: 11

carobee

Offline

Posting Whiz in Training

Re: Update from Asp.net to Sql server db

Jun 22nd, 2009

add a watch in the values at this point

 Help with Code Tags 
 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);

•

Join Date: Apr 2009

Posts: 214

Reputation: mail2saion is an unknown quantity at this point

Solved Threads: 31

mail2saion mail2saion is offline

Offline

Posting Whiz in Training

Re: Update from Asp.net to Sql server db

Jun 23rd, 2009

Could you please post the table structure of Loc_mast?

MARK AS SOLVED if its help you.

REGARDS
MCTS - Shawpnendu bikash maloroy
http://shawpnendu.blogspot.com

•

Join Date: Jun 2009

Posts: 14

Reputation: nikichu is an unknown quantity at this point

Solved Threads: 0

nikichu

Offline

Newbie Poster

Re: Update from Asp.net to Sql server db

Jun 24th, 2009

•

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

•

Join Date: Apr 2009

Posts: 214

Reputation: mail2saion is an unknown quantity at this point

Solved Threads: 31

mail2saion mail2saion is offline

Offline

Posting Whiz in Training

Re: Update from Asp.net to Sql server db

Jun 24th, 2009

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.

MARK AS SOLVED if its help you.

REGARDS
MCTS - Shawpnendu bikash maloroy
http://shawpnendu.blogspot.com

•

Join Date: Jun 2009

Posts: 14

Reputation: nikichu is an unknown quantity at this point

Solved Threads: 0

nikichu

Offline

Newbie Poster

Re: Update from Asp.net to Sql server db

Jun 24th, 2009

•

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"