dipesh1405241559
Members-
Content Count
10 -
Joined
-
Last visited
Everything posted by dipesh1405241559
-
hi, thank you for your replay, the reason i not using ado.net is because my uni course has not covered it.
-
hi, i need help with connecting to a mysql database, i am developing my application in microsoft visual studio with vb.net and require help with the code for the connection string, as i am not using ado.net to connect to the database, i am using a vb class file to connect to the database. Private Sub OpenDatabase(ByVal DatabaseName As String, ByVal TableName As String)'declare a variable to store our SQLDim SQL As String'declare a new command builderDim CB As OleDbCommandBuilder'declare a variable to store the application pathDim DbPath As String = System.AppDomain.CurrentDomain.BaseDirectory & "App_Data\"'this is the connection string to an Access 2003 file uncomment as reguiredDim ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DbPath & DatabaseName & ";Persist Security Info=False"'this is the connection string for Office 2007'Dim ConnectionString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & DbPath & DatabaseName & ";Persist Security Info=False"'opens the connection object based on the connection stringmNewConnection = New OleDbConnection(ConnectionString)Try'open the connectionmNewConnection.Open()Catch ex As ExceptionStop'DatabaseTable error!!!!!!!!!!!!!!'the program has crashed probably due to mis typing the database name'DatabaseTable error!!!!!!!!!!!!!!End Try'build up our SQLSQL = "select * from " & TableName'connect the data adapter to the connection object using the specified sqlmDataAdapter = New OleDb.OleDbDataAdapter(SQL, mNewConnection)'initialise the select command of the data adaptermDataAdapter.SelectCommand = New OleDbCommand(SQL, mNewConnection)'initialise the command builder to initialis the other commands of the data adapterCB = New OleDbCommandBuilder(mDataAdapter)Try'populate the datatable via the data adaptermDataAdapter.Fill(mTableData)Catch ex As ExceptionStop'DatabaseTable error!!!!!!!!!!!!!!'the program has crashed probably due to mis typing the table name'DatabaseTable error!!!!!!!!!!!!!!End Try'take a copy of the record structuremARow = mTableData.NewRow'close the connectionmNewConnection.Close()End Sub
-
Updating Graphics Card Problems
dipesh1405241559 replied to dipesh1405241559's topic in Hardware Workshop
thanks for your help everyone -
Updating Graphics Card Problems
dipesh1405241559 replied to dipesh1405241559's topic in Hardware Workshop
my current grapics card is a nvidea geforce fx5600 -
Updating Graphics Card Problems
dipesh1405241559 replied to dipesh1405241559's topic in Hardware Workshop
hi , thanks for the help so far, i am look for a new grapics card cause i wish to improve my gaming experiance also my budget is £50 - £100. -
hi, i am trying to upgrade my graphcs card for the following motherboard p4sd-vx but can not find out what type of grapics card it supports, can any one please help?
-
hi, i am new to programming and have started creating my own turned based mmo in php, can any one help me i am stuck with the coding for the main part of the mmo also the php tutorials were not useful.this is the site for my mmo http://forums.xisto.com/no_longer_exists/ mmo will be similar on astroempires.com and ogame.org
-
I Need Help Finding The Best Way To Learn Php
dipesh1405241559 replied to dipesh1405241559's topic in Programming
thank you for your help everyone -
hi my name is dipesh, i resentally signed up to the site and would like the know the best way to learn php programming, my end goal is to create an mmorpg which is turn based like astroempires and ogame