Click here to Skip to main content
15,888,351 members
Home / Discussions / Database
   

Database

 
Questionhelp with connecting to database server Pin
cpence2527-Feb-06 19:39
cpence2527-Feb-06 19:39 
AnswerRe: help with connecting to database server Pin
Mike Dimmick28-Feb-06 6:28
Mike Dimmick28-Feb-06 6:28 
GeneralRe: help with connecting to database server Pin
cpence2528-Feb-06 13:03
cpence2528-Feb-06 13:03 
QuestionHow to insert records into two tables using single Query Pin
Rajkamal_dfine27-Feb-06 18:53
Rajkamal_dfine27-Feb-06 18:53 
AnswerRe: How to insert records into two tables using single Query Pin
Andy Brummer27-Feb-06 19:02
sitebuilderAndy Brummer27-Feb-06 19:02 
Questionrow.Insert(x) isn't updating my table. Pin
3197527-Feb-06 10:56
3197527-Feb-06 10:56 
AnswerRe: row.Insert(x) isn't updating my table. Pin
Ritesh123427-Feb-06 19:53
Ritesh123427-Feb-06 19:53 
AnswerRe: row.Insert(x) isn't updating my table. Pin
3197515-Mar-06 10:34
3197515-Mar-06 10:34 
I got it figured out. Since I was using the DataAdapter,it seems that in order to "post back" to the dataset you have created, the table in the database needs to have a Primary Key. I guess because since when you re using the dataAapter, the resultant dataset (in memory) needs to somehow map back to the original table and a primary key is needed. I didn't need to use a DataAdapter but I was trying to do it using the new cool stuff in DotNet.

Here is a complete sample. (I palgerized some of this fro the help...)
Notice you will need to return a connectin. I did this with my sconneciton function...



**********UPDATING AN EXISTIN ROW WITH THE DATA ADAPTER - SQLSERVER**********
(I needed a primary key.)


''This works!!!!
Public Sub UpdateExistingRow()

Dim myConnection As New SqlConnection(sConnection)
Dim mySqlDataAdapter As SqlDataAdapter

mySqlDataAdapter = New SqlDataAdapter("SELECT * FROM TestTable1", sConnection)

Dim myDataSet As DataSet = New DataSet

Dim myDataRowsCommandBuilder As SqlCommandBuilder = New SqlCommandBuilder(mySqlDataAdapter)
mySqlDataAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey

mySqlDataAdapter.Fill(myDataSet, "TestTable1")


Dim table As DataTable
table = myDataSet.Tables(0)

Dim myDatarow As DataRow
myDatarow = table.Rows(0)

myDatarow.Item(1) = "Wednesday"



mySqlDataAdapter.Update(myDataSet, "TestTable1")

End Sub
QuestionExecute an SQL command with return value Pin
stephanm@cae.ca27-Feb-06 8:33
stephanm@cae.ca27-Feb-06 8:33 
QuestionSQL Server Comparing Dates Pin
Murthy India27-Feb-06 2:36
Murthy India27-Feb-06 2:36 
AnswerRe: SQL Server Comparing Dates Pin
J4amieC27-Feb-06 2:48
J4amieC27-Feb-06 2:48 
GeneralRe: SQL Server Comparing Dates Pin
Paul Conrad27-Feb-06 15:33
professionalPaul Conrad27-Feb-06 15:33 
GeneralRe: SQL Server Comparing Dates Pin
Murthy India27-Feb-06 18:19
Murthy India27-Feb-06 18:19 
QuestionDynamic Database Design Pin
Ingo27-Feb-06 0:20
Ingo27-Feb-06 0:20 
AnswerRe: Dynamic Database Design Pin
darkelv27-Feb-06 4:17
darkelv27-Feb-06 4:17 
GeneralRe: Dynamic Database Design Pin
Ingo27-Feb-06 21:20
Ingo27-Feb-06 21:20 
Questionnewbie: how to get started Pin
rnvrnv26-Feb-06 23:54
rnvrnv26-Feb-06 23:54 
AnswerRe: newbie: how to get started Pin
Paul Conrad27-Feb-06 15:42
professionalPaul Conrad27-Feb-06 15:42 
QuestionSQL Profiler trace and Performance Pin
devvvy26-Feb-06 14:56
devvvy26-Feb-06 14:56 
AnswerRe: SQL Profiler trace and Performance Pin
Andy Brummer27-Feb-06 18:50
sitebuilderAndy Brummer27-Feb-06 18:50 
QuestionSQL Server log - recycling Pin
devvvy26-Feb-06 14:42
devvvy26-Feb-06 14:42 
Questionoj Pin
dev dhoundiyal26-Feb-06 5:50
dev dhoundiyal26-Feb-06 5:50 
AnswerRe: oj Pin
Colin Angus Mackay26-Feb-06 6:29
Colin Angus Mackay26-Feb-06 6:29 
GeneralRe: oj Pin
J4amieC26-Feb-06 22:38
J4amieC26-Feb-06 22:38 
QuestionUploading images to sql db Pin
foolygoofy2625-Feb-06 16:55
foolygoofy2625-Feb-06 16:55 

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.