I have a problem with my datetimepicker i.e. it is always taking one value "12/30/1899". I am using following statement to get the values from the datetimepicker and then insert it into datagriedview.
this.datetimepi cker.text.toStr ing();
Above statement I am using in my Insert query in order to insert the date into table.
Could any one help me, and tell me why it is taking same value again and...
artteam
Last Activity: Mar 15 '07, 03:01 AM
Joined: Feb 1 '07
Location:
-
I appreciate for taking time. Could you be more specific. I did not understand when you say cancelling the prompt. I myself not aware of from where the prompt is generated.
Thank you in advance....
Sudhamsh Mahankali... -
Datagridview to excel
Hi All,
I try to export the table in DataGridView control on my form to MS excel with the following code.
...Code:private void fnExtractToExcel() { Microsoft.Office.Interop.Excel.ApplicationClass excel = new Microsoft.Office.Interop.Excel.ApplicationClass(); excel.Application.Workbooks.Add(true) ; DataTable inventoryTable = this.inventoryDataSet.Tables["Inventory"]; try { -
export datagridview to excel
Hi All,
I try to export the table in DataGridView control on my form to MS excel with the following code.
private void fnExtractToExce l()
{
Microsoft.Offic e.Interop.Excel .ApplicationCla ss excel = new Microsoft.Offic e.Interop.Excel .ApplicationCla ss();
excel.Applicati on.Workbooks.Ad d(true) ;
DataTable inventoryTable = this.inventoryD ataSet.Tables["Inventory"];... -
I thank you for your time. But my application is in ADO.Net....Leave a comment:
-
.msi Files
I have leant that .msi files help us install a microsoft based application on our hard drive at a particular location. I need to deliver a project developed in VS 2005, C#.Net to a client. Could someone please help me to make a .msi file and is there any other way I could get the projet installed on the client's machine.
Note:The application has 20 Winforms among which many of them are connected to database. And the client machine... -
The following statement is written by us which is calling the system generated code and it is the one which is raising the exception.
this.inventoryT ableAdapter.Upd ate((ArtStoreDa taSet.Inventory DataTable)this. artStoreDataSet .Tables["Inventory"]);
System Generated Code: in bold
[System.Diagnost ics.DebuggerNon UserCodeAttribu te()]
private System.Data.Ole Db.OleDbDataAda pter Adapter {
...Leave a comment:
-
Concurrency error when deletinga record from datagridview
Hi All,
I get an error when I try to delete a record from the datagridview, which says Concurrency violation:the DeleteCommand affected 0 of the expected 1 records .
Could someone please let me know which statement is causing this exception.
I have made use of wizards to establish connection and generate the datagridview on to my form rather than writing code.
Thanks in advance. -
Concurrency error when deletinga record from datagridview
Hi All,
I get an error when I try to delete a record from the datagridview, which says Concurrency violation:the DeleteCommand affected 0 of the expected 1 records .
Could someone please let me know which statement is causing this exception.
I have made use of wizards to establish connection and generate the datagridview on to my form rather than writing code.
Thanks in advance. -
Editing the records in database via DataGridView
Hi frnds,
I am working on a project in which one of the form has a datagridview, I was successful in retrieving the table from the database.Now that I want to edit the records on this datagrid and save them back in the physical database.I have been try to do this in a number of ways but getting some or other error pops up.
The following is the code I have used.
myUpdateCommand .CommandText = @"UPDATE... -
problem with the update
private void btnSave_Click(o bject sender, EventArgs e)
{
//this.dataGridVi ew1.CurrentRow. Cells[5].Value.ToString ())
string sqlCommand;
sqlCommand =
"Update Inventory SET @ItemDescriptio n= ? " + ",@ItemNumb er= ?" +
",@ItemCode = ? " + ",@ItemType = ?" + ",@Location = ? " +
... -
Update query syntax for datagrid
we are having a sql query error when we are trying to update values from the datagridview to access database. The problem is because of date(because of its format), a runtime error pops up saying that "missing operator in query expression "to_date(2/2/2007 12:00:00 AM, "mm/dd/yy")"
we are only interested in date portion and not the time.
this our command string
cmd = "update Inventory... -
Yes you are right.We cleared the errorProvider before closing the form.Thank you very much for your suggestion.Leave a comment:
-
Installating a project
Hi All,
My team and I have developed a project which is ready to be delivered to a client shortly.The project was developed in Visual C#.Net on VS 2005. Now that we are ready to deliver the project, none of us are familiar about how this could be done. Do we need to create an .msi file and burn it to a DVD/CD and install on the client machine? If this is the only way could someone walk us through the steps for making one?
... -
Hi,
But I do not have to check for the validation when the user is trying to close the form without entering any text into any of the textfields. And this happening with respect to only one textform. And the close button is not bothered with other textboxes on the form. If i enter some value in that textbox then the form closes.
Please help me out!!!Leave a comment:
-
ErrorProvider
Hi All,
I have used errorProvider to validate the text in the textboxes. One among them is that it does not allow the user to enter empty string.But when I click the close button on the form it does not close instead the errorProvider pops up validating for the text(As the textbox is left blank).Is there a property to disbale or to make it inactive?
Thank You in advance. -
I thank you for your time. We could figur it out. All we did was, used RejectChanges method which does not allow the user to enter any duplicate values.
Thank you very much.Leave a comment:
-
Textboxes and OleDbException
Hi All,
My team and I are working on an Inventory Management project in Visual C#.Net and it is a WinFrom application.Com ing to the point, one of the Winform of the project lets the user to add items to the database.It was working fine when I did not validate the text in the textboxes as entered by the user.But when I started validating using errorProvider it throws and OleDbException saying that, the changes could not be made to...
No activity results to display
Leave a comment: