basically i want to write a method that does what Excel does in asp.net. The function of forecasting can be applied to datagrid selection.Any idea?thanks~ mijan

is it possible to do excel function using datagrid selection value to calculate forecast value?anyone has any idea? mijan

is it possible to do excel function using datagrid selection value to calculate forecast value?anyone has any idea? mijan

how to implement excel function e.g forecast from selected value from datagrid in asp.net? mijan

I have a code that can automtically insert the content of excel file into sql database. But what i want is non hardcoded part.which is user can browse through the file using browse function and choose the excel file that they want. When we click submit then everything is saved to the sql database. First of all i have this code: Dim objConn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" _ & "Data Source=" & Server.MapPath("../ExcelData.xls") _ & ";" & "Extended Properties=Excel 8.0") ' Open connection with the database. Try objConn.Open() ' Create new OleDbCommand to return data from worksheet. Dim objCmdSelect As New OleDbCommand("SELECT * FROM Range ", objConn) ' Create new OleDbDataAdapter that is used to build a DataSet ' based on the preceding SQL SELECT statement. Dim objAdapter1 As New OleDbDataAdapter ' Pass the Select command to the adapter. objAdapter1.SelectCommand = objCmdSelect ' Create new DataSet to hold information from the worksheet. Dim objDataset1 As New DataSet ' Fill the DataSet with the information from the worksheet. objAdapter1.Fill(objDataset1, "XLData") Dim xldt As New DataTable objAdapter1.Fill(xldt) objAdapter1.Dispose() ' objConn.Close() DataGrid1.DataSource = objDataset1.Tables(0).DefaultView DataGrid1.DataBind() ' Clean up objects. objConn.Close() Dim conn As New SqlConnection("workstation id=x;packet size=4096;user id=sa;data source=x;persist security info=True;initial catalog=Gx;password=x") conn.Open() Dim da As New SqlDataAdapter("select * from TEST_DATA", conn) Dim cb As SqlCommandBuilder = New SqlCommandBuilder(da) Dim ds As New DataSet da.Update(ds, "TEST_DATA") For Each xlrow As DataRow In xldt.Rows Dim dr As DataRow = ds.Tables("TEST_DATA").NewRow For Each col As DataColumn In ds.Tables("TEST_DATA").Columns dr(col.ColumnName) = xlrow(col.ColumnName) Next ds.Tables("TEST_DATA").Rows.Add(dr)

I've tried using javascript, which kind of easier.I only tried out two letter which 'a' and 'b'..how can i proceed until 'z' in much easier way? var letter, length, total, percent; total = 0; total1 = 0; letter = window.prompt('Please enter a letter', ''); length = letter.length; var my_array = letter.split(""); for(var i=0;i<length;i++){ if( my_array[i] == 'a' ){ total++; percent = total/length * 100; } if (my_array[i] == 'b' ) { total1++; } } document.write('The number of \'a\'s you have input is ' + percent) document.write( 'The number of \'b\'s you have input is ' + total1) mijan

How to count freqency of letters appeared in a textbox as input?Let say we type 'I believe', thus the code should count how many each letter appears and also in percentage. e.g. Letter 'E', Frequency = 3, percentage = 0.3 % (out of all letters) Any code example on this? thank you~ mijan

how to construct a charts(dynamic charts) using sql statement?do i have to create a database as well? can i have example please?thank you~ mijan

to do an interpretation, does it deal with intelligene system or coding part?the coding here is what is already kept in repository. tq~ mijan

Is it possible to generate a graph by retrieving the x and y value from a database? mijan

Is there any idea on what application can be done by using asp.net (in VB script) and voice recognition device? e.g developing voice command to read story for blind people in PC . So far i have known that we can use Microsoft .Net Speech SDK and voice . My other query is that what platform to run on the voice xml code? Can it be coded inside asp.net platform as well? Where can i get the VXML 2.0 file? Can I simply generate the code by using notepad? mijan

Is the palm emulator consists coding platform as well similar like GoDB software? mijan

I have few questions about Palm OS.. 1) How we can build the application for Palm OS for demonstration purpose ... I have heard anbout emulator stuff but i still don't get how it works. 2) If I were to build an application in the Palm OS, of course I will have to run the application using my own PC first. What is the language usually being used for developing application for Palm OS? My idea is to build an order management system like food order done by waitress and thus the waiter will have to take order by just using the Palm provided. The system will later on cater the order management upon the waiter put the Palm in its cradle (HotSync) so that the information will be sent to the main system in computer (e.g cashier) remotely.. menaing no wireless system required here. mijan

how to draw a graph by using asp.net environment?(preferably in VB.NET)..i have been adding the tool for graphs and code for the information needed but then the graph still couldn't be displayed..help!! mijan

Is it possible to use asp.net in stand alone pc which got no LAN? What i mean is to run the application in my pc. Let say i want to use asp.net language as my coding languange for system development, and that i use microsoft visual studio.net as the coding platform. As far as i concern that visual.net need to establish connection to the server side. how can i make the connection a success?is it still have to connect Internet? mijan

Is it possible to use asp.net in stand alone pc which got no LAN? Let say i want to use asp.net language as my coding languange for system development, and that i use microsoft visual studio.net as the coding platform. As far as i concern that visual.net need to establish connection to the server side. how can i make the connection a success?is it still have to connect Internet? mijan

how did it look like to use xml in asp.net? is it same like using it in html? mijan

yeah..it works.tq for sharing with me ;) mijan

Basically, how do we do it when it comes to code for table which having curves at the corner of the table? mijan

thanks guys! i really gonna put a hand on it..=) mijan