|
Hi,
I have a page which has Labels and Textboxes. Those textboxes contain data which is coming from a database. I want to be able to export the data in the textboxes into excel. Is there anyway for doing that? Do you know of any site which shows me how to?
Thanks!
|
|
|
|
|
you can use componentOne's tools or either use excel.dll for that.
Lxcite's Planet
... the ultimate solution
|
|
|
|
|
hi,
if you do not need any formatting in your destination excel file you can create a simple text file with the extension xls. you only have to seperate your content throug vbTab and vbNewLine.
solidIT.de - under construction
Components for Microsoft .Net
audittrail, objectcomparer, deepcopy and much more ...
|
|
|
|
|
Hi ,
I am using a property grid to show some controls property and dynamically set them.I want to remove some property or customized some choosed property .How can I do this.Please help me.It is urgent.
thanks in Advance
Sandy
|
|
|
|
|
Don't. Cross. Post.
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
|
Thanks For these advice.
I thinks these will solve my problem.
|
|
|
|
|
hello all,
Am working with windowsform Using .net 2005 and sql server.
Am developing an small application regarding payroll. code begin is vb.
my problem is whenever i give details about basicsal, Hra, conveyance etc it will automatically compute netsalary, In netsalry text box maximum length allowed is 8. but it was shown to many numbers in fraction like "2345.901245629871".How can i trim that value to"2345.90" 0r "2346". this is only my problem. am also wrote code for trim the paticular text box value. but it didn't work. please tell me suggetions to solve this problem
|
|
|
|
|
Do you use DataBinding?
Do the number showed in textbox, is allowed to be edited and return to Database?
is String.Format function or Math.Round suitable for u?
|
|
|
|
|
YOU CAN USE FORMAT
Eg:
TXTBOX.TEXT = FORMAT(TXTBOX.TEXT,"####.##")
|
|
|
|
|
Hi,
Or you can just use:
<br />
YourTextBox.Text = Decimal.Round(CDec(YourValue), 2)<br />
Johan
My advice is free, and you may get what you paid for.
|
|
|
|
|
Thanks a Lot it was working Nice....
|
|
|
|
|
Hi;
I m using VB.net. I have inserted the data in SQLSERVER in this form but having this error while trying in Oracle. Im using class for connection
"ORA-01036, Illegal Name/Variable "
this is the Code I m using.
Dim LclsGeneral As New GClsGeneral
Dim fs As FileStream = New FileStream(txtContent.Text, FileMode.Open, FileAccess.Read)
Dim img(fs.Length) As Byte
fs.Read(img, 0, System.Convert.ToInt32(fs.Length))
Dim conn As New OracleClient.OracleConnection
Dim LClscnn As New GClsConnection
conn.ConnectionString = LClscnn.GetConnectionString
If conn.State = ConnectionState.Closed Then conn.Open()
Dim Lcmd As New OracleClient.OracleCommand
Lcmd.Connection = conn
Lcmd.CommandText = "Insert into Test (DOCUMENTID,DOCUMENTCONTENT) VALUES ('" & txtID.Text & "',@DOCUMENTCONTENT)"
Lcmd.Parameters.Add("@DOCUMENTCONTENT", OracleClient.OracleType.Blob,img.Length).Value = img
Lcmd.ExecuteNonQuery()
fs.Close()
txtID.Text = ""
txtContent.Text = ""
Kindly help me
Thank you
|
|
|
|
|
Hello,
Now I can use windows media encoder to broadcast my media by using vb.net. And I try to generate the video on demand but I can't do it because it must use windows media server. Please explain me in details how to generate video on demand on windows xp by using vb.net.
Thankyou very much.
|
|
|
|
|
 how to insert undeletable image in word document
Please Give me solution
Thanks
Arun
Arun Kr
|
|
|
|
|
Make the file read only ?
I don;t know that Word allows you to add images that then can't be removed.
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
Hi
When we sign assign the document with certificate there is a image or may be a control shown that is unselectable and undeletable. My interest only to get that type object.
Thanks
Arun
Soft.Engg - DOTNET
Arun Kr
|
|
|
|
|
I have an application that uses Excel 2003. How can I know what is the version of Excel in the end user? Is there any way I can find it out when the program starts?
Thank you in advance
|
|
|
|
|
And option could be to find out where/ if Excel is installed on a machine via the registry.
Then open the fileinfo (use Diagnostics.FileVersionInfo and FileVersionInfo.GetVersionInfo(strPathToFile)) and extract the excel.exe file version.
Based on the result of that, you will know what excel version the user has.
- Dan Nobel
"The question is not how far. The question is, do you possess the constitution, the depth of faith, to go as far as is needed?"
boondock saints
|
|
|
|
|
hi
u go to help menu and see that ABOUT tab.u will get the version
|
|
|
|
|
Iam Sorry , vry simple Problem
I got this Error in ConnectionString..So pls Help me ..
I want to take the Database TablesName
The ConnectionString property has not been initialized.
Dim con As New SqlConnection
Dim cmd As New SqlCommand
Dim dr As SqlDataReader
Try
constr = "Initial Catalog=Pubs;User ID=sa;Password=sa;Data Source=.;"
con.Open()
cmd = New SqlCommand("select * from tablename", con)
dr = cmd.ExecuteReader()
While (dr.Read())
TextBox1.Text = (dr(0))
End While
Catch ex As Exception
MsgBox(ex.Message)
End Try
con.close
Thanking you
Somasundaram G
|
|
|
|
|
I see two problems
1 - you set a connection string but don't use it
2 - you don't specify a data source ( although it looks like it's SQL Server )
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
I didnt use the Datasource and connectionstring also but again same error The ConnectionString property has not been initialized. so pls Wt i do .so pls help me.....
|
|
|
|
|
I don't understand, how do you expect this to work without a connection string ? you have what looks like one, but it's not used anywhere. How did you come up with this code ?
Here[^] are the docs for the SqlConnection class. Basically, you need to pass in a valid connection string to the constructor.
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
Christian Graus wrote: How did you come up with this code ?
Thats the million dollar question that comes to my mind lots of times when seeing something like this.
I am not saying the OP did this - but many times people just copy paste some code and when it does not work as expected, they post it verbatim in forums to get an answer.
I can understand if the problem was related to say, Graphics, drawing or some bit shifting etc., but something fundamental as database handling needs to be learnt and not copied.
Thanks for listening, I needed to say this sometime.
Shreekar
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
