|
I assume that this is just your test code, and that you will not ship code that is totally open to SQL injections.
Why are you fetching the data twice? If you need it more than once, fetch into a DataSet or something. Then you don't have to loop through the records to find out how many there are either.
I can't see any code where you try to insert data in any combobox. If you want any help with your error, you have to show the code where it does occur, not some completely different code.
---
single minded; short sighted; long gone;
|
|
|
|
|
Hi,
I need to get the name of an instance of class. Perhaps, using reflection?
Below i show the example
class Idle<br />
Public one as int32<br />
end class<br />
<br />
class form1<br />
Dim MyIdle as new Idle<br />
public Sub button1_click(sender,...) handles button1.click<br />
textbox1.text= ?¿<br />
end Sub<br />
end class
How can i get the name 'MyIdle' ??
|
|
|
|
|
hi!
you can't get the variable name. With Reflection you can get types of assemblies, for example. but a variable name is not metadata in a compiled assembly, because a variable is only a location in the ram.
solidIT.de - under construction
Components for Microsoft .Net
audittrail, objectcomparer, deepcopy and much more ...
|
|
|
|
|
Hi 2 All,
Please suggest me,how can insert a ocx control in word document?
Thanks
Arun Kumar
Soft Engg - DOTNET
Arun Kr
|
|
|
|
|
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
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
