Import data from Excel to SQL 2005 on a Win 7 32 bit platform.

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.

In my previous articles I talked about exporting GridView to excel. Although most of the time you will be exporting the content displayed on the screen but sometimes it might not be the case. In this article I will demonstrate how to export a DataSet to excel.

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

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

 

Hi,

      I'm trying to export a dataset to excel directly. I'm repeating, it's a dataset to excel (NOT DATA GRID OR GRID VIEW TO EXCEL). The problem I face is formatting. I'm exporting the excel which has aroung 13 columns.

    A column should be in dd/MM/yyyy 00:00:00 format. Time will always be 00:00:00. It is exporting in correct format only, but for example when the date is Jan 05, 2010, when it comes from database it shows correct format as 05/01/2010 00:00:00. When it binds, it binds as 5/1/2010 00:00 which is not suppose to happen.

 And the other problem is with the decimal formatting. I need 2 decimal places at the last. In c# code, I'm converting to decimal with 2 decimal places, but when it binds, it won't happen. I tried inserting a ' (colon) before the text is entered, but the cell is not converted into a text field

   Can anyone give me a solution for this?

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

 

My page has ListView with SqlDataSource. I set SqlDataSource as DataSet and EnableCaching = True.

BEFORE I filter SqlDataSource, I don't have problem to get the record value for selected record data in my ListView.

AFTER I filter SqlDataSource, my ListView can display the filter record data properly, but I have problem to get the record value for selected record data in my ListView. The record value for selected record data does not refer to the record value what I am selecting.

Please advise this problem. SqlDataSource must be set as DataSet and EnableCaching = True for solving this problem.

Thanks.