Do u mean same database property? Actually, the database is restored but some changes had been made. But any changes had not been made to that data table which I'm trying to insert a record. Thanks for your help..

I'm using MSSQL2005. Inserting includes code such as 'X001' which is varchar and it needs to be incremented automatically. So that I converted varchar to numeric. It's ok for one database, but it's not ok for another one. I've checked all the data fields. It's all the same. Any solution for this? Thanks a lot.

I have a problem of inserting a record which includes data type conversion. There are two databases with the same data structure. One database is ok to insert that record, but another is not ok for data type conversion. I've checked all the data fields.Please give me any suggestion to solve it.

How to display detail information of a particular product in database? I want to write a web program for online product list which is similar to product list page of online shopping websites on the internet. Could anyone help me??

Dear raju melveetilpurayil, Thanks for your reply. It's useful. :thumbsup:

I want to fill gridview textbox by selecting data from gridview Dropdownlist

In my report, I added two different fields from two different datatables =First(Fields!NameOne.Value, "TestDataSet_TestDataTableOne") and =First(Fields!NameTwo.Value, "TestDataSet_TestDataTableTwo"). The result shows one row and no NameTwo is displayed. Then I changed the field as =Fields!NameOne.Value,=Fields!NameOne.Value. Then error occured. How can I display Both fields containing the selected data in Both datatable. Can anybody help me???

Hi. Can I use RequireFieldValidator control to check for the blank data? There, both of the two textboxes must not be blank. But it'll be ok if only one of these two textbox must be entered data. If with RequireFieldValidator, how can I use with it? Thanks.

Thanks for your help. I'm now trying to write my program according to your psudo code. At first, I thought this program in a very confused way. Thanks a lot! :)

Can u give me solution? I need to accomplish it. Thanks.

The GridView columns are as follow:       <Columns>                         <asp:BoundField HeaderText="ID No." DataField="NRIC" />                         <asp:BoundField HeaderText="Name" DataField="LabourName" />                         <asp:BoundField HeaderText="Event Name/Duty Roster" DataField="EventName/DutyRoster" />                         <asp:BoundField HeaderText="Working Date" DataField="WorkingDate" />                         <asp:BoundField HeaderText="Normal(hr)" DataField="NormalHour" />                         <asp:BoundField HeaderText="Amt(N)" DataField="NormalRate" />                         <asp:BoundField HeaderText="Extra(hr)" DataField="ExtraHour" />                         <asp:BoundField HeaderText="Amt(E)" DataField="ExtraRate" />                         <asp:BoundField HeaderText="Weekend(hr)" DataField="WeekEndHour" />                         <asp:BoundField HeaderText="Amt(W)" DataField="WeekEndRate" />                         <asp:BoundField HeaderText="Holiday(hr)" DataField="HolidayHour" />                         <asp:BoundField HeaderText="Amt(H)" DataField="HolidayRate" />                         <asp:BoundField HeaderText="Allowance" DataField="Allowance" />                 &n