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.

Hi I want to convert Sql Server Database to Access Database , I have one database and it has different tables and view also. please help me how to do this ?

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 = …

Hi all I am trying to insert a record into MS-Access database using VS2008 as front end and this is my code i am using to connect to the database. login.mdb has two tables(login,schedules) [CODE] Dim con As New OleDb.OleDbConnection Dim cmd As OleDbCommand Dim myquery As String Dim count …

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...