ASP.NET Discussion Boards

Re: create a runtime table in Ms Access database

Colin Angus Mackay11-Dec-06 4:17

Colin Angus Mackay

11-Dec-06 4:17

arpita2006 wrote:
ASP.net 2.0

ASP.NET will not help you because that is a technology for web applications. ADO.NET is that part of the .NET Framework that deals with databases.

With ADO.NET you can issue pretty much any commands that the underlying database understands. So you can use OleDbCommand.ExecuteNonQuery() to issue CREATE TABLE commands. You will need to look up the MS Access reference for details of what SQL you need to perform these actions.

Upcoming Scottish Developers events:
* Glasgow: Tell us what you want to see in 2007

My: Website | Blog | Photos

Re: create a runtime table in Ms Access database

Vasudevan Deepak Kumar11-Dec-06 4:21

Vasudevan Deepak Kumar

11-Dec-06 4:21

http://www.stpworks.com/DesktopDefault.aspx?tabindex=1&tabid=3&articleid=3[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

defining color palette in System.Drawing

Fred_Smith11-Dec-06 3:28

Fred_Smith

11-Dec-06 3:28

Hi,

I am quite OK with using the System.Drawing class to create an image on the fly, but if I want to save it as a .gif image, how do I create/define/set the colour palette to avoid horrible dithereing if I use anything other than "standard" colours?

Any pointers gratefully appreciated
thanks
Fred

Re: defining color palette in System.Drawing

ed^nrgc11-Dec-06 6:15

ed^nrgc

11-Dec-06 6:15

Web-safe colors are the closest thing to a sure bet. After that, you're on your own.

parameters problem in .net 2005

jabbarsb11-Dec-06 2:52

jabbarsb

11-Dec-06 2:52

hi friends,
i am facing a problem in vs 2005 i am using gridview control and sqldatasource bounded to it
in the update command of the sqldatasource i am passing a query

UPDATE aspnet_UsersInRoles SET RoleId = @RoleId WHERE UserId =@userid

the gridview is having three columns userid,username and roleid among which userid is hidden

if i make this column visible then the above query is working fine but when i make it visible=false then i am getting an
error : Must declare a variable @userid

also i want to know if i place a dropdownlist in gridview how to access its selectedvalues as a parameter

can anybody help me

regards jabbar

jabbarsb

Re: parameters problem in .net 2005

Anil Ch11-Dec-06 8:00

Anil Ch

11-Dec-06 8:00

Hi,
error : Must declare a variable @userid
when column propert visible is false is correct.
Since in visual 2005 if column in visible false then data is not binded to that column.
Sol: To avoid this problem make visible false of column in RowCreated event of grid. This will solve your problem.
hope this helps.

Cheers! Anil

Setting order of HTTPHandlers

Not Active11-Dec-06 2:51

Not Active

11-Dec-06 2:51

Does any one know if there is a way to set the order in which HTTPHandlers are called? Or is it determined by the order in which they appear and are rendered on the page?

only two letters away from being an asset

Re: Setting order of HTTPHandlers

minhpc_bk11-Dec-06 15:38

minhpc_bk

11-Dec-06 15:38

Hi Mark,
MSDN says about the httpHandlers Element[^]:
"The <httpHandlers> settings are inherited by the application subdirectories.

The <add> directives are processed in top-down, sequential order. If two or more <add> elements specify the same verb/path combination, the final <add> overrides all others."

So, IMHO you can put the handler down on the list if you it to run.

Re: Setting order of HTTPHandlers

Not Active11-Dec-06 15:56

Not Active

11-Dec-06 15:56

I probably screwed something up because it didn't seem to process them in the correct order. Thought I might be missing something.

only two letters away from being an asset

Error: "Product registry key not found"

Ivo Mestre11-Dec-06 2:07

Ivo Mestre

11-Dec-06 2:07

Hi there,
I'm making a website in ASP.net which shows some data from Microsoft SharePoint on it. but an error occured and it says this:

Product registry key not found.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Microsoft.SharePoint.Portal.Topology.ProductKeyNullException: Product registry key not found.

Source Error:
[No relevant source lines]

Also this source file: _paj-teg.0.cs in my temporary asp.net files directory

I can't find nothing in internet to resolve this problem, it's a very important project and I can't do anything more Sigh | :sigh:

Hope I can get any help here

Hugs

Beautiful URLs

phimix11-Dec-06 1:58

phimix

11-Dec-06 1:58

Aloha,

I'm porting a Wordpress (Linux blog/CMS) based system to ASP.NET. Many of the articles in Wordpress have URLs like www.domain.com/santa-claus.

How do I handle requests to such URLs in ASP.NET. We have ported the data, but our ASP.NET pages have URLs like www.domain.com/article?id=234

I'm considering implementing an IHttpHandler that transforms the requests with the help of a database query (table with Wordpress/ASP.NET matches).

Is that the correct thing to do?

Thank you, Mads

phi
Geek Load - Free Geek Stuff for Everybody OMG | :OMG:

Re: Beautiful URLs

Not Active11-Dec-06 2:29

Not Active

11-Dec-06 2:29

Maybe this will help http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnaspp/html/urlrewriting.asp[^]

only two letters away from being an asset

Re: Beautiful URLs

phimix11-Dec-06 2:59

phimix

11-Dec-06 2:59

Great, thanks. I'll definately take a look at that one.

Currently my attempt looks like this (no IHttpHandler stuff), it works, but there might be a best practice I don't know about...

<br />
    protected void Application_BeginRequest(Object sender, EventArgs e)<br />
    {<br />
        // Check if request contain virtual adress, so we should redirect<br />
        string requestPath = HttpContext.Current.Request.Path.ToLower();        <br />
        if (string.IsNullOrEmpty(requestPath) == false)<br />
        {<br />
            if (requestPath.Contains(".aspx") == false)<br />
            {<br />
                // Look up and see if this is an adress that should be redirected<br />
                int accountItemId = <Database Call><br />
                if (accountItemId > 0)<br />
                {<br />
                    string convertedPath = "Article?Id=" + accountItemId.ToString();<br />
                    HttpContext.Current.RewritePath(convertedPath);<br />
                }<br />
            }<br />
        }<br />
    }<br />

phi
Geek Load - Free Geek Stuff for Everybody OMG | :OMG:

How to use Link Grammer's open source to access WordNet Database

Soniya_k11-Dec-06 1:16

Soniya_k

11-Dec-06 1:16

Hello Friends.

I think this is one of the most innovative and challenging tasks I have ever encountered in my career.

I want to incorporate the Link Grammer open source project for the Open Source WordNet Dictionary.
Link Grammer:
http://bobo.link.cs.cmu.edu/link/index.html[^]

Wordnet:
http://wordnet.princeton.edu/[^]

The Link grammer project is available as a C code+ VC++ code + a API in C# as a console application.

Can anybody help me about this.

Thank You.

Export To CSV File

Suresh Pirsquare11-Dec-06 0:15

Suresh Pirsquare

11-Dec-06 0:15

I want to export data from a table(sql) to a CSV file, using asp.net.

Thanks in advance,

Suresh Dayma

Re: Export To CSV File

Vasudevan Deepak Kumar11-Dec-06 4:23

Vasudevan Deepak Kumar

11-Dec-06 4:23

After you get the data in dataset using Sql Adapters, you can check out this article http://www.codeproject.com/Purgatory/Exporting_Dataset_ASPNet.asp[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

Re: Export To CSV File

Suresh Pirsquare11-Dec-06 22:13

Suresh Pirsquare

11-Dec-06 22:13

Thanks for the Reply.

Regards,

Suresh Dayma

Everything Is Possible!

Sessions question

just3ala211-Dec-06 0:13

just3ala2

11-Dec-06 0:13

Dear all
i'm using a session variable in my application and it's workin fine for some time and if i leave the page for a while the session expires

what i need is to expire the session only when the user closes the browed
(i don't want to set the session timeout to a specific time duration)

how can i implement that?

Best Regards
3ala2 Smile | :)

Re: Sessions question

Guffa11-Dec-06 0:20

Guffa

11-Dec-06 0:20

Make the page request something periodically from the server, so that the session does not time out while the page is open. You can for example use a Javascript to request a small image at a certain interval.

You have to have a timeout on the session, or the server will fill up with old unused session objects.

---
b { font-weight: normal; }

Re: Sessions question

just3ala211-Dec-06 1:55

just3ala2

11-Dec-06 1:55

can u give me an example?
and i think that there is a default timeout for the sessions, right?
i mean why does it disapear after a while without using the page.

I'll try to do the refresh function and c what happens Smile | :)

Thanx for ur response

Best Regards
3ala2 Smile | :)

Re: Sessions question

Guffa11-Dec-06 2:42

Guffa

11-Dec-06 2:42

just3ala2 wrote:
i think that there is a default timeout for the sessions, right?

Yes. The default timeout is 20 minutes.

---
b { font-weight: normal; }

Re: Sessions question

Vasudevan Deepak Kumar11-Dec-06 4:24

Vasudevan Deepak Kumar

11-Dec-06 4:24

Default Timeout is 20 seconds.

You can have a hidden IFRAME with a page like pingserver.aspx which would have a META Httpequiv TAG to the server.

Or without IFRAMES, you can have a JavaScript Timer and send a AJAX request to the server.

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

Re: Sessions question

Suresh Pirsquare11-Dec-06 0:21

Suresh Pirsquare

11-Dec-06 0:21

Type the following code, in the logout(link) button event.

Session.Clear()
Response.Redirect("Login.aspx")

Regards,

Suresh Dayma

Everything Is Possible!

Passing variables from one application to other web application

Guru_yogi10-Dec-06 23:07

Guru_yogi

10-Dec-06 23:07

HI..
Suppose I have two application A and B. I want to redirect from one page of application A to one page of application B along with some variables. how can I do this?.. plz help me..

Gurudatta B. Shelke

Re: Passing variables from one application to other web application

IamMohan10-Dec-06 23:45

IamMohan

10-Dec-06 23:45

You can pass a value in form a Query string to other application like,

You can place the value inside the session from one application to the other application,This solution will be workable only if these two apps share a common session, means same server Smile | :)

If this two application is in different server then try this,

http://ServerName/AliasName/FileName.aspx?name=value, just pass the value as a query string

Mohan

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