|
So make the connection string of the app point to the one DB, on the LAN.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
And if in same time 2 want to update one table what happens?
Best wishes
|
|
|
|
|
mehrdadc48 wrote: if in same time 2 want to update one table what happens?
SQL Server is a highly scalable multi user database system. You get versions from Express upto Enterprise which can handle thousands of users simultaneously. The database engine deals with it - that's what its good at.
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
"I wouldn't say boo to a goose. I'm not a coward, I just realise that it would be largely pointless."
Ready to Give up - Your help will be much appreciated.
My website
|
|
|
|
|
You have a few choices, you can have it as last one to update wins, you could put in a check to see if the record has been updated since the last read (sql server provides the TIMESTAMP column type for this).
You could create some sort of checkout/checkin/lock system.
It all depends on what the app is for and how it will be used. This issue is called concurrency if you want to do some searching on the subject. I personally tend towards optimistic concurrency, but that is what normally suits my apps.
|
|
|
|
|
How do I make a window application run on a network
|
|
|
|
|
What do you mean by 'run on a network' ? It will access files on the network, just pass network paths to it. You can run it over a network, point to the exe over the network. How else do you mean ?
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
I have a various tables which gets activated as a user selects an option.I want to poulate the results in a datatable and check they are not duplicate data from each table.My datatable should contain a dataonly once no duplicates.
How do i go about that?
Is there a function that checks the data before writing it to datatable so that it cant duplicate?
Please advice
Thanks and regards
|
|
|
|
|
Not really, your database should have keys set so that it won't accept duplicates. The other way is to write a select to see if the data exists. Finally, you can insert with a stored proc that first checks if the data exists, and only inserts if it doesn't.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Every table must have primary key and the Domain of each column must matches with one another to get the correct type of data in a column of the datatable.Load 1st row from i(Option selected) table to common datatable, check whether that rows is exists in common datatble,if it is then dont add the row else add them and proceed further with next row in i table.
Regards
Chintan
www.visharadsoft.com
(Nothing is so purify as KNOWLEDGE)
|
|
|
|
|
THANK YOU ALL YOUR HELP IS VERY GREAT.
|
|
|
|
|
Have a look at DataColumn.Unique property.
|
|
|
|
|
Kindly link me anyone who have successfully deployed a windows based application with crystal report, using C#.Net 2005. B'cos am bug with deployment issue on crystal report.
|
|
|
|
|
Describe your bug with the deployment and someone might be able to help.
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
hi
the application is written in .net compact framework 1.0.
i need to display a list of items with different forecolor for each item. the items get added to the list from a file. i have two problems:
1. the items get added but i get a horizontal scrollbar by default. i just want them too be added to the end like that in a listbox.
2. how do i set the forecolor of individual items?
thanks.
|
|
|
|
|
i got the way to get view the items in a list with vertical scrollbar but the second problem still remains...
does anyone have any suggestions???
thanks.
|
|
|
|
|
For each item in listview you have to set the color like
this.listView1.Items[0].ForeColor = System.Drawing.Color.Red;
this.listView1.Items[0].ForeColor = System.Drawing.Color.Blue;
|
|
|
|
|
hi
How can i build colourful context menu for notification icon(System Tray Icon). Plz share any idea with u. I am getting sooo trouble on it
thanks
evilinside
|
|
|
|
|
You are going to have to read up on custom controls.
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
Hai friends
I am working for one private software company where in i a need to do the chatting program. I am new to .NET platform. please help me by sending either an sample program or by sending the coding. I need the thing in ASP .NET using C# coading.
Sathiya
|
|
|
|
|
go to google.com and search "multithreaded chat application in c# " you may get your answer.
evilinside
|
|
|
|
|
go to www.questpond.com if you wanna need whole project on chat application.
Regards
Chintan
www.visharadsoft.com
(Nothing is so purify as KNOWLEDGE)
|
|
|
|
|
What s session time? How to calculate the session time? wat s the duration of session? Pls reply soon...
Thanx
|
|
|
|
|
session time relates to web dev, it means how long the web app regards you as being connected when you stay idle. It can be configured on the server.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
The mysterious error i've found in the database that is.
This group section cannot be printed because its condition field is
nonexistent or invalid. Format the section to choose another condition field.
Error in File C:\DOCUME~1\ADMINI~1.ABC\LOCALS~1\Temp\temp_ef660b00-652e-4d6f-ba7c-e56310031a98 {583537DD-DED3-4230-BB59-FC225EDD5F1E}.rpt:
Invalid group condition.
Can any one help me against this gaint i'd worked very hard for solving it out but failed..... .
Help Help Help.... .
Thank
Syed Shahid Hussain
|
|
|
|
|
Hi,
I have a custom button, that can have any background Color. Now user can pick background color, byt I don't want user to pick it's forecolor (text color) . I want to calculate that color myself. Can you help me out with some algorithm to do this = to calculate a fore color that is diffrent enough from specified background so that it is perfectly readable for human eye ?
I understand HSL Color scheme and tried to create something by myself but it was not good enough and I don't want to put it here so you won't be influenced by my sollution.
My only requirement is to keep that text color in grayscale.
thanx
PS: I've tried luck at Graphics department but not much people visit that forum...
|
|
|
|