ASP.NET

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