Conversion failed when converting the varchar value ''null'' to data type int. ERROR Please help!

In ASP.NET 1.X and ASP.NET 2.0 DataList was the primary control used to display data in groups. In ASP.NET 3.5 we have a new control that takes care of grouping data. In this article we are going to demonstrate how to group data using the ListView control.

Many times you want to select multiple columns in a DataGrid and highlight the columns selected.

In the DataGrid MouseDown Event you will find out if you have selected a column header through the hit test. You then find the co-ordinate of the column and construct a rectangle out of that. If you are selecting multiple columns you can store the index of the columns and the rectangle in ArrayList.

Make sure you clear the ArrayList when you HitType is None.

Hi,

I would want to know what is better: to keep a lot of data in cache at once or to keep a little data by paging?

 

For example:

I have 1000 articles and 200 pages.

 Hi, I have window form to let user fill data, I want to alert user if close web browser before saved web form data, could anyone provide any clue?

 

Thanks,

Martin

I'm trying to figure out how I can get around an error I get when multiple users are accessing different my site. I'm getting an error:

there is already an open datareader associated with this connection which must be closed first

It's not the same query everytime but I recently triggered it on this statement:

Dim adapterSavedState As New SQLDataAdapter("SELECT SavedStateContactView, SavedStatePropertyView, SavedStateTransView, SavedStateCompanyView FROM WebusersProfiles WHERE ContactID = '" & Session("ContactID") & "'", myConnection)
    Dim dtSavedState As New DataTable()
    adapterSavedState.Fill(dtSavedState)
         Dim rowSavedState As DataRow
         For Each rowSavedState In dtSavedState.Rows
             If Request.QueryString("View") = "Contact" Then
                SavedState = rowSavedState("SavedStateContactView").ToString()
            Else If Request.QueryString("View") = "Property" Then
                SavedState = rowSavedState("SavedStatePropertyView").ToString()
            Else If Request.QueryString("View") = "Trans" Then
                SavedState = rowSavedState("SavedStateTransView").ToString()
            Else If Request.QueryString("View") = "Company" Then
                SavedState = rowSavedState("SavedStateCompanyView").ToString()
            End If
         Next rowSavedState

I define my connection in my basepage

    Public Dim MyConnection As SqlConnection
    Public Shared Dim strSite As String = "dev"
        
    Protected Overrides Sub OnLoad(ByVal e As System.EventArgs)
        myConnection = New SqlConnection("server=xxxx;database=xxxxx;User ID=xxxxx;Password=xxxxx;")

Where is my issue and how can I overcome it? This is a .net 1.1 site so MARS I know is not available...

Hi all,

I have a SQL routine which builds me an entire XML file and returns it as a string. 
If I save the content of this file as sample.xml for instance, I am able to open it in IE or any other browser and the user can expand the nodes and see all the content he wishes.

I am trying to build a ASP.Net page which will display the content of a XML file in the same way (or similar) that the browsers do.

So far, I've been reading some posts and noticed I can use XmlDataSource control and its Data property to load the entire XML doc as a string. Now I am stuck how to display the contents. I found TreeView very confusing and not sure if DataGrid would be a alternative as well. I need to user to be able to open and expand the nodes.

Please someone point me to the right direction. What controls to use, etc... sample codes are the best ;-)

Thank you

 

I'm doing an application which has already contains a master page named Master.master. And all related web forms(Webpage) are running well. But I create another master page in same application named Profile.master for some other web form(Webpage). But this time some of the related pages are running a blank page and some are generating an error that is:-

is not allowed here because it does not extend class 'System.Web.UI.Page'.

please help me to rectify this error.

Vishal Purohit

Hi All,

i have a program in vb.net..i use the webrequest to post the data to another page (http://localpost/posReceived.aspx), and use the webResponse to get the back the response from the remote page.

When i run this program, it returned error "The remote server returned an error: (403) Forbidden.". I have no idea on this. Coz my aspx page and posReceived.aspx are placed in the same server and same directory. I supposed it should be worked without any security concerns.

Can anyone help me to solve it. Thanks a lot!

 

 

 

i grid view contain the following coloum

id    name         DateofBirth                  DateofJoining 

1       a            22-Aug-1980                      10-jan-2000

1       a            22-may-1980                      20-feb-2000

1       a            12-Feb-1980                      15-mar-2000

1       a            3-Aug-1980                      7-jan-2000

how to sort if we click   DateofBirth or Dateofjoining and not sort any where if we click(Id,Name)

i have created university timetable.

how to display data.??

days show in row wise and period showin column wise

aur every period have particular course..

gridview..detalview or any thing..??

plz reply urgent....

give complete steps