473,466 Members | 1,658 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Update Datagrid's table

In my datagrid, there is Boolcolumn, i allow the user to click it .
Now, i need to update the table which the boolcolumn is True. if the column
is false,
I should not save those row.
How can I do that ?
Thanks a lot
Nov 21 '05 #1
4 1206
I solve myproblem by "add the filter condition in select command"
Now, How can I refresh the datagrid ??

"Agnes" <ag***@dynamictech.com.hk> ¦b¶l¥ó
news:el**************@TK2MSFTNGP11.phx.gbl ¤¤¼¶¼g...
In my datagrid, there is Boolcolumn, i allow the user to click it .
Now, i need to update the table which the boolcolumn is True. if the column is false,
I should not save those row.
How can I do that ?
Thanks a lot

Nov 21 '05 #2
Agnes,

When you really "need" a refresh, than I never solved that problem and do I
just set the
datagrid.datasource = nothing
and than again the
datagrid.datasource = datasource.

When you get no other solution maybe you can do that.

Cor

"Agnes" <ag***@dynamictech.com.hk>
I solve myproblem by "add the filter condition in select command"
Now, How can I refresh the datagrid ??

"Agnes" <ag***@dynamictech.com.hk> ¦b¶l¥ó
news:el**************@TK2MSFTNGP11.phx.gbl ¤¤¼¶¼g...
In my datagrid, there is Boolcolumn, i allow the user to click it .
Now, i need to update the table which the boolcolumn is True. if the

column
is false,
I should not save those row.
How can I do that ?
Thanks a lot


Nov 21 '05 #3
I found that I didn't solve my problem indeed.
the datagrid got 10 rows , only 2 row 's boolcolumn is true.
I use SQL analzyer to check the table, 10 rows is saved.
Any method that I only save 2 rows which is true ?
Do I need to proceed another command to delete the False rows ?

"Cor Ligthert" <no************@planet.nl> ¦b¶l¥ó
news:eA**************@TK2MSFTNGP12.phx.gbl ¤¤¼¶¼g...
Agnes,

When you really "need" a refresh, than I never solved that problem and do I just set the
datagrid.datasource = nothing
and than again the
datagrid.datasource = datasource.

When you get no other solution maybe you can do that.

Cor

"Agnes" <ag***@dynamictech.com.hk>
I solve myproblem by "add the filter condition in select command"
Now, How can I refresh the datagrid ??

"Agnes" <ag***@dynamictech.com.hk> ¦b¶l¥ó
news:el**************@TK2MSFTNGP11.phx.gbl ¤¤¼¶¼g...
In my datagrid, there is Boolcolumn, i allow the user to click it .
Now, i need to update the table which the boolcolumn is True. if the

column
is false,
I should not save those row.
How can I do that ?
Thanks a lot



Nov 21 '05 #4
Agnes,

I gave an answer on your last question not your first, for your first, may I
assume your boolean column is not a part of the received datatable?

Or as I see your last message you do not receive any datarow in advance?

Cor

"Agnes" <ag***@dynamictech.com.hk>
I found that I didn't solve my problem indeed.
the datagrid got 10 rows , only 2 row 's boolcolumn is true.
I use SQL analzyer to check the table, 10 rows is saved.
Any method that I only save 2 rows which is true ?
Do I need to proceed another command to delete the False rows ?

"Cor Ligthert" <no************@planet.nl> ¦b¶l¥ó
news:eA**************@TK2MSFTNGP12.phx.gbl ¤¤¼¶¼g...
Agnes,

When you really "need" a refresh, than I never solved that problem and do

I
just set the
datagrid.datasource = nothing
and than again the
datagrid.datasource = datasource.

When you get no other solution maybe you can do that.

Cor

"Agnes" <ag***@dynamictech.com.hk>
>I solve myproblem by "add the filter condition in select command"
> Now, How can I refresh the datagrid ??
>
>
>
> "Agnes" <ag***@dynamictech.com.hk> ¦b¶l¥ó
> news:el**************@TK2MSFTNGP11.phx.gbl ¤¤¼¶¼g...
>> In my datagrid, there is Boolcolumn, i allow the user to click it .
>> Now, i need to update the table which the boolcolumn is True. if the
> column
>> is false,
>> I should not save those row.
>> How can I do that ?
>> Thanks a lot
>>
>>
>
>



Nov 21 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Randy | last post by:
Hello All, I'm trying to discover the best way to handle the situation where you have a datagrid in your app and someone changes a cell but doesn't leave that cell (so there's the little pencil...
1
by: Demetri | last post by:
I have a datagrid on an aspx page with one column added via property builder - the edit/update/cancel. In addition there is a dropdownlist which has a list of table names. Upon selecting one of...
3
by: D. Shane Fowlkes | last post by:
I have a Datagrid which in theory, should allow you to edit and update the records. I've stripped my test page down so that it's only attempting to update one field - "description". Yet when I...
5
by: Hennie | last post by:
When trying to update a record in an editable datagrid I ran into a few problems. My update procedure is just not working. Can someone please have a look at my code and see what am I doing wrong....
3
by: Larry Woods | last post by:
I have a datagrid that is carrying all fields of a record...except one. Now I want to update the underlying database via a dataadapter. The update is working but the field that is "left out" is...
1
by: mursyidatun ismail | last post by:
Dear all, database use: Ms Access. platform: .Net i'm trying to update a record/records in a table called t_doctors by clicking da edit link provided in the database. when i ran through da...
3
by: dbuchanan | last post by:
Hello, (Windows forms - SQL Server) I fill my datagrid with a stored procedure that includes relationships to lookup tables so that users can see the values of the combobox selections rather...
5
by: Stephen Plotnick | last post by:
I'm very new to VB.NET 2003 Here is what I have accomplished: MainSelectForm - Selects an item In a public class I pass a DataViewRow to ItemInformation1 Form ItemInformation2 Form
1
by: Sharon | last post by:
Hello All, Is it possible to update Sql Table through DataGrid. I have a DataGrid which is being populated through a stored procedure, all i wanted to do is to update one field...
13
by: shookim | last post by:
I don't care how one suggests I do it, but I've been searching for days on how to implement this concept. I'm trying to use some kind of grid control (doesn't have to be a grid control, whatever...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.