|
I know you might have gone through these links. If not have a look
|
|
|
|
|
Navaneeth. wrote: I know you might have gone through these links
yes :->
Any way thanks for your reply
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
I have a web application that updates records in a Sql Server Table. Also I have another table where I insert data from a hardware device.
The systems works well.
The web page has 8 buttons controls that update boolean values in the first table. Everytime I press the button the page is reloading. What I want now is to interate AJAX in my application so when I press on of the buttons the page will not realoaded.
Also I need to poll every few seconds the second table so when my hardware device inserts a record it will automatically will be updated in my gridview.
I have absolutely no idea about Ajax and I have about one month before the deadline for my project.
Is this difficult to implement?
Any help or tutorials will be apprecieted...
Thank you
|
|
|
|
|
The easiest way to implement this would be to use ASP.NET Ajax (Atlas) Update Panel. http://ajax.asp.net/[^]
You could also use Javascript setInterval to call an Ajax method that would query the database and update the page as necessary.
only two letters away from being an asset
|
|
|
|
|
I have one problem when use Ajax panels in Visual Studio. The pages on my computer refresh very fast so I cannot understand if Ajax worked or it was just a fast refresh.
|
|
|
|
|
Set a break point. Use a debug message. Set the timer interval higher.
kallileo wrote: The pages on my computer refresh very fast so I cannot understand if Ajax worked or it was just a fast refresh.
I can see no excuse for this statement.
only two letters away from being an asset
|
|
|
|
|
OK. Thanks...
I do some tests at the moment:
script runat="server">
Sub ShowTime(ByVal sender As Object, ByVal e As EventArgs)
Label1.Text = DateTime.Now.ToLongTimeString()
End Sub
<asp:scriptmanager id="ScriptManager1" runat="server">
<asp:updatepanel id="UpdatePanel1" runat="server" updatemode="Conditional" childrenastriggers="true">
<contenttemplate>
<asp:timer id="Timer1" interval="1000" runat="server" ontick="ShowTime">
Update Panel Refresh
<asp:label id="Label1" runat="server" height="2px" backcolor="Silver" forecolor="Blue">
|
|
|
|
|
Hi all,
I need to Import data from excel to Gridview, can anyone tell me how should I start.
Thanks in advance...
|
|
|
|
|
What are you really trying to do? You can display excel files in the web. If this is data that really belongs in a database table you can do that as well. You can use the import functionality to import an excel file into a new database table. Then you could select from that table and display in your gridview.
I am thinking you may just want to look at displaying excel files. Of course that does mean you need to have office installed.
Ben
|
|
|
|
|
Thanks for the reply, actually I want to just take the email ID's from excel file and show them in GridView and then send mail to those ID's.
So I need Importing excel file data to GridView.
Please help me...
Thanks again...
|
|
|
|
|
You can take look on the below example,
Using Con As New Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(".") & "\myfile.xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"";User ID=Admin; Password=")<br />
Dim Com As New Data.OleDb.OleDbCommand<br />
Dim DR As Data.OleDb.OleDbDataReader<br />
Dim sQuery As String<br />
<br />
Con.Open()<br />
Com.Connection = Con<br />
<br />
sQuery = "SELECT * FROM [sheet1$]"<br />
<br />
Com.CommandText = sQuery<br />
DR = Com.ExecuteReader<br />
<br />
Dim DT As New Data.DataTable<br />
DT.Columns.Add("name")<br />
DT.Columns.Add("details")<br />
While DR.Read<br />
Dim DatRow As Data.DataRow = DT.NewRow<br />
Dim Value As String = ""<br />
DatRow("name") = DR("name")<br />
DatRow("details") = DR("email id")<br />
DT.Rows.Add(DatRow)<br />
End While<br />
<br />
MyGrid.DataSource = DT<br />
MyGrid.DataBind()<br />
<br />
End Using
|
|
|
|
|
Thanks Venkatesh. This code only take the files which are on server but I want to take the files from client machine.
Can u please help me with this.
Thanks again...
|
|
|
|
|
ASP.NET 2.0 wrote: This code only take the files which are on server but I want to take the files from client machine.
Upload the file which you want to read, then apply my code.. Thats it...
|
|
|
|
|
Thanks for the reply but I dont want to save the file on server.
Please help me...
Thanks again...
|
|
|
|
|
I wrote something a while back, where you copied the excel doc and then pasted it in a window. Then pressed a button on the web. When the button was pressed the excel data that was in the control was parsed and processed. It worked pretty good for me and that was my solution to a very similar problem. I can show you the code I used, it is in vb.net 1.1, but it would be easy enough to translate to C# as well. Let me know.
Ben
|
|
|
|
|
I wrote something a while back, where you copied the excel doc and then pasted it in a window. Then pressed a button on the web. When the button was pressed the excel data that was in the control was parsed and processed. It worked pretty good for me and that was my solution to a very similar problem. I can show you the code I used, it is in vb.net 1.1, but it would be easy enough to translate to C# as well. Let me know.
Ben
|
|
|
|
|
Thanks for the reply, I am using ASP.NET 2.0 (VB), will u please post that code.
Thanks again...
|
|
|
|
|
So on the button click event grab the text of the multi line text box then:
Private Sub IbtnSubmit_Click(ByVal sender As System.Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles IbtnSubmit.Click
Dim I As Integer
Dim J As Integer = 0
Dim oldI As Integer
Dim oldJ As Integer
Dim colnum As Integer = 0
Dim tmparray(35) As String
Dim tmpstr As String
Dim instr As String = tboxauto.Text
Dim objArrayList As New Collections.ArrayList 'Input parameters
If instr.Length = 0 Then
showmessagebox("You need to copy the Excel section into the text box")
Exit Sub
End If
'Parse through the excel file copied into the textbox
I = instr.IndexOf(Chr(13))
oldI = 0
While I <> -1
tmpstr = instr.Substring(oldI, I - oldI)
oldJ = 0
J = tmpstr.IndexOf(Chr(9))
cleararray(tmparray)
colnum = 0
While J <> -1
If colnum > 32 Then
Exit While
End If
tmparray(colnum) = tmpstr.Substring(oldJ, J - oldJ)
colnum += 1
oldJ = J + 1
J = tmpstr.IndexOf(Chr(9), J + 1)
End While
If tmparray(1).ToUpper = "ISR" OrElse tmparray(1).ToUpper = "HELP DESK TICKET" Then
'skip because this is the header of the excel file
Else
processauto(tmparray)
End If
oldI = I + 2 '2 because of cr and lf
I = instr.IndexOf(Chr(13), I + 1)
End While
End Sub
Private Sub cleararray(ByRef inarry() As String)
Dim I As Integer = 0
While Not (inarry(I) Is Nothing)
inarry(I) = Nothing
I += 1
End While
End Sub
Private Sub processauto(ByVal inarry() As String)
'YOu can write some code here to use the data.
End Sub
Hope that helps.
Ben
|
|
|
|
|
Thanks for the reply, but how will I get the name of the excel file from client machine???
Please help me...
|
|
|
|
|
You don't need the file name. They copy the excel file and paste it into a text box and then press a button. The code I posted parses through the copied excel file.
Ben
|
|
|
|
|
Thanks, but still its not working.Can u please give me an example what is the input given in textbox and how this code works???
I am not getting this line:
instr.IndexOf(Chr(13))
Thanks again.
|
|
|
|
|
When you copy the excel doc and then paste it into a multi line text box, what you get is text where the columns are sepparated by a tab character and the end of the line is delimited by a return character (13).
So since the user copies the data from excel and pastes it into your textbox on your website and then presses a button. You can parse the excel data and then do something with it.
Ben
|
|
|
|
|
Now its giving error on the line :
J = tmpstr.IndexOf(Chr(9))
What for chr(9) is???
|
|
|
|
|
Char 9 is the tab character which is what each column should be sepparated by. What is the error you are getting?
Ben
|
|
|
|
|
Actually I am having only one column in excel file which is Email ID column. I suppose I will have to remove the second while loop. Is it so??
Its giving Error:
Object reference not set to an instance of an object.
On Line:
If tmparray(1).ToUpper = "ISR" OrElse tmparray(1).ToUpper = "HELP DESK TICKET" Then
|
|
|
|