How to update a record using Subsonic 3

Submitted by Administrator on Wed, 01/20/2010 - 12:25
Tags:

 

 

How to update a record using Subsonic 3 and SQL.

catalog.data.catalogDB WDB = new catalog.data.catalogDB();

string query = "UPDATE TableName SET FieldName= @Parameter WHERE FieldName = "+Value

QueryCommand q = new QueryCommand(query, WDB.DataProvider);

q.Parameters.Add("@Parameter", Value, DbType.DataBaseType);

 

WDB.DataProvider.ExecuteScalar(q);

 

Comments

No bad post, write more

Submitted by tershorndog547 (not verified) on Mon, 02/15/2010 - 16:31.

No bad post, write more

Post new comment

  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <img>
  • Lines and paragraphs break automatically.

More information about formatting options

CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
Image CAPTCHA
Enter the characters shown in the image.