|
If SQL Server is running on the network machine, then you are connection to a database server. It doesn't matter that the machine itself isn't actually called a database server. In either case, you can find any connection string you might need here.[^]
If you want to connect directly to a SQL Server database file on an a machine with an instance of SQL Server or SQL Server Express, you need to look at the "Microsoft SQL Server Database File" data source. This attaches a database file when you open a connection.
Semicolons: The number one seller of ostomy bags world wide. - dan neely
|
|
|
|
|
Hi All
how can select personal folder in outlook programmatically from C#...
Thanx in Advance...
Mohan t working for N.I.C
|
|
|
|
|
Hi everyone,
If I compile my project on the vista 64bit can I use of it on the XP(32bit) or no?
|
|
|
|
|
Building a project ON a 64 bit machine and building a project FOR a 64 bit machine are two different things. If you are building a solution to run on a 64 bit machine, it won't run on a 32 bit machine. But a 32 bit executable will run on a 64 bit machine with the help of a window on windows subsystem.
Nobody can give you wiser advice than yourself. - Cicero
.·´¯`·->Rajesh<-·´¯`·.
Codeproject.com: Visual C++ MVP
|
|
|
|
|
If the platform target of the project is "Any CPU", it will work on both 32-bit and 64-bit systems.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
i have table used by two users , and i want to display alarm to user2 when user1 insert new row to the table ..
how to do that
regards
|
|
|
|
|
Hi,
You may try the following code snippet, it checks whether the row which user is trying to edit is a new row or not. If yes then it will show a message box.
BEGIN CODE
If dataGridView1.Rows(dataGridView1.CurrentRow.Index).IsNewRow = True Then
MsgBox ("This is a new row")
End If
END CODE
Hope this helps  .
Regards,
John Adams
ComponentOne LLC
|
|
|
|
|
If you are using SQL Server 2005, you may be able to do it with Notification Services (haven't used it myself). Otherwise, you will have to poll the database periodically to see if new rows have been inserted.
Cheers,
Vikram.
The hands that help are holier than the lips that pray.
|
|
|
|
|
can i count the table rows and display the message when rows count incremented by 1 row?
i need some help to do that
regards to all posts
|
|
|
|
|
What's the explanation for why this doesn't work? What I'm after is a MouseMove handler that does not get called as a result of my programmatic mouse moves. (I know there aren't a lot of good reasons to move the cursor programmatically. This is just an example. I'm after the theory here).
The result of this code is that the MouseMove handler is continuously called (as a result of the code that moves the mouse in the MouseMove handler). But why doesn't unsubscribing from the event prior to moving the mouse keep the handler from being called?
private void OnMouseMove(object sender, MouseEventArgs e)
{
this.MouseMove -= OnMouseMove;
Cursor.Position = new Point(Cursor.Position.X + 1, Cursor.Position.Y);
this.MouseMove += OnMouseMove;
}
My best guess is that this is a threading issue. If that's the case, any ideas on how to fix it? Any ideas?
Thanks!
Ian
|
|
|
|
|
In that event handler, you unsubscribe the event, change the position of mouse pointer, and subscribe again. The event handler will be called again after that.
For me, the codes works just fine.
|
|
|
|
|
But the handler is called in response to the move, which took place after I unsubscribed, and before I re-subscribed.
|
|
|
|
|
Hello everyone,
How to check whether a port on the local machine is occupied by another thread/process? (only whether or not occupied is ok, no need to know which party occupied the port.)
Any samples or APIs to use?
thanks in advance,
George
|
|
|
|
|
If Socket.Bind(EndPoint); throws exception, the port is in use. Does it helps?
|
|
|
|
|
Thanks d@nish,
It helps.
regards,
George
|
|
|
|
|
You could also use Socket.Poll or Socket.Select.
|
|
|
|
|
Thanks dude!
regards,
George
|
|
|
|
|
I have a data grid that contains a checkbox in its one of the columns. I have another column that needs to get populated with current date after we check the checkBox, as soon as we click on checkBox but not after we leave the CheckBox cell.Please help me.
Thank you
|
|
|
|
|
Hi Prabhat,
You can set that extra column visible = false with the current date value. Then when user check the particular checkbox, then you can reset the column visibility to true.
I hope this will help you.
Regards
|
|
|
|
|
Hi Aragon,
well thanx .This is just a trick.I need an event such that if we click on the cell of the grid,it should give response at the time we click on that cell.I think the way u suggested also works when we leave that cell.
Thank you. 
|
|
|
|
|
I can't understand the "leave cell" term. Do you mean that that date column should be displayed in the place of the checkbox?  you can use the ItemCreated event for registrations of the checkedchanged event of the checkbox and then apply your logic for this.
Regards
|
|
|
|
|
Hi Aragon,
I cant find any ItemCreated event.Will u please tell me the procedure.For ur confusion I have written my code below.
if (Convert.ToBoolean(e.FormattedValue) == true)
{
myDataGrid.Rows[e.RowIndex].Cells["Column2"].Value = DateTime.Now.ToString("MM/dd/yyyy");
}
else
{
myDataGrid.Rows[e.RowIndex].Cells["Column2"].Value = null;
}
Here,Column 1 should get populated when we check "column 1",lets say.
|
|
|
|
|
How about using CellContentClick event?
|
|
|
|
|
Hi d@nish,
It still doesnot work.Yes it gets populated with current date but not at the very moment we click on the checkbox.
|
|
|
|
|
It works absolutely fine for me. Can I have a look at your code?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
