|
I am currently working Asp.net with c#, inserting data from webform into sqlserver 2000 datatable.
table id column contain identity increment.It will increment id for every new recored.
I inserting 10 recoreds id 1 to 10 into table then deleted last two records (9&10) then inserting a new record
these record id having 11 insted of 9 in id column.
Plz help me .......
Thanks in adv
|
|
|
|
|
If you go with the Identity increment it will be automatically increment the record. Once the reords are inserted the id will be created for that record and if you delete the record then also the id will not get deleted it will go only where it stops and then it will increment, as you stated.
Instead if you go by coding for ID increment it will perform better.
And this is not the correct forum to ask your question.
Please put your question in the Sql/Ado.net forum.
Regards,
Satips. ![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
|
|
|
|
|
Thanks Satips for u r reply
|
|
|
|
|
Welcome 
Regards,
Satips.
|
|
|
|
|
The auto increment works like the increment in sql server. Therefore it is correct that the new row gets an id equal to 11. Otherwise, reusing 9 and 10 could lead to wrong data dependencies.
Furthermore I suggest to set an increment of -1 and a seed of -1. This way, all new data has negative values. When they are stored to the database the ids will be set by the database resulting in new positive values.
Happy Programming
Urs
-^-^-^-^-^-
no risk no funk
|
|
|
|
|
Hi everybody, 
I use ASP (not ASP.net). I need to show the book database pictures with 3 lines and 3 cells in 1 line.
I use the loop around <tr></tr> but it's not what I want.
Please, help. Thanks
Nguyen Thi Hong Thao
|
|
|
|
|
Select a Suitable forum and post your Questions.
This is Asp.Net Forum.
One post is Enough. BTW delete the other post.
Regards,
Satips.
|
|
|
|
|
Hi everybody, 
I use ASP (not ASP.net). I need to show the book database pictures with 3 lines and 3 cells in 1 line.
I use the loop around but it's not what I want.
Please, help. Thanks
Nguyen Thi Hong Thao
|
|
|
|
|
Hi all,
There is a requirement where i need to generate radio button dynamically.The scenario is like this, when the number of question is 3 then for each , we need to generate 6 radio button dynamically.And also need to populate the checked value in an object.Any pointers, highly appreciated.Thanks in advance!
Regards,
Sathyanarayanan
|
|
|
|
|
Hi
How to use radio button(server control) in gridview.How can i access the selected value in the code behind page.
|
|
|
|
|
|
hi guys,
I was wondering, how you could create web pages on the fly and then include them in your site. I'm thinking along the lines of a CMS or a portal where a page designer has the rights to design a page that inherits from the global master page(s). This new page is then incorporated in to the site.
Its the web page design that is giving me the headache, is it a series of templated webpages filled with webparts? doubt it.
Many thanks
There are 10 kinds of people in this world. Those who understand binary and those who don't...
______________________
Its the idiot who stops learning and the wise that keep asking you questions!!!!
______________________
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook
|
|
|
|
|
Well you can use File and StreamWriter to create a new page on fly.
Have a nice day.
|
|
|
|
|
ASP.NET pages are always created on the fly. The aspx markup code is parsed into an object tree, which is then rendered into an html page. To make a page contain different contents, just put it in the object tree, and let it be rendered into a page.
So, creating extra pages is not needed at all. You can have a single page that displays contents that it gets from a file, a database, or anywhere you like.
---
single minded; short sighted; long gone;
|
|
|
|
|
I think he/she is talking about named pages (e.g. do-something-page.aspx, bmw-for-sale.aspx)
In which case it will depend on exactly what you want to do. You can obivously create new pages like previously stated (using a stream writer object), but you will more than likely need to save some data in a db to help with creating the page by reusing replicated code.
Now, if you need the newly created page to contain events and such, you will either need to write these events in script tags on the aspx page itself, or create a new code behind file that possibly inherits from a base page with some built in functionality.
Your going to have to map out what suits your needs first.
If you compile your pages into dll's you are going to be limited to some extent what you can do on the fly an which route you take.
|
|
|
|
|
I'd imagine the obvious way is to have your documents as XML and use an XSLT to turn the data into a portion of a web page that displays it.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hehe, didn't think of that option. Should be great 
WM.
What about weapons of mass-construction?
"What? Its an Apple MacBook Pro. They are sexy!" - Paul Watson
My blog
|
|
|
|
|
hi,
I am using asp.net 2003 with c#
my doubt is it possible to write the content of my web page to a file using response.write(..)??
my need is, i need to write the content of a .. to an excel file.
the may or may not contain some
<labl>..
<dtagrid>..
All I ever wanted is what others have....
CrazySanker
|
|
|
|
|
You can create an excel file by either using a CSV style or tables. The easiest route would be to store the table information (html that is built on the fly) into a (string) then you could just write this string to a file with a .xls extension.
If you use the html method, it should be valid HTML just like on your page with proper open / closing tags.
|
|
|
|
|
I setup a local server using IIS and ASP.NET on windows xp (connected on our company's network). From that unit, i can open my ASP.NET pages, but when i tried to open it on other computer/laptop which is connected also on the network, it shows... cannot display the webpage. i'm entering the "http://IP:PORT/xx" to open it on the other pc.
Shall I edit the Authentication/Authorization?
please help...
|
|
|
|
|
hi,
it s not the fault in authentication or authorization.
You have to give access to the users through the network connection.
first go to network connection.
Then open the properties.
You have to select the TCP/IP option.
in that option select advanced and you have to check the http web server for
accessing the web.
All The Best
Sathesh Pandian
|
|
|
|
|
Hi all,
I have one "aspx" page and one "usercontrol(ascx)" page.In the usercontrol page i have one HTML table which i use to show data when the usercontrol is loaded.I'm loading the data into the table using a javasript which is registered in the page load of the usercontrol.
In the javascript i'm now referring the Html table as "document.all(""html_cart"").insertRow();"
But when the javascript is executed i'm getting the error
"document.all().insertrow(); is null or not an object"
I even tried with "document.form[0].Usercontrolname_html_cart.insertRow();"
where Usercontrolname is the name for
the usercontrol page.I used this "Usercontrolname1_html_cart", bcoz in the viewsource i saw that the usercontrol is referred as Usrcontrolname1.
Please any one suggest the correct method to refer the html table in the javascript, so that i can add rows and data into the rows
Thank you in advance
Regards,
Sathya
|
|
|
|
|
You should create a variable and make it's value the ClientID property of the table control. Then you'll always have the client side Id of the table. Assuming it needs to be a server control at all.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hi Graus,
Thanks for the immediate reply Grauss.
In the view source i found the name which aspx page refers to the usercontrol .So i hardcoded the name in the referring session "document.forms[0].Usercontrolname_html_cart.insertRow();"
but still its not working. I tried with the alternative " document.all(""html_cart"").insertRow(); Even this is not working.
One more thing is that im not dragging and droping the usercontrol in the aspx page . Im using another method to load the usercontrol when the applications starts.
Please suggest alternate methods to make it working.
with regards
Sathyanarayanan
|
|
|
|
|
Hi,
I am developing an application for my company intranet.In which i have to get information regarding softwares installed in all the systems in the company intranet on a single click.
Can anyone please tell me that how it is possible to get informations regarding all the softwares installed in all the system connected through company intranet?
I am developing this application in asp.net with C#.
Thanks in Advance
Vijay kumar
Programmer.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
