ASP.NET

27-Sep-09 16:31

Illegal Operation wrote:
My question is how can I access the dataset in the DAL?

You're asking us how to use a library for which you presumably have the source code, and we do not. If it doesn't return what you need, change it so it does.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Re: N-Tier ASP.NET

Vimalsoft(Pty) Ltd28-Sep-09 2:15

Vimalsoft(Pty) Ltd

28-Sep-09 2:15

What Error are you getting ?

Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Gridview Merge Rows?

Lash2027-Sep-09 14:44

Lash20

27-Sep-09 14:44

Hi,

Can anyone tell me how to display multiple records of data as one row in a Gridview. I have data coming from the database in the following format, but I would like to display records in the same group as one row when bound in a Gridview. Any help would be greatly appreciated.

Thanks

PRODUCT GROUP JAN FEB MAR
Product A Group1 20 30 10
Product B Group1 40 100 20
Product C Group1 80 45 70
Product A Group2 50 30 40
Product B Group2 20 10 100
Product C Group2 90 30 60
-
-
-

Christian Graus27-Sep-09 14:53

27-Sep-09 14:53

If you want to group stuff together like this, you probably need to nest gridviews, or perhaps repeaters, to give you more control. Your data source should then change accordingly, so each nested control is bound to a group.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Lash2027-Sep-09 15:19

Lash20

27-Sep-09 15:19

Thanks for your response Chris,

If it is no bother, could you please post a sample code snippet? put in mind though that I can't change the datasource because it is being used in multiple places but I was thinking that the grouping could be done on databound..

Christian Graus27-Sep-09 16:00

27-Sep-09 16:00

If you can't change the data source, then you have a lot of work ahead of you. I was imaging two controls like this:

<asp:Repeater >
<ItemTemplate>
<asp:Repeater>

Then you bind a list of the top level ids to the repeater, and in onitemdatabound, look up the inner repeater and bind it to the table that corresponds to the id passed into the row. Obviously you add code to style it the way you want, define the columns, etc, the point is just that you get the granularity to create and style the data into groups.

I imagine if you're not allowed to create a new method to return a group of tables, that you'd need to write code that binds to the group names, and then searches the data source to filter based on group name.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Cannot run a website hosted outside. Locally works.

Lash2027-Sep-09 16:56

Lash20

27-Sep-09 16:56

Thanks Christian.

Takhir27-Sep-09 12:11

Takhir

27-Sep-09 12:11

I have a website (web-project), which I can publish locally and then run thru the virtual directory.
But when I moved that published code to the hosting of www.godaddy.com, it doesn't work and says:

Runtime Error
Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.

Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".

Why it happens? No one error happens on my side, the pages are simple, moreover, the one I tried to run has the only one control with static text, under masterpage. Even when I set the cutomErrors="Off", nothing is shown for me and no additional information...

Please advise.

Re: Cannot run a website hosted outside. Locally works.

Christian Graus27-Sep-09 13:23

Re: Cannot run a website hosted outside. Locally works.

27-Sep-09 13:23

Well, what's obvious is, there is an error, and you've not succeeded in setting up your web.config in such a way that the error is reported to you.

That it's reading the web.config means that you have .NET installed ( although perhaps the wrong version ). Beyond that, you need to find out the actual error, in order to fix it.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Not Active27-Sep-09 13:26

Not Active

27-Sep-09 13:26

It could be any number of things, wrong version of .net framework, a custom control, a dependent assembly is missing, a bad character in the config file. I would suggest you contact godaddy technical support.

only two letters away from being an asset

Re: Cannot run a website hosted outside. Locally works.

Christian Graus27-Sep-09 13:30

Re: Cannot run a website hosted outside. Locally works.

27-Sep-09 13:30

Mark Nischalke wrote:
I would suggest you contact godaddy technical support.

ROTFL. They will say 'it's a coding error, fix it yourself'. They say that even when you present evidence that this is not the case. They are worse than useless.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Not Active27-Sep-09 15:54

Not Active

27-Sep-09 15:54

Never used GoDaddy. I'm spoiled by having control over my own environments.

only two letters away from being an asset

Re: Cannot run a website hosted outside. Locally works.

Christian Graus27-Sep-09 16:03

Error - can not create enum dynamically

27-Sep-09 16:03

We're a big company, I have been fighting for that ability for some time now.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

$unil Dhiman27-Sep-09 8:40

$unil Dhiman

27-Sep-09 8:40

Hi All,
I am trying to create Enum Dynamically.
When I try to Save dll It gives me error - "Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))" I am also writing code snippet :-

AppDomain currentDomain = AppDomain.CurrentDomain;
AssemblyName aName = new AssemblyName("TempAssembly");
AssemblyBuilder ab = currentDomain.DefineDynamicAssembly(aName, AssemblyBuilderAccess.RunAndSave);
ModuleBuilder mb = ab.DefineDynamicModule(aName.Name, aName.Name + ".dll");
EnumBuilder eb = mb.DefineEnum("Elevation", TypeAttributes.Public, typeof(int));
eb.DefineLiteral("Low", 0);
eb.DefineLiteral("High", 1);
Type finished = eb.CreateType();
ab.Save(aName.Name + ".dll");

I got error at last line.
Please help me.
your help is appreciated.

Regards,
Sunil Dhiman

Re: Error - can not create enum dynamically

Abhijit Jana27-Sep-09 9:02

Abhijit Jana

27-Sep-09 9:02

Is it your web application ? if yes then where the application is hosted ? Do you have the write permission on that dll ?

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Re: Error - can not create enum dynamically

Abhishek Sur27-Sep-09 9:20

Abhishek Sur

27-Sep-09 9:20

The code seems to be fine. It should work.
The problem definitely is the FileIOPermission. Check if ASP.NET has write permission to the folder where the dll is created.

Frown | :(

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.

Arabic data is not displaying properly while exporting data to csv

Khaja A. Imtiaz27-Sep-09 1:42

Re: Arabic data is not displaying properly while exporting data to csv

27-Sep-09 1:42

Hi,

In my intranet application (VB.Net, Framework 2) when Iam trying to export data to csv format junk charaters are displayed in place of Arabic data...

When Iam tying to export the same data to Excel it is working fine...

What could be the reason why it is not displaying the junk characters....

Please guide what is going wrong...

Thanks

Imtiaz

Imtiaz A.K

N a v a n e e t h27-Sep-09 1:44

N a v a n e e t h

27-Sep-09 1:44

What encoding are you using? When Unicode characters are included, you should save in Utf8 encoding.

Navaneeth

How to use google | Ask smart questions

Re: Arabic data is not displaying properly while exporting data to csv

Khaja A. Imtiaz27-Sep-09 1:56

Re: Arabic data is not displaying properly while exporting data to csv

27-Sep-09 1:56

Iam using the below code..

<br />
da = New SqlDataAdapter(sQuery, Conn)<br />
        da.Fill(ds)<br />
        Dim GridView1 As New GridView<br />
        GridView1.AllowPaging = False<br />
        GridView1.DataSource = ds<br />
        GridView1.DataBind()<br />
        Response.Clear()<br />
        Response.Buffer = True<br />
Response.AddHeader("content-disposition", "attachment;filename=Report.csv")<br />
        Response.Charset = ""<br />
        Response.ContentType = "application/text"<br />
        Dim sb As New StringBuilder()<br />
<br />
        For k As Integer = 0 To ds.Tables(0).Columns.Count - 1<br />
             sb.Append(ds.Tables(0).Columns(k).ColumnName + ","c)<br />
            <br />
        Next<br />
       sb.Append(vbCr & vbLf)<br />
        For i As Integer = 0 To ds.Tables(0).Rows.Count - 1<br />
<br />
            For k As Integer = 0 To ds.Tables(0).Columns.Count - 1<br />
                'add separator <br />
                'sb.Append(ds.Tables(0).Rows(i)(k).ToString().Replace(",", ";") + ","c)<br />
                sb.Append(ds.Tables(0).Rows(i)(k).ToString() + ",")<br />
            Next<br />
            'append new line <br />
            sb.Append(vbCr & vbLf)<br />
        Next<br />
        Response.Output.Write(sb.ToString())<br />
        Response.Flush()<br />
        Response.End()<br />

Is there anything wrong in this code...

But when Iam trying to export the same data to Excel it is working fine....
if the issue is with unicode then it should not also support the Excel....

Please guide..

Imtiaz

Imtiaz A.K

N a v a n e e t h27-Sep-09 2:08

N a v a n e e t h

27-Sep-09 2:08

Try,

Response.ContentEncoding = Encoding.UTF8;
Response.Charset = "UTF-8";

Navaneeth

How to use google | Ask smart questions

Re: Arabic data is not displaying properly while exporting data to csv

Khaja A. Imtiaz27-Sep-09 2:36

Re: Arabic data is not displaying properly while exporting data to csv

27-Sep-09 2:36

no change..

same issue..

any other suggestion...

Imtiaz A.K

Abhishek Sur27-Sep-09 9:30

Abhishek Sur

27-Sep-09 9:30

Well, csv is only comma-separated values. You can open it in Text editors. If you are downloading a unicode file and open in TextMode it will not be shown properly. try to open the same file in unicode editors. I think you can see them clearly.

Excel format is actually supports Unicode. So if you open a file containing unicode characters in Excel, it will be shown properly. Smile | :)

As Navaneeth suggested, you can make the file download using

Response.ContentEncoding = Encoding.UTF8;
Response.Charset = "UTF-8";

which will ensure that the data downloaded is parsed as Unicode. Rose | [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.

Re: Arabic data is not displaying properly while exporting data to csv

Khaja A. Imtiaz27-Sep-09 21:27