Ad:

ASP.NET Discussion Thread
Unsolved
Views: 2780

You are currently viewing page 2 of this multi-page discussion thread; Jump to the first page

Jun 24th, 2009

Re: Update from Asp.net to Sql server db

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

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

Bind:

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

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.

nikichu

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

14 posts
since Jun 2009

Permalink

Jun 26th, 2009

Re: Update from Asp.net to Sql server db

Click to Expand / Collapse Quote 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

vplmega

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Jun 2009

Permalink

Jul 6th, 2009

Re: Update from Asp.net to Sql server db

hello someone thre to help please............
still stuck in the code,which updates only the first record!!!!!!!!!!!!!

nikichu

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

14 posts
since Jun 2009

Previous
1
Page 2

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