Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 ASP.NET
 Updating Value in a List Box

Author  Topic 

vk18
Posting Yak Master

146 Posts

Posted - 2007-05-03 : 19:16:15
Hi Guys,

I have a data below that I am populating in a List Box. I want to update one value
Because of the Same Ckid I couldn’t. Any body help me on this.?

I am populating “ext”+“description” Concatenating in a list box. Below is the Table Structure. If I want to update any one of the value suppose Ext – 7 Description how can I update this.?
Right now I am updating like this, but it doesn’t work
I am using Vb.Net/Asp.Net
Thx


update tblsubgroups set description = '" & Me.txtsubgroupdesc.Text & "' WHERE ckid = '" & Me.txtpkid.Text & "'



Ckid ext Description

1013 1 General
1013 2 General
1013 3 General
1013 4 General
1013 5 General
1013 6 General
1013 7 General
1013 8 General
1013 9 General
1013 10 General




spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-05-03 : 19:28:18
well the you have to put something more unique in the where.
maybe ext?

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp
Go to Top of Page
   

- Advertisement -