I am developing a win form application with sq l server2005, in client system after install the application I created the folder for storing the database of running application, like that I have every year database separately, My doubt is how to connect the particular year database while loading the app?
View 1 RepliesHow can i browse database name and server to connect?
View 3 Replies View RelatedI have so far tried MySQL++, ODBC, SimpleDB, and the MySQL C++ Connector. All of them give me a FLOOD of errors in the output. Is there an easy way to connect?
View 7 Replies View Relatedlibrary management system in which c is used as front end and oracle is used as back end in order to retrieve the data. if possible can u send the source code for it.
View 1 Replies View RelatedI am studying Software Engineer and i have a project on C. The project is a simple Pharmacy Management. I know how to develop it also i have already created the DataBase but i don't know how to connect it.
Well here is the code :
#include <stdio.h>
void main(void) {
int option;
puts("Farmacy Managemet
");
puts("Options :
[code]....
So... I'd liked to save the details from <scanpre> to sqlite db. Also i'd liked to load the details to <scanmed> from my db (name,price,form, etc.)
I'm in the middle of creating a ePOS for my uncle and so far I've created a database for it where it will create, update and delete records successfully.
My next step I would like to do is to create a printer till thing, but how do I connect my database to that ?
I can create a till but how do I do link my database with it? I followed this example here [URL] ....
I have created 2 form which is login form, which username textbox already connected to the database and it is successfully. When user login, it direct to the second form, and in the second form, there are multiple textbox that i have created using Array List, and it has shown.
Here is my problem: I want to connect the textboxes in second form to the database, but it shown nothing when i run the program, i already trace the code which is the error, and the error is on when OleDBDataReader is reading, i dunno what's wrong with my code, in login form it run perfectly, but in the second form, there is an error.
Here is the image for Login Form:
Here is the image for Second Form:
Here is the code for Second Form: [CODE]
private List<List<TextBox>> textBoxCodeContainer = new List<List<TextBox>>();
string connectionString = (@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=ArchivesProjectsProgramSell SystemSell SystemApp_Datadb1.accdb;Persist Security Info=False;");
//****TextBox for Code****
for (int y = 0; y <= 16; y++)
[code]....
For the Second Form, in the column of code, it supposed to shown the autocomplete like at the Login Form.
I just got this new project from my employer. He asked me to create a desktop application that could remotely access our sites database in cPanel.
View 4 Replies View Relatedhow to connect a Firebird database with a Devc++ console application? I have tried different things with no success.
View 5 Replies View Relatedhow i upload excel file with value Save in database on server without show error.
Actually i have code who work correct on local host but not work on server then show error who write down Below
Microsoft.ACE.OLEDB.12.0 is not registered local machine.
I have an client application and server application, I want to make an update program, In my program I want client send a message to server if there is an new version or not, and server reply with a text message ,send will be done via web service .
View 1 Replies View RelatedI have tried to connect my sql server 2005 using a domain name. i have bought a domain name and a dns client. this is my connection string
{ SqlConnection sqlconn =
new SqlConnection("user id=user1;" + "password=pass2;"
+ "server=www.mysite.infoServerInstance;"
+ "trusted_Connection=false;" + "network
library=DBMSSOCN;" + "Integrated security=false;"
+ "initial catalog=Mydatabase;" +"connection timeout=5
;"); }
I have added sql browser & sql server in fire wall, and also enabled tcp port 1433 and udp port 1434. the above connection string works perfect when i run it in the server machine, but whenIi try to run it on other machines I am getting an error that server is not available or cannot find the specified server.. I desperately need to access my database through an url. ie., through internet..
I'm animating a human hand made in blender, so I allredy the hand, but I don't know how can I load this .obj to a windows form aplication that I'm working on. I need to load this .obj and animated .....
View 4 Replies View RelatedI'm getting error ID 10061 - WSAECONNREFUSED - No connection could be made because the target computer actively refused it. This usually results from trying to connect to a service that is inactive on the foreign host—that is, one with no server application running.
However, when I use 127.0.0.1 or localhost dns, everything works fine, Im connecting to the ip from [URL] .... with port 1337 ...
The main question how to fully traverse/circumvent through all TreeView, for transforming Tree structure into a Table structure.
I want to note that the TreeView may contain a different number of branches, with different depths and different names.
I found a lot of information how to populate TreeView e.g. from DataTable, but I didn't found information how to recursively traverse/circumvent a TreeView and populate/fill data e.g. to DataTable.
As sample I have following TreeView:
Aaron
-Baldwin
--Caleb
---Dale
--Earl
-Fabian
Gabriel
-Harold
-Ian
Necessary to convert the TreeView into e.g. DataTable:
id | Name | ParentId
--------------------------------
1 | Aaron | null
2 | Baldwin | 1
3 | Caleb | 2
4 | Dale | 3
5 | Earl | 2
6 | Fabian | 1
7 | Gabriel | null
8 | Harold | 7
9 | Ian | 7
How to set execute statement in the end of sql, Attach is my code:
private void InsertintoDB() {
string strSQL = "";
string strDBType = System.Configuration.ConfigurationManager.AppSettings["DBType"];
string strConn = System.Configuration.ConfigurationManager.AppSettings["DB_CONNECTION_STRING1"].ToString();
string strInsertTableName_Sql = "CIMMGR.[dbo].ANSDATA";
[Code] ....
I just wanna update my database with one click only.
I do for update my database from datagridview1 but it shows a error like this :
Unhandled exception has occurred in your application . If you click Continue, the application will ignore this error and attempt to continue. If you click Quit,the application will close immediately.
Update requires a valid UpdateCommand when passed DataRow collection with modified rows
Attached Files : WindowsFormsApplication4.zip (127.2 KB)
I have a text box invoice no on windows form and i need to retrieve data from database and everytime user click on the add button the invoice no should increment by 1...
View 7 Replies View RelatedI have application that codes and binds an access database to a windows form application. Everything seems to work however, nothing is actually saved in the database. Updates and deletes are coded and debugging steps through, but checking the db, the data is the same.
View 2 Replies View RelatedI have an application which inserts large amount of data in Access database. So to speed up the things i have set Indexed property to No.
So at the end of insertion i need to set the index to the column of the one of the table to Indexed (Duplicates OK) through C#.
I'll work soon on a program that should take the finger print from a reader and save it in sql server to determine employees's presence and leaving. My questions are:
1- Is the written code differ from one reader to another? or any code apply to all readers?
2- I knew that i should take the image and save it in varbinary in sql server, but how i shall take it?
3- Libraries i should use in visual studio 2010 and c#?
4- should i write license with a definite number of fingerprints save?
5- when i try to approve an employee pressece (by taking his fingerprint), shall i go directly to his id in SQL server and compare his fingerprint stored with the new one entered, OR i Should take the fingerPrint and search for it?
I have a program in C#.net. There is a datagridview which shows all the details of the student. Then I add a column to update another column using the value I entered. Means I want to add roll no to student details table while running. I want the code to update it. Is it possible?
View 1 Replies View RelatedI am facing a problem which is that when i search image from database then it just shows last image which is stored in the database. My code is
private void Images() {
SqlConnection con = new SqlConnection("Data Source=chusman-pc;
Initial Catalog=Hotel_Management;Integrated Security=True");
con.Open();
SqlCommand com = new SqlCommand();
[Code] ....
I call this function at SelectedIndexChanged of dropbox..
i want make a setup for C# program with SQL data base but i can not . i use installshield but i have error in connection to database in execution program.
View 32 Replies View Relatedadding a column in ms access database and update it with a value.Here is my code, it gives an error that says syntax error in field definition.
string myConn = " ";
myConn = "Provider=Microsoft.ACE.OLEDB.12.0;
Data Source=C:/Users/EmployeeAttendanceRegister/EmployeeAttendanceRegister.accdb";
OleDbConnection myCon = new OleDbConnection(myConn);
string myInsert = "ALTER TABLE Attendance ADD COLUMN SignIn" + dateTimePicker1.Value;
[Code] .....
I have patient_table in the database. which contain Id, name ,Image & other fields I have inserted the image in the Byte form in the database.Now i want to display all records in the Datagrid view in windows Form.
i am able to display id & Name & all fields but unable to display the image of a patient in the datagrid view.
I put all the records in the genric list:-
public static List<Personal_Details> AllMembers() {
List<Personal_Details> listMembers = new List<Personal_Details>();
Personal_Details pDetails;
try {
String Constring = ConnectionString.dataBaseConnectionString;
[code]...
i am unable to write the code for displaying the image on data gridview.
I am unable to find the solution for binding the image field in the datagrid view.