How can i crate aint value that will display the value as 0001 to 9999 without omitting the zeroes Thanks javierarka

I need to create a Column id in my table. This Column ID has to be a 'sa0200701260001' where sa0 is a value i give to it 20070126 is the current date and 0001 is a number that will increment everytime this statement is called can somebody tell me how can i make this incrmented value. Thanks Javierarka

How can i convert a getdate() result to a style of yyyymmddhhmmss Thanks Javierarka

does anyone knows how can i leave everyother row in a gridview empty and be able to bind a label to it javierarka

Hello I need an answer for my question. Imagine a html table. When you loop through the last column of the table that column needs to be display in a row alone immediately after the row that shows all the other information for that id is bind. It is possible to do this in a grid view If you need something else to clarify this let me know Thanks Javierarka

:laugh:I have a label in my page that display an error when it find it. This is what it does. The user enters a value in a text box, It looks in a database and if does not find the value displays a label saying that that value does not exist and to type another value. When the user types a correct value it redirect to another page with the results for that value. When the user hit the back button in the browser the label is disply again saying that the value does not exist, but it does. How can i disable this label after the page is redirected so when the user hit the back button that label is not display ? Thanks:laugh: Javierarka

:laugh::laugh:I have a sqlconnection to a sql server 2005. This server is in one server and my application is in another server. I create a userid and password but when i try to connect to my database an error saying Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. appears. I do not know what is the problem for this. Can somebody help me Thanks Javierarka

Yes that is right i need to disable the individual cells. How can i use the template column sto let it know that it need to be able only when the cells has a value of 1 or more Thanks

How can i disable a hyperlink column when the value inside is 0 Lets said is a monthly display and tehy are going to be reference to another page according to the value if the value inside the column is 1 or more i need to be hyperlink bu tif the value is 0 i do not need it to be hyperlink. How can i achieve this Thanks:-D