I havent used it.. The update code of the gridview is like below.There is no mistake... UPDATE [CP_MASTER] SET [ORDERNUMBER] = @ORDERNUMBER, [NEWRPT] = @NEWRPT, [UNICLODEL] = CAST(@UNICLODEL as smalldatetime), [SUPPLDEL] = @SUPPLDEL, [CUSTOMER] = @CUSTOMER, [DEPARTMENT] = @DEPARTMENT, [SUPPLIER] = @SUPPLIER, [LINE] = @LINE, [COLORS] = @COLORS, [QTY] = @QTY, [NOTES] = @NOTES, [RATIO] = @RATIO, [WC] = @WC, [KIMBALL] = @KIMBALL, [LAPDIPSENT] = @LAPDIPSENT, [LAPDIPAPPRV] = @LAPDIPAPPRV, [WASH] = @WASH, [WASHTYPE] = @WASHTYPE, [PRINTX] = @PRINTX, [PRINTAPPRV] = @PRINTAPPRV, [EMB] = @EMB, [EMBAPPRV] = @EMBAPPRV, [BULKFABRICARRV] = @BULKFABRICARRV, [FITSENT] = @FITSENT, [FITAPPRV] = @FITAPPRV, [SIZESETSENT] = @SIZESETSENT, [SIZESETAPPRV] = @SIZESETAPPRV, [SEALERSENT] = @SEALERSENT, [SEALERAPPRV] = @SEALERAPPRV, [BULKFABRICTEST] = @BULKFABRICTEST, [GARMENTTEST] = @GARMENTTEST, [CUTDATE] = @CUTDATE, [SEWING] = @SEWING, [MIDINSPECTION] = @MIDINSPECTION, [PRODSENT] = @PRODSENT, [PRODAPPRV] = @PRODAPPRV, [INSPECTIONDATE] = @INSPECTIONDATE, [STATUS] = @STATUS WHERE [ORDERDATE] = @ORDERDATE AND [ONUNICLO] = @ONUNICLO AND [STYLE] = @STYLE AND [MERCH] = @MERCH

Hello Experts, There are some date columns in my data grid. The data in a date column is like below: "01/11/2010" But when I press the update button on the gridview then the edititemtemplate directly converts the data as: "01/00/2010" What is the problem??..Please help...

Thank you for your reply.Of course I did it...And the result is ""

Hello Experts, I have a gridview on a web page.I have set the data format of all columns that consist date data as {0:dd/MM/yyyy}. I have also configured my sqlcommand string as: set dateformat DMY But update operation still works as Month/Day/Year format. I have tried many things but could not solve the problem. Please Help

Hello Experts, I want to retrieve cell values from a gridview data row.There are unbound and bound columns in a row.I can retrieve values for bound columns but cannot get it for unbound columns. My code is like below: protected void Button1_Click(object sender, EventArgs e) { GridViewRow objRow = GridView1.SelectedRow; TextBox2.Text = objRow.Cells[41].Text; //bound column TextBox3.Text = objRow.Cells[42].Text; //!!!!unbound column!!!! } Please help.What is wrong?

Hello, Thank you for your reply. I have added the following code but nothing changed: <asp:TemplateField HeaderText="EAN" SortExpression="EAN"> <EditItemTemplate>  <asp:DropDownList ID="DropDownList1" runat="server" DataTextField="EAN" DataValueField="EAN" > <asp:ListItem Text="YES" Value="YES" /> <asp:ListItem Text="NO" Value="NO" /> </asp:DropDownList> </EditItemTemplate>

Thanks for your reply.. I have added the following code and no change occured: <asp:TemplateField HeaderText="EAN" SortExpression="EAN"> <EditItemTemplate>  <asp:DropDownList ID="DropDownList1" runat="server" DataTextField="EAN" DataValueField="EAN" > <asp:ListItem Text="YES" Value="YES" /> <asp:ListItem Text="NO" Value="NO" /> </asp:DropDownList> </EditItemTemplate>

Hi folks, I have add a dropdownlist into my datagridview. This dropdown list consists two unbound value (item1= 'YES' and item2= 'NO') How can I update my datagridview data by using update button. Any idea? error message is: "DropDownList1' has a SelectedValue which is invalid because it does not exist in the list of items"

Is it too difficult to write just a few words? But thanks for your help also.

Hi folks, I have an extremely simple question. I have a datagrid that consists 18 edititemtemplate columns.But When I try to edit these columns then I can only view 16 of them. how can I view and edit all of these columns. Please Help

Wow...really good results... Is it possible to move a column from second row to first row? I mean suppose that I made a basic select operation and got the result as below: --------------------------------------------------------- SELECT Voyage_ID,StartDate,PlateNumber,Driver1 FROM voyage_END order by startdate Voyage_ID StartDate PlateNumber Driver1 421 2005-12-28 34 VS 0845 X 750 2005-12-28 34 VS 0845 Y ---------------------------------------------------------------- The MAJOR problem is: How can I create a new table such as: Voyage_ID StartDate PlateNumber Driver1 Driver2 421 2005-12-28 34 VS 0845 X Y difficult case...right?

Wow...really good results... Is it possible to move a column from second row to first row? I mean suppose that I made a basic select operation and got the result as below: --------------------------------------------------------- SELECT Voyage_ID,StartDate,PlateNumber,Driver1 FROM voyage_END order by startdate Voyage_ID StartDate PlateNumber Driver1 421 2005-12-28 34 VS 0845 X 750 2005-12-28 34 VS 0845 Y ---------------------------------------------------------------- The MAJOR problem is: How can I create a new table such as: Voyage_ID StartDate PlateNumber Driver1 Driver2 421 2005-12-28 34 VS 0845 X Y difficult case...right?

Hi Folks, I have a database table named Voyage_History that stores the voyage information of our company's vehicles. I have imported data from an MS Excel file and finally I had get the result as screen below: --------------------------------------- SELECT Voyage_ID,PlateNumber,StartDate from Voyage_End as ddd Group By Voyage_ID,PlateNumber,StartDate Voyage_ID PlateNumber StartDate ----------- ----------- ------------------------------------------------------ 1 34 DD 0254 2005-12-28 00:00:00 2 34 DD 0254 2005-12-28 00:00:00 3 34 DD 0254 2005-12-30 00:00:00 4 34 DD 0254 2005-12-31 00:00:00 5 34 DD 0254 2006-01-01 00:00:00 6 34 DD 0254 2006-01-04 00:00:00 7 34 DD 0254 2006-01-05 00:00:00 8 34 DD 0254 2006-01-05 00:00:00 9 34 DD 0254 2006-01-06 00:00:00 10 34 DD 0254 2006-01-06 00:00:00 11 34 DD 0254 2006-01-12 00:00:00 12 34 DD 0254 2006-01-13 00:00:00 13 34 DD 0254 2006-01-16 00:00:00 14 34 DD 0254 2006-01-17 00:00:00 15 34 DD 0254 2006-01-17 00:00:00 16 34 DD 0254 2006-01-21 00:00:00 17 34 DD 0254 2006-01-23 00:00:00 18 34 DD 0254 2006-01-26 00:00:00 ------------------------------------------------ In fact, voyage_ID 1 and Voyage_ID 2 are same voyages. Because all data is same. How can I create another table that stores unique Voyage_ID, and the most important part of the question how can I import this data correctly? ( I mean how to determine the same voyages) Should I have apply a recursive select statement? -- modified at 9:44 Thursday 13th July, 2006

I am really sorry for my bad english.. The question is I think very simple? How can I send a smalldate parameter from c# to SQL server. That's all!

Firstly I would like to say thank you for you attention. I already tried to get success result via a stored procedure. And unfortunately the result was not ok.Here is my stored procedure: /**************************************************************** CREATE PROCEDURE [MaintStartUpdate] (@PlateNumber_1 [char], @MaintEntryDate_2 [smalldatetime], @MaintReason_5 [char](20), @MaintCompany_6 [char](20), @MaintCompanyTel_7 [char](11), @MaintCompanyAddress_8 [nvarchar](50)) AS UPDATE [CollLogistics].[dbo].[MAINT_START] SET [MaintReason] = @MaintReason_5, [MaintCompany] = @MaintCompany_6, [MaintCompanyTel] = @MaintCompanyTel_7, [MaintCompanyAddress] = @MaintCompanyAddress_8 WHERE PlateNumber = @PlateNumber_1 AND [MaintEntryDate]= @MaintEntryDate_2 GO /************************************************************** I really want to crash my computer right now. Because this is a very stupid and easy SQL update...And I still could not do anything!

Hello Folks, I really need help to solve a real stupid situation I have a SQL Server database table named MAINT_START.Columns of this table are: PlateNumber char(11)--------> PK MaintEntryDate smalldatetime---> PK MaintReason char(20) I want to update this table's MaintReason column via a SQL String. My code is like this: /********************************************************************** string strUpdate="UPDATE MAINT_START SET MaintReason='" + cMaintReason.Text.TrimEnd() + "'," + " MaintCompany='" + cMaintCompany.Text.TrimEnd() + "'," + " MaintCompanyTel='" + cMaintCompanyTel.Text.TrimEnd() + "'," + " MaintCompanyAddress='" + cMaintCompanyAddress.Text.TrimEnd() + "'" + " WHERE PlateNumber='" + cPlateNumber.Text + "' AND" + " MaintEntryDate =Convert.ToDateTime(cMaintEntry.Text)"; SqlCommand aCommand=new SqlCommand(strUpdate,Myconnection); /************************************************************************ Dear friends is it really impossible to insert or update a smalldatetime column? Please Help..

Hi Folks, I have 3 datagrids on a same webform. I want to assign a value to 3rd datagrid's specific cell on DataGrid2's SelectedIndexChanged event. How can I do this? Is it possible to do this on Runtime? private void DataGrid2_SelectedIndxChanged(object sender, System.EventArgs e) { //Assign a specific value to DataGrid3 } Thanks in advance and King Regards

Thank you very much for your attenton...But Unfortunately the result is not correct... I really wonder is this really an IMPOSSIBLE question???

string strSQL="INSERT INTO SupplierOperations VALUES (" + txtOrderNum.Text + ",'" + txtModelNum.Text + "','" + ddListVendor.SelectedItem.Text + "','" + DropDownList3.SelectedItem.Text + "','" + txtModelType.Text + "','" + txtModelExp.Text + "','" + ddlistGrup.SelectedItem.Text + "'," + Convert.ToDateTime(Textbox2.Text) + "," + Convert.ToDateTime(TextBox1.Text) + "," +(TextBox6.Text) + "," + txtTerminDayCount.Text + "," + txtOKcount.Text + "," + txtConditionCount.Text + "," + txtStopCount.Text + "," + txtTotalCount.Text + "," + txtControlCount.Text + "," + txtMajor.Text + ")"; try { CollConnection.Open(); SqlCommand cmd=new SqlCommand(strSQL,CollConnection); cmd.ExecuteNonQuery(); . . Enough??

First of all,I would like to tell thank you very much for your attention... The problem is very clear I think.. INSERT INTO tbl1 VALUES (........) How can I convert the TextBox string to a SmallDateTime value?