This is a migrated thread and some comments may be shown as answers.

How to enter values to null cells

5 Answers 60 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Stavros
Top achievements
Rank 1
Stavros asked on 11 Dec 2008, 07:59 AM
I am trying to enter values in a row that have half the fileds with values and the other half of the fields as nulls.
I used the update command to set values to the null cells with no lack.
Any ideas?
Thank you.

5 Answers, 1 is accepted

Sort by
0
Stavros
Top achievements
Rank 1
answered on 11 Dec 2008, 08:21 AM
I see the the problem is not the null cells.
I enter values manually using the sql management studio but I still cannot update the cells.
I am using edit in line.

Here's the code:

http://www.shorttext.com/7k7mz8z
0
Stavros
Top achievements
Rank 1
answered on 11 Dec 2008, 08:56 AM
I have tried every possible way but still the values are not updated.
Any ideas?
Thank you very much.
0
Stavros
Top achievements
Rank 1
answered on 11 Dec 2008, 09:08 AM
I even tried to use ? in the update command but I get the error :

Incorrect syntax near '?'.

0
Stavros
Top achievements
Rank 1
answered on 11 Dec 2008, 10:30 AM
The transact-sql code :

UPDATE

 

dbo.buildings_pagies_ergasies

 

SET

 

column1=150

 

WHERE

 

column2=4

works fine but the update command I am using in the code :

 

UpdateCommand

 

="UPDATE [buildings_pagies_ergasies] SET [column1]=@column1

 

WHERE

[column2]=@original_column2"

does not work!

0
Georgi Krustev
Telerik team
answered on 12 Dec 2008, 11:35 AM
Hi Stavros,

We create a test application, with the latest build of the Telerik controls, which covers your scenario. I have attached the code sample that I used for testing in the support ticket that you opened on the matter. To avoid duplicate posts, if you do not mind we can continue our communication there.

Best regards,
Georgi Krustev
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.
Tags
Grid
Asked by
Stavros
Top achievements
Rank 1
Answers by
Stavros
Top achievements
Rank 1
Georgi Krustev
Telerik team
Share this question
or