|
I the code i define all the required parameter to connect to a sql server.
Also I define dataset in the code.
i need to bind rows in the dataset to a textbox using textbox binding propertise.
what code i must write in textbox -> properties -> bindingdata -> advance -> text to connect dataset that i define in the code to the textbox.
Thanks....
|
|
|
|
|
after filling the dataset with datatable
write this:
textbox1.text=ctype(dst.tables(0).rows(0).item("ColumnName"),string)
thats all
abhinav
|
|
|
|
|
It's as easy:
TextBox1.DataBindings.Add("Text", myDataSet.Table1, "myField")
vonb
|
|
|
|
|
I have Oracle DB Table with one of its column (VARCHAR). I read and write to
this data [non-english or English] using VC application then everything
works fine. But if I use a VB application to read the data[non-english] and
write it back to the same palce the content is corrupted.
Any help is appreciated
|
|
|
|
|
The problem is solved. It was due to the difference in the way, the Unicode characters are handled by "Oracle Provider for OLE DB" (OraOLEDB.DLL) and "Microsoft OLE DB Provider for Oracle" (msdaora.dll).
Refer : http://support.microsoft.com/kb/q244661/
My vb application was using msdaora.dll while VC++ was using OraOledb.dll !
Suhredayan
|
|
|
|
|
I need create interface in my application program like windows xp.
Pls. Send me *.OCX files to my mail kusal1@gmail.com
Kusal
|
|
|
|
|
Goggle[^]
Noone here is just going to send you stuff. We'll help you with your code, but your responsible for actually putting effort into searching for your solution first.
BTW, there are no OCX controls that will give the you look and feel of Office controls. You actually have to code it. But like I said, Google for it first. There are TONS of examples out there.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hello everyone,I'm migrating the VB Engine to VB.NET. I manage to run the function only in the first time,it will occur this error>>"Exception has been thrown by the target of an invocation" when it start to continue running the second time by the time interval have been set. This Engine is set to run by time intervals. Anyone can help me to solve the problem?
And this is what the error I got:
************** Exception Text **************
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidOperationException: The connection is already Open (state=Open).
at System.Data.SqlClient.SqlConnection.Open()
--- End of inner exception stack trace ---
at System.Reflection.RuntimeMethodInfo.InternalInvoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean isBinderDefault, Assembly caller, Boolean verifyAccess)
at System.Reflection.RuntimeMethodInfo.InternalInvoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean verifyAccess)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters)
at Microsoft.VisualBasic.CompilerServices.LateBinding.FastCall(Object o, MethodBase method, ParameterInfo[] Parameters, Object[] args, Type objType, IReflect objIReflect)
at Microsoft.VisualBasic.CompilerServices.LateBinding.InternalLateCall(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack, Boolean IgnoreReturn)
at Microsoft.VisualBasic.CompilerServices.LateBinding.LateCall(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack)
at TT_Front.First.Distribution() in C:\Documents and Settings\Kam\My Documents\Visual Studio Projects\TT_Front\First.vb:line 165
at TT_Front.First.Timer1_Tick(Object sender, EventArgs e) in C:\Documents and Settings\Kam\My Documents\Visual Studio Projects\TT_Front\First.vb:line 146
at System.Windows.Forms.Timer.OnTick(EventArgs e)
at System.Windows.Forms.Timer.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr idEvent, IntPtr dwTime)
Thank you so much,I can't really solve this problem because I'm still new to VB.NET. I wish someone really can help me in this. Thank you so much.
|
|
|
|
|
Noone is going to look at this post, simply because of it's size. Don't post your entire app, just the relevent code.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Yes,thank you for the advice. I have post up the error founded. Do you know what might be the problem occurred?
|
|
|
|
|
The error already told you exactly what is going wrong: System.InvalidOperationException: The connection is already Open (state=Open).
Read a little below that and you will find the error is comming from the class System.Data.SqlClient.SqlConnection with function Open(). So it looks to me you're trying to open a connect to a database when there already is an open connection.
|
|
|
|
|
Oh,thank you so much for helping me to solve this problem. I'm quite new to VB.Net,but feel so lucky U manage to help me. I solve this problem by rechecking all the connection open between my database and this Engine. Thank you so much Mr Gerben Jongerius.
Wish You and the others Have A Wonderful New Year~!
|
|
|
|
|
The rule for database connections is simple. Open the connection to the database as late as possible, execute your batch as quick as possible, then close your connection as early as possible. It's very bad practice to hold open a database connection for the life of your app.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Thank you so much for the information provide,I think I should learn more from you all in the future. Thats great you all really help me a lot on solving the problem. All the best and happy new year.
|
|
|
|
|
at LoadLibraryW(UInt16* )
at System.EnterpriseServices.Thunk.Security.Init()
at System.EnterpriseServices.Thunk.Security.SuspendImpersonation()
at System.EnterpriseServices.Platform.Initialize()
at System.EnterpriseServices.ResourcePool..ctor(TransactionEndDelegate cb)
at System.Data.SqlClient.ConnectionPool..ctor(DefaultPoolControl ctrl)
at System.Data.SqlClient.PoolManager.FindOrCreatePool(DefaultPoolControl ctrl
)
at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConn
ectionString options, Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
at checkConn.Module1.Main()
I am getting the above error, when I try to open a connection with local MSDE 2000 database
can you help me?
Thank You
|
|
|
|
|
hi all,
i have a problem dealing with cascading style sheet.
how do i link my style sheet (placed background pic inside) to Default.aspx (example).
i want the picture to appear when i run Default.aspx
error occurs when i tried.
error message:-
Error 1=> Cannot switch views: Validation (XHTML 1.0 Transitional): Element 'link' cannot be nested within element 'html'.
where shall i put this link then?
link: thanks for the help..
-DarkangeL-
|
|
|
|
|
Put your <link> tag in the <head> section.
Michael Flanakin
Web Log
|
|
|
|
|
Gee..
thanks for your help..
it does solve my problem..
thank you once again.
-DarkangeL-
|
|
|
|
|
I have an aspx page that generates an xml file and saves it to a directory using server.mappath. I want to use this page to generate that xml file when someone logs in. How can I reference this to make it happen?
E
|
|
|
|
|
Hadware,
use session or cookies to trace the login of users and then redirect to that XML page
something like this ...>
Session("strEmail") = Request.QueryString("ID")
Response.Redirect "xmlPage.aspx"
Session will be available on that page too and u can use this session to print some data according to it in XML format.
Hope it is helpful for you
R A M
|
|
|
|
|
Any thoughts on why changing a form's ShowInTaskbar property at runtime would cause an "Error Creating Window Handle" error?
Thanks ... George
"Evidently your parents slapped together version 1.0 of you and hoped no one would notice the bugs." ... Dogbert (tech support)
|
|
|
|
|
how do you open a web page in the default web browser using vb.net
http://ixpress.sourceforge.net/feedmonster
http://simpleread.blogspot.com
|
|
|
|
|
System.Diagnostics.Process.Start(WebURL)
... where WebURL is a string containing the URL of a web site
"Evidently your parents slapped together version 1.0 of you and hoped no one would notice the bugs." ... Dogbert (tech support)
|
|
|
|
|
If you want to test if the URL is reachable (e.g. an Internet connection is available and the URL is valid), pass the URL string to this function.
Private Function WebSiteIsAvailable(ByVal linkText As String) As Boolean
Dim URL_Object As New System.Uri(linkText)
Dim URL_WebRequest As System.Net.WebRequest
Dim URL_WebResponse As System.Net.WebResponse
Dim Response_Result As Boolean
' Attempt to get a response from the URL
Try
URL_WebRequest = System.Net.WebRequest.Create(URL_Object)
URL_WebResponse = URL_WebRequest.GetResponse
Response_Result = True
Catch Any_Error As Exception
Response_Result = False
End Try
URL_WebResponse = Nothing
URL_WebRequest = Nothing
URL_Object = Nothing
' Return the result
Return Response_Result
End Function
"Evidently your parents slapped together version 1.0 of you and hoped no one would notice the bugs." ... Dogbert (tech support)
|
|
|
|
|
thanks
i think this will do it
|
|
|
|