ASP.NET

31-Jan-07 19:59

hi,
i have a dropdownlist.in this ddl i want to place the grid how is it possible?here i want to perform all the operations that can be performed on normal grid i.e., outside the the ddl.

now i want to perform the operations on the grid which is inside the ddl

Re: ddl with grid

www.Developerof.NET31-Jan-07 20:14

www.Developerof.NET

31-Jan-07 20:14

You must be kidding, why do u want 2 display grid in a dropdown.Do u have more than 1 grid in d DDL?.Try using a button and make the grid visible -invisible alternatively.

Re: ddl with grid

praveenanand31-Jan-07 20:25

where I must(should) use Forms authentication

31-Jan-07 20:25

iam ordered by my boss to do so.....
i have to make it.hepl me

indian14331-Jan-07 19:52

31-Jan-07 19:52

Hi all,
Can abybody please tell me answer for one question that is, do I need to use Forms Authentication for all Asp.Net applications that are running on Internet, or For only those applications that need high security.
And can I use the normal Windows authentication for the ASP.Net applications which doesnt need much security. I am little bit confused about it. Will the Windows authentication works if I put in an Asp.Net application which is running on the Internet. And is it right that, Windows authentication works only with the applications which are running on local intranet only.

Could you please give me some scenarios where I must(should) use Forms authentication. Thank you.

Regards,

S/W Engineer
Akebono Soft Technologies
aleem_abdul@akebonosoft.com.

Siva Rama Raju31-Jan-07 20:32

Siva Rama Raju

31-Jan-07 20:32

Hi,

By default Asp.Net applications uses Windows authentication
It is not necessary to use Forms Authentication for all Asp.Net applications

Forms Authentication is a system in which unauthenticated requests are redirected to a Web form where users are required to provide their credentials. Upon submitting the form, and being properly verified by your application, an authorization ticket is issued by your Web application in the form of a cookie. This authorization cookie contains the user's credentials or a key for reacquiring the user's identity (e.g. therefore making the identity persistent). In essence, Forms Authentication is a means for wrapping your Web application around your own login user interface and verification processes.

indian14331-Jan-07 20:57

31-Jan-07 20:57

Thank you Sir,
By your mean that, I can use "Windows" authentication too for the Web applications which are even run on Internet too, and it has no relation. And they need not be(not compulsory) running on intranet.
And "Forms" authentication is for the applications which have to have security system embedded within the application itself. Is it right?. Please tell me. Thank you.

Regards,

S/W Engineer
Akebono Soft Technologies
aleem_abdul@akebonosoft.com.

Pete O'Hanlon1-Feb-07 9:18

Pete O'Hanlon

1-Feb-07 9:18

OK - I'm going to weigh in here and say "Excellent posts". 10 out of 10 for the way you are handling this one. It shows research and a desire to understand further - and that's all we were asking.

Anyway, you use Forms authentication for custom authentication and Windows authentication to authenticate users using Windows authentication. I don't mean to make it sound like a cop-out, but the name says what they are. What the name doesn't show is why you would use it.

In an Intranet you will be authenticating the users on a company network, where you have access to the domain login information. Using this ASP.NET can get the login details from the domain directly. In this scenario, you would use Windows authentication.

Forms authentication relates to when you are operating beyond the use of domains, say on an internet site or where the login should be handled in a none-standard fashion. In this case, you need to handle the authentication yourself. This is where you use Forms authentication.

the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer

Deja View - the feeling that you've seen this post before.

indian1431-Feb-07 17:51

1-Feb-07 17:51

Dear Pete,
Thank you for your patience reply. But, can you please tell me, cant I use the windows authentication for the site which runs on the Internet if I wanna do it. Should I complesoury go for the Forms authentiation only, for the site which runs on the Internet. Please tell me patiencely, dont mind. Thank you.

Regards,

S/W Engineer
Akebono Soft Technologies
aleem_abdul@akebonosoft.com.

Pete O'Hanlon1-Feb-07 22:23

Pete O'Hanlon

1-Feb-07 22:23

The thing about Windows authentication is that you must be able to authenticate within a domain that you can see. In other words, you can't get login information from somebody else's network. This means that you must rely on Forms authentication if you want somebody to log in to your site on the internet. Of course, if you don't want any security, i.e. your pages are open to everybody, then it doesn't matter what authentication mode you have because you aren't going to be restricting pages.

I hope that this makes sense.

indian1431-Feb-07 22:37

Re: sql connection string

1-Feb-07 22:37

Yeah its great and more than sufficient. Thank you, very much.

Regards,

S/W Engineer
Akebono Soft Technologies
aleem_abdul@akebonosoft.com.

sql connection string

niki_nilu31-Jan-07 19:52

niki_nilu

31-Jan-07 19:52

pls send me sql connection string
i write this sql string =
SqlConnection conn = new SqlConnection("workstation id=TIPL2;packet size=4096;integrated security=SSPI;user id=gayatri;password=gayatri;persist security info=False;initial catalog=eSRS");

but when connection open that time i have error---
An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll

Additional information: System error.
pls solve this problem
thanku

Gayatri

varshavmane31-Jan-07 20:04

varshavmane

31-Jan-07 20:04

Try doing this:
In the Class define 2 variables SqldbCon and strConnection and write the function GetConnection to open the connection.Define this
<appSettings>
<add key="DbConnection" value="server=buddha;database=TMM;uid=TMM;pwd=TMM098" />
</appSettings>
in ur Web Config file.Fillowing is the way.

Dim SqldbCon As SqlConnection
Dim strConnection As String

Public Function GetConnection() As SqlConnection
strConnection = System.Configuration.ConfigurationManager.AppSettings.Item("DbConnection").ToString

If IsNothing(SqldbCon) Then

SqldbCon = New SqlConnection(strConnection)

End If

If SqldbCon.State = ConnectionState.Closed Or SqldbCon.State = ConnectionState.Broken Then
SqldbCon.Open()
End If

Return SqldbCon
End Function

Hope it will help u.

Re: sql connection string

varshavmane31-Jan-07 20:05

varshavmane

31-Jan-07 20:05

For closing connection you can use the following function

Public Function CloseConnection()
If IsNothing(SqldbCon) = False Then
If Not (SqldbCon.State = Data.ConnectionState.Closed) Then _
SqldbCon.Close()
SqldbCon = Nothing
End If
End Function

validation problem

niki_nilu31-Jan-07 19:45

niki_nilu

31-Jan-07 19:45

hi i want required filed validation on button control.
pls help me

Re: validation problem

Sylvester george31-Jan-07 19:50

Sylvester george

31-Jan-07 19:50

What do you mean?

Regards,
Sylvester G
Senior Software Engineer
Xoriant Solutions

How to generate Report in MS Word

Jay_se31-Jan-07 19:33

Jay_se

31-Jan-07 19:33

Hi,

I am using asp.net 2.0 and working with creating reports.

I have shown the Output (Report) in the web page using several GridView, Details view, etc. by binding with the database Sql Server.

I wish to SAVE the entire (report) page, how I am seeing the page actually in the page, as MS WORD (.doc) format. Because I wish to send this file as a attachment to the client.

Anyone can give me the clue for this? Thanks.

Regards,

Jay

Re: How to generate Report in MS Word

praveenanand31-Jan-07 20:21

Re: How to generate Report in MS Word

31-Jan-07 20:21

hi
use the code given below this will be usefull

protected void word_Click(object sender, EventArgs e)
{

//string attachment = "attachment; filename=f.xls";
SqlDataAdapter da = new SqlDataAdapter("select * from empdata", cn);
DataSet dsExport = new DataSet();
da.Fill(dsExport);

System.IO.StringWriter tw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw =
new System.Web.UI.HtmlTextWriter(tw);
DataGrid dgGrid = new DataGrid();
dgGrid.DataSource = dsExport;

// //Report Header
hw.WriteLine("" +
"Report for the Employee Information: " +
"");
//hw.WriteLine("
");
//// Response.AddHeader("emp info", attachment);

// // Get the HTML for the control.
dgGrid.HeaderStyle.Font.Bold = true;
dgGrid.DataBind();
dgGrid.RenderControl(hw);

// // Write the HTML back to the browser.
Response.ContentType = "application/msword";
this.EnableViewState = false;
Response.Write(tw.ToString());
Response.End();
}

praveenanand31-Jan-07 20:28