Visual Basic

FirstPrevNext

Re: connectivity in vb.net bhawna_k24-Mar-07 2:05 bhawna_k 24-Mar-07 2:05  Imports System.Data.OleDb Public Class Form1 Inherits System.Windows.Forms.Form Public mycon As New OleDbconnection Public mycomm As New OleDbCommand Public d As New OleDbDataAdapter Dim i As Integer Public strquery As String Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load mycon = New OleDbConnection("provider=msdaora.1;user id=scott;data source=;password=tiger;") mycon.Open() End Sub Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click strquery = "insert into bhawna values(? ? ?)" mycomm.Connection = mycon mycomm.Parameters.Add(New OleDbParameter("name", OleDbType.VarChar, 10, "name")) mycomm.Parameters.Add(New OleDbParameter("class", OleDbType.VarChar, 10, "class")) mycomm.Parameters.Add(New OleDbParameter("roll_no", OleDbType.Char, 5, "roll_no")) mycomm.Parameters(0).Value = TextBox1.Text mycomm.Parameters(1).Value = TextBox2.Text mycomm.Parameters(2).Value = TextBox3.Text mycomm.CommandText = strquery i = mycomm.ExecuteNonQuery MsgBox("record submitted") End Sub End Class Re: connectivity in vb.net Pankaj Garg24-Mar-07 4:14 Pankaj Garg 24-Mar-07 4:14  Sir/Madam Try ur connection string using the udl file.Hope this may help u. Pankaj Re: connectivity in vb.net Dave Kreskowiak24-Mar-07 4:24 Dave Kreskowiak 24-Mar-07 4:24  There's just about never a reason to use a UDL file anymore. Dave Kreskowiak Microsoft MVP - Visual Basic Re: connectivity in vb.net Dave Kreskowiak24-Mar-07 4:24 Dave Kreskowiak 24-Mar-07 4:24  Your connection string is bad. You're trying to use DAO (msdaora.1) which is older than dirt itself. Try http://www.connectionstrings.com[^] for using an Access database. Dave Kreskowiak Microsoft MVP - Visual Basic Re: connectivity in vb.net bhawna_k24-Mar-07 5:34 bhawna_k 24-Mar-07 5:34  i m cery new to vb.net i dont knw much abt it.whtever i knw is if i run this command on server there is no problem mycon = New OleDbConnection("provider=msdaora.1;user id=scott;data source=;password=tiger;") mycon.Open() i think for a standalone sys there should be data source value.if yes if yes can u tell wht it should be. Re: connectivity in vb.net Dave Kreskowiak24-Mar-07 5:55 Dave Kreskowiak 24-Mar-07 5:55  The full path to your Access database file. Dave Kreskowiak Microsoft MVP - Visual Basic Re: connectivity in vb.net bhawna_k24-Mar-07 6:09 bhawna_k 24-Mar-07 6:09  my database is in oracle Re: connectivity in vb.net Dave Kreskowiak24-Mar-07 7:15 Dave Kreskowiak 24-Mar-07 7:15  I just assumed you were using access. Next time, specifiy which database you're using. It makes all the difference in the world how accurate an answer is going to be. Now, which provider aare you using? If you don't know (you REALLY should!), then use: Provider=msdaora;Data Source=yourDatabaseName;User Id=username;Password=password; Dave Kreskowiak Microsoft MVP - Visual Basic Re: connectivity in vb.net bhawna_k24-Mar-07 21:25 bhawna_k 24-Mar-07 21:25  i heard frm somwhere data source should be the host string if yes then while opening oracle,there is no need for host string.i leave it blank Re: connectivity in vb.net Dave Kreskowiak26-Mar-07 2:40 Dave Kreskowiak 26-Mar-07 2:40  Then how are you going to tell it which database to use? Are you going to believe the documentation, or some rumor? Dave Kreskowiak Microsoft MVP - Visual Basic Crystal Report (Cross Tab Report) Shady Aly23-Mar-07 23:12 Shady Aly 23-Mar-07 23:12  dear all how can i make my cross tab report designed by crystal report 9.0 direction Righ-To-Left , that problem faced me because my report has data in arabic language which force me to print report in right to left format to be suitable in reading. thank you all Application Path siddhi030323-Mar-07 23:04 siddhi0303 23-Mar-07 23:04  Hi, I have a vb.Net application saved in D:\VbProject\Library.vbproj. In this folder there exists a bin folder. I want to get the application path and for that i have used following line of code: System.AppDomain.CurrentDomain.BaseDirectory. But this gives me application path as D:\VbProject\bin. In D:\VbProject , I have a folder named DownLoad and i want the path to come as D:\VbProject\Download. Please Provide me with suitable solution. Thanks Siddhi Siddhi Re: Application Path JUNEYT23-Mar-07 23:47 JUNEYT 23-Mar-07 23:47  At design time Application path is actually under bin\debug diretcory. You can use Application.StartupPath statment to address to directory. If there is no directory as named DOWNLOAD, you should consider using Environment.CurrentDirectory + "\Download" (But this is not advisable because current directiroy changes when user deals with saving and opening the documents.) I hope that helps! What a curious mind needs to discover knowledge is noting else than a pin-hole. Re: Application Path Dave Kreskowiak24-Mar-07 4:22 Dave Kreskowiak 24-Mar-07 4:22  The best solution is to copy the Download folder and it's contents to the bin\Debug and bin\Release folders so that your output folders look just like they're going to in the distribution when you install the application on other machines. Dave Kreskowiak Microsoft MVP - Visual Basic Make Source Code read only ,, vb.net 2005 kindman_nb23-Mar-07 8:29 kindman_nb 23-Mar-07 8:29  Hi... I will give the source code to others >> How can I prevent any one from edit the source code of the program >> Isn't availble on VB.net 2005 ?? jooooo Re: Make Source Code read only ,, vb.net 2005 MatrixCoder23-Mar-07 8:33 MatrixCoder 23-Mar-07 8:33  Isn't the whole point of Open Source to allow others to modify the your code? You will still have your own copy of the code, right? Trinity: Neo... nobody has ever done this before. Neo: That's why it's going to work. Re: Make Source Code read only ,, vb.net 2005 kindman_nb23-Mar-07 8:35 kindman_nb 23-Mar-07 8:35  I see .. but I still want to know . can I make the source code is Readonly.. maybe Like pdf files that you can read it only jooooo Re: Make Source Code read only ,, vb.net 2005 Dave Kreskowiak23-Mar-07 13:51 Dave Kreskowiak 23-Mar-07 13:51  No, you can't. If you give the source code to anyone, you have absolutely no hope of keeping people from making changes to it. Dave Kreskowiak Microsoft MVP - Visual Basic Re: Make Source Code read only ,, vb.net 2005 Christian Graus23-Mar-07 9:20 Christian Graus 23-Mar-07 9:20  ROTFL. There's NO way you can give someone some files, and make it so they cannot ever edit them. How could that be possible ? You can send the files out as read only. VS 2005 will ask the user if they want to over write the file. Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum ) Re: Make Source Code read only ,, vb.net 2005 kindman_nb23-Mar-07 9:23 kindman_nb 23-Mar-07 9:23  Thanks Graus .. Your respose is so enough jooooo Re: Make Source Code read only ,, vb.net 2005 Daniel Grunwald24-Mar-07 4:14 Daniel Grunwald 24-Mar-07 4:14  The best you can do is to print it out and give them the code on paper. C# to VB.NET mlauahi23-Mar-07 6:25 mlauahi 23-Mar-07 6:25  Thanks for any guidance. I am working in a gray area that I am not familiar with. I have a DLL by a third party supplier. It has a .H file and a .LIB File. So they have been created in C I am guessing. How do I wrap this DLL so that I call its functions from within VB.NET This is the C# lines from thier example: #ifdef SPOEM_EXPORTS #define SPOEM_API __declspec(dllexport) #else #define SPOEM_API __declspec(dllimport) #pragma message("automatic link to spoem.lib") ' <== add this line #pragma comment(lib, "spoem.lib") ' <== add this line #endif Re: C# to VB.NET Christian Graus23-Mar-07 6:34 Christian Graus 23-Mar-07 6:34  mlauahi wrote: So they have been created in C I am guessing. Or C++ mlauahi wrote: This is the C# lines from thier example: Are you sure ? That looks like C to me. p/invoke is how you'd call your dll in C# or VB.NET. Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum ) Re: C# to VB.NET mlauahi23-Mar-07 6:37 mlauahi 23-Mar-07 6:37  Thanks for your fast reply: I have tried: <dllimport("spoem")> _ Public Shared Function InitParameter(ByVal chSPDir As char) End Function <dllimport("spoem")> _ Public Shared Function ExitSpDll() End Function <dllimport("spoem")> _ Public Shared Function USBCommunication() As BOOLEAN End Function etc..... It says that it cannot find the DLL. I have Spoem.dll, spoem.h, and spoem.lib in the project directory. How do I point this class to the DLL. Re: C# to VB.NET mlauahi23-Mar-07 6:39 mlauahi 23-Mar-07 6:39  I am using <dllimport("spoem")> _ This line did not appear on the last post

Last Visit: 31-Dec-99 18:00     Last Update: 14-May-24 15:54 Refresh ᐊ Prev1...2683268426852686268726882689269026912692 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.