Hai Friends, I have a Requirement ,in that Dynamically Textboxes and Dropdowns will be generated then page will become large, when i click on any dropdownlist(autopostback = true) it is being post backed, its again starting from page begining agin i am going to that dropdownlist position,again doing some thing not doing like this,when i click on it, post back should be done and ctrl should be there only,is there any solution for it? actually iam using SMARTNAVIGATION = TRUE,It is working fine, postback is done, ctrl is there only but some times ,it is giving problems some times we can use ajax for it but other than that is there any solution for it?

Hai Friends, I have one problem withe Excel Sheet, Actually Iam uploading excel sheet , and I am storing the contents of Excel sheet in DATASET and i am reading the data from DATASET While Reading Data from DATASET,Iam unable to read the INTEGER data Even i am reading the data of Text, getting problems with INTEGER data and it is giving error is INVALID CAST ERROR and it is showing the valuse DBNull i have tried to solve it by changing the properties of Excel Sheet CEll,but could not Succeed Iam giving Code what i wrote in aspx.vb Dim TNo As String Dim ASFD As integer For i = 4 To DS.Tables(0).Columns.Count - 1 TNo = Trim(DS.Tables(0).Rows(0).Item(i)) ASFD = DS.Tables(0).Rows(6).Item(i) when i am reading the ASFD,iam getting the INVALID CAST Error

Hai Friends, I have one problem withe Excel Sheet, Actually Iam uploading excel sheet , and I am storing the contents of Excel sheet in DATASET and i am reading the data from DATASET While Reading Data from DATASET,Iam unable to read the INTEGER data Even i am reading the data of Text, getting problems with INTEGER data and it is giving error is INVALID CAST ERROR and it is showing the valuse DBNull i have tried to solve it by changing the properties of Excel Sheet CEll,but could not Succeed Iam giving Code what i wrote in aspx.vb Dim TNo As String Dim ASFD As integer For i = 4 To DS.Tables(0).Columns.Count - 1 TNo = Trim(DS.Tables(0).Rows(0).Item(i)) ASFD = DS.Tables(0).Rows(6).Item(i) when i am reading the ASFD,iam getting the INVALID CAST Error

Hai Friends, I have one problem withe Excel Sheet, Actually Iam uploading excel sheet , and I am storing the contents of Excel sheet in DATASET and i am reading the data from DATASET While Reading Data from DATASET,Iam unable to read the INTEGER data Even i am reading the data of Text, getting problems with INTEGER data and it is giving error is INVALID CAST ERROR and it is showing the valuse DBNull i have tried to solve it by changing the properties of Excel Sheet CEll,but could not Succeed Iam giving Code what i wrote in aspx.vb Dim TNo As String Dim ASFD As integer For i = 4 To DS.Tables(0).Columns.Count - 1 TNo = Trim(DS.Tables(0).Rows(0).Item(i)) ASFD = DS.Tables(0).Rows(6).Item(i) when i am reading the ASFD,iam getting the INVALID CAST Error

hai friends, my name is kishore kumar actually i am getting one problem ,but i am unable to solve it please help me That is : i will enter text(number), that should be changed into currency formate that means suppose if i enter 99 in a textbox ,that shuld be changed to 99.00 and i have to show it as currency formate i have three text boxes in two text boxes, i will enter values , in third text box, the multiply of those two text boxes values shuld be displayed with currency formate if i enter first text box : 9 second text box : 11 out put : third text box: 99.00 ,shuld be displayed please help me,that should be done at client side

Thanks Apurv but Even Iam doing same thing what u said, it is giving same error kishore

My application needs Exports to Excel and From Excel to Database for that ,i have used the code For Export: Dim mySQLCommand As New SqlCommand Dim myConnection As New SqlConnection Dim datagrid1 As New DataGrid Dim DS As New DataSet Dim DT As New DataSet myConnection = New SqlConnection("Password=technologies;Persist Security Info=False;User ID=sa;Initial Catalog=Lims_Demo;Data Source=VISHWA") 'ConfigurationSettings.AppSettings("MyConStr")) myConnection.Open() Dim da As New SqlDataAdapter("SELECT top 30 ProductCode,ProductName,GenericName,RetestPeriod FROM Results where status=0", myConnection) da.Fill(DT) datagrid1.DataSource = DT datagrid1.DataBind() Response.Clear() Response.ContentType = "application/vnd.ms-excel" Response.Charset = "" Me.EnableViewState = False Dim tw As New System.IO.StringWriter Dim hw As New Html32TextWriter(tw) datagrid1.RenderControl(hw) Response.Write(tw.ToString()) Dim path As String = "C:\...\abc.doc" Response.AddHeader("content-disposition", "attachment; filename=Worddocument.xls") Response.End() 'FileStream sourceFile = new FileStream(path, FileMode.Open); 'long FileSize; 'FileSize = sourceFile.Length; 'byte[] getContent = new byte[(int)FileSize]; 'sourceFile.Read(getContent, 0, (int)sourceFile.Length); 'sourceFile.Close(); 'Response.BinaryWrite(getContent); 'dim SaveFileDialog1 as System. 'If SaveFileDialog1.ShowDialog() = DialogResult.OK Then ' RichTextBox1.SaveFile(SaveFileDialog1.FileName, _ ' RichTextBoxStreamType.PlainText) 'End If myConnection.Close() the above coding is working very good and giving the required results but when i am going to Import Excel data to Database I have used the code, which i found in Msdn help '---------------------Importing Data From Excel to Database If Not FILE1.PostedFile.FileName = "" Then FilePath = FILE1.PostedFile.FileName End If 'Excel Work Sheet Database Connection MyConnection = New System.Data.OleDb.OleDbConnection( _ "provider=Microsoft.Jet.OLEDB.4.0; " & _ "data source=" & FilePath & "; " & _ "Extended Properties=Excel 8.0;") 'Select the data from Sheet1 of the workbook. 'MyConnection.Open() 'Dim dt As Table = MyConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null) Dim f As Array f = Split(FilePath, "\") Dim k As Integer = f.Length Dim str As String = f(k - 1) Dim filename As String = str.Substring(0, str.LastIndexOf(".")) 'str.Split(".xls") 'Dim f1 As Array 'f1 = Split(str, ".") 'Dim str1 As String = f1(f1.Length - 1) Try D

hai friends, this is kishore, i have one requirement importing data from excel to database, it should be done at server side it is very urgent need i could get succeed in exporting database to excel ,but iam unable to import excel to database actually i have got the solution but it is giving some problems, it is working only for one workbook(excel) the code is below 'Getting a file path If Not FILE1.PostedFile.FileName = "" Then FilePath = FILE1.PostedFile.FileName End If 'Excel Work Sheet Database Connection MyConnection = New System.Data.OleDb.OleDbConnection( _ "provider=Microsoft.Jet.OLEDB.4.0; " & _ "data source=" & FilePath & "; " & _ "Extended Properties=Excel 8.0;") 'Select the data from Sheet1 of the workbook. 'FilePath comes as c:\export\mydata.xls Dim f As Array f = Split(FilePath, "\") Dim k As Integer = f.Length Dim str As String = f(k - 1) Dim filename As String = str.Substring(0, str.LastIndexOf(".")) '' Select the data from Sheet1 of the workbook. MyCommand = New System.Data.OleDb.OleDbDataAdapter( _ "select * from [" & filename & "$]", MyConnection) DS = New System.Data.DataSet 'DataSet MyCommand.Fill(DS) 'Filling The dataset please help me, when iam going to export the data from database to excel, it is storing it as c1.xls(we give) and sheet1 name is also stored as c1.xls when i am going to retrieve the data from it, it is giving an error please help me regards kishore

'Getting a file path If Not FILE1.PostedFile.FileName = "" Then FilePath = FILE1.PostedFile.FileName End If 'Excel Work Sheet Database Connection MyConnection = New System.Data.OleDb.OleDbConnection( _ "provider=Microsoft.Jet.OLEDB.4.0; " & _ "data source=" & FilePath & "; " & _ "Extended Properties=Excel 8.0;") 'Select the data from Sheet1 of the workbook. 'FilePath comes as c:\export\mydata.xls 'now i am going to retrive the "mydata" name only because of while iam storing the excel file,it is being stored as mydata.xls and at the same time sheet name also being changed as mydata whenever i am going to retrieve the data, i have to specify the sheet name for that i am doing the below code, but i am getting an error, it is alreday open by another user or some other error is displayed Dim f As Array f = Split(FilePath, "\") Dim k As Integer = f.Length Dim str As String = f(k - 1) Dim filename As String = str.Substring(0, str.LastIndexOf(".")) '' Select the data from Sheet1 of the workbook. MyCommand = New System.Data.OleDb.OleDbDataAdapter( _ "select * from [" & filename & "$]", MyConnection) DS = New System.Data.DataSet 'DataSet MyCommand.Fill(DS) 'Filling The dataset please help me, when iam going to export the data from database to excel, it is storing it as c1.xls(we give) and sheet1 name is also stored as c1.xls when i am going to retrieve the data from it, it is giving an error(as above said) please help me regards kishore go2kish@yahoo.com kishore