duplicates primary key Programming Software Development by arezz09 … has create system registration that use vb.net 2008 & accessdatabase (oledb connection) i set ID as primary key,when i… base, please insert ID corectly" if data already in accessdatabase... anyone.. Casting oledb to Sqlclient objects Programming Software Development by waleed.makarem … As OleDb.OleDbConnection Public gg as object if applicType="AccessDatabase" then directcast(gg,oledib.oleDbConnection") but this gave… me an error . I tried also : if applicType="AccessDatabase" then directcast(aa,oledib.oleDbConnection") but gave an… Casting oledb to Sqlclient objects Programming Software Development by waleed.makarem … As OleDb.OleDbConnection Public gg as object if applicType="AccessDatabase" then directcast(gg,oledib.oleDbConnection") but this gave… me an error . I tried also : if applicType="AccessDatabase" then directcast(aa,oledib.oleDbConnection") but gave an… Re: Casting oledb to Sqlclient objects Programming Software Development by TnTinMN … worked fine for me. Dim applicType As String = "AccessDatabase" 'I just intitialized the objects to get rid of… As System.Data.Common.DbDataReader Select Case applicType Case "AccessDatabase" conn = New OleDb.OleDbConnection() cmd = New OleDb.OleDbCommand… Re: Casting oledb to Sqlclient objects Programming Software Development by TnTinMN … it to the System.Data.Common.DbParametersCollection. If applicType = "AccessDatabase" Then cmd.Parameters.Add(New OleDb.OleDbParameter("Name… updating table 2 from table1 in msaccess Programming Software Development by regalla … field which is same as table 1 field in ms accessdatabase. when ever i enter data in table1, table2 field which… mulitple search queries to display records from access database Programming Databases by rahulsaigal hello , i have the following accessdatabase access database name = surya table name = collection field 1=id … combo load access Programming Software Development by arezz09 anybody know how to load 1 column data from accessdatabase into combobox item...i mean, i have 1 table " info_table and 1 column "product..so in product column have data like nokia and sony"..i want nokia and sony to be load into combobox item or dropdownlist...anybody help me... load data to combobox Programming Software Development by arezz09 … create 2 combobox in form, comboproduct & combomodel. i using accessdatabase and using oledbconnection..database in debug folder... i create 1… crystal report Programming Software Development by arezz09 i hve create crystal report in vb.net 1 accessdatabase with password..using oledb connection when i wont to print data using crystal report, it will ask a password cz i have set database with password.. do i set password in crystal report or anywhere cz i dont know, so nexttime i wont print, it will not password.. listview column Programming Software Development by arezz09 i hve create 1 listview and all data from accessdatabase (using oledbconnection) in database hve 4 column, so in listview … filtering multiple column Programming Software Development by arezz09 i using datagrid and all contents in datagrid from accessdatabase (using dataset) i hve this in query builder.. SELECT product, … datagrid refresh Programming Software Development by arezz09 i hve 2 form..first for insert dat & second for preview data..i'm using datagrid to preview data from accessdatabase.. how to make datagrid automaticly load data form database after insert new data..data grid only load after i relaunch my application...do i need create refresh button or anything else?? combobox load Programming Software Development by arezz09 i using this code to load data from accessdatabase to 2 combobox [CODE] Dim cmd As OleDbCommand = New OleDbCommand(&… retrive picture based on ID Programming Software Development by arezz09 … application... i using this code to save employee information into accessdatabase [CODE]If _contactIC = 0 Then sql = "insert into employee_table… combine 2 statment Programming Software Development by arezz09 how to combine this 2 statment.. [CODE] IsConnected("Select * from manager_table", False) Call Loader() IsConnected("Select * from Clerk_table", False) Call Loader()[/CODE] i hve 2 listview, 2 table from accessdatabase..i put listview in tabcontrol..1 in tab 1 & second in tab 2... PHP / MYSQL Connection Error Programming Web Development by João_7 …/web/Classes/AcessDatabase.php online 9 The selected database Source AccessDatabase.php file: <?php class Acesso { public function Conexao () { $this… Re: Nested loop Programming Web Development by TobbeK Now it does hangs, but it keep on error I can email you an Accessdatabase with the exakt tables as i have in my MySQL at this moment. Re: Acces DataBase Programming Software Development by K.Vanlalliana ….0; Data Source = " & App.Path & "\Your AccessDatabase Name.mdb;" ConnectData.Open end sub Whenever you need… Re: Excel To Access...!!! Programming Software Development by DdoubleD … OleDbCommand()) { cmd.CommandText = @"SELECT * INTO [MS Access;Database=" + accessDatabase + "].[" + tableName + "] FROM [" + sheetName + "$]"… Re: export check listview item to crystal report Programming Software Development by arezz09 1.i hve create listview on form1..all data in listview from accessdatabase..im using oledb connection.. 2.in listview i hve create a checkbox.. 3. i wont print data in listview using crystal report but only check item in listview will display in crystal report..i mean, display item that i hve check in listview to crystal report.. Re: check & print Programming Software Development by arezz09 i hve 1 project about product information.. all data from accessdatabase & i using oledb connection..so i only need print few data from listview..i hve create checkbox in listview but i dont know how to print selected data by checkbox.. Re: Browse exe.. Programming Software Development by arezz09 let forget about browse.. yes i using accessdatabase... can i make standalone system be server & client so i can using in 2 computer Connecting accessdatabase Programming Software Development by jrosh a Re: duplicates primary key Programming Software Development by Jx_Man just select id from database..if id key already saved in database then give an error message.. Re: duplicates primary key Programming Software Development by arezz09 what u men..do i need use select statment... Re: duplicates primary key Programming Software Development by debasisdas Why not make the ID field an auto number . Re: duplicates primary key Programming Software Development by Jx_Man [QUOTE]what u men..do i need use select statment... [/QUOTE] Yes.. before insert your data, you need to search the ID in database.. if Id exist in database then show an error message.. Re: duplicates primary key Programming Software Development by arezz09 can i put select statment with insert statment in same button.. when id in database not same data succesful insert, if same i get mesej & get focus() on id.text can u help me, i hve try mny time but i still dont how to combine 2 statment... Re: duplicates primary key Programming Software Development by debasisdas Yes. Using the select statement you need to check if the ID already exist. If not --insert it. If already exist---try a new ID.