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

Re: Update from Asp.net to Sql server db

#11

Jun 24th, 2009

•

Originally Posted by mail2saion

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

Bind:

 Help with Code Tags 
 c# Syntax (Toggle Plain Text) 
SqlConnection con1=new SqlConnection(@"Server=sqloledb.1;User ID=sa;password=;Data Source=IRID_BDC1;Initial Catalog=Nisha");
con1.Open();
  SqlCommand cmmd=new SqlCommand("Select * from  Loc_mast",con1);
 SqlDataReader dar=cmmd.ExecuteReader();
  Droploc.Items.Clear(); 
  Droploc.DataSource=dar;
  Droploc.DataTextField ="Loc";
 Droploc.DataValueField="Slno";
 Droploc.DataBind();
 con1.Close();
SqlConnection con1=new SqlConnection(@"Server=sqloledb.1;User ID=sa;password=;Data Source=IRID_BDC1;Initial Catalog=Nisha");
con1.Open();
  SqlCommand cmmd=new SqlCommand("Select * from  Loc_mast",con1);
 SqlDataReader dar=cmmd.ExecuteReader();
  Droploc.Items.Clear(); 
  Droploc.DataSource=dar;
  Droploc.DataTextField ="Loc";
 Droploc.DataValueField="Slno";
 Droploc.DataBind();
 con1.Close();

Update

 Help with Code Tags 
 c# Syntax (Toggle Plain Text) 
RadioButton1.Checked =false;
if(Page.IsValid == true) 
{  
using (SqlConnection con1=new SqlConnection(@"Server=sqloledb.1;User ID=sa;password=;Data Source=IRID_BDC1;Initial Catalog=Nisha"))
{    
con1.Open();  
SqlCommand cmd=new SqlCommand("Update Loc_mast Set Loc =('"+ txtrnme.Text+"') Where Slno =('"+ Droploc.SelectedItem.Value+"')",con1);   
cmd.ExecuteNonQuery();  
con1.Close();  
}}
RadioButton1.Checked =false;
if(Page.IsValid == true) 
{  
using (SqlConnection con1=new SqlConnection(@"Server=sqloledb.1;User ID=sa;password=;Data Source=IRID_BDC1;Initial Catalog=Nisha"))
{    
con1.Open();  
SqlCommand cmd=new SqlCommand("Update Loc_mast Set Loc =('"+ txtrnme.Text+"') Where Slno =('"+ Droploc.SelectedItem.Value+"')",con1);   
cmd.ExecuteNonQuery();  
con1.Close();  
}}

Last edited by peter_budo; Jun 25th, 2009 at 1:44 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: Jun 2009

Posts: 1

Reputation: vplmega is an unknown quantity at this point

Solved Threads: 0

vplmega

Offline

Newbie Poster

Re: Update from Asp.net to Sql server db

#12

Jun 26th, 2009

•

Originally Posted by mail2saion

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

The ASP.NET Application Service APIs are designed to be pluggable and implementation agnostic, which means that the APIs do not hardcode the details of where data is stored with them. Instead, the APIs call into “providers”,you can get lot of information about the Software Testing from Macrotesting . Any of you guys get useful information about this please share wih me.

All the best for your carrer..
Meganathan