ObjectDataSource To SqlDataSource RSS

• • Reply
  

  Khaliz Neo

  Member

  45 Points

  37 Posts

  ObjectDataSource To SqlDataSource

  Mar 06, 2012 07:45 AM|LINK

  <div>

  Hi...
  I want change this code from ObjectDataSource To SqlDataSource...
  Any suggestion....??
   

  protected void Page_Load(object sender, EventArgs e)
      {
  		System.Threading.Thread.CurrentThread.CurrentCulture = System.Globalization.CultureInfo.InvariantCulture;
      }
  	
  	protected void ObjectDataSource1_Selected(object sender, ObjectDataSourceStatusEventArgs e)
  	{
  	}
  
  	protected void ObjectDataSource1_Inserted(object sender, ObjectDataSourceStatusEventArgs e)
  	{
  		e.AffectedRows = ((int)e.ReturnValue > 0) ? 1 : 0;
  
  		lbResult.Text = String.Format("Affected Rows = {0}. Generated NamaID = {1}", e.AffectedRows, (int)e.ReturnValue);
  	}
  	
  	protected void ObjectDataSource1_Updated(object sender, ObjectDataSourceStatusEventArgs e)
  	{
  		e.AffectedRows = (int)e.ReturnValue;
  
  		lbResult.Text = "Affected Rows = " + e.AffectedRows;
  	}
  	
  	protected void ObjectDataSource1_Deleted(object sender, ObjectDataSourceStatusEventArgs e)
  	{
  		e.AffectedRows = (int)e.ReturnValue;
  
  		lbResult.Text = "Affected Rows = " + e.AffectedRows;
  	}

   

  </div>
  • Moved by XIII on Mar 06, 2012 08:17 AM
• • Reply
  

  Decker Dong ...

  All-Star

  118619 Points

  18779 Posts

  Re: ObjectDataSource To SqlDataSource

  Mar 08, 2012 12:44 AM|LINK

  Almost the same thing like what you've shown to us，but change the objectDataSource to SqlDataSource。For more you can have a good look at this——Events of DataSource：

  http://msdn.microsoft.com/en-au/library/system.web.ui.webcontrols.sqldatasource_events(v=vs.80).aspx

  • Marked as answer by decker dong - msft on Mar 12, 2012 02:03 AM
• • Reply
  

  Khaliz Neo

  Member

  45 Points

  37 Posts

  Re: ObjectDataSource To SqlDataSource

  Mar 13, 2012 12:38 PM|LINK

  tq for the artical Decker Dong - MSFT...