I wrote an application with wpf and c sharp. And I use ado dotnet framework to connect the database. Now the problem is I want a centralize database for the application. And I hav e installed sql server on one of the which I want to serve as server. I now want all other clients to be able to connect to the database through local area network. how will I do that?
View 2 RepliesI have small Project In Vs 2013.i have to deploy it.but i did through Installshield. Project is working same PC but when i try to deploy another PC i cannot loin in to my project.it seems to me that i didn't add database .
View 2 Replies View RelatedI have 2 database. One is on live server and the other on local desktop.
User can make changes in database offline on local desktop.
But later he wants to move his changes to live server and also get the updates done on live server by other users. How can this be accomplished? What algorithm can be applied?
I am making a console based database system. Because I have to keep inserting, editing , deleting data blocks from my record file I have decided to use either vectors or list to store the all records. From the file I shall read the entire vector/list and work with it to add , remove or edit record and then again write the entire vector/list to the file again. I figured it would stop all the weird things that happen when directly working with the file. Is it an efficient way ?Or is it totally unnecessary ?Is there a better way?
View 2 Replies View Relatedi am trying to make a simple log in system without the use of database or whatever it is called.
my only concern is this
cout<<"enter password:";
cin>>pass;
how would i be able to make the characters appear as **** rather than the actual character that i would type as i am typing my password in CIN? or is it even possible?
Which is best option to save images in database or file system, I am developing c++ server client app. I want to save the images in server using file system or database. I am confusing to choose which option?
View 5 Replies View RelatedThe first time my application opens up, it should get the local date out of the System and store this in a registry key. But the second time it should get the date stored in that registryKey and compare it to the date right now.And there is where I am stuck, I just don't know how to get the date out of that key and compare it to the date right now.
This is my code:
RegistryKey key1;
private void btnTrial_Click(object sender, EventArgs e) {
DateTime current = DateTime.Now;
key1 = Registry.CurrentUser.OpenSubKey("myKey");
if (key1 == null)
[code]....
at the last "if" statement it should compare the date stored in the key with the DateTime.Now.
I have a desktop application in which i want to copy files from my local computer to an online server. I have the user name and the password of the server. is there any way like
file.copy(sourcePath,destinationPath)
to copy the files where the destinationPath will be something like
"192.168.x.xx/files" ..
I am making an application that runs on Machine1 and the purpose of the application is to copy the files from Machine1 to Machine2. It works fine but i have to share the folder of the Machine2 where i copy the files.
Is it possible without sharing.
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 can't seem to get my program to save the Set.savv file and encrypt it and decrypt it when user logs back on to there virtual file on a CD and writing it to the disk its self and closing the session
View 8 Replies View RelatedI 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 Replies View RelatedHow can i browse database name and server to connect?
View 3 Replies View RelatedI 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.
i am student working on a project in c# to maintain the datas from a solar battery monitoring.i already imported the datas from the battery monnitoring and saved them in mysql database and retrived the data in c#.
i have problem in retriving the data in accordance with the date and time range selection.
what i am trying to do is there are more than 1000 datas in the table if i select two date and time the datas in the table should cross check these dates and show all the datas in the table in between those date&time
I have tried to use File.Copy and File.Move but non of them would work as I expected .....
View 1 Replies View Related