Ask a Question related to ASP.NET Data Grid Control, Design and Development.
-
Simon Gorski #1
Re: Add primary key
Hello Barney,
"Barney" <anonymous@discussions.microsoft.com> schrieb im Newsbeitrag
news:ECCDAF82-099F-4DBE-82A2-FB4F38E9F6DE@microsoft.com...5, I need to add just 1 to it.> Folks,
> This will be a very simple for you.
>
> I need to increment the database item by one. So, if the item number isserver with this statement:>
> What I want help from you is that there is a way of reading from the sql" & Request.QueryString("ID").Trim>
> Dim strSQL As String
>
> strSQL = "SELECT MAX(Item) FROM OrderDetails WHERE PONumber =want from you is to increment the selected Item by 1.>
>
> Then incrementing the selected attribute. In this particular case, what I
try
strSQL = "SELECT MAX(Item)+1 FROM OrderDetails WHERE PONumber = " &
Request.QueryString("ID").Trim
^^^
a tip;
use params, becaus of sql-injection
[url]http://www.developer.com/db/article.php/2243461[/url]
mfg simon g.
Simon Gorski Guest
-
Primary Scratch & Windows Primary Paging file?
Okay, I accidentally uninstalled Adobe Photoshop the other day. So I re-installed it and now when I click on the Photoshop Icon and it starts to... -
Select Primary Key
Hi Is there any way to select Primary key from table . If you do not know your primary key. I mean can we make any condition or check in which... -
Composite primary Key
hi... i am creating a table : create table student_content (student_id varchar(10) references student_info (student_id), story_id numeric(4)... -
Primary Keys
How is it that even though I have the column "username" in my database set as a Primary key, using my PHP script to add new users to the database... -
Get Primary Key
How do I get the primary key of a record just enter into the database? Then pass that same primary key ID column value to another table? Example:...
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
