Question about MySql Database in C# - ASP.NET Discussion Boards

shabya21-Mar-09 3:30

21-Mar-09 3:30

no , haven't.
at the web configutation it stands on 'Use visual studio development server'

now i changed it to 'Use IIS web server'

how do i activate a virual IIS web server ?

start-> programs-> ... ?

i have it installed using the windows components add/remove but cant seem to find it

tnx

Re: My first published ASP.NET project

vinodkrebc21-Mar-09 3:14

vinodkrebc

21-Mar-09 3:14

Hi,

Have You created a virtual directory of that Web site

If you have created the virtual directory then I think this should not come

Re: My first published ASP.NET project

Yusuf21-Mar-09 4:22

Yusuf

21-Mar-09 4:22

shabya wrote:
in order to jump to the cold water of asp i need a push.

sorry, I'm not pushing you to cold water. Try warm water instead. Wink | ;)

Look, tell us the steps you took to build and publish your asp.net project. Something is not right.

Yusuf

Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]

Re: My first published ASP.NET project

tech60321-Mar-09 6:29

tech603

21-Mar-09 6:29

This link will help you with setting up a virtual server in IIS.

http://www.hostmysite.com/support/dedicated/IIS/virtualdirectory/[^]

Here is another link that has some more useful IIS tips

http://www.hostmysite.com/support/dedicated/iis/[^]

Hope that helps

Matthew Vass
QA Analyst
mvass@hostmysite.com
HostMySite.com

how to attach aspx pages to master page

naveen attri20-Mar-09 20:16

naveen attri

20-Mar-09 20:16

hi
i m using master page.In my application aspx pages are generated dynamically. is it possibile to attach them to my master page
programatically.

In my code i m doing

respponse.redirect("url");

i want this page add to my master page

Re: how to attach aspx pages to master page

Abhijit Jana21-Mar-09 1:34

Abhijit Jana

21-Mar-09 1:34

Did you tried to give the master page name while generating the aspx page, like this.MasterPageFile = filename; . And make sure about contentPlaceHolderID in content page also.

cheers,
Abhijit
CodeProject MVP

Re: how to attach aspx pages to master page

Gaurav Mahajan21-Mar-09 1:55

Gaurav Mahajan

21-Mar-09 1:55

Hi
Yes it is possible to attach MasterPage of your own choice in ASP.Net 2.0 or later.

You just has to set Page.MasterPageFile property in Page's PreInit Event.

Code
VB
<%@ Page Language="VB" %>
<script runat="server">
Protected Sub Page_PreInit(ByVal sender As Object, ByVal e As System.EventArgs)
Page.MasterPageFile = "~/MyMasterPage.master"
End Sub
</script>
C#
<%@ Page Language="C#" %>
<script runat="server">
protected void Page_PreInit(object sender, EventArgs e)
{
Page.MasterPageFile = "~/MyMasterPage.master";
}
</script>

Remeber Page's PREINIT Event only.

Precautions:

There must present same contentplaceholders, as in MasterPage you want to attach dynamically.
All content palceholders Ids must match with MasterPage you are binding at runtime.

Hope it will clear the concept.

To see video tutorial for the same provided my microsoft then visit: http://www.asp.net/learn/videos/video-265.aspx[^]

From:

Gaurav Mahajan [Website: www.sushilindia.com]

Senior Website Developer and Computer Lecturer
Ga

Question about MySql Database in C#

Deepak the Cool20-Mar-09 20:09

Deepak the Cool

20-Mar-09 20:09

Hi All,

I am using MYSql DB for backend.I have fullfill all the requirment e.g. Dot Net Connector for MYSQL etc.

Now in my application I have seen a different type of bug. One of my project I create a class clsLogin and has a following method

public int AuthenticateUser(boclsLogin objboclsLogin)
{
int inRes = 0;
using (MySqlConnection mySqlCon = new MySqlConnection(ConfigurationManager.ConnectionStrings["MySqlCon"].ConnectionString.ToString()))
{
string strSQL = "select count(vcUSerId) from Login " +
" where vcUserId=@UserId ";
" and vcPassword=@Password" +
" and vcUserType=@UserType";
MySqlCommand _cmd = new MySqlCommand(strSQL, mySqlCon);
_cmd.Parameters.Add("@UserId", MySqlDbType.VarChar).Value = objboclsLogin.UserId;
_cmd.Parameters.Add("@Password", MySqlDbType.VarChar).Value = objboclsLogin.Password;
_cmd.Parameters.Add("@UserType", MySqlDbType.VarChar).Value = objboclsLogin.UserType;
if (mySqlCon.State == ConnectionState.Closed)
mySqlCon.Open();
inRes = Convert.ToInt32(_cmd.ExecuteScalar());
mySqlCon.Close();
}
return inRes;

}

the above method in native application works fine.But I have need the same class into a another project then i just copy paste the class File into my 2nd application it is return me a 0(scalar value).

But when i pass the hardcoded value into my query then it'll return me the 1.

So i am very phatectic,How I solve this anyone give me idea.

thanks in advance

Deepak

Smile a Lots,Its Costs Nothing

Re: Question about MySql Database in C#

Gaurav Mahajan21-Mar-09 3:10

Gaurav Mahajan

21-Mar-09 3:10

Hi
I do had problems with ExecuteScalar, So I suggest you just replace it with ExecuteReader and read value using DataReaderInstance(0) in vb.net DataReaderInstance[0] in C#.

Or if you are using .Net 3.5 version use LINQ to read data from database instead.

Hope this will solve your problem.

Gaurav Mahajan [website www.sushilindia.com], Amritsar
Website Developer and Computer Lecturer.

How to change the address in the address bar from a windows application

Nekkantidivya20-Mar-09 19:52

Nekkantidivya

20-Mar-09 19:52

Hi,

I am working on a windows application in this when I click "GO to" button I have to check the browser window where my website is opened and in that I have to change the address in the address bar to another address.

or

I have to change the address in the current active browser window to the new address which will fixed by me.

Please send me reply if you know reply for any one of the above two.

Thank you.

Re: How to change the address in the address bar from a windows application

venu65620-Mar-09 21:16

venu656

20-Mar-09 21:16

hi,
let me know u want ur website in the exisiting c# application?if so use web browser control.
webbrowser1.navigate("google.com");
try this

cheers
venu gopal reddy

Re: How to change the address in the address bar from a windows application

Yusuf21-Mar-09 4:37

Yusuf

21-Mar-09 4:37

venu656 wrote:
know u want ur

It very nice of you trying to help out. Thumbs Up | :thumbsup:

Please to try to avoid txtspk.
thanks

Re: How to change the address in the address bar from a windows application

Yusuf21-Mar-09 4:26

Yusuf

21-Mar-09 4:26

Nekkantidivya wrote:
windows application in this when I click "GO to" button

There is no GO button on windows application? are you takling about web application?

Nekkantidivya wrote:
I have to check the browser window where my website is opened and in that I have to change the address in the address bar to another address.

Why do you want to do this? You can not change the address but you can spoof it. One way is to host your page on Frames.

Event of Dynamic Control

shoyebaziz12320-Mar-09 19:47

shoyebaziz123

20-Mar-09 19:47

Hi All,
i have created dynamic button and adding them to the panel, when i click the button it refresh and buttons are vanish, i want to handle event of button to show value in textbox

Re: Event of Dynamic Control

N a v a n e e t h20-Mar-09 19:53

N a v a n e e t h

20-Mar-09 19:53

You have absolutely no idea about how ASP.NET events and dynamic controls works. ASP.NET will not maintain viewstate for the dynamic controls if it is created after the viewstate events. Please read about viewstates and ASP.NET page lifecycles.

Smile | :)

Navaneeth

How to use google | Ask smart questions

Re: Event of Dynamic Control

Gaurav Mahajan21-Mar-09 2:14

Gaurav Mahajan

21-Mar-09 2:14

Hi

Hope you know how to attach Click event on dynamic control. Just do it by

Button1.Clcik+=new EventHandler(MethodName);

But dynanic controls are refreshed during page refresh/postback.

To learn how to handle dynamic controls just see: http://www.aspsnippets.com/post/2009/03/01/Dynamic-Controls-Made-Easy-ASPNet.aspx[^]

Or help from Microsoft via Video Tutorial:
http://www.asp.net/Learn/ajax-videos/video-286.aspx[^]

From: Gaurav Mahajan [www.sushilindia.com] Website Developer at Amritsar and Computer Lecturer.

Re: Event of Dynamic Control

Abhijit Jana21-Mar-09 2:16

Abhijit Jana

21-Mar-09 2:16

shoyebaziz123 wrote:
when i click the button it refresh and buttons are vanish,

Please read Dynamic Web Controls, Postbacks, and View State [^] this article.

cheers,
Abhijit
CodeProject MVP

Ajax

Bhim Prakash Singh20-Mar-09 19:14

Bhim Prakash Singh

20-Mar-09 19:14

i am developing a web app and i wud like to use AJAX . I am receving one other page and dispaly on my page but other page events does not work here.

Plz help.

Re: Ajax

Abhijit Jana21-Mar-09 1:42

Abhijit Jana

21-Mar-09 1:42

prakash_adysoft wrote:
I am receving one other page and dispaly on my page but other page events does not work here.

I didn't understand you problem. Confused | :confused:

can you please explain it clearly?

prakash_adysoft wrote:
i am developing a web app and i wud like to use AJAX

If you are new in AJAX, please start with AJAX in W3School[^]

cheers,
Abhijit
CodeProject MVP

AJAX controls for asp.net2.0

Subin Alex20-Mar-09 19:04

Subin Alex

20-Mar-09 19:04

i am developing a web app and i wud like to use AJAX "Adrotator control" for both images and swf files, Where cud i find these controls for free.
Plz help.

Re: AJAX controls for asp.net2.0

N a v a n e e t h20-Mar-09 19:11

N a v a n e e t h

20-Mar-09 19:11

Subin Alex wrote:
AJAX "Adrotator control"

Adrotator is not part of AJAX framework, right? Here[^] is a KB article which explains how to use it.

Smile | :)

Navaneeth

How to use google | Ask smart questions

Re: AJAX controls for asp.net2.0

Subin Alex20-Mar-09 20:24

Subin Alex

20-Mar-09 20:24

but i saw the AJAX controls for asp.net2.0 with "update panel control" suporting the Adrotator cntrol.

Best way to repopulate cache item once it expires without using the CacheItemRemoveCallback delegate.

Steve Holdorf20-Mar-09 7:53

Steve Holdorf

20-Mar-09 7:53

I am trying to design a CacheManager class that will automatically repopulate the cache item once the dependency changes or when it timesout without using the CacheItemRemoveCallback delegate. If anyone has developed anything similar to this and has some ideas please share them with me.

Thanks,

Steve

Re: Best way to repopulate cache item once it expires without using the CacheItemRemoveCallback delegate.

ToddHileHoffer20-Mar-09 9:53

ToddHileHoffer

20-Mar-09 9:53

As with Session, Application, and app.config values why not just create static class such as CachedItems and do something like this?

For example, why not just do something like this?

<br />
public static class CachedItems<br />
{<br />
<br />
 /// <summary><br />
    /// Retruns the next 8:00 AM when the data should be new<br />
    /// </summary><br />
    private static DateTime cacheExpirationDateTime<br />
    {<br />
        get<br />
        {<br />
            if (DateTime.Now.Hour < 8)<br />
                return DateTime.Today.AddHours(8);<br />
            else<br />
                return DateTime.Today.AddDays(1).AddHours(8);<br />
        }<br />
    }<br />
<br />
    public static YourType YourObject<br />
    {<br />
        get<br />
        {<br />
            Object x  = System.Web.HttpContext.Current.Cache["YourObject"]<br />
            if (x == null)<br />
                System.Web.HttpContext.Current.Cache.Add("YourObject", getYourObjectMethod(), null, cacheExpirationDateTime, Cache.NoSlidingExpiration, CacheItemPriority.AboveNormal, null);<br />
<br />
            return (YourType)x;<br />
        }<br />
    }<br />
<br />
}

I didn't get any requirements for the signature

Re: Best way to repopulate cache item once it expires without using the CacheItemRemoveCallback delegate.

N a v a n e e t h20-Mar-09 18:44

N a v a n e e t h

20-Mar-09 18:44

Steve Holdorf wrote:
or when it timesout

Why do you want to refill the cache when it time out? It will make the timing out mechanism kinda pointless.

Navaneeth

How to use google | Ask smart questions

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