Re: connection with my sql with ASP.Net - ASP.NET Discussion Boards

Christian Graus9-Nov-09 18:46

9-Nov-09 18:46

I've never seen the driver specified in the connection string, I've just installed the right classes to deal with the data source, and used them.

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: connection with my sql with ASP.Net

Gamzun9-Nov-09 20:06

Gamzun

9-Nov-09 20:06

Try this An ASP.NET Application Using a MySQL Database[^]

Please don't forget to mark 'Good Answer', if you find it really a good one!

Kashif

found solution

Amit Patel19859-Nov-09 20:21

Amit Patel1985

9-Nov-09 20:21

Hi All,

Thanks all . I have solved this problem

using following way

MySqlConnection con = new MySqlConnection(("server=127.0.0.1; user id=root; password=password; database=testwithdotnet; pooling=false;"));

Thanks and regards,

Amit Patel

modified on Tuesday, November 10, 2009 2:57 AM

Re: found solution

Christian Graus9-Nov-09 21:09

Christian Graus

9-Nov-09 21:09

Well, that's what we both told you to do, so....

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.

[Message Deleted]

Amit Patel19859-Nov-09 18:30

Amit Patel1985

9-Nov-09 18:30

[Message Deleted]

Re: connection with my sql with ASP.Net

N a v a n e e t h9-Nov-09 18:31

N a v a n e e t h

9-Nov-09 18:31

Use the connector[^] provided by MySql folks.

Best wishes,
Navaneeth

Re: connection with my sql with ASP.Net

Amit Patel19859-Nov-09 18:46

Amit Patel1985

9-Nov-09 18:46

hi ,

i m using this

string ConnStr = "Driver={MySQL ODBC 6.1.2 Driver};Server=localhost;Database=testwithdotnet;uid=root;pwd=password;Port=3306;Option=3";

OdbcConnection odbcConnection = new OdbcConnection(ConnStr);
OdbcCommand cmd = new OdbcCommand("SELECT * FROM amit", odbcConnection);
odbcConnection.Open();

but this is giving following error.

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

thanks and regards,
amit patel

Re: connection with my sql with ASP.Net

Christian Graus9-Nov-09 18:47

Christian Graus

9-Nov-09 18:47

Amit Patel1985 wrote:
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

What makes you think this error is wrong ? What leads you to believe that the connection string is pointing to a valid driver ? Have you installed/configured one for ODBC ?

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.

Async updates to DB without BackgroundWorker

student_rhr9-Nov-09 12:40

student_rhr

9-Nov-09 12:40

Hi,

In my ASP.NET application, I have a situation where I am doing a lot of computing and database reads/inserts/updates.
I needed to gather statistics on the processing records. This info is actually displayed on another webpage. Processing routine looks something like this:

public void Process()
{
    int recordCount = 0;
    ProgressHelper.Start();
    while(processing)    
    {
        //Actual processing logic
        recordCount++;

        //Every 10 processed records, update the progress table
        if(recordCount % 10 == 0)
        {
           ProgressHelper.UpdateProcessedRecordCount(recordCount); 
        }
    }
    ProgressHelper.End();
}

These database calls to update the progress add additional delay.

I was wondering if there is a way to actually execute all the ProgressHelper stuff asynchronously (without using background worker)? (perhaps delegates ... but are delegates really async?)

Re: Async updates to DB without BackgroundWorker

N a v a n e e t h9-Nov-09 15:32

N a v a n e e t h

9-Nov-09 15:32

What is ProgressHelper?

BackgroundWorker is a class designed for windows applications not web applications. So using it in a web application is not a good idea. If I understood your question, you need to do a time consuming task on background and show a progress bar on another ASP.NET page, correct?

If yes, follow the below steps.

From the first page, start a thread (or better if you can use ThreadPool) and run the Process() method on that.
This method should update the progress to a session variable say Session["progress"]
Once the thread started, redirect to the page where progress will be displayed
Use AJAX and poll the Session["progress"] value and show it on the page. For creating progress bar, you can use HTML DIV tag with a background color.

You need to pass HttpContext.Current to the Process() method because it is thread specific and a worker thread won't have access to it. Use this context to access the session.

Hope that helps Smile | :)

Best wishes,
Navaneeth

Re: Async updates to DB without BackgroundWorker

student_rhr10-Nov-09 5:10

student_rhr

10-Nov-09 5:10

Thanks Navaneeth. ProgressHelper is my internal DAL responsible for udpating the progress table (sorry I should have explained). I agree with you that BackgroundWorker is a bad idea that's why I was wondering if there might be a better way to accomplish this.

Also, what are your thoughts about Async Delegates? Have you seen any adverse effects of using them in ASP.NET?

Appreciate your hlep!

Re: Async updates to DB without BackgroundWorker

N a v a n e e t h10-Nov-09 14:41

N a v a n e e t h

10-Nov-09 14:41

student_rhr wrote:
I agree with you that BackgroundWorker is a bad idea that's why I was wondering if there might be a better way to accomplish this.

See the point 1 in my first reply.

student_rhr wrote:
Also, what are your thoughts about Async Delegates? Have you seen any adverse effects of using them in ASP.NET?

Asynchronous pattern will make your code unnecessarily complicated. So I'd stay away from it unless there is a strong need for using it. As I said, work with Thread or ThreadPool directly.

Best wishes,
Navaneeth

how to connect to the pop3 server from web page

amalatsliit9-Nov-09 11:45

amalatsliit

9-Nov-09 11:45

Hi,
I need to develope web site which connect to the pop3 mail server and populate all emails in a grid.
so after user can select emails from grid and can delete unnecessary mails through grid.

i have search lot of samples most of them are windows based.does any body know or can direct me to correct path.

i'm using .net 3.5 with sql server 2008.

thankx

Re: how to connect to the pop3 server from web page

Christian Graus9-Nov-09 11:51

Christian Graus

9-Nov-09 11:51

It makes no difference. your web page, on postback, can use the same code to check mail and populate the page with the results.

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: how to connect to the pop3 server from web page

amalatsliit9-Nov-09 12:18

amalatsliit

9-Nov-09 12:18

can any u provide few examples...

Re: how to connect to the pop3 server from web page

Christian Graus9-Nov-09 14:49

Christian Graus

9-Nov-09 14:49

You said you found lots of them on the web, so why would you need more ?

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: how to connect to the pop3 server from web page

Kannan Ar9-Nov-09 15:27

Kannan Ar

9-Nov-09 15:27

You can connect to a pop3 server using a TCP connection. Once the connection established, there are a set of commands to communicate with pop3 server. There is an RFC[^] for these commands.

Show/hide menu

aspneter9-Nov-09 9:38

aspneter

9-Nov-09 9:38

Hi All,

How to maintain "session" state or the like for a show/hide menu when I click a sub link from an open block of sub category, like the one The Code Project did it on the left menu panel.

For example, if I click on "Web Development" link under "ARTICLES" category, it will show many links under the "Web Development" block. Click on a link in that open block, the page will refresh and show me article I wish to view. The problem I have is I can't figure out how to maintain session of the link I just clicked. That is keep the block "Web Development" open after the page refreshes.

Thank you.

Re: Show/hide menu

Abhishek Sur9-Nov-09 10:26

Abhishek Sur

9-Nov-09 10:26

What is the problem with that. Use hiddenfield to get it. Smile | :)

Or rather you could get the group where the user clicked from its url as well... Wink | ;)

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

Can I get a hold of ASP controls in an ASPX page

fiaolle9-Nov-09 8:22

fiaolle

9-Nov-09 8:22

Hi I have en Asp file lcon.asp in my website project, where I use an Iframe. I want to be able to use the iframe in the code behind from another aspx page.

<iframe runat =server id="left" src="ShowGroups.aspx" scrolling="no" frameborder="0" width="100%" height="1000"></iframe>

I would like to do something like this.

protected System.Web.UI.HtmlControls.HtmlGenericControl frame1;
HtmlControl frame1 = (HtmlControl)this.FindControl("left");
frame1.Attributes["src"] = "http://search.msn.com";

But if there is another way to refresh the iframe, please tell me.

Fia

Re: Can I get a hold of ASP controls in an ASPX page

fiaolle9-Nov-09 8:26

fiaolle

9-Nov-09 8:26

I don't want to use javascript.

Re: Can I get a hold of ASP controls in an ASPX page

Abhishek Sur9-Nov-09 8:42

Abhishek Sur

9-Nov-09 8:42

AFAIK ... no wayout other than javascript. At least the page should be posted back to the aspx page to get the iframe.

You need to use custom handler to do this as your actual page is asp.

Why dont you convert the asp page to aspx then.

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

Re: Can I get a hold of ASP controls in an ASPX page

fiaolle9-Nov-09 9:00

fiaolle

9-Nov-09 9:00

Thank's for your answer, but I can't convert or not allowed to convert tha asp page to aspx. What do you mean by post back to the aspx page. And what is custom handler.

Fia

Re: Can I get a hold of ASP controls in an ASPX page

Abhishek Sur9-Nov-09 10:23

Abhishek Sur

9-Nov-09 10:23

I mean say you have a page called submitRequest.aspx

Now from your Asp page use:

<br />
<form action ="submitRequest.aspx" >

thus when the page is posted back it goes to submitRequest.aspx. You can get each of those form elements using Request object from submitRequest.aspx (even the IFrame) where page is your custom handler.

You can also use a class which inherits from IHttpHandler to call its process request.

On the other hand, how could you access the iframe from the server side, if your actual parent page is made using asp. You better use javascript to get reference from Iframe if you do require.

I hope you got my point. Smile | :)

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

Re: Can I get a hold of ASP controls in an ASPX page

fiaolle9-Nov-09 10:59

fiaolle

9-Nov-09 10:59

Hi again

I'm grateful for your answers, but I'm rather new to asp.net. How should I write to get a hold of the iframe. The iframe have id="left" in the asp page. But when I try Request["left"], I get null. And how am I going to change the src of the iframe.

Hope you have time to help me more

Fia

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