ASP.NET

FirstPrevNext

Re: StyleSheet - CSS, examples? S Ullas19-Jul-07 11:14 S Ullas 19-Jul-07 11:14  check this also I think you will get an idea about how to make rounded corner http://www.alistapart.com/articles/slidingdoors/[^] Ullas Sadanandan about the stored procedure Sonia Gupta19-Jul-07 2:11 Sonia Gupta 19-Jul-07 2:11  i read somewhere two lines in the stored procedure. @companyname varchar(120), declare @companyname varchar(120), What is the differnce between them? Sonia Gupta Soniagupta1@yahoo.co.in Yahoo messengerId-soniagupta1 Love is Friendship and Friendship is Love.... Re: about the stored procedure Not Active19-Jul-07 2:19 Not Active 19-Jul-07 2:19  In short, the first would be used to specify a parameter to the proc. The second would be to declare a variable to use with the proc only two letters away from being an asset Re: about the stored procedure sathesh pandian19-Jul-07 2:20 sathesh pandian 19-Jul-07 2:20  @companyname varchar(120) is the parameter which value will be sent by the user input. declare @companyname varchar(120) is the variable declared inside the procedure. if you are passing some arguments in the procedure, then you will never needed it to redeclare. All The Best Sathesh Pandian Re: about the stored procedure Sonia Gupta19-Jul-07 2:22 Sonia Gupta 19-Jul-07 2:22  thanks.. Sonia Gupta Soniagupta1@yahoo.co.in Yahoo messengerId-soniagupta1 Love is Friendship and Friendship is Love.... Re: about the stored procedure Piyush Vardhan Singh19-Jul-07 2:20 Piyush Vardhan Singh 19-Jul-07 2:20  (@companyname varchar(120),) its declare to takes parameter for storprocr (declare @companyname varchar(120),) not take parameter Piyush Vardhan Singh Programmer TAS NewDelhi India 9313077379 Re: about the stored procedure Raghvendra Kumar Roy19-Jul-07 2:24 Raghvendra Kumar Roy 19-Jul-07 2:24  BY declare @companyname varchar(120) Variables are declared in the body of a batch or procedure with the DECLARE statement and are assigned values with either a SET or SELECT statement. While @companyname varchar(120) When we pass parameter in Procedure Then we stored them that parameter through Addparameter function. Raghvendra Kumar Roy Re: about the stored procedure Piyush Vardhan Singh19-Jul-07 2:25 Piyush Vardhan Singh 19-Jul-07 2:25  u have not given my answer yaar which i previews asked Piyush Vardhan Singh Programmer TAS NewDelhi India 9313077379 Cant reach object in LoginView ??? (C#) totocaster19-Jul-07 2:09 totocaster 19-Jul-07 2:09  Hi All, I have a Master Page view LoginView Control on it, in LoginView I have <loggedintemplate> tags and whole site (HTML, Controls, ...) is place between this tags. But the problem is that I cant reach non of them from the code. For example: I have menu with id "Menu1" adn when I type Menu1. and press CRTL+SPACE nothing happends at all, only control which is visible from master page is LoginView. How to make other to be reachable too? Tenx sql query for next and previous record in asp.net Sonia Gupta19-Jul-07 1:41 Sonia Gupta 19-Jul-07 1:41  is there any sql query that implements the next and previous records. Sonia Gupta Soniagupta1@yahoo.co.in Yahoo messengerId-soniagupta1 Love is Friendship and Friendship is Love.... Re: sql query for next and previous record in asp.net Piyush Vardhan Singh19-Jul-07 1:54 Piyush Vardhan Singh 19-Jul-07 1:54  i think it should n0t possible in sql query.it possible in ui Piyush Vardhan Singh Programmer TAS NewDelhi India 9313077379 Re: sql query for next and previous record in asp.net Piyush Vardhan Singh19-Jul-07 2:03 Piyush Vardhan Singh 19-Jul-07 2:03  can u tell me how it possible :- friendship is love and love is friendship Piyush Vardhan Singh Programmer TAS NewDelhi India 9313077379 Re: sql query for next and previous record in asp.net Sathesh Sakthivel19-Jul-07 2:10 Sathesh Sakthivel 19-Jul-07 2:10  No. SSK. Re: sql query for next and previous record in asp.net Not Active19-Jul-07 2:14 Not Active 19-Jul-07 2:14  There isn't anything specific like NEXT RECORD or PREVIOUS RECORD. If you are using SQL Server 2005 look at this http://www.davidhayden.com/blog/dave/archive/2005/12/30/2652.aspx[^] or this for both 2005 and 2000 http://www.dotnetspider.com/kb/Article2590.aspx[^] only two letters away from being an asset Re: sql query for next and previous record in asp.net Raghvendra Kumar Roy19-Jul-07 2:16 Raghvendra Kumar Roy 19-Jul-07 2:16  No it is not possible Raghvendra Kumar Roy Re: sql query for next and previous record in asp.net Not Active19-Jul-07 2:23 Not Active 19-Jul-07 2:23  You mean this won't work SELECT Description, Date<br /> FROM (SELECT ROW_NUMBER() OVER (ORDER BY Date DESC)<br /> AS Row, Description, Date FROM LOG)<br /> AS LogWithRowNumbers<br /> WHERE Row >= 1 AND Row <= 10 Guess I have a unique build of SQL Server 2005. See the links in my post. only two letters away from being an asset Gridview SortExpression deep719-Jul-07 1:22 deep7 19-Jul-07 1:22  Hi, In my application i have a gridview for whose columns i'm using templatefields <asp:TemplateField HeaderStyle-CssClass="templateHeaderStyle" HeaderText="<%$ Resources:Resource, AT_JobID_Text %>" SortExpression="JOB_OID" > here if i give 'SortExpression', then the column header gets underlined...I dont want it like that, the underline must be seen on hover of the mouse on the header...the sorting is also required... how to accomplish this.. could anyone please tell me? thanks Re: Gridview SortExpression Imran Khan Pathan19-Jul-07 1:24 Imran Khan Pathan 19-Jul-07 1:24  Use styleSheet class for headerTemplate Best Regard Pathan GOD HELP THOSE WHO HELP THEMSELVES Re: Gridview SortExpression deep719-Jul-07 1:37 deep7 19-Jul-07 1:37  hi, i have stylesheet for it: .templateHeaderStyle { font-family:Arial;font-size:small; font-weight:normal;padding-left: 0.5em; text-decoration:none; } If i remove 'SortExpression' from: <asp:TemplateField HeaderStyle-CssClass="templateHeaderStyle" HeaderText="<%$ Resources:Resource, AT_JobID_Text %>" SortExpression="JOB_OID" > then the underline for column header doesn't come...but then sorting doesn't work.... i need it to sort the column based on "JOB_ID"...how do i do it? kindly do guide me..thanks displaying latest 5 values from database table in datagrid mavii19-Jul-07 0:59 mavii 19-Jul-07 0:59  which SQL query will be used to display the last added 4 or values, i want the recent values to b displaed into datagrid as the database i updated daily Re: displaying latest 5 values from database table in datagrid Eduard Keilholz19-Jul-07 1:02 Eduard Keilholz 19-Jul-07 1:02  SELECT TOP # [fields] FROM [table] Replace # with the maximum number of records to return... .: I love it when a plan comes together :. http://www.zonderpunt.nl Re: displaying latest 5 values from database table in datagrid Sonia Gupta19-Jul-07 1:46 Sonia Gupta 19-Jul-07 1:46  sir, i think top # will give the first-n entries. but the question was the last 4 addded records. Sonia Gupta Soniagupta1@yahoo.co.in Yahoo messengerId-soniagupta1 Love is Friendship and Friendship is Love.... Re: displaying latest 5 values from database table in datagrid Eduard Keilholz19-Jul-07 2:29 Eduard Keilholz 19-Jul-07 2:29  Sir, I think you need to invert the order of your result set then... ORDER BY Fieldname DESC This will make sql sort the result set descending on field Fieldname and then pick the top 5 (which is then the latest 5) .: I love it when a plan comes together :. http://www.zonderpunt.nl Re: displaying latest 5 values from database table in datagrid Sathesh Sakthivel19-Jul-07 1:03 Sathesh Sakthivel 19-Jul-07 1:03  Post your Question in the Suitable Forum. SSK. Re: displaying latest 5 values from database table in datagrid Md Mustafa19-Jul-07 2:04 Md Mustafa 19-Jul-07 2:04  select top 5 * from table use above query .it will work... Mohammad Mustafa

Last Visit: 31-Dec-99 18:00     Last Update: 28-Apr-24 10:51 Refresh ᐊ Prev1...4589459045914592459345944595459645974598 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.