[database] Forum Topics

i am just developing a library management system as one of my project. i using vb.net 2010 and the MS Access 2007 as back end. when i save some records into my database through my application it is correctly saved and i confirmed it through opening the relevant table in …

How often is this updated. Is it cached? After creating/answering posts, the latest activity doesn't seem to be recorded. I assumed that because the new data -> DB, the 'TITI' - you gotta love that acronym - would query the DB and return said new data?

hello friends, i have a windows project in vb.net, in which i have to connect my project with an excel database i have microsoft office 2007 installed on my lappy.. please help me with the code. thanks in advance..

Hello all! I'm helping my employer redesign their database system. They're currently using MS Access exclusively, but they are updating their computer systems to Apple machines and want to convert to a standalone application to access a background database (e.g., a standalone Java program using JDBC to access a background …

[B]hello ! my thesis is all about language translation and im having a problem with the concatenation of strings in the textbox...because for example i input city kiss and it will display the ilocano(dialect) ili agek but when i input kiss city it still display ili agek[/B]

Hello guys, I found a lot examples about this one but I still don't have it all working. So the thing is that I have a button in my C# web application called Export to Excel. The functionality should works as if the button is clicked - it just simply …

1) Can a single connection to a MySql database be shared among applications? 2) Are there any possibilities that an error might accure when two applications compete for a single connection to a MySQL database? For example, Application 1 is using the connection to submit an insert operation to the …

Firstly, Sorry for the long post :) Im currently creating a training database for use within the business (not done many getting used to coding) I used MySQLMaestro to construct the datagrid and have modified it to suit most my needs. however i have one issue that i cant resolve. …

I had created a registration page for users to sign up an account and a database to store all information such as username and password. I had also created a login page for users to login after registering an account. How do I link the database so that I will …

All, I can't seem to find anything on the web about how to connect to a LibreOffice database. I am currently using the following code to connect to a MS Access database and would like to know how to change it to work with LibreOffice. [CODE]String strConnect = "jdbc:odbc:DRIVER=Microsoft Access …

Hi guys! I got a problem with my logging in system. I can connect to my database with the code: [CODE]session_start(); include('header.html'); $page_title = 'Home Page'; $mail = $_POST['email']; $password = $_POST['password']; $msg =''; if(isset($mail,$password)){ $con = mysql_connect('127.0.0.1','root',''); if(!$con) { die('Could not connect: '.mysql_error()); } else{ echo "Connected!"; } } …

Greetings! I have what I guess is a simple problem with a simple php code. What I want, is that with a simple form, the name and the password that are entered, are saved in a database. I have a form, and the action ="Process_Form.php" calls this file. Then, with …

Hi all I am currently working on a project for tech (university). It's a login form that uses a CAPTCHA as validation and must monitor the IP address of the computer that has currently requested the form. The IP monitoring part is so that if a user has made x …

Hi guys, I have a problem when using gridview which source is a database VIEWS, not a table. I have a MySQL database running, ASP web application(C# behind). Then the GridView's source is a combination of 8 views from the database. ([CODE]SELECT * FROM v1,v2,v3... v8[/CODE]) Then the problem is …

Hi there, I would like to implement a web based UI that allows people to drag and drop "chairs" and "tables" onto a floor layout (grids) and save it to their profile by storing in the database. I am wondering how do I start doing this? I am using vb.net …

i need code for vb.net 2008. That is invoice system i have number in each invoice. my database invoice number is null. when i click tab automatically invoice number increased number 1 ( EC000 to EC001). I used tab control . please reply...

Hello guyz, First of all, sorry for starting new thread with similar topic but I read each and still can't figure out how to do it. I'm having a database, using GridView I retrieve the data into my WEB application. Then I set the rows to editable (not sure if …

Hi! I'm trying to show 5 random images from my database and i seem to be stuck. Would appreciate some help or tips. I obviously dont want any duplicate images. Have tried to figure it out by googling butt my head hurts too much xD Got thumbnails for the picture …

Everytime I run this program and enter a new record, it gets terminated on these statements: [CODE] stud.pcent=((stud.mhin+stud.meng+stud.mmat+stud.msci+stud.msst)*100)/(mm.hin+mm.eng+mm.sst+mm.sci+mm.mat); fwrite(&stud,recsize,1,file); [/CODE] The whole program is this. It is only partially complete. [CODE] #include<conio.h> #include<iostream.h> #include<stdlib.h> #include<string.h> #include<stdio.h> #define UARROW 72 #define DARROW 80 #define ENTER 13 #define ESCAPE 27 int key; …

Hello guyz, First of all, sorry for starting new thread with similar topic but I read each and still can't figure out how to do it. I'm having a database, using GridView I retrieve the data into my WEB application. Then I set the rows to editable (not sure if …

Hello. I have a datagrid with 9 columns. I want to add a one row from data table who is that same. I believs I can do it that: [CODE]DataGridViewRow drow = new DataGridViewRow(); foreach (DataRow wiersz in dTable2.Rows) { for (int i = 0; i <= ilosckolumn - 1; …

What im doing is i have a form with 4 inputs like below. and im using the post method to store the fields values so i can send them to the database. what i neeed is each input to be put into a separate row in a databases table. also …

Hi, I wonder which is best tool for synhronise localhost project with the same project on shared hosting. For example, when I run that tool, my localhost project should get all files that doesn't contain from shared hosting (newest added images for news, organizations etc). I need something like SVN, …

Hello again. On topic, haha, I am using VB 2008, then I noticed that with the Provider.Oledb.12.ACE = database.accdb whatever connection string uses the bin/debug/database.accdb file when I connect my program with a database. Suddenly, a database with the same name appeared on the lets say "WindowsApplication1" folder. Then whenever …

I know i'm probably goin about this bassackwards. But, window is loaded, binded textboxes get filled, user edits textboxes and clicks a save button it works, all except crashing with a "vb.net 2010 Concurrency violation: the UpdateCommand affected 0 of the expected 1 records." most of the time but the …

[CODE] Public con As ADODB.Connection Public cmd As ADODB.Command Public dept_rs As ADODB.Recordset Public gen_rs As ADODB.Recordset Public stud_rs As ADODB.Recordset Public sql As String Private Sub cmdExit_Click() con.Close End End Sub Private Sub cmdSave_Click() With cmd .ActiveConnection = con .CommandText = "student_table" .CommandType = adCmdTable End With With stud_rs …

Hello guys, My question is not very direct and clear but i'll try to explain it nicely. I have a database running on MySQL with 1 important table which i need to use. Then I put this table into my C# application (I'm using Microsoft Visual Studio 2010). The only …

this thing is getting into my nerves and i really don't know what to do.. i tried a lot of variations in my code and even sql statement but still nothing happens.. i really need to do thing messed up project of mine and put all my efforts here.. but …

Hi all, I have 4 (four) tables using MySql database, ie: [CODE]tb_item ( id_item, (varchar) --> PK item_name, (varchar) price, (double) ) tb_order ( id_order, (varchar) --> PK id_item, (varchar) -->FK date_order, (date) lead_time, (float) order_quantity, (double) ) tb_use ( id_use, (varchar) --> PK id_item, (varchar) -->FK date_use, (date) use_quantity, …

Hey guys I'ld really appreciate if u can help me with this. I'm building an application that has an access database for storing codes for voters. my problem is that after i update my database with the usual vb codes, i'll have to exit the application before the datagrid view …