ASP.NET Discussion Boards

Have a look at the documentation of HttpContext.SkipAuthorization property.

- walter

thank you

Hi,
I m working on crystal report in asp.net 2005.
Page type is landscape of my report.
Problem i m facing is whatever i place at footer section,that data is shown correctly in report but when i take the print out then the footer information appear in new page.
I have already suppress all non required field.
Even if my data in report of two or three lines still the information on footer appear on next page.
I havent checked insert page before at footer but at Group Header1 i have set insert page before so that my report begin Group wise from new page.
Pls help me to find the solution
Thanks in advance....

Ajay

Try to remove extra spaces after the fileds.

Regards,
Sylvester G
Senior Software Engineer
Xoriant Solutions
sylvester_g_m@yahoo.com

Sir,
i have already suppressed unused sections and also compressed all fields as much as they can be.
The problem occurs whn i change my report page setup to landscape while taking hte printout from printpreivew option.Then page footer section create show that information in new page.
I've set my crystal report printer setup to landscape while creating the report but while printing it from internet explorer i have to convert page setup to landscape again.If i show print without changing page setup to landscape then it shows footer information at the end of same page but when i change it to landscape then footer information move to next page.
Pls see the problem...

Hello, there,

I'd like to know how I can change the rowState in GridView.

I want to set every row to the edit state when open the gridview control.

I made changes to rowCreated function of the grid view to change every datarow to the Edit state. But the it is not working at all.

The following are the code.
If (e.Row.RowType = DataControlRowType.DataRow) Then
e.Row.RowState = DataControlRowState.Edit
End If

Will you please tell me what I should do to make it happen?

Thank you so much in advance.

Haven't tried this but if you want your gridview to be in the edit state by default, why not use use template columns and textboxes for your itemtemplates?
sounds like a silly hack but...

acodeisacodeisacode

Hi all! I'm not able to get connected to Sql server 2005 from ASP.net 2.0 application which is HTTP based. When I run the code I get these errors

Login failed for user 'NIT\ASPNET'. (where NIT is system name)<br />
<br />
'con.ServerVersion' threw an exception of type 'System.InvalidOperationException'<br />
<br />
This is my connection string.<br />
<add key="strCon" value="Data source=localhost;Initial catalog=Anything;uid=;pwd=;Integrated security =SSPI;"/>

I've tried everthing in book, Like Trusted_connection = true also but to no avail.Problem is my another application which is File based running on a random port number assigned by ASP.net runs smoothly. After googling I could not come with something worthwhile.

Pls help

Thanks in advance.

Don't Quit

Has the ASPNET account permitted to access your SQL Server? And it is set up as a user on the database you want to use?

Upcoming events:
* Glasgow: Geek Dinner (5th March)
* Edinburgh: Web Security Conference Day for Windows Developers (12th April)

My: Website | Blog | Photos

Hi Colin! Thanks for reply.
As I told you another asp.net application can access the sql server.

Colin Angus Mackay wrote:
Has the ASPNET account permitted to access your SQL Server? And it is set up as a user on the database you want to use?

How to give permission to ASPnet account I dont know Pls tell me.

Thanks in advance.

Don't Quit

hi colin!
I've done this through

sp_grantlogin 'NIT\ASPNET'
grant insert on dbo.categories to [NIT\ASPNET]

but it created more questions than answers
1. serverversion is still there which can be seen while debugging ?

2. How to give persmission to this user for whole database in one go?

3. Earlier I've used insert queries in similar fashion but why it is asking for permission now.

Can you point me to a good link to find all the things I know about sql authentication and windows but all these things are somewhat new for me.

Thanks

Don't Quit

Nitin1981 wrote:
2. How to give persmission to this user for whole database in one go?

Add the user to the server role db_owner - it will then own the database and can do anything with it. NOTE: This is a security risk and should not be done on a live system.

There is another role, sysadmin, that gives a user access to all the databases on the server.

Nitin1981 wrote:
3. Earlier I've used insert queries in similar fashion but why it is asking for permission now.

There must be some difference between the previous connection and this one. SQL Server will not randomly deny access to things.

Nitin1981 wrote:
Can you point me to a good link to find all the things I know about sql authentication and windows but all these things are somewhat new for me.

SQL Server Books On-Line - i.e. the Help file that comes with SQL server is the best resource.

Upcoming events:
* Glasgow: Geek Dinner (5th March)
* Edinburgh: Web Security Conference Day for Windows Developers (12th April)

My: Website | Blog | Photos

Hi,
I have this problem with a gridview from which I am tryng to update a database table. I have this handler for my Row_Updating event:

Dim index As Integer = gvRecruit.EditIndex
Dim row As GridViewRow = gvRecruit.Rows(index)
Dim Id as Integer = Integer.Parse(row.Cells(0).Text)
Dim fName As TextBox = CType(row.FindControl("txtFirstName"), TextBox)
Dim firstName As String = fName.Text
Dim lName As TextBox = CType(row.Cells(1).Controls(1), TextBox)
Dim lastName As String = lName.Text
etc...
Problem is, when I step thru the code, the fName and lName still hold the old values, even though I have updated them with new ones.
I think I am missing something. Can anybody help?

PS
I don't really do VB, but I don't think that is an issue here.

acodeisacodeisacode

Hi Dear,

How to connect MS Access database using ASP.net

regards
adil

Hello Adil,
you can use OleDbConnection, for e.g
using System.Data.OleDb;
//...
//...
//...
OledbConnection conn = new OleDbConnection("your connection string here");
//...

but maybe you should be more specific. what exactly do you want to do with the data? bind to a grid?...
Also, what version of Asp.Net

acodeisacodeisacode

hi dear
I was trying to use following code ..but it is not working properly.

Imports System.Data.OleDb
Public Class Form1 Inherits System.Windows.Forms.Form
Dim cn As OleDbConnection
Dim cmd As OleDbCommand
Dim dr As OleDbDataReader
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e as _
System.EventArgs) Handles MyBase.Load
End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As_
System.EventArgs) Handles Button1.Click
Try
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;_
Data Source=C:\emp.mdb;")
'provider to be used when working with access database
cn.Open()
cmd = New OleDbCommand("select * from table1", cn)
dr = cmd.ExecuteReader
While dr.Read()
TextBox1.Text = dr(0)
TextBox2.Text = dr(1)
TextBox3.Text = dr(2)
' loading data into TextBoxes by column index
End While
Catch
End Try
dr.Close()
cn.Close()
End Sub
End Class

regards
adil

Standard question #1:
What do you mean by "not working"?

Standard question #2:
What error message do you get?

---
single minded; short sighted; long gone;

Hi Adil,
You said something about ASP.Net but it looks like it is a windows form you are dealing with. Anyhow, it doesn't matter.
What you can do is put a breakpoint in your code for the Button click event

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As_
System.EventArgs) Handles Button1.Click

then step though the code and find out where it breaks. This would give us info enough to help you.
Meanwhile, i expect that the database has a table, Table1 with at least 3 fields that are all of Text type (?).
(gain maybe it would help for you to go with:
TextBox1.Text = dr(0).ToString().....etc

acodeisacodeisacode

Hi all,

I am using a datagrid to display employee information such as Name,grade,dept,expertise... My problem is that the expertise column goes on expanding and the text wraps and everything`s spoiled.I want that if the length of the column increase the extra information be shown by using onmouseover on that cell of datagrid. How do i dothis in itemcreated event of datagrid

1.Use template column for particular field
<asp:TemplateColumn HeaderText="Office Location">
<ItemTemplate>
<div class="divstyleNormal"><%#DataBinder.Eval(Container.DataItem , "Location")%></div>
</ItemTemplate>
</asp:TemplateColumn>

CSS refered for the above is

.divstyleNormal
{
overflow: hidden;
width: 175px;
}

This way you can cut the text, and while binding(ItemDataBound) you can set the tool tip

Regards,
Sylvester G
Senior Software Engineer
Xoriant Solutions
sylvester_g_m@yahoo.com

Please need help on building a web search engine with c#.net got some note but haven't read them yet. want to get much idea so i can work and sort them out offline .

shawn414

shawn414 wrote:
Please need help on building a web search engine with c#.net got some note but haven't read them yet. want to get much idea so i can work and sort them out offline .

This is such a vague question I don't know where to start. What, specifically, are you stuck with? Database design? Database interaction? internet protocols? Parsing of web pages? and so on...

Upcoming events:
* Glasgow: Geek Dinner (5th March)
* Edinburgh: Web Security Conference Day for Windows Developers (12th April)

My: Website | Blog | Photos

there are good articles in the articles on this site that will assist you.
do a search for web spiders in the articles.

but as angus says there is alot of detail you need to consider, and as exactly what do you mean by search engine? are you looking to incorporate a full text search on your web site? search engine can mean so many things in this world!

Kind Regards,
Gary

My Website || My Blog || My Articles

I'm having a problem with this peice of code and for the life of me I cant figure out why. If I run it as a C# application on my computer it will send an email to the testaddress@gmail.com containing the text "HI!" ... When I copy this code into my Asp.Net applictation and run it on the server I get the error shown below the code... The server version is also shown. Any ideas would be very welcome as I've been trying to make this work for several hours now!

<br />
    protected void Button1_Click(object sender, EventArgs e)<br />
    {<br />
        MailMessage message = new MailMessage("mailer@testdomain.com", "testaddress@gmail.com", "feedback", "HI!");<br />
        SmtpClient mailClient = new SmtpClient("mail.testdomain.com");<br />
<br />
        mailClient.Port = 25;<br />
        mailClient.UseDefaultCredentials = false;<br />
        mailClient.Credentials = new NetworkCredential("mailer@testdomain.com", "test");<br />
        mailClient.DeliveryMethod = SmtpDeliveryMethod.Network;<br />
<br />
        mailClient.Send(message);<br />
        <br />
<br />
<br />
        message.Dispose();<br />
    }<br />

Server Error in '/' Application.<br />
--------------------------------------------------------------------------------<br />
<br />
The SMTP server requires a secure connection or the client was not authenticated. The server response was: PLESK.home ESMTP MailEnable Service, Version: 1.95-- denied access at 02/18/07 02:02:23 <br />
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. <br />
<br />
Exception Details: System.Net.Mail.SmtpException: The SMTP server requires a secure connection or the client was not authenticated. The server response was: PLESK.home ESMTP MailEnable Service, Version: 1.95-- denied access at 02/18/07 02:02:23<br />
<br />
Source Error: <br />
<br />
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.  <br />
<br />
Stack Trace: <br />
<br />
<br />
[SmtpException: The SMTP server requires a secure connection or the client was not authenticated. The server response was: PLESK.home ESMTP MailEnable Service, Version: 1.95-- denied access at 02/18/07 02:02:23]<br />
   System.Net.Mail.SmtpConnection.GetConnection(String host, Int32 port) +819256<br />
   System.Net.Mail.SmtpTransport.GetConnection(String host, Int32 port) +316<br />
   System.Net.Mail.SmtpClient.GetConnection() +42<br />
   System.Net.Mail.SmtpClient.Send(MailMessage message) +2004<br />
   Email.Button1_Click(Object sender, EventArgs e) +153<br />
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105<br />
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107<br />
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7<br />
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11<br />
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33<br />
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102<br />
<br />
 <br />
<br />
<br />
--------------------------------------------------------------------------------<br />
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210

Thank you in advance,

Curt

hetrobezz wrote:
The SMTP server requires a secure connection or the client was not authenticated.

I think you'll find your answer in there.