Updating tables and Alias's
Updating tables and Alias's
Updating tables and Alias's
Updating tables and Alias's
Updating tables and Alias's
Updating tables and Alias's Updating tables and Alias's Updating tables and Alias's Updating tables and Alias's Updating tables and Alias's Updating tables and Alias's Updating tables and Alias's Updating tables and Alias's
Updating tables and Alias's Updating tables and Alias's
Updating tables and Alias's
Go Back  Xtreme Visual Basic Talk > > > Updating tables and Alias's


Reply
 
Thread Tools Display Modes
  #1  
Old 07-03-2013, 08:31 AM
sturner333 sturner333 is offline
Newcomer
 
Join Date: Feb 2006
Posts: 10
Default Updating tables and Alias's


I am using alias's from a saved procedure that referes to different columns in an sql table in vb .net. I then have a dataset and i use the alias's on a form. My question is when I have refernced those alias's on the form change them , can i update them to the appropiate column\record in the original table?

The update in the code:
Code:
 Me.Validate()
 Me.Sheet2_D1CriteriaProceedureBindingSource.EndEdit()
 Me.TableAdapterManager.UpdateAll(Me.Msd_database1fDataSet_testd1)
The alias code in the procedure:
Code:
 if @criteriaCategory = 1 
begin
 SELECT projectid,id,
 criteria1 as crit,
 criteria1a as crit1,
 criteria1b as crit2,
 criteria1c as crit3,
 criteria1d as crit4,
 criteria1e as crit5
 FROM sheet2_d1criteria
 where @projId = projectID
 Order By projectid
 end 
else if @criteriaCategory = 2
 begin
 SELECT projectid,id,
 criteria2 as crit,
 criteria2a as crit1,
 criteria2b as crit2,
 criteria2c as crit3,
 criteria2d as crit4,
 criteria2e as crit5
 FROM sheet2_d1criteria
 where @projId = projectID
 Order By projectid
 end

Last edited by Flyguy; 07-03-2013 at 08:52 AM.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
Updating tables and Alias's
Updating tables and Alias's
Updating tables and Alias's Updating tables and Alias's
Updating tables and Alias's
Updating tables and Alias's
Updating tables and Alias's Updating tables and Alias's Updating tables and Alias's Updating tables and Alias's Updating tables and Alias's Updating tables and Alias's Updating tables and Alias's
Updating tables and Alias's
Updating tables and Alias's
 
Updating tables and Alias's
Updating tables and Alias's
 
-->