This isn't going to help with calling a funciton dependent upon the underlying data row.... Assuming you want to create a specific Javascript call for each row, dependent on (say) the row ID of the underlying dataview, you would do better to use a ButtonColumn: <asp:ButtonColumn ButtonType="LinkButton" CommandName="doesnt_matter" Text="whatever" /> and add your JavaScript fucntion in the page's head: function fname(r) { alert('You clicked row with ID# ' + r); } and bind this in the ItemDataBound event: If e.Item.ItemType = ListItemType.Item Or e.Item.ItemType = ListItemType.AlternatingItem Then Dim dr As DataRow = e.Item.DataItem.Row Dim js As String Dim btn As LinkButton = e.Item.Cells(X).Controls(0) ' replace "X" by the appropriate column index js = "fname(" & CStr(dr("ID")) & ")"; return false;" btn.Attributes.Add("onclick", js) End If NB the extra "return false" statement - this prevents the link-button from posting the entire form back to the server. btw, OP: re "It's very urgent." Please don't put this sort of thing in your posts. That is no-one's problem but yours.

It looks like you need something on the line of this article: DataCalendar[^] This should get you started!

Thanks friends, I have got it in another way. select * from [sheet1$] where LoginDate=#21/04/10# It's working fine. Thanks everyone. Regards, Dileep.

Thanks friends, I have got it in another way. select * from [sheet1$] where LoginDate=#21/04/10# It's working fine. Thanks everyone. Regards, Dileep.

You have to release resources used during the first phase of your code, which is saving file into physical space/directory. For example: fileObjectUsed.dispose(); OR FileUpload1.dispose(); I would recommend you not to store file into your web server location as this will add extra overhead of saving and deleting files and of-course security problem. You can directly store it(file) into database by converting it to bytes. Check out the link Storing Binary Data to Database using ASP.NET 2.0[^] Observe the code lines... Dim imageBytes(fileUpload1.PostedFile.InputStream.Length) As Byte fileUpload1.PostedFile.InputStream.Read(imageBytes, 0, imageBytes.Length) puranonnet@hotmail.com BCS Technology

may be u don't have excel providers installed try installing 2007 Office System Driver: Data Connectivity Components from below link http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en[^] They are used to install drivers on the machine not having excel installed on it. Tej Aj, http://opexsolution.com/forum/[^]

Try: ContentType = "application/vnd.xls"; Another thought to the issue, you using Office 2003 or 2007? Both have different extensions to excel files, might that be the reason!

use this function public static DataTable GetDataTableFromExcel(string SourceFilePath) { string ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + SourceFilePath + ";" + "Extended Properties=Excel 8.0;"; using (OleDbConnection cn = new OleDbConnection(ConnectionString)) { cn.Open(); DataTable dbSchema = cn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null); if (dbSchema == null || dbSchema.Rows.Count < 1) { throw new Exception("Error: Could not determine the name of the first worksheet."); } string WorkSheetName = dbSchema.Rows\[0\]\["TABLE\_NAME"\].ToString(); OleDbDataAdapter da = new OleDbDataAdapter("SELECT \* FROM \[" + WorkSheetName + "\]", cn); DataTable dt = new DataTable(WorkSheetName); da.Fill(dt); return dt; } } This will return you datatable after that with the help of loop insert it into database Gaurav Dudeja http://www.gdinfotechindia.com Dont be afraid of changing your life to better !

Check these pages - JavaScript Confirm[^] JavaScript - Confirm pop up[^]

Thanks dude. its working now.

Hi, Please check the following articles on how to use the split method: http://dotnetperls.com/string-split[^] http://msdn.microsoft.com/en-us/library/system.string.split(VS.71).aspx[^] Regards, Jamil

Your problem could it be like sandympatil said! or maybe you're setting the same dropDownList1.DataValueField in the data source... for example I have as source: -column1----column2 --------------------- -red------------value1 -blue-----------value1 -orange-------value1 -black----------value1 and dropdownlist is dropDownList1.DataTextField = "column1"; dropDownList1.DataValueField = "column2"; look out that. If that's so, the post back always select the first option with 'value1'... Ahh! I recommend you to use ajax CascaddingDropDownList Here!![^]

Iterate through the grid view from javascript, find the textbox either by tagname or by Id and enable it like this, txtBox.disabled=false; Let me know if it works. Arun Jacob http://codepronet.blogspot.com/