Click here to Skip to main content
15,442,338 members
Home / Discussions / Database
   

Database

 
AnswerRe: Creating SQL statements in Access Databases Pin
Member 115083508-Mar-15 17:18
MemberMember 115083508-Mar-15 17:18 
GeneralRe: Creating SQL statements in Access Databases Pin
Chris Quinn8-Mar-15 22:07
MemberChris Quinn8-Mar-15 22:07 
AnswerRe: Creating SQL statements in Access Databases Pin
Abdulnazark9-Mar-15 6:51
MemberAbdulnazark9-Mar-15 6:51 
GeneralRe: Creating SQL statements in Access Databases Pin
Member 115083509-Mar-15 17:01
MemberMember 115083509-Mar-15 17:01 
GeneralRe: Creating SQL statements in Access Databases Pin
Abdulnazark9-Mar-15 21:06
MemberAbdulnazark9-Mar-15 21:06 
AnswerRe: Creating SQL statements in Access Databases Pin
Member 115083509-Mar-15 16:48
MemberMember 115083509-Mar-15 16:48 
GeneralRe: Creating SQL statements in Access Databases Pin
Member 115083509-Mar-15 17:59
MemberMember 115083509-Mar-15 17:59 
QuestionVB.NET MYSQL SAVE DATAGRIDVIEW VALUES TO DATABASE Pin
KipkoechE28-Feb-15 22:01
MemberKipkoechE28-Feb-15 22:01 
i am trying to save datagridview records to mysql table...But am getting the error:
"value cannot be null
parameter:datasource"

any help
private sub Save()
Try
con = New MySqlConnection(dbPath)
sql = "SELECT *FROM shubject1"
da = New MySqlDataAdapter(sql, con)
con.Open()
ds = New DataSet()
cmdb = New MySqlCommandBuilder(da)
da.Fill(ds, "subject1")
bsource.DataSource = ds.Tables("subject1")
dgMarksheet.DataSource = bsource
Catch ex As Exception
MsgBox(ex.Message)
End Try
end sub
Private Sub SaveRecords()

Try
ds = New DataSet()
dt = New DataTable()
dt = ds.Tables("subject1")
Me.dgMarksheet.BindingContext(dt).EndCurrentEdit()
Me.da.Update(dt)
MsgBox("Saved", MsgBoxStyle.Information, "Record Changes")
Catch ex As Exception
MsgBox(ex.Message)
Exit Sub
End Try

End Sub
AnswerRe: VB.NET MYSQL SAVE DATAGRIDVIEW VALUES TO DATABASE Pin
manchanx1-Mar-15 1:01
professionalmanchanx1-Mar-15 1:01 
GeneralRe: VB.NET MYSQL SAVE DATAGRIDVIEW VALUES TO DATABASE Pin
KipkoechE3-Mar-15 19:48
MemberKipkoechE3-Mar-15 19:48 
AnswerRe: VB.NET MYSQL SAVE DATAGRIDVIEW VALUES TO DATABASE Pin
Mycroft Holmes1-Mar-15 13:54
professionalMycroft Holmes1-Mar-15 13:54 
GeneralHow to increase SQL Query Performance for the Oracle Database Pin
Blog euth26-Feb-15 23:08
MemberBlog euth26-Feb-15 23:08 
GeneralRe: How to increase SQL Query Performance for the Oracle Database Pin
Jörgen Andersson26-Feb-15 23:37
professionalJörgen Andersson26-Feb-15 23:37 
GeneralRe: How to increase SQL Query Performance for the Oracle Database Pin
Mycroft Holmes1-Mar-15 13:48
professionalMycroft Holmes1-Mar-15 13:48 
GeneralRe: How to increase SQL Query Performance for the Oracle Database Pin
PIEBALDconsult6-Mar-15 14:56
professionalPIEBALDconsult6-Mar-15 14:56 
QuestionDifficult Select Query Pin
Dimitris Sakellariou25-Feb-15 23:59
MemberDimitris Sakellariou25-Feb-15 23:59 
AnswerRe: Difficult Select Query Pin
Corporal Agarn26-Feb-15 0:56
professionalCorporal Agarn26-Feb-15 0:56 
AnswerRe: Difficult Select Query Pin
Abdulnazark9-Mar-15 8:49
MemberAbdulnazark9-Mar-15 8:49 
QuestionDB Conversion Advice Pin
Kyudos25-Feb-15 11:00
MemberKyudos25-Feb-15 11:00 
GeneralRe: DB Conversion Advice Pin
PIEBALDconsult25-Feb-15 12:21
professionalPIEBALDconsult25-Feb-15 12:21 
AnswerRe: DB Conversion Advice Pin
Mycroft Holmes25-Feb-15 13:10
professionalMycroft Holmes25-Feb-15 13:10 
GeneralRe: DB Conversion Advice Pin
Kyudos25-Feb-15 14:38
MemberKyudos25-Feb-15 14:38 
GeneralRe: DB Conversion Advice Pin
Mycroft Holmes25-Feb-15 14:59
professionalMycroft Holmes25-Feb-15 14:59 
GeneralRe: DB Conversion Advice Pin
Mycroft Holmes25-Feb-15 15:05
professionalMycroft Holmes25-Feb-15 15:05 
GeneralRe: DB Conversion Advice Pin
Kyudos25-Feb-15 15:23
MemberKyudos25-Feb-15 15:23 

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.