|
try the code below...this is just a snippet....you have to properly declare the variables or path of the file and you have to check for proper file name and extension also where needed....
Dim conStr As String = "provider=Microsoft.Jet.OLEDB.4.0;data source=" + filepath + "; Extended Properties=Excel 8.0;"<br />
''"filepath" is the path of the .xls file <br />
Dim sql As String = "select * from [Sheet1$]" ''"Sheet1" is the name of the excel sheet<br />
MyConnection = New System.Data.OleDb.OleDbConnection(conStr)<br />
MyConnection.Open()<br />
MyAdapter = New System.Data.OleDb.OleDbDataAdapter(sql, MyConnection)<br />
dim myDs As DataSet = New System.Data.DataSet<br />
MyAdapter.Fill(myDs)
let me know if you face any problem
Tirthadip
Live life to the fullest
|
|
|
|
|
Here is a C# code
//-------------------------------------------
private DataSet PerformQueryIntoDataSet(string strFileName,string sheetName)
{
string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + strFileName + ";" + "Extended Properties=" + Convert.ToChar(34).ToString() + "Excel 8.0;HDR=YES; IMEX=1;" + Convert.ToChar(34).ToString();
//You must use the $ after the object you reference in the spreadsheet
OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM ["+ sheetName + "$]", strConn);
DataSet myData = new DataSet();
myCommand.Fill(myData, sheetName);
return myData;
}
//-------------------------------------------
|
|
|
|
|
u can do this.
Dim ds As New DataSet
ds.ReadXml("test.xml")
now this dataset can be bind to any control.
Thanks,
Sun Rays
|
|
|
|
|
Hi
We are developing an ASp.net application where we can upload video files . When user upload a video we need to convert file to FLV. Conversion should be automated and the result needs to displayed to user.
How to do this?
|
|
|
|
|
Hi tiger have you found solution? we also need same feature
Pramit
Lets develop
|
|
|
|
|
I want to make a radio on my site. My site is writen in asp.net and ajax. On the main page I've got a tag <embed src="MusicFile.mp3" /> witch plays me a single music file. I want to create a page in witch music will be played, and when the music file ends - another file will be loaded and played. How do I do that? Is the the embed tag good for that or do I need a different tag?
|
|
|
|
|
Hi, I need you execute a windows service from webform, work in visual studio .net 2003 vb.net. I try with servicecontroller component but not work
Try
Dim servicio As New ServiceProcess.ServiceController
servicio.MachineName = "SINNIUNO"
servicio.ServiceName = "DEMONIO"
Me.Button4.Text = GetServiceStatus(servicio)
If servicio.CanStop Then
servicio.Stop()
Else
End If
Catch ex As ServiceProcess.TimeoutException
End Try
appear this error message
Detalles de la excepción: System.ComponentModel.Win32Exception: Acceso denegado
[Win32Exception (0x80004005): Acceso denegado]
[InvalidOperationException: No se puede abrir el servicio DEMONIO en el equipo 'SINNIUNO'.]
System.ServiceProcess.ServiceController.GetServiceHandle(Int32 desiredAccess)
System.ServiceProcess.ServiceController.Stop()
MataServicios.WebForm1.Button4_Click(Object sender, EventArgs e)
Any idea
Thank's
|
|
|
|
|
Hi,
I'm using Windows Authetication For my datagrid. And I got this example But it's not giving me the name. Where I'm I getting it wrong?
<authentication mode="Windows">
...
<authorization>
<deny users="?">
Thanks
|
|
|
|
|
There was no pasted snippet.
|
|
|
|
|
It is a common mistake.
Make sure IIS is not set to allow anonymous users. This will force a principle to be created with security information.
File Not Found
|
|
|
|
|
Hi Thanks,
I got a web site that explains to me how to change to Anonymous But I got stack some how on the way. after Enabling Anonymous access Check box and click ok. I do not understand what next would you explain to me please? Here is the example.
http://technet2.microsoft.com/WindowsServer/en/library/764d5c12-261e-4bb4-
bd6d-a394f61054041033.mspx?mfr=true
Thank you.
|
|
|
|
|
I need help from someone in asp.net. I want to select some particular string while i am entering the letter of the string in list box or by using some other control like combo box, list box. for ex: i have so many items like pen,pencil,pepper,pendulam etc., if i enter the letter according to that the cursor should move to the corresponding string.
thanks.
v.rajagopalan
v.rajagopalan
|
|
|
|
|
I think u need something like google suggest functionality. You can download the code from codeproject itself there are many google suggest like article
Nobody is perfect i'm Nobody
|
|
|
|
|
Capture the keydown event of the list/combo box in javascript and find the string what you pressed. You have to concatinate the keys you pressed and flush it after some interval of time.
|
|
|
|
|
Hi all,
I am showing employee information in a datagrid. I wan`t to give various options 2 operate on the data and to do this i want 2 provide a dropdown at the end of each row containing various options such as change,remove etc and on selection change the corresponding row of the datagrid must be updated.How do i generate the dropdown for each row and associate it with that row???
|
|
|
|
|
Use a template column like this:
<asp:DataGrid ....>
<Columns>
// put your other columns here ....
<asp:TemplateColumn HeaderText="Action">
<asp:DropDownList ID="ddAction" runat="server">
<asp:ListItem Text="(select an option)" />
<asp:ListItem Text="change" />
<asp:ListItem Text="remove" />
</asp:DropDownList>
</asp:TemplateColumn>
</Columns>
</asp:DataGrid>
|
|
|
|
|
How do i fire it`s selection change event and the change must be reflected in the corresponding row.i.e how do i know which dropdown was selected and which row to modify???
Thanks in advance!!!
|
|
|
|
|
Set the AutoPostback peoperty of the DropdownList and then capture the SelectedIndexChanged Event of the DataGrid.
|
|
|
|
|
I need to automatic upload a file to the client machine,could any one help me on how to do that
Thanks,
Marwa Bahaa
|
|
|
|
|
|
Read the file in arraybytes format and and throught streamwriter write the arraybytes one you get the arraybytes.
|
|
|
|
|
wrote: I need to automatic upload a file to the client machine,could any one help me on how to do that
Do you want to upload file from client to server or download from server to client. ? If you want to copy file from server to client, ASP.NET should have write access in the client machine where u want to copy the file
|
|
|
|
|
wrote: upload a file to the client machine
The above phrase means download, not upload...
|
|
|
|
|
yes, i need to download file from web server to client machine
Marwa
|
|
|
|
|
I am having some issues with some of my code which is based around creating properties inside a user control and then having the page that the user control resides in work with these properties.
Code is as follows:
Private IntendedType As String<br />
<br />
Public Sub SetIntendedType(ByVal IntendedType As String)<br />
IntendedType = IntendedType<br />
End Sub 'Set Intended Type<br />
<br />
Public Function GetIntendedType() As String<br />
Return IntendedType<br />
End Function 'Get Intended Type
Sits inside the user controls page behind code. The next chunk of code is in the encapsulating pages page_load event.
If Not dr.IsDBNull(15) Then<br />
CreditRatingControl.SetIntendedType(dr(15))<br />
End If<br />
If Not dr.IsDBNull(16) Then<br />
CreditRatingControl.SetIntendedUse(dr(16))<br />
End If<br />
If Not dr.IsDBNull(17) Then<br />
CreditRatingControl.SetIntendedPurpose(dr(17))<br />
End If
Obviously that part is sat inside a datareader while loop but I have ommited this. And then finally I have this inside the user control page load
<br />
SetIntendedPurpose("c**k")<br />
Label13.Text = GetIntendedPurpose() + GetIntendedType() + GetIntendedUse() + "Poo"
All I get is "poo" shown on the page. Now surely the values set from the data retrieval should have been passed in. Am I any where close with this code or not?? Does this kind of approach even work?
Thanks in advance
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
