dipesh1405241559
-
Content Count
10 -
Joined
-
Last visited
Posts posted by dipesh1405241559
-
-
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
-
thanks for your help everyone
-
I would recommend an Sapphire Radeon HD 2600 PRO w/ 512 MB GDDR3
http://forums.xisto.com/no_longer_exists/
Newegg has it listed as $79.99.
xboxrulz
my current grapics card is a nvidea geforce fx5600
-
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.You should have mentioned what brand was it. Anyway, it's ASUS P4SD-VX. It's support all AGP based video card. So you need to let us know what range of video card you want, and budget. Are you just looking for replacement for your existing broken video card? Or you want to improve your gaming experience. For the latter case, it would recommend changing monther/cpu/ram all together. Merely upgrading your video card while still using APG and DDR ram is quite limiting. It's a waste if you intent to invest in an expensive APG card, cause it won't be usable if you upgrade your system next time.
-
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
-
thank you for your help everyone
-
hi, i, am planning to build a turn based mmorpg like ogame or astro empires and need help with code for a battle calculator and sim, i am planning to code the mmo in php, can anyone help me please?
-
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
Connecting To Mysql Databse
in Programming
Posted · Report reply
hi, thank you for your replay, the reason i not using ado.net is because my uni course has not covered it.