Datagrid item - ASP.NET Discussion Boards

First Prev Next

Re: Server error in ASP.NET while publishing

Ahamed Azeem5-Aug-10 0:45

Ahamed Azeem

5-Aug-10 0:45

master pages are published and are accessible to all

Ahamed Azeem
software Programmer

Re: Server error in ASP.NET while publishing

m@dhu5-Aug-10 1:17

m@dhu

5-Aug-10 1:17

hav a look at this link http://forums.asp.net/p/1133927/1805459.aspx

Effective method for rendering tabular data

afsal qureshi4-Aug-10 22:17

afsal qureshi

4-Aug-10 22:17

I have a scneraio where I need to show the search results in a table. The headers consists of column span in more than one rows.

I will try to draw the basic layout here but the actual layout would be more complex than this.

<table >
<tr border=1>
    <td colspan=2 border=1> Column1</td>
    <td colspan=2 border=1> Column2 </td>
</tr>
<tr border=2>
    <td border=1> Col11 </td>
     <td border=1>col12</td>
    <td border=1> col21</td>
    <td border=1> col22</td>
</tr>
<tr>
  <td></td>
</tr>
</table>

The count of columns will be dynamic.

Now, I have two questions.

1. Please let me know if going for a gridview will be appropriate to do this?
2. The data that will be loaded could be huge. I cannot go for a paging approach. Please let me know if we can do a rendering whenever we have the data rather than waiting for full data to be buffered and then render at one shot. I am thinking about features such as response.flush

Please let me know any thoughts.

Thanks,
Afsal

modified on Thursday, August 5, 2010 5:14 AM

Re: Effective method for rendering tabular data

Anurag Gandhi5-Aug-10 1:21

Anurag Gandhi

5-Aug-10 1:21

You can achieve this in GridView in just a few lines of code.
Following articles will help you in doing that wholly or partially
based on what exactly you need to do.

How to merge cells with equal values in a GridView[^]
Check MergeHeader portion of this article:
Pivoting DataTable Simplified[^]

Hope this will help.

Anurag Gandhi.
http://www.gandhisoft.com
Life is a computer program and every one is the programmer of his own life.

Re: Effective method for rendering tabular data

afsal qureshi5-Aug-10 1:46

afsal qureshi

5-Aug-10 1:46

Well, that's the answer for my first question and I am aware of this can be done with grid view. Can you please give your thoughts to my second question.

Thanks.

Re: Effective method for rendering tabular data

Anurag Gandhi5-Aug-10 2:02

Anurag Gandhi

5-Aug-10 2:02

Well, the huge data is not defining the size of your data you want to display. Definitely you can do incremental loading also.

You can google a bit to get the info on incremental page load.

http://www.vikramlakhotia.com/Incremental_Page_display_using_the_Aspnet_Ajax_Extension.aspx[^]
Incremental Page Display Pattern for User Controls[^]

The only issue is: if your data has millions of records, clients browser may crash depending on their system configuration.

Anurag Gandhi.
http://www.gandhisoft.com
Life is a computer program and every one is the programmer of his own life.

Re: Effective method for rendering tabular data

afsal qureshi5-Aug-10 23:21

afsal qureshi

5-Aug-10 23:21

Thanks for the reply.
In my case the column count is dynamic. Hence I cannot design a gridview in the aspx.

Datagrid item

Morgs Morgan4-Aug-10 21:46

Morgs Morgan

4-Aug-10 21:46

Hi guys,
i have a datagrid, i would like to get the value of one column
when user clicks on that row(item) so that i can show the details
of that row(item) on the next page. I have tried the below and
am not so sure how to proceed:

protected void available_ItemDataBound(object sender, DataGridItemEventArgs e)
{
//string striD;
   foreach(DataGridColumn col in available.Columns)
   {
       if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item)
       {
            //striD = available.DataKeys[e.Item.ItemIndex].ToString();
            e.Item.Attributes.Add("onmouseover", "this.style.backgroundColor='#F9F9F9' this.style.cursor='pointer';");
            e.Item.Attributes.Add("onmouseout", "this.style.backgroundColor='#ffffff';this.style.cursor='pointer';");

        }
    }
}

Does anyone know how i can manage to get the value of one column in tha
row that has been clicked?
Please help me D'Oh! | :doh:

Regards
MS

Re: Datagrid item

NeverHeardOfMe4-Aug-10 22:31

NeverHeardOfMe

4-Aug-10 22:31

Assuming your DataGrid is bound to a DataView with a unique ID value for each row,
include a Hypelink in your DataGrid columns - say hypDetails, maybe within a template column -
then you can put in your ItemDatBound code:

DataRow dr = e.Item.DataItem.Row;
HyperLink hypDetails = CType(e.Item.FindControl("hypDetails"), HyperLink);
hypDetails.NavigateUrl = "details.aspx?id=" & CStr(dr("ID"));

This will pass the ID value of that row as a parameter to the next page (details.aspx)

Re: Datagrid item

Morgs Morgan4-Aug-10 22:53

Morgs Morgan

4-Aug-10 22:53

Thanks alot man, i will give it a try just now.... but unfortunatly
'CType' does not exist in C# only VB...is there an alternative to this? D'Oh! | :doh:

Regards,
MS

Re: Datagrid item

NeverHeardOfMe4-Aug-10 23:07

NeverHeardOfMe

4-Aug-10 23:07

OMG I've been outed! Wink | ;-)

I'm sure a little Googling will sort you out...

Re: Datagrid item

m@dhu5-Aug-10 0:15

m@dhu

5-Aug-10 0:15

in c#....

HyperLink hypDetails = (HyperLink)e.Item.FindControl("hypDetails");

How to Change the Color of the Pie Chart in ASP.Net ................?????

Sivan.G4-Aug-10 20:21

Sivan.G

4-Aug-10 20:21

Hi,

How to Change the Color of the Pie Chart in ASP.Net Application.
I have used ASP Charts in my application and the Pie Chart is Filled with some Default Colors. How shall i change them to some Specific Colors??
Please Help me fixing this Issue...

Regards
Sivan.G

Re: How to Change the Color of the Pie Chart in ASP.Net ................?????

Prosanta Kundu online4-Aug-10 20:30

Prosanta Kundu online

4-Aug-10 20:30

See this link [http://forums.asp.net/p/1379517/2912223.aspx]

Sending mail with excel attachment issue

Mugdha_Aditya4-Aug-10 19:17

Mugdha_Aditya

4-Aug-10 19:17

I'm sending mail with excel attchment and it's working fine when I run it from my local
machine. but if I try to access it from another machine it's giving me this
Error:
Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005 Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)).

Error coming on first line of below code
Microsoft.Office.Interop.Excel.Workbook aBook;
Microsoft.Office.Interop.Excel.Application ExlApp = new Microsoft.Office.Interop.Excel.Application();

i have given all rights still error is coming Frown | :(

please help me out as soon as possible

Re: Sending mail with excel attachment issue

Prosanta Kundu online4-Aug-10 20:12

Prosanta Kundu online

4-Aug-10 20:12

It means that your application user does not have necessary permission to open an excel instance. Open DCOM Config, and Grant Launch & Activation permisson, and Access permission to Microsoft Excel Application.

Or you can see this [http://forums.asp.net/t/1303594.aspx]

Re: Sending mail with excel attachment issue

Mugdha_Aditya4-Aug-10 20:24

Mugdha_Aditya

4-Aug-10 20:24

i checked the same link and given rights like tht only
still it gives error Frown | :(

Re: Sending mail with excel attachment issue

Prosanta Kundu online4-Aug-10 20:28

Prosanta Kundu online

4-Aug-10 20:28

If you are deploying this Windows Server 2008 then see this link [http://social.msdn.microsoft.com/Forums/en-US/innovateonoffice/thread/b81a3c4e-62db-488b-af06-44421818ef91?prof=required]

Re: Sending mail with excel attachment issue

Mugdha_Aditya4-Aug-10 20:38

Mugdha_Aditya

4-Aug-10 20:38

its its win2003 server

Re: Sending mail with excel attachment issue

Prosanta Kundu online4-Aug-10 21:14

Prosanta Kundu online

4-Aug-10 21:14

Grant Access Permission in DCOM Config for Network Service account (Application Pool user)

Message Removed

4-Aug-10 15:27

coderclan

4-Aug-10 15:27

Message Removed

Re: How to create chat with asp.net, ajax and xmpp?

Prosanta Kundu online4-Aug-10 18:56

Prosanta Kundu online

4-Aug-10 18:56

Keep the question as brief as possible. Also see this [link]

Do I need to keep auto generated meta information in connection string for Entity Model ?

Nadia Monalisa4-Aug-10 13:17

Nadia Monalisa

4-Aug-10 13:17

Hi,

I can see that, in my web.config file, my Entity Model set created the following connection string,

<add name="ConnStrDemo" connectionString="metadata=res://*/Models.SDB.csdl|res://*/Models.SDB.ssdl|res://*/Models.SDB.msl;provider=System.Data.SqlClient;provider connection string='Data Source=SDGSDG-PC\SQLEXPRESS;AttachDbFilename=&quot;D:\Demo\WebApp\App_Data\myDb.mdf&quot;;Integrated Security=True;MultipleActiveResultSets=True'"
      providerName="System.Data.EntityClient" />

Obviously I need to change the data source part when I will deploy my web application my production server. My production server SQL Connection string should be something like this,

Server=XXX.XXX.XXX.XXX;Database=XXX;User ID=XXXX;Password=XXX;

Now, if I change the connection string from my web.config file to

<add name="ConnStrDemo" connectionString="Server=XXX.XXX.XXX.XXX;Database=XXX;User ID=XXXX;Password=XXX;" />

Will everything simply work in my production server ? I am afraid if the metadata part in the connection string is required by the Entity Framework or not. Please advice.

Regards.

Message Removed

4-Aug-10 6:03

arkiboys

4-Aug-10 6:03

Message Removed

Re: ajax dropdown

Sandeep Mewara4-Aug-10 6:10

Sandeep Mewara

4-Aug-10 6:10

Let me guess, you are using IE6. Is it? If so, then there are various issues with IE6. Almost whole world has moved to IE7/IE8. Why are you not?

In case it's not IE6, then how can you say it's a style issue. It looks fine. Did you try a sample POC that a generic issue for you or specific to this very istance? Build a sample and see if it's an issue there too.

Last Visit: 31-Dec-99 18:00 Last Update: 24-Apr-24 19:24

Refresh

ᐊ Prev 1...807 808 809 810811812 813 814 815 816 Next ᐅ

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