HAVE A LOOK THROUGH THIS LINK, http://www.projectdmx.com/tsql/rowconcatenate.aspx[^]

You can use following: SET @STRSQL='SELECT @someVariable = MAX(TRN_AMOUNT) FROM TRN You can declare @someVariable in your SP. BTW there is no need to dynamic query in the scenario you have mentioned.

Same as any other version of Windows, by using REGSVR32. The only difference is you need admin privs to do it. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007, 2008 But no longer in 2009...

Check this Post it may help..! http://forums.asp.net/t/1302358.aspx[^] LatestArticle :Log4Net Why Do Some People Forget To Mark as Answer .If It Helps.

You should store the values in database then use function for Sum of Field. If you can think then I Can.

try the below SELECT CONVERT(VARCHAR(10), GETDATE(), 103) AS [DD/MM/YYYY]

Have a look Cheers!! Brij

Wow Amazing..! :doh: You have to tell your Requirements Exactly wat u r trying to Do ..! Why Would You want to use java script..! IF you want to add data You want to add it in Database not in the Grid view..! tRY TO UNDERSTAND THE framework first..! If your requirement is like tht..! REFER THE LINK BELOW http://www.codeguru.com/forum/showthread.php?t=446823[^] LatestArticle :Log4Net Why Do Some People Forget To Mark as Answer .If It Helps.

Hi Here is your answer. 1. Create a css file in your Theme folder 2. Declare a class in css file say ".customAlign", like .customAlign { text-align:right; } 3. In aspx page use CssClass="customAlign" in your control Cheers Prosanta Kundu

Hi, since actions with nearly every ASP.NET control work by postback (which uses javascript) it seems impossible. But you could use a HTML-Button for each row to select, which will force a submit, but this will be really ugly... Regards Sebastian It's not a bug, it's a feature! Check out my CodeProject article Permission-by-aspect. Me in Softwareland.

.NET- India wrote: InnerException: {"Unable to connect to the remote server"} Your exception says that, you system is not able to connect with the remote server. Please check the connectivity between them. Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Don't forget to click "Good Answer" on the post(s) that helped you.

Try this declare @tbl table(id int identity, refid int) insert into @tbl select 0 union all select 1 union all select 2 union all select 1 union all select 1 select t.id,t.refid,case when x.cnt is null then 0 else x.cnt end as total from @tbl t left join ( select refid,count(refid) as cnt from @tbl where refid <> 0 group by refid having (count(refid)>0)) x on t.id = x.refid Output : id refid total 1 0 3 2 1 1 3 2 0 4 1 0 5 1 0 :) Niladri Biswas

Of course. Just place a handler which can process this. But mind that, you need to register DNS entry for each of your domain. Means if your use just types http://noida.myDomain.com I will not go to http://www.myDomain.com automatically, unless you register the both in same IP. :) Abhishek Sur **Don't forget to click "Good Answer" if you like this Solution. My Latest Articles-->** Simplify Code Using NDepend Basics of Bing Search API using .NET Microsoft Bing MAP using Javascript

Sorry, its not working document.body.scrolling="no";

how about select Name as Address, Address as Name from table Just create a view on it and start working .. :) :) Abhishek Sur My Latest Articles **Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB **Don't forget to click "Good Answer" if you like to.

Create CSS classes like .fs12 { font-size : 12px; ... } .fs14 { font-size : 14px; ... } Now when you load apply one default settings. And use javascript to change the class of each.:rose: Abhishek Sur My Latest Articles **Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB **Don't forget to click "Good Answer" if you like to.

I have the same problem can you take a look: <%@ Control Language="C#" AutoEventWireup="true" CodeBehind="ctrlUserProfilePics.ascx.cs" Inherits="OmegaLove.Web.UI.ctrlUserProfilePics" %> <%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %> <%--<%@ Register Src="ctrlGPStatusBox.ascx" TagName="ctrlGPStatusBox" TagPrefix="uc1" %> --%> <asp:UpdatePanel ID="UpdatePanel1" runat="server"> <ContentTemplate> <br /> <div id="UploadArea"> <table> <tr> <td> Browse Image: </td> <td> <asp:FileUpload ID="FileUpload1" runat="server" /> </td> </tr> </table> </div> <p> <asp:Button ID="UploadButton" runat="server" Text="Upload Now" OnClick="UploadButton_Click" /> </p>                 <asp:Label ID="lblResult" runat="server" ForeColor="#0066FF"></asp:Label> </ContentTemplate> <Triggers> <asp:PostBackTrigger ControlID="UploadButton" /> </Triggers> </asp:UpdatePanel> <br /> <hr /> <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="5" GridLines="None" ShowHeader="False"> <Columns> asp:TemplateField <ItemTemplate> <asp:Image ID="imgSaved" runat="server" ImageUrl='<%# imageURL(DataBinder.Eval(Container.DataItem, "img_id").ToString()) %>' AlternateText='<%#DataBinder.Eval(Container.DataItem,"img_title") %>' /> </ItemTemplate> </asp:TemplateField> </Columns> <EmptyDataTemplate> No records found </EmptyDataTemplate> </asp:GridView>

Is it mandatory for you to write down the file to the server????? why don`t you try ds.GetXml(); But remember to fill you dataset with the data. which actually returns you a XmlDocument. Debug your code and see what results you get in the document object. When you fail to plan, you are planning to fail.