.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Binding Gridview using MDX query

Posted By:      Posted Date: September 15, 2010    Points: 0   Category :Sql Server
Hi, I tried to show results in a gridview using MDX query. In addition, I created a dropdownlist. I was hoping that the content of the gridview would change when I choose different conditions  from the dropdownlist. However, there was an error: "The result set returned by the server is not a rowset."  I did much research on the problem, but I still don't understand. The following is my code: public partial class Default3 : System.Web.UI.Page { StringBuilder sb = new StringBuilder(); protected void Page_Load(object sender, EventArgs e) { string conString = "Datasource=localhost;Initial Catalog=PIsystem"; AdomdConnection con = new AdomdConnection(); con.ConnectionString = conString; con.Open(); AdomdCommand cmd = con.CreateCommand(); cmd.CommandText = sb.ToString(); DataTable dt = new DataTable(); dt.Load(cmd.ExecuteReader()); GridView1.DataSource = dt; GridView1.DataBind(); con.Close(); } protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { if (DropDownList1.SelectedIndex > -1) { if (DropDownList1.Items[1].Selected) { sb.Append("SELECT {[Measures].[NBP]} ON COLUMNS, {[Time].[Month]} ON ROWS"); sb.Append("FROM [PISystem]"); sb.Append("WHERE ([Employ].[Region

View Complete Post

More Related Resource Links

Binding Compiled Query to Gridview


how can i bind data to gridview
when using compiles query?
load all country

GridView1.DataSource = myclas.EmployeesByManagerId(db);
this is class
static class myclas
        public static Func<Entities2, IQueryable<Country>>
              EmployeesByManagerId =
                   (Entities2 db) =>
                      from c in db.Country
                      select c);

Binding the multiple drop down boxes in GridView using JQuery in ASP.NET

Here is the code for binding the multiple drop down boxes in GridView using JQuery in ASP.NET

Binding GridView with SqlDataSource at runtime?


Hi, I want to create a generic page which contains a gridview and sqldatasource. I want to put these two controls on .aspx (C#) page but bind them at runtime. It should have selectcommand, updatecommand, deletecommand and insertcommand. Stored procedures are created for that. Help is needed to make it. Please post some link or code. Regards, ap.

Need some help BINDING to Gridview


Here is how I set this up....Still not working.

  •     Dim cs As ConnectionStringSettings   
  •     cs = ConfigurationManager.ConnectionStrings("ConnectionStringVendors")   
  •     Dim connString As String = cs.ConnectionString   
  •     Dim dbConnection As New SqlConnection(connString)   
  •     Dim query As String  
  •     Dim query1 As String  
  •     query = "SELECT keyID, projectNum, projectDescripti
  • GridView Paging + Unsupported overload used for query operator 'Distinct'


    The issue is two fold in my ASP.NET Web Application. I need to use a custom Distinct() via LINQ to SQL, and then assign thevar as a DataSource to a GridView. If I use the custom Distinct that implements IEqualityComparer, I get "Unsupported overload used for query operator 'Distinct'" exception. but if i somehow get past this, i get "The data source does not support server-side data paging" exception on GridView.DataBind(). here is the code:

    distinct_employees =
        (from emp in wsq.LIT_Active_Employees
        where (String.IsNullOrEmpty(ssFirstName.Text) ? (emp.FIRST_NAME == null || emp.FIRST_NAME.StartsWith(String.Empty)) : emp.FIRST_NAME.Contains(ssFirstName.Text)) &&
                (String.IsNullOrEmpty(ssLastName.Text) ? (emp.LAST_NAME == null || emp.LAST_NAME.StartsWith(String.Empty)) : emp.LAST_NAME.Contains(ssLastName.Text)) &&a

    Binding xml data (which is return from Url) to gridview


    I have used Yahoo BOSS API for internal search. This API return string and i want to bind it with gridview. How can i achieve this following is the code

    string AppId = "sRP_q9bV34HI_zNyuahPFBGnf1SHyBaIKCtvEjB89EuiNJI6fcfSwAFbwAFSsCV_";
    //string Query = "site:way2k.com engineering colleges in pune";
    string Query = "colleges in pune"; int NumResults = 10;
         int NumResults = 10;
    System.Net.WebClient webClient = new System.Net.WebClient(); request = string.Format( "http://boss.yahooapis.com/ysearch/web/v1/{1}?appid={0}&format=xml&results={2}", AppId, Query, NumResults); byte[] response = webClient.DownloadData(request); string responseXML = System.Text.UTF8Encoding.UTF8.GetString(response); return responseXML;

    this code returns result in xml format, how can i bind this XML to gridview so that it looks like search result

    binding innerhtml data to gridview

    I have innerhtml data in database(which contains both text and picture) fro example it will look like this <P>&nbsp;which one is afgnfgdggm</P><P>gfglkfgfgriwtiouweoituwetjhewoituewointwektiujwent</P><P><IMG src="http://localhost:3032/IHSOnline/editorimages/UserImages/7b709.jpg" width=150>&nbsp;</P> I have to bind this data to gridview.These are the steps i tried.......I took this data to a string using Server.HtmlDecode .(this step i have done in an imagegrab.aspx page using id of image,to retrieve and bind data dynamically to griview). in gridview i made a templatefield and code is like this <asp:TemplateField HeaderText="Question"> <ItemTemplate> <%# FormatURL(DataBinder.Eval(Container.DataItem, "question_id")) %> </ItemTemplate> </asp:TemplateField> where server side function public string FormatURL(object strArgument) { return ("imagegrab.aspx?id=" + strArgument); } I tried to call imagegrab.aspx.But it is not working.Can anyone describe me how to call and pass this id to imagegrab.aspx....... and also how to bind this data to gridview

    binding datetimecontrol,dropdown,textbox inside gridview and update each gridviewrow

    i have a web part with datetimecontrol(sharepoint) inside a  gridview. when the page loads this this gridview will be loaded with dtc control and the selecteddate would be one of the columns in the splist.also gridview contaisn dropdowns, textboxes, when an update button cliked inside grid, i need to save the info in the splist.  currently i am not getting the value  bound with dtc control. i am getting blank date inside dtc. though in the  rowdatabound event i amcapturing the values due to some reason i am not able to view the value in the DTCcontrol. can anybody give me help me how to achieve this? any  help links/ sample code.. appreciate the help                         

    Binding Web Service Result in asp:gridview and enable sorting(paiging)

    Hello everyoneI have web service and gridviewI'm binding it without problemcode: protected void Page_Load(object sender, EventArgs e) { GetCallsService wservice = new GetCallsService(); List<Call> list = wservice.getCalls(2); GridView1.DataSource = list; //GridView1.AllowSorting = true; GridView1.DataBind(); } But I want to enable sorting and(or) paging.   GridView1.AllowSorting = true; this doen't solves problem.everything worls fine if I'm usign sqlDatasource but when datasource is web service it doesn't wokdoes enyone know solution?

    Problem Binding DropdownList in a gridView to a datasource

    I have a Dropdownlist in an itemTemplate in a gridview. My gridView binds to dataTable1 (from which the selected value for dropdown comes from) and dropDown binds to dataTable2 (i need to get DataValueField and DataTextField from here).<asp:TemplateField HeaderText="Category"> <ItemTemplate> <asp:DropDownList ID="Cat" runat="server" SelectedValue='<%#Bind("CATEGORY") %>' > </asp:DropDownList> </ItemTemplate> <FooterStyle BorderStyle="None" /> <HeaderStyle BorderStyle="None" /> <ItemStyle BorderStyle="None" /> </asp:TemplateField>How do I do that? thanks in advance!

    GridView column/row data binding problem

    Hi All, I have a table with the following structure: Attribute------------- AttributeIdWeekNoDayNoAttribute1Attribute2Attribute3Attribute4Attribute5 ........ likewise. I want to display these data in a gridview in the following manner                                  Sunday    Monday Tuesday ............ (till Saturday) - should be gridview columns, I can retrieve this using dayno Attribute 1 Attribute 2 Attribute 3 Attribute 4 .......... like wise attributes should be taken in to rows.Is this possible in a gridview, if so how can I do that?

    How to enable delete column at Gridview when having specify query.

    Hello:  I have trouble to add delete column to gridview when using specific query. I have PK set up at the table, I need add specific query to display data at gridview:   SELECT [PID], [GID], [TID], [SID], [NEWSID] FROM [TableOne] WHERE ([NAME] = ?)   After builder this query, I click advanced button. However, generate insert, update, and delete Statements is not enabled.   How to add delete column to this gridview?   Your help is highly appreciated.

    Why does "reader" in my c# codebehind skip the first row of data when binding to a gridview?


    Argh.. I'm making the switch from vb.net to c#, and am just trying to bind some data from a reader in my c # codebehind, but no matter what, the gridview always skips the first row returned from my stored procedure.  What am I doing wrong???

    comm.CommandText = "123456";
    comm.Parameters.AddWithValue("@SubSectionParentID", SubSectionParentID.Text);
    reader = comm.ExecuteReader();
                      while (reader.Read())
                gvMenu.DataSource = reader;


    Merging gridview header after binding in winforms



    Note : I am talking about Winform grid only

    I want to bind a grid, structure should look like below after binding with the datatable,


        26_sept            l         27_sept          l            28_sept       l           29_sept

    col1 col2 col3 col4 l   col1 col2 col3 col4  l   col1 col2 col3 col4 l  col1 col2 col3 col4

                               l                               l                              l


    Here, I have datatable dt 16 columns as below but no parent header

    col1 col2 col3 col4 l   col1 col2 col3 col4  l   col1 col2 col3 col4 l  col1 col2

    Change image in gridview after binding


    I have a need to change the image (bound) in a gridview after it has been databound.  Basically i need to assign a photo to a record and I want to change the image url for that row.  I can change the text in any of the cells of the row but I can't seem to find property for the imageurl.

    This is what I do to change the text(cell 5).

    int index = int.Parse(Session["NSI"].ToString());

    GridViewRow row1 = GridView1.Rows[index];
    row1.Cells[5].Text = "just some text";

    But now I need to change the image url for cell 0

    something along the lines of ...

    row1.Cells[0].ImageUrl = "~images\photos\12345.jpg";

    How do I get to that property?

    Thank you.

    Binding a Button's Content property to an XPath query, Accelerator functionality is lost



    I'm using WPF 3.5.

    I'm binding a button's Content property to an XPath query, and all is well until I try to make use of the Accelerator feature. 

    When I hardcode the text, and place an _ (underscore) in the content, it renders as an accelerator key when the Alt key is pressed.  However, when the content is a binding expression that uses an XPath query, the underscore does not render as an accelerator key.  It simply appears as part of the content. 

    Here is some simplified XAML code to illustrate:

    <UserControl x:Class="Myapp.UI.Screens.PortalScreens.Portal"
    	xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="d"
    		<XmlDataProvider x:Key="languageResources" d:IsDataSource="True" Source="Resources\Language\English.xml" />
    <Grid x:Name="layoutRoot">
    		<Button x:Name="ExitButtonWithHardCodedText" Grid.Row=&quo

    Export a Query to Gridview then Excel


    I have not done this before so pardin this question that I am sure has been asked before.

    I have a user that asks me to run queries each month and copy & paste the data into a spreadsheet

    I want to set up the queries in a web page for him to choose, enter the data in the parameters

    and either show the data in a gridview then export or just export to the spreadsheet

    direclty to the file name and location of his choice.

    Using C#

    Links or code samples would great.

    ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
    Sql Server  SharePoint  Silverlight  Others  All   

    Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend