ASP.NET Forum RSS Feed

client side authorization in asp.net web project

Sun, 05 Feb 2012 23:47:26 -0800

i am developing a server-client program in which server will be showing datas sent by client across a network. without Authentication it works fine but i need some authentication because server side its a website.once i give authentication i am not able to get datas from client.i know that client must be given authorization to put data into server.can anyone tell me how to do that?i am developing based on the link given below

blog.bobcravens.com/2009/11/browse-files-on-remote-computers

posting server side authentication code

<authentication mode="Forms">
<forms loginUrl="Login.aspx" name=".ASPXFORMSAUTH">

</forms>
</authentication>

<authorization>
<deny users = "?"/>
</authorization>
login.aspx

<script runat="server">
Sub Login_Click(ByVal sender As Object, ByVal e As EventArgs)
If ((UserEmail.Text = "s@gmail.com") And _
(UserPass.Text = "000")) Then
FormsAuthentication.RedirectFromLoginPage _
(UserEmail.Text, Persist.Checked)
Else
Msg.Text = "Invalid credentials. Please try again."
End If
End Sub
</script>

i have written validation code also.everything works fine on the server side but not able to get data from client side..

client program is written in c#,client-server communication is via http post.

i am getting error shown below when i run client program

client side authorization in asp.net web project

Sun, 05 Feb 2012 23:45:36 -0800

not able toop en design page

Thu, 02 Feb 2012 23:29:29 -0800

its actually a isue with IDE visual studio
when i open the application in VS 2005 and click the design tab i am not able to get the design sheet immediately
it takes nearly 1 hr to load the page
in the status bar its showing creating controls one by one all the time & on right there is VS icon showing some processing
during this pahse neither i am able to build or execute or do anything with the VS as there is no effect or any click or key press
till yest it was working fine , it started suddenly

Attachment: screen.png (17469 bytes | downloaded 6 times)

not able toop en design page

Thu, 02 Feb 2012 23:26:40 -0800

Help me on asp.net

Fri, 20 Jan 2012 05:42:45 -0800

How to compare textbox value with database table field to check whether name is exist. If name is exist than give message name is exist otherwise allow user to insert name on table....

Hide/show menus based on user's role

Thu, 05 Jan 2012 22:09:41 -0800

I am using a horizonatl menu. I want to hide some menus based on the logged in user's role. For example, if the user is administrator, then only the Master menu should be visible. How do I acheieve this?

Please find the enclosed ascx, js & css files

If there is a simple version also, do help me out.

sankari

Looking for ASP.NET Facebook Style one to one Chat for my SM site?

Mon, 02 Jan 2012 01:12:41 -0800

Hey guys, We have a requirement for a one to one chat from one of our clients for a social media kind of project we are doing. The problem is that we need it in quick time so i would rather use an already made component that is out there. I do not mind paying a license fee but it must not be a yearly thing. One time fee is something that we can convince our project lead for. I have been searching google for the past 4 days and i do not see any components similar to what we need in asp.net. I do see comet chat for php but we need that in asp.net.

below are some of our main requirements:

1-1 chat
Footer placement in bottom right similar to that of facebook and gmail. The ones i can find right now are all chat room sort of layout which we cannot do.
Status to be changes by user. Appear Offline is a must.
SQL Server Database. We need all chat transcripts to be saved until we want to delete/archive them.
Group Chat is a plus as we might need that in future but is not needed right now. But a possibility of having in future would be a good thing.

Any help/suggestions will be highly appreciated.

Looking for ASP.NET Facebook Style one to one Chat for my SM site?

Mon, 02 Jan 2012 01:10:07 -0800

database connectivity in asp.net

Tue, 20 Dec 2011 23:41:06 -0800

i have created a vs 2008 solution that contain 3 projects i.e.

1. BLL

2. DAL

3. GUI (Website)

Language used C#

I have add references & connect it through vs 2008 inbuilt sql server & it is working fine on

localhost but when i upload it on internet it is giving error in web.config file i.e. customerrors.

Plz suggest some solution or there is a diffferent way to do it.

thanks

This post has been deleted.

Tue, 20 Dec 2011 23:38:05 -0800

This post has been deleted.

asp.net deployment issue

Thu, 15 Dec 2011 20:48:56 -0800

I have hosted my asp.net appln in a web server. (it works perfectly in my local system). I am getting error 500.
This is my source code:

index.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="index.aspx.cs" Inherits="index" %>

<%@ Register Src="WebUserControl5.ascx" TagName="WebUserControl5" TagPrefix="uc1" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Login</title>
<script language="javascript" type="text/javascript">
// <!CDATA[

function TABLE1_onclick() {

}

// ]]>
</script>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <uc1:WebUserControl5 ID="WebUserControl5_1" runat="server" />
        <table border="0" style="height: 45%" width="100%">
            <tr>
                <td style="width: 100px">
                    <img src="images/BATraining800.jpg" style="width: 261px; height: 167px" /></td>
                <td rowspan="2" style="width: 175px">
                    <span style="font-size: 10pt; font-family: Verdana">
                    What's in Store?<br />
                    <br />
                    </span>
                    <ul>
                        <li><span style="font-size: 10pt; font-family: Verdana">Multiple Portfolios </span></li>
                        <li><span style="font-size: 10pt; font-family: Verdana">Dividend Updates </span></li>
                        <li><span style="font-size: 10pt; font-family: Verdana">NAV Updates </span></li>
                        <li><span style="font-size: 10pt; font-family: Verdana">Summary Statement</span>s </li>
                    </ul>
                </td>
                <td>
                    <div style="text-align: right">
                        <div style="text-align: left">
                            <table border="2" cellpadding="0" cellspacing="0" style="border-right: darkkhaki thick solid; border-top: darkkhaki thick solid; border-left: darkkhaki thick solid; border-bottom: darkkhaki thick solid" id="TABLE1" onclick="return TABLE1_onclick()">
                                <tr>
                                    <td align="center" colspan="3" style="border-left-color: white; border-bottom-color: white; border-top-style: solid; border-top-color: white; border-right-style: solid; border-left-style: solid; height: 21px; border-right-color: white; border-bottom-style: solid">
                                        <asp:Label ID="Label1" runat="server" Text="LOGIN" Font-Bold="True" Font-Names="Verdana" Font-Size="Small"></asp:Label></td>
                                </tr>
                                <tr>
                                    <td align="center" colspan="3" style="border-left-color: white; border-bottom-color: white;
                                        border-top-style: solid; border-top-color: white; border-right-style: solid;
                                        border-left-style: solid; height: 21px; border-right-color: white; border-bottom-style: solid">
                                        <asp:Label ID="Label4" runat="server" Font-Names="Verdana" Font-Size="XX-Small" ForeColor="Red"
                                            Width="140px"></asp:Label></td>
                                </tr>
                                <tr>
                                    <td align="center" style="width: 100px; border-left-color: #ffffff; border-bottom-color: #ffffff; border-top-style: solid; border-top-color: #ffffff; border-right-style: solid; border-left-style: solid; border-right-color: #ffffff; border-bottom-style: solid;">
                                        <asp:Label ID="Label2" runat="server" Text="User ID" Font-Bold="True" Font-Names="Verdana" Font-Size="X-Small"></asp:Label></td>
                                    <td align="center" colspan="" style="width: 100px; border-left-color: #ffffff; border-bottom-color: #ffffff; border-top-style: solid; border-top-color: #ffffff; border-right-style: solid; border-left-style: solid; border-right-color: #ffffff; border-bottom-style: solid;">
                                        <asp:Label ID="Label3" runat="server" Text="Password" Font-Bold="True" Font-Names="Verdana" Font-Size="X-Small"></asp:Label></td>
                                    <td align="center" rowspan="2" style="width: 96px; border-left-color: #ffffff; border-bottom-color: #ffffff; border-top-style: solid; border-top-color: #ffffff; border-right-style: solid; border-left-style: solid; border-right-color: #ffffff; border-bottom-style: solid;">
                                        <asp:ImageButton ID="ImageButton1" runat="server" ImageAlign="Bottom" ImageUrl="~/images/go.gif" OnClick="ImageButton1_Click1" /></td>
                                </tr>
                                <tr>
                                    <td align="left" style="width: 100px; border-left-color: #ffffff; border-bottom-color: #ffffff; border-top-style: solid; border-top-color: #ffffff; border-right-style: solid; border-left-style: solid; border-right-color: #ffffff; border-bottom-style: solid;">
                                        <asp:TextBox ID="txt_uid" runat="server" Font-Names="Verdana" Font-Size="Small" Width="100px"></asp:TextBox></td>
                                    <td align="left" style="width: 100px; border-left-color: #ffffff; border-bottom-color: #ffffff; border-top-style: solid; border-top-color: #ffffff; border-right-style: solid; border-left-style: solid; border-right-color: #ffffff; border-bottom-style: solid;">
                                        <asp:TextBox ID="txt_pass" runat="server" Font-Names="Verdana" Font-Size="Small" Width="100px"></asp:TextBox></td>
                                </tr>
                                <tr>
                                    <td align="right" colspan="3" style="border-left-color: #ffffff; border-bottom-color: #ffffff; border-top-style: solid; border-top-color: #ffffff; border-right-style: solid; border-left-style: solid; border-right-color: #ffffff; border-bottom-style: solid">
                                        <asp:LinkButton ID="LinkButton1" runat="server" Font-Bold="True" Font-Names="Verdana"
                                            Font-Size="X-Small">Forgot Password...?</asp:LinkButton><br />
                                        </td>
                                </tr>
                                <tr>
                                    <td align="right" colspan="3" style="border-left-color: #ffffff; border-bottom-color: #ffffff; border-top-style: solid; border-top-color: #ffffff; border-right-style: solid; border-left-style: solid; border-right-color: #ffffff; border-bottom-style: solid">
                                        <asp:LinkButton ID="LinkButton2" runat="server" Font-Bold="True" Font-Names="Verdana"
                                            Font-Size="X-Small">Register Now...!</asp:LinkButton><br />
                                        </td>
                                </tr>
                            </table>
                        </div>
                    </div>
                </td>
            </tr>
            <tr>
                <td style="width: 100px; height: 145px;">
                    <img src="images/security800.jpg" style="width: 258px; height: 133px" /></td>
                <td style="width: 237px; height: 145px;">
                </td>
            </tr>
        </table>
        <hr style="border-right: #cccc99 thick solid; border-top: #cccc99 thick solid; border-left: #cccc99 thick solid; border-bottom: #cccc99 thick solid; height: 11px;" />
        <br />
       </div>
       
    </form>
</body>
</html>

index.aspx.cs

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using Logic;

public partial class index : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["exp"] == "y")
        {
            Label4.Text = "Session expired";
            Session["exp"] = "";
        }
    }



    protected void LinkButton2_Click(object sender, EventArgs e)
    {
        Response.Redirect("RegUser.aspx");

    }
    protected void LinkButton2_Click1(object sender, EventArgs e)
    {

    }
    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
    {
        Includes obj = new Includes();
        string user = txt_uid.Text.ToString().Trim();
        string pass = txt_pass.Text.ToString().Trim();
        //string str = "select user_id,user_pass from user_master where user_id='" + user + "' ";

        string str = "select user_status,user_id,user_pass from user_master where user_id='" + user + "' and user_pass='" + pass + "'";
        DataSet ds = obj.getDataSet(str);
        //  int row_cnt = ds.Tables[0].Rows.Count;  ********///this is also correct. instead of using datatabl****///
        DataTable dt = ds.Tables[0];
        int count = dt.Rows.Count;
        //int row_cnt = dt.Rows.Find("user_status='y'");
        DataRow[] foundRows;

        //int foundRow = dt.DefaultView.Find("Y");
        foundRows = ds.Tables[0].Select("user_status = 'Y'");
        int noRows = foundRows.Length;
        //dataSet1.Tables["Customers"].Select("CompanyName Like 'A%'");

        // string statt=dt.Rows[row_cnt]["status"].ToString().Trim()
;
        if (count > 0)
        //for (int i=0; i<count ; i++)
        {
            if (noRows == 1)
            {
                //    string pass = dt.Rows[i]["user_pass"].ToString().Trim();
                //  if ( txt_pass.Text      == pass )
                //{
                //    Session["user_id"]=dt.Rows[i]["user_id"].ToString(
).Trim();
                Session["user_id"] = txt_uid.Text.ToString().Trim();
                Response.Redirect("main.aspx");
            }//
            else
            {
                Label4.Text = "Your account is under activation. ";
                // Response.Redirect("home.aspx");
            }
        }
        else
        {

            Label4.Text = "Invalid User ID/Password";
            // Response.Redirect("home.aspx");
        }

    }



    protected void LinkButton1_Click(object sender, EventArgs e)
    {
        Response.Redirect("forget_pass.aspx");
    }
    protected void ImageButton1_Click1(object sender, ImageClickEventArgs e)
    {
        Includes obj = new Includes();
        string user = txt_uid.Text.ToString().Trim();
        string pass = txt_pass.Text.ToString().Trim();
        //string str = "select user_id,user_pass from user_master where user_id='" + user + "' ";

        string str = "select user_status,user_id,user_pass from user_master where user_id='" + user + "' and user_pass='" + pass + "'";
        DataSet ds = obj.getDataSet(str);
        //  int row_cnt = ds.Tables[0].Rows.Count;  ********///this is also correct. instead of using datatabl****///
        DataTable dt = ds.Tables[0];
        int count = dt.Rows.Count;
        //int row_cnt = dt.Rows.Find("user_status='y'");
        DataRow[] foundRows;

        //int foundRow = dt.DefaultView.Find("Y");
        foundRows = ds.Tables[0].Select("user_status = 'Y'");
        int noRows = foundRows.Length;
        //dataSet1.Tables["Customers"].Select("CompanyName Like 'A%'");

        // string statt=dt.Rows[row_cnt]["status"].ToString().Trim()
;
        if (count > 0)
        //for (int i=0; i<count ; i++)
        {
            if (noRows == 1)
            {
                //    string pass = dt.Rows[i]["user_pass"].ToString().Trim();
                //  if ( txt_pass.Text      == pass )
                //{
                //    Session["user_id"]=dt.Rows[i]["user_id"].ToString(
).Trim();
                Session["user_id"] = txt_uid.Text.ToString().Trim();
                Response.Redirect("main.aspx");
            }//
            else
            {
                Label4.Text = "Your account is under activation. ";
                // Response.Redirect("home.aspx");
            }
        }
        else
        {

            Label4.Text = "Invalid User ID/Password";
            // Response.Redirect("home.aspx");
        }

    }
}

the include file (to create Logic namespace) is placed under App_code folder

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
namespace Logic
{

 public class Includes
 {
        public void executeQuery(string strsql)
        {
            string conn = ConfigurationManager.ConnectionStrings["conn"].Con
nectionString;

            SqlConnection con = new SqlConnection(conn);
            SqlCommand cmd = new SqlCommand(strsql, con);

            try
            {
                con.Open();
                cmd.ExecuteNonQuery();

            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                con.Close();
                con.Dispose();
                cmd.Dispose();
            }

        }

        public DataSet getDataSet(string strsql)
        {

            string conn = ConfigurationManager.ConnectionStrings["conn"].Con
nectionString;
            SqlConnection con = new SqlConnection(conn);
            SqlCommand cmd = new SqlCommand(strsql, con);
            try
            {
                con.Open();
                SqlDataAdapter ad = new SqlDataAdapter(cmd);
                DataSet ds = new DataSet();
                ad.Fill(ds);
                return ds;

            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                con.Close();
                con.Dispose();
                cmd.Dispose();
            }
        }
    }

    
}

at last web.config file

<connectionStrings>
<add name="conn" connectionString=" Server=xxx.db.xxxx.hostedresource.com; Database=xxx; User ID=xxx; Password=xxx; Trusted_Connection=False" providerName="System.Data.SqlClient" /> <remove name="LocalSqlServer"/> <add name="LocalSqlServer" connectionString=" Server=xxx.db.xxxx.hostedresource.com; Database=xxx; User ID=xxx; Password=xxx; Trusted_Connection=False" providerName="System.Data.SqlClient" />
</connectionStrings> 
<configuration>
<system.webServer>
<httpErrors errorMode="Detailed" />
<asp scriptErrorSentToBrowser="true"/>
</system.webServer>
<system.web>
<customErrors mode="Off"/>
<compilation debug="true"/>
</system.web>
</configuration>

This post has been deleted.

Thu, 15 Dec 2011 20:47:06 -0800

This post has been deleted.

Christmas gift in passcert

Fri, 02 Dec 2011 21:54:37 -0800

Some questions had been available in passcert , And 20% discount for all IT exams , here a gift from Passcert as Christmas Day is coming . Perfect Your Xmas plan, UP TO 80% OFF (Coupon “xmas”)+ New members 100 points (equal to 10USD) .

Uploading Csv and inserting to Database

Thu, 01 Dec 2011 06:27:47 -0800

Im new to this and Im creating a asp.net website that will allow you to upload a csv file to a specified folder in the site and the contents of the csv file will be inserted into a table called product_backlog on sql server. Below is the following names and data types that are in the product_backlog table:

UserStoryID int
UserStoryPriority int
UserStory varchar(MAX)
UserStoryEstimate varchar(50)
ProjectName varchar(50)

The file must only be .csv format and the contents of the file must be inserted into the product_backlog table, also the filename of the csv file may be different each time it is uploaded.

UserStoryID is auto incremented so each new userstory inserted it will go up by 1, and also UserStoryID and ProjectName are primary keys.

I have no idea at all how to attempt this, i need the code for the .VB part of the page and dont know how to start or what to write. Does anybody have any code that would do this for me, or that would help me????

Uploading Csv and inserting to Database

Thu, 01 Dec 2011 06:25:57 -0800

login page Client Side validation with javascript in asp.net

Wed, 23 Nov 2011 20:51:59 -0800

can anyone post me the code for login page having fields username and passsword and clientside validation with javascript in asp.net

Page Loads?

Thu, 17 Nov 2011 18:09:42 -0800

How do other websites make so that when you click a <a href>, it appears if the page is scrolling to the side and then you arrive on the page you clicked. For example, check out http://aleksfaure.com/, and then click the menu item WORK.

importing from excel

Thu, 17 Nov 2011 00:33:08 -0800

i am imorting excel data to sql db uisng asp.net
i have 2 issue regrading the same

1) suppose i import a A.xls when the .net application is executed
it gets imported correctly for the first time
but if i try to import the same file again i get error as this file is used by some process...

i have
private void KillUnusedExcel()
{
System.Diagnostics.Process[] killUnused = System.Diagnostics.Process.GetProcessesByName("Exc el");
foreach (System.Diagnostics.Process open in killUnused)
{
if (open.MainWindowTitle.Length == 0)
{
open.Kill();

}
}
}

i closed the connection string also but still the excel doesnot quit from memory
so how to relase the excel from memory once the importing of one file is done

2) Al l records not getting imported in production server but works fine in development server
i am having 50 records in my excel sheet
in my developemnt server all 50 recods gets imported
i published the same code in my production server & using the same exxel files
so all 50 records shld be imported
but only one record is imported & no error msg is thrown
so asked abyt the remaining records
as the code is same ,database is same & excel sheet is aslo same

Help on button.click

Tue, 15 Nov 2011 18:23:07 -0800

I'm trying to make it on my website so that if I click a button or image button , another div will load that image. What is the best way to do this?

Help on button.click

Tue, 15 Nov 2011 18:21:15 -0800

I'm trying to make it on my website so that if I click a button or image button , another div will load that image. What is the best way to do this?

nested update panel

Mon, 14 Nov 2011 03:24:07 -0800

Hi,

I used 2 update panels, nested with each other
1st update panel contains GridView1
2nd update panel contains GridView2. Gridview2 contains GridView3. But GridView3 just displays data. It has no rowcommand or any events.

My problem is when a button in GridView2 is clicked. both GridView1 and GridView2's rowcommand event are fired. But, i do not want the GridView1's Rowcommand event to fire.

How do i achieve it. Please do help me asap.

I set updatemode to conditional for both up1 & up2 -> did'nt work.
I set updatemode to conditional, and childrenAsTriggers for both up1 & up2 -> did'nt work.

I set updatemode to conditional for both up1 & up2 and defined the trigger for up1 alone -> did'nt work
I set updatemode to conditional for both up1 & up2 and defined the trigger for up2 alone -> did'nt work
I set updatemode to conditional for both up1 & up2 and defined the triggers for both -> did'nt work.

------------------------------------------------------------------------------------------------

These are the triggers i tried

1) Inner update panel's trigger
<Triggers>
<asp:AsyncPostBackTrigger ControlID="GridView2" EventName="RowCommand" />
</Triggers>
2) Outer update panel's trigger

<Triggers>
<asp:AsyncPostBackTrigger ControlID="GridView1" EventName="RowCommand" />
</Triggers>
------------------------------------------------------------------------------------------------

<asp:UpdatePanel ID="up1" runat="server" UpdateMode="Conditional">
<ContentTemplate>
<asp:GridView ID="GridView1" .... OnRowCreated="GridView1_RowCreated" OnRowDataBound="GridView1_RowDataBound" OnRowCommand="GridView1_RowCommand">

....
..

<td>

<asp:UpdatePanel ID="up2" runat="server" UpdateMode="Conditional">
<ContentTemplate>
<asp:GridView ID="GridView2" .... OnRowCreated="GridView2_RowCreated" OnRowDataBound="GridView2_RowDataBound" OnRowCommand="GridView2_RowCommand">

<asp:GridView ID="GridView3" ....>
</asp:GridView>
</asp:GridView>
</ContentTemplate>
</asp:UpdatePanel>

</td>

.....

</asp:GridView>

</ContentTemplate>
</asp:UpdatePanel>

Please someone help

thanks in advance.

nested update panel

Mon, 14 Nov 2011 02:05:59 -0800

Pivot table in asp.net GridView

Fri, 11 Nov 2011 22:52:22 -0800

Hi,

I have 4 tables in my database. i want to create pivot table using them in a gridview.

1) Category
CategoryID CategoryName
1 Milk
2 Nuts
3 Fruits
4 Vegetables
5 Cakes

2) SubCategory
SubCategoryID CategoryID SubCategoryName
1 1 Soya
2 2 Almonds
3 2 Cashew
4 3 Apple
5 3 Orange
6 3 Grapes
7 3 Cherry

3) Product
ProductID ProductCode ProductName SubCategoryID Price
1000 A1 Cashew1 3 5
2000 B1 Cashew2 3 5
3000 C1 Cashew3 3 5
4000 D1 BlackGrapes 6 10
5000 E1 GreenGrapes 6 10
6000 F1 RoseGrapes 6 10

4) Sales
ID Date ProductID Qty Cost
1 25-Oct-11 1000 1 5
2 25-Oct-11 2000 1 5
3 25-Oct-11 3000 1 5
4 26-Oct-11 1000 2 10
5 26-Oct-11 2000 2 10
6 26-Oct-11 3000 2 10

------------------------------------------------------------

These are the tables in my DB.

I use the following query to display a pivot table

DECLARE @var nvarchar(500)
DECLARE @str nvarchar(2000)
SELECT @var =
STUFF(
(
select distinct ',[' + ltrim(rtrim(cast(CategoryName as char(10))))+ ']'
from Category
For XML Path('')
),
1,1,'')

SELECT @str = N'
select *
from (
select S.Date, S.Cost, C.CategoryName
from Sales S
left join Product P on S.ProductID = P.ProductID
left join Subcategory SC on SC.SubCategoryID = P.SubCategoryID
left join Category C on C.CategoryID = SC.CategoryID
) DataTable
PIVOT (
Sum(DataTable.Cost)
FOR DataTable.CategoryName IN (' + @var + ')
) PivotTable'

exec sp_executesql @str

It works fine.

It produces the following output.

Date | Cakes | Fruits | Milk | Nuts |Vegetables
2011-10-25 | NULL | NULL | NULL | 15.0000 | NULL
2011-10-26 | NULL | NULL | NULL | 30.0000 | NULL

But, i want to display this in my web page in a GridView as hierarchial data, just like how it will be displayed in a excel pivot table.

That is,

25-Oct-11 15
----Nuts 15
---------Cashew3 15
---------1000 5
---------2000 5
---------3000 5

26-Oct-11 30
----Nuts 30
---------Cashew3 30
---------1000 10
---------2000 10
---------3000 10
Grand Total 45

-----------
I checked this link to display a treeview inside a gridview.
http://www.codeproject.com/KB/aspnet/GridViewTreeView.aspx?msg=2484303

Can anyone please suggest me how to do this to produce a pivot table in a gridview-like control, that will be exactly like how pivot table looks in excel spreadsheet.

Thanks in advance

Pivot table in asp.net GridView

Fri, 11 Nov 2011 22:48:40 -0800

Uploading values from excel to DB

Mon, 07 Nov 2011 03:57:28 -0800

Hi Members,

Help me with this logic..

I have an excel sheet as specified below i need to upload values from this sheet to DB ( sql 20008). G1 is net value,sometimes net value can also be Null

Code Label
G1 Nokia
1 Nokia N series
2 Nokia C series
3 Nokia E series
4 Nokia Base Model
G2 NULL
5 Sony Ericsson
G3 Samsung
6 Samsung Galaxy
7 Samsung Galaxy Tab
8 Samsung Windows
9 Samsung Base Model
G4 Null
10 BLACKBERRY
11 MOTOROLA
12 LG
13 APPLE
14 Intex
15 ASUS
16 ACER
17 HTC
18 SPICE
19 Other

My values must be displayed in table as shown below:

Net code Label
G1 0 Nokia
G1 1 NokiaNseries
G1 2 NokiaEseries
G2 0
5 sony Erricson
G3 6 Samsung
G3 7 Samsung Galaxy Tab
G3 8 Samsung Windows
G4 0
10 BLACKBERRY
11 MOTOROLA

The code column should not accept any duplicate numbers other than 0(zero).
Please help me in writing logic for this

Thanks,
Sreemanth