shuhana84

Hi, I got this problem in my program when trying to execute stor procedure and xml file.. below is my code and script : Please help. code: Public Overloads Function ExecuteNonQuery(ByVal connection As IDbConnection, ByVal commandType As CommandType, ByVal commandText As String, ByVal ParamArray commandParameters() As IDbDataParameter) As Integer Try …

HI,anyone know how to check every single record that we have been inserted in sql server?either exist or not..please help.

anyone know how to do this in coding vb.net????

Function selectDB17() Dim cn As New SqlConnection Dim cmd As New SqlCommand cn.ConnectionString = ("server=EKS-HQ;database=BGB;user id=administrator;password=admineks2005") cn.Open() cmd.Connection = cn cmd.CommandText = "SELECT KODSTATE,USERID,PASSWORD,KUMPULAN FROM USERID" Dim lrd As SqlDataReader = cmd.ExecuteReader() Try Do While lrd.Read() If lrd.HasRows Then a = lrd("KODSTATE") b = lrd("USERID") c = lrd("PASSWORD") d = …

[QUOTE=pritesh2010;1253711]use the System.Transaction class with your connection. for commit the transaction and rollback transaction. [CODE] Dim trans As SqlTransaction trans = con.BeginTransaction Try cmd = New SqlCommand("insert query", con, trans) ''con is a connection cmd.ExecuteNonQuery trans.Commit() MsgBox(" Number of Records inserted : " & count) Catch ex As Exception trans.Rollback() …

hi,i want to know how to export sql server 2005 database to access through vb.net coding..no need to select n insert table one by one,just save package...