Hello, I have to download data into excel Sheet Using JavaScript Only(Not VB or C#.Net).Please any one help me regarding this.

Hello EveryOne, How to allow only numeric values ina textbox.if we allow characters it should pop up a message showing "need to enter numeric values". Please HElp Regarding this, Thanks Nagalakshmi

hello, I need count the number of empty html input boxes . I am using asp.net(coding in vb.net) I am using the following code to get access to all the input boxes since there are many of them in my form.Can u tell me what should I write in the if condition so that I can check if the input box is empty? Dim count As Integer Dim form As HtmlForm form = Me.FindControl("Form1") Dim control As Control For Each control In form.Controls If (Convert.ToString(control.GetType) = "System.Web.UI.HtmlControls.HtmlInputText") Then if( ) count = count + 1 end if End If Next Thanks & Regards Nagalakshmi

hello .. How to add edit button at runtime in datagrid control and also how to hide datagrid column at runtime... can u help me in this regard.... Thanks & Regards Nagalakshmi

hello, i am making use of table control and when i am creating a new cell ia setting colors ,height,width dynamically but it is not effecting please can anybody tell how to convert table cell string into float i have used convert function but it is showing me error thanks & regards Nagalakshmi

Hello, I have a bar chart to display scores for each month.I am using ChartDirector in ASP.NET(Codin in VB.NET) for this.I want to display the text "No Score" on the chart where there is no score entered for a particular month. I was trying to use this code which displays the values of the bar if score exists and "No Score" if score doesnot exist (though it is not not necessary to display values of bars). BarLayer.setAggregateLabelFormat("{test}") where test is a string array containg values to be displayed on top of bar. But the problem with this is only the text {test} is being displayed where as I want the value in the string test to be displayed. Please suggest a solution. Thanks & Regards Nagalakshmi

Hi , When I select an item in datagrid the selected item color changes.But when I close the application and open again the changed color for the previously selected item remains.I want the previously selected item to be displayed as the remaining items and only the currently selected item to change its color. Thanks & Regards Nagalakshmi

hello, How do I count the number of textbox controls in a asp.net webpage thanks & regards Nagalakshmi

hello, i have to change the color of datagrid rows dynamically as per the values present in the row .... for example row has 5 columns and in that way it had 5 rows first first row should data in datagrid should compare with second row data in datagrid if it exceeds the row color should have blue color other wise green in this way i have to check with each row with ecah column in datagrid plz can any body help in this regard i am sending code for the datagrid plz check it out and say how to add color to it cmdControlTower.Connection = CON con.Open() cmdControlTower.CommandType = CommandType.StoredProcedure cmdControlTower.CommandText = "ACE_CONTROLTOWER" Dim cellid As New SqlParameter Dim fromDATE As New SqlParameter Dim toDATE As New SqlParameter cellid.ParameterName = "@CELLID" cellid.SqlDbType = SqlDbType.VarChar cellid.Value = strControlTowerList(0) cellid.Direction = ParameterDirection.Input cmdControlTower.Parameters.Add(cellid) fromDATE.ParameterName = "@fromDATE" fromDATE.SqlDbType = SqlDbType.DateTime fromDATE.Value = strFromDATE fromDATE.Direction = ParameterDirection.Input cmdControlTower.Parameters.Add(fromDATE) toDATE.ParameterName = "@toDATE" toDATE.SqlDbType = SqlDbType.DateTime toDATE.Value = strToDate toDATE.Direction = ParameterDirection.Input cmdControlTower.Parameters.Add(toDATE) 'Dim dr As SqlDataReader 'dr = cmd.ExecuteReader() 'Datagrid2.DataSource = dr 'Datagrid2.DataBind() 'dr.Close() 'closing data reader 'cmd.Dispose() Dim daControlTower As SqlDataAdapter daControlTower = New SqlDataAdapter(cmdControlTower) dsControlTower = New DataSet("CONTROLTOWER") daControlTower.Fill(dsControlTower, "CONTROLTOWER") dgControlTower.DataSource = dsControlTower.Tables("CONTROLTOWER") dgControlTower.DataBind() thanks & regard Nagalakshmi

hello, The code shown below is for excel sheet generation but when i execute this i am getting an error as access is denied .plz go though the code and if any mistake plz correct it .... Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click da1.MissingSchemaAction = MissingSchemaAction.AddWithKey CMD.Connection = con con.Open() CMD.CommandType = CommandType.StoredProcedure CMD.CommandText = "ACE_CONTROLTOWER" Dim cellid As New SqlParameter Dim fromDATE As New SqlParameter 'Dim tomonth As New SqlParameter 'Dim fromyear As New SqlParameter Dim toDATE As New SqlParameter cellid.ParameterName = "@CELLID" cellid.SqlDbType = SqlDbType.VarChar cellid.Value = TextBox1.Text cellid.Direction = ParameterDirection.Input CMD.Parameters.Add(cellid) fromDATE.ParameterName = "@fromDATE" fromDATE.SqlDbType = SqlDbType.DateTime fromDATE.Value = TextBox2.Text fromDATE.Direction = ParameterDirection.Input CMD.Parameters.Add(fromDATE) toDATE.ParameterName = "@toDATE" toDATE.SqlDbType = SqlDbType.DateTime toDATE.Value = TextBox5.Text toDATE.Direction = ParameterDirection.Input CMD.Parameters.Add(toDATE) Dim dr As SqlDataReader dr = CMD.ExecuteReader() DataGrid2.DataSource = dr DataGrid2.DataBind() dr.Close() 'closing data reader CMD.Dispose() con.Close() End Sub Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click bln = CreateExcelWorkbook("example") '= Server.MapPath(".") + "\PWReports\" filePath = "c:\" filename = "example" filePath = filePath & filename & ".xls" Dim MyFileStream As FileStream = New FileStream(filePath, FileMode.Open) Dim FileSize As Long FileSize = MyFileStream.Length Dim Buffer(FileSize) As Byte MyFileStream.Read(Buffer, 0, MyFileStream.Length) MyFileStream.Close() Response.ContentType = "application/vnd.ms-excel" Response.AddHeader("content-disposition", "attachment; filename=" & filename & " .xls") Response.BinaryWrite(Buffer) End Sub Public Function CreateExcelWorkbook(ByVal strFileName As String) As Boolean Dim oXL As Excel.Application

hello, how to export image control in asp.net into excelsheet and also how to export datagrid containing images.. plz help inthis regard.. very urgent plz...

hello, please help me regarding my problem i have to store stored procedure in one dataset, and sqlquery in one dataset and i have to merge these two datasets and then bind to datagrid,stored procedure has one input parameter.... first help me in retriveing data from stored procedure into dataset... please help me regarding this Thanks & Regards Nagalakshmi

Hello, How to add row and columns dynamically to table control and assign database data to the table control.plz help me inthis regard Thnaks & Regards, Nagalakshmi

hello, I have used two datasets for two tables and i have to pass these two datasets into datagrid.. i am using sqlserver 2000 plz help in this regarding, Thanks & Regards, Nagalakshmi -- modified at 6:16 Wednesday 21st December, 2005

hello, i have used combobox in one webform and the selected combo box data should get retrived into another webform..as input plz help me in this regard. Thanks & Regards Nagalakshmi

hello, I have to generate table control dynamically ,the rows and columns are created dynamically and i have used stored procedure in sqlserver and the data present in sqlserver should generate dynamically into table contol.. plz help me in this regard.. Thanks & Regards Nagalakshmi

hello, The datagrid that is generated in webform should generate in excel form in vb.net.The entire form should be generated into excelsheet and form also contains picture images also.plz explain with namespaces plz help me as i am beginner to vb.net. thanks & regards Nagalakshmi -- modified at 22:52 Monday 19th December, 2005