ASP.NET

Re: Cannot use a leading .. to exit above the top directory

13-Apr-09 3:21

can you give us the quick overview of folder hierarchy of you application ?

cheers,
Abhijit
CodeProject MVP

PleaseHelpCP13-Apr-09 3:53

PleaseHelpCP

13-Apr-09 3:53

Master page is in root directory.
.aspx page is in folder "A" which is in root. In .aspx page i am loading control(.ascx) which is in folder "B", which is again in root. I am using stylesheet which is also created in root.
To load control, i have written following lines: UC=(UserControl)Pa ge.LoadControl("../Try/TestPage.ascx");

daylight saving

248912813-Apr-09 2:37

2489128

13-Apr-09 2:37

Hi. I'm storing datetime data in DB in UTC format. now i want to display correct date with daylight saving. can any one help me in this regards?

Re: daylight saving

Yusuf13-Apr-09 14:09

Yusuf

13-Apr-09 14:09

2489128 wrote:
now i want to display correct date with daylight saving

Well, there are number of issues here. Do you want to show the server or client time?

Not all countries follow the same daylight saving starting and ending date see here for detail.[^]. Then you need to figure out where the user is located and apply the time difference from UTC and apply Daylight Saving appropriately.

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[^]

What's username and password should use to access http://localhost?

Shahdat Hosain13-Apr-09 2:32

Shahdat Hosain

13-Apr-09 2:32

I want to send mails from local host. At first I setup up IIS with SMTP server. After applying the command http://localhost by Run a authentication required window shown. But I don't no what username and password should use to access http://localhost.

shahdat

Re: What's username and password should use to access http://localhost?

Abhijit Jana13-Apr-09 2:49

Re: What's username and password should use to access http://localhost? [modified]

13-Apr-09 2:49

MD. SHAHDAT HOSAIN wrote:
But I don't no what username and password should use to access http://localhost.

This should be the your domain user id and password. If you do not want to receive this, you can change the authentication settings to anonymous.
Good luck !!

cheers,
Abhijit
CodeProject MVP

Shahdat Hosain13-Apr-09 3:08

Shahdat Hosain

13-Apr-09 3:08

Could you inform me how can I change the authentication setting to anonymous? Please help me.

Hurry, ha ha ha...! Boss I have completed authentication setting to anonymous just now. Thanks

shahdat

modified on Monday, April 13, 2009 9:19 AM

Re: What's username and password should use to access http://localhost?

Abhijit Jana13-Apr-09 3:20

I need webparts video examples

13-Apr-09 3:20

MD. SHAHDAT HOSAIN wrote:
Could you inform me how can I change the authentication setting to anonymous?

Yah Sure!
1. Open IIS [ Run > inetmgr ]
2. In Tree Explorer > Web Sites > Default Web Sites
3. Right Click > Directory Security > Edit > Check Enable "Anonymous Access Checkbox".

Note : This will be applicable to all of the Virtual Directory that are hosted inside the "default web sites". If you want to Virtual Directory Specific, rather than doing on Default web site, do the same changes on particular virtual directory.

Let me know if you have any issue,

Good Luck !!

cheers,
Abhijit
CodeProject MVP

md_azy13-Apr-09 2:30

md_azy

13-Apr-09 2:30

Hi
I need webparts video examples . can anyone send me the link for

webparts video examples .

thanks in advance.

Re: I need webparts video examples

Colin Angus Mackay13-Apr-09 3:10

*Developer Day Scotland - Free community conference Delegate Registration Open

13-Apr-09 3:10

The UK DPE Team did a bunch of videos on Webparts. You can find them here: http://www.microsoft.com/uk/msdn/screencasts/tags/ASP.NET/default.aspx[^]

Drop down list z-index

scar_face13-Apr-09 1:14

scar_face

13-Apr-09 1:14

hi,
I have a drop down list box and a menu bar above it. The menu bar produces drop down sub-menus on mouse over. But the Drop down list box is being displyed over the menu option. What can i do to display the sub-menus above drop down list. I am not able to get the z-index property for drop down list....

scarface

Re: Drop down list z-index

Abhishek Sur13-Apr-09 5:04

Abhishek Sur

13-Apr-09 5:04

well... this is the most common problem with IE 6. Dropdown always comes over divs. I think what you can do, is to create an IFrame below the div a floating one, or an IFrame just below the dropdown, and then above the IFrame place the menu.

Iframe comes over selects always. Rose | [Rose]

Abhishek Sur

My Latest Articles
Basics on LINQ and Lambda Expressions

Create .NET Templates

insert in sql

ptvce12-Apr-09 23:52

12-Apr-09 23:52

i have 2 table in different database and different server, i want select records from one server(e.x. 100 records) and insert them to other table in the other server. do any body know how is my query?
i dont want use for and insert the records one by one,

Abhijit Jana12-Apr-09 23:58

12-Apr-09 23:58

ptvce wrote:
i have 2 table in different database and different server, i want select records from one server(e.x. 100 records) and insert them to other table in the other server. do any body know how is my query?

Does it any thing related with ASP.NET? Smile | :)

Any way, you can check this link,
Check

cheers,
Abhijit
CodeProject MVP

ptvce13-Apr-09 0:02

13-Apr-09 0:02

yes, its in C#.net
/////
public static SqlConnection connCommDB = new SqlConnection("Data Source=SADAFIT-9D6E926;Initial Catalog=ReservationSynchorizer;Integrated Security=True;");

SqlCommand cmd = new SqlCommand();
SqlDataAdapter da = new SqlDataAdapter();

cmd.CommandType = CommandType.Text;
cmd.CommandText = "?????"

cmd.Connection = conn;
conn.Open();
da.SelectCommand = cmd;
da.Fill(ds);
conn.Close();

Colin Angus Mackay13-Apr-09 0:34

*Developer Day Scotland - Free community conference Delegate Registration Open

13-Apr-09 0:34

ptvce wrote:
yes, its in C#.net

ASP.NET is a framework dealing with web applications. It has nothing to do with database access. ADO.NET is the part of the .NET Framework that deals with database access.

If you are wanting to INSERT data using SQL, then don't use a SqlDataAdapter unless it is directly related to the source of the data, which in this case it isn't. In fact, I wouldn't use data adapters at all.

The command Text should probably look something like this:

INSERT INTO myTable (column1, column2, column3) VALUES(@column1, @column2, @column3)

Replacing myTable, columnX and @columnX with the approproate table name, column names, and parameter names.

You will also have to create parameters to put the data that you want to insert into the query.

cmd.Parameters.AddWithValue("@column1", myValue);

When you are done, use cmd.ExecuteNonQuery() rather than with a DataAdapters. You can't fill anything with an INSERT statement. Only SELECT.

pra.chaudhari13-Apr-09 0:33

pra.chaudhari

13-Apr-09 0:33

try this

INSERT INTO database..tablename (columnname)
(SELECT top 100 columnname FROM database..tablename)

Colin Angus Mackay13-Apr-09 0:35

*Developer Day Scotland - Free community conference Delegate Registration Open

13-Apr-09 0:35

You can do it all in SQL, but remember to link the servers together too. The source and destination are on different servers.

ptvce13-Apr-09 0:55

13-Apr-09 0:55

yes i can not do that

Colin Angus Mackay13-Apr-09 1:11

*Developer Day Scotland - Free community conference Delegate Registration Open

13-Apr-09 1:11

Why not? What is stopping that solution? It would be the most efficient if it works.

ptvce13-Apr-09 1:36

13-Apr-09 1:36

because insert is onse server and select is from the other server
how i define them?

Colin Angus Mackay13-Apr-09 1:44

*Developer Day Scotland - Free community conference Delegate Registration Open

13-Apr-09 1:44

A fully qualified table name is as follows:
[server].[database].[schema].[table]

Normally you omit the bits that can be inferred. e.g. if you are in a specific database and the table is in the same database you don't have to specify anything other than the table.

So: SELECT * FROM DB-SRV1.Sales.dbo.Order

You will have to link the SQL Servers together first otherwise it won't know where to find the other server.

Linking Servers[^] (MSDN)

Session Active Problem

pra.chaudhari12-Apr-09 23:44

pra.chaudhari

12-Apr-09 23:44

hi

in asp.net application one user is login then how many active session is created i am confused about that because iis performance
moniter active session display 612 and my login user is only more than 50. also when i particuler user logout that time session active in not not decrease.

thank you advance
urgent please

Re: Session Active Problem

Abhijit Jana12-Apr-09 23:54