Click here to Skip to main content
15,914,010 members
Home / Discussions / Database
   

Database

 
QuestionHow to read XML from Sql server 2005? Pin
DGtech18-Sep-07 18:46
DGtech18-Sep-07 18:46 
QuestionListbox Pin
jaakinye18-Sep-07 8:59
jaakinye18-Sep-07 8:59 
AnswerRe: Listbox Pin
Kschuler18-Sep-07 9:16
Kschuler18-Sep-07 9:16 
QuestionMSVS 2005 and Vista Pin
Jon Stroh18-Sep-07 8:42
Jon Stroh18-Sep-07 8:42 
GeneralPHP WORK (PAID WELL) [modified] Pin
miggy200518-Sep-07 8:01
miggy200518-Sep-07 8:01 
GeneralRe: PHP WORK (PAID WELL) Pin
Dave Kreskowiak18-Sep-07 8:23
mveDave Kreskowiak18-Sep-07 8:23 
GeneralRe: PHP WORK (PAID WELL) Pin
Pete O'Hanlon18-Sep-07 10:58
mvePete O'Hanlon18-Sep-07 10:58 
Questionusing MS Access queries from a .NET application Pin
pete007_ke18-Sep-07 4:59
pete007_ke18-Sep-07 4:59 
greetings everyody,

When building an application that utilises a databases such as SQL Server or Sybase SQL Anywhere one can use stored procedures to manipulate the database. For example, I use the follwing bit of code in my DataAccess class:

SACommand cmd = new DataAccessor(m_connectionString).GetCommand("[OrderDetails.UpdateInventory]");
cmd.Parameters.Add(new SAParameter("@Quantity",Quantity));
cmd.Parameters.Add(new SAParameter("@ProductID", ProductID));
cmd.Parameters.Add(new SAParameter("@DistributorID", DistributorID));
cmd.Parameters.Add(new SAParameter("@InventoryReceiptHeaderID", ReceiptID));
cmd.Parameters.Add(new SAParameter("@OrderID", OrderID));
cmd.Parameters.Add(new SAParameter("@DeliveryNote", DeliveryNote));
cmd.Parameters.Add(new SAParameter("@UserID", UserID));
cmd.ExecuteNonQuery();




Problem is MS Access does not have stored procedures.
Now, im trying to avoid typing SQL statements directly in my code. Im hoping to use queries in my MS Access databse which i pass parameters to etc
How can i achieve the same in MS Access 2000/2003 database?
AnswerRe: using MS Access queries from a .NET application Pin
Justin Perez18-Sep-07 5:07
Justin Perez18-Sep-07 5:07 
QuestionHow to set a stored procedure's time-out period Pin
MatthysDT18-Sep-07 4:20
MatthysDT18-Sep-07 4:20 
AnswerRe: How to set a stored procedure's time-out period Pin
Pete O'Hanlon18-Sep-07 4:56
mvePete O'Hanlon18-Sep-07 4:56 
GeneralRe: How to set a stored procedure's time-out period Pin
MatthysDT18-Sep-07 5:06
MatthysDT18-Sep-07 5:06 
GeneralRe: How to set a stored procedure's time-out period Pin
Pete O'Hanlon18-Sep-07 5:13
mvePete O'Hanlon18-Sep-07 5:13 
GeneralRe: How to set a stored procedure's time-out period Pin
MatthysDT18-Sep-07 5:22
MatthysDT18-Sep-07 5:22 
QuestionTool similar to SQL Builder Pin
arnoldpinto8418-Sep-07 3:24
arnoldpinto8418-Sep-07 3:24 
AnswerRe: Tool similar to SQL Builder Pin
MatthysDT18-Sep-07 5:58
MatthysDT18-Sep-07 5:58 
Questionhow to get Table name and Fields name Pin
Sachin Pimpale18-Sep-07 0:04
Sachin Pimpale18-Sep-07 0:04 
AnswerRe: how to get Table name and Fields name Pin
Colin Angus Mackay18-Sep-07 0:26
Colin Angus Mackay18-Sep-07 0:26 
GeneralRe: how to get Table name and Fields name Pin
Sachin Pimpale18-Sep-07 2:06
Sachin Pimpale18-Sep-07 2:06 
GeneralRe: how to get Table name and Fields name Pin
Colin Angus Mackay18-Sep-07 2:38
Colin Angus Mackay18-Sep-07 2:38 
GeneralRe: how to get Table name and Fields name Pin
Sachin Pimpale20-Sep-07 0:12
Sachin Pimpale20-Sep-07 0:12 
GeneralRe: how to get Table name and Fields name Pin
Colin Angus Mackay20-Sep-07 7:09
Colin Angus Mackay20-Sep-07 7:09 
QuestionConnecting to SQL express Pin
twsted f817-Sep-07 22:28
twsted f817-Sep-07 22:28 
AnswerRe: Connecting to SQL express Pin
Colin Angus Mackay18-Sep-07 0:30
Colin Angus Mackay18-Sep-07 0:30 
AnswerRe: Connecting to SQL express Pin
Frank Kerrigan18-Sep-07 2:40
Frank Kerrigan18-Sep-07 2:40 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.