Jump to content
xisto Community

dipesh1405241559

Members
  • Content Count

    10
  • Joined

  • Last visited

Everything posted by dipesh1405241559

  1. hi, thank you for your replay, the reason i not using ado.net is because my uni course has not covered it.
  2. 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
  3. my current grapics card is a nvidea geforce fx5600
  4. 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.
  5. 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?
  6. 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
  7. 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?
  8. 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
×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.