Visual Basic

FirstPrevNext

Problem with insert command fitz2345678-Dec-05 2:13 fitz234567 8-Dec-05 2:13  Hi All, Hope someone can help me on this I have written an insert command in VB for a connection to a MySQL database here is the code - cmdSelect = cnn.CreateCommand cmdSelect.CommandText = "SELECT Transaction_No, User_ID, Expiry_Date, " & _ "Expiry_Date_Hex, Product_ID, Update_Date, Key_Serial_No, Developer_ID, " & _ "Locking_Code, Unlock_Code FROM KeyIssueDetails" mda.SelectCommand = cmdSelect cmdInsert = cnn.CreateCommand cmdInsert.CommandText = "INSERT INTO KeyIssueDetails(Transaction_No, User_ID, Expiry_Date, Expiry_Date_Hex, Product_ID, Update_Date, Key_Serial_No, Developer_ID, Locking_Code, Unlock_Code) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" prm = cmdInsert.Parameters.Add(New Microsoft.Data.Odbc.OdbcParameter("Transaction_No", Microsoft.Data.Odbc.OdbcType.Int, 0, "Transaction_No")) prm = cmdInsert.Parameters.Add(New Microsoft.Data.Odbc.OdbcParameter("User_ID", Microsoft.Data.Odbc.OdbcType.VarChar, 50, "User_ID")) prm = cmdInsert.Parameters.Add(New Microsoft.Data.Odbc.OdbcParameter("Expiry_Date", Microsoft.Data.Odbc.OdbcType.DateTime, 0, "Expiry_Date")) prm = cmdInsert.Parameters.Add(New Microsoft.Data.Odbc.OdbcParameter("Expiry_Date_Hex", Microsoft.Data.Odbc.OdbcType.VarChar, 50, "Expiry_Date_Hex")) prm = cmdInsert.Parameters.Add(New Microsoft.Data.Odbc.OdbcParameter("Product_ID", Microsoft.Data.Odbc.OdbcType.VarChar, 50, "Product_ID")) prm = cmdInsert.Parameters.Add(New Microsoft.Data.Odbc.OdbcParameter("Update_Date", Microsoft.Data.Odbc.OdbcType.DateTime, 0, "Update_Date")) prm = cmdInsert.Parameters.Add(New Microsoft.Data.Odbc.OdbcParameter("Key_Serial_No", Microsoft.Data.Odbc.OdbcType.VarChar, 50, "Key_Serial_No")) prm = cmdInsert.Parameters.Add(New Microsoft.Data.Odbc.OdbcParameter("Developer_ID", Microsoft.Data.Odbc.OdbcType.VarChar, 50, "Developer_ID")) prm = cmdInsert.Parameters.Add(New Microsoft.Data.Odbc.OdbcParameter("Locking_Code", Microsoft.Data.Odbc.OdbcType.VarChar, 50, "Locking_Code")) prm = cmdInsert.Parameters.Add(New Microsoft.Data.Odbc.OdbcParameter("Unlock_Code", Microsoft.Data.Odbc.OdbcType.VarChar, 50, "Unlock_Code")) ' mda.InsertCommand = cmdInsert prm.SourceVersion = DataRowVersion.Original prm.Direction = ParameterDirection.Output mda.Fill(mds, "KeyIssueDetails") DGMain.DataSource = mds DGMain.DataMember = "KeyIssueDetails" My Problem is that the command works fine bar the last parameter. "Unlock_Code" comes back as NULL even though the dataset accepts the data I enter. I am fairly new to this so I may just be missing something obvious but any help would be great I can't figure out where I went wrong. dll registration problem uktrips0077-Dec-05 21:47 uktrips007 7-Dec-05 21:47  hi dear I m facing a problem.I have devlpoped a dll file in vb.net.now I want to register it.while registration with regsrv32 it gave me message as follows. "dll file was loaded, but dllRegisterServer entry point was not found. file can't b registered" I don'tknow how to solve this error. please help me...... thank you be the best... registering dll problem uktrips0077-Dec-05 21:46 uktrips007 7-Dec-05 21:46  hi dear I m facing a problem.I have devlpoped a dll file in vb.net.now I want to register it.while registration with regsrv32 it gave me message as follows. "dll file was loaded, but dllRegisterServer entry point was not found. file can't b registered" I don'tknow how to solve this error. please help me...... thank you be the best... Re: registering dll problem Gerben Jongerius7-Dec-05 22:08 Gerben Jongerius 7-Dec-05 22:08  For as far as I know it is impossible to register .Net dll's with RegSvr32, its not supported. This should not be a problem when you only use this DLL in other .net projects. However if you want other projects to use the DLL you can try regasm.exe which allows COM clients to create .NET Framework classes transparently. For more information on this I advice you to read this article on the tool. Re: registering dll problem uktrips0077-Dec-05 22:15 uktrips007 7-Dec-05 22:15  Thanks for ur prompt answer.But I have to use it in ASP coding.and I think without having register it I couldn't use it in asp coding.if u know the way by which i can use this dll in asp coding without registering it tell me pls.and regasm.exe is not there in window xp as it shows error:"window can't find regasm.exe" Help me pls........... be the best... Re: registering dll problem Gerben Jongerius7-Dec-05 22:48 Gerben Jongerius 7-Dec-05 22:48  I take it the .Net framework is installed. This should include the regasm.exe program in its root directory. The location is usuallay 'C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322', though the version number could vary pending on the version you are using. Re: registering dll problem uktrips0077-Dec-05 23:32 uktrips007 7-Dec-05 23:32  how can i use this.I've got regasm.exe.if i double click it just flash once on screen and become unvisible.using command prompt i tryed but same result, tell me the way i should Use. Thanks n regards Uttam kumar be the best... Re: registering dll problem Gerben Jongerius8-Dec-05 2:17 Gerben Jongerius 8-Dec-05 2:17  Its easy, just open your command prompt and type: Register: %windir%\Microsoft.Net\Framework\v1.1.4322\RegAsm.exe <library> Unregister: %windir%\Microsoft.Net\Framework\v1.1.4322\RegAsm.exe /unregister <library> Replace <library> with the name of the DLL (include the full path) Re: registering dll problem uktrips0079-Dec-05 0:42 uktrips007 9-Dec-05 0:42  Thank you Gerben Jongerious! I got my Answer. Thanks a lot. Uttam Kumar;) try to be the best... whereever you go, Re: registering dll problem uktrips0079-Dec-05 2:24 uktrips007 9-Dec-05 2:24  hi dear I have register my dll file on server.but after using it in my asp coding it shows incorrect program id.could u tell me y it is so? try to be the best... whereever you go, Re: registering dll problem Gerben Jongerius9-Dec-05 7:22 Gerben Jongerius 9-Dec-05 7:22  Each class in your dll should have its own progid. This will include the full namespace, you can check that by using regasm and exporting to a register file instead of directly into the register. (add /regfile:<dllname>.reg So if I have a class in the VB.Net DLL called Test in a project called Test1 the full progID name should be Test1.Test and not just Test. However you can set a custom ProgID for each class with the ProgIdAttribute, see MSDN Article for more on that attribute. Re: registering dll problem uktrips0079-Dec-05 18:59 uktrips007 9-Dec-05 18:59  I did so now when i call the function of this class in dll it shows me that Microsoft VBScript compilation error '800a0414' Cannot use parentheses when calling a Sub /uttam/dlltest/test.asp, line 14 myObject.callweb(intvalue,i) ----------------------------^ I used myObject=Server.CreateObject("dllkeysearch.Class1") where dllkeysearch is dll project name and Class1 is the class name. try to be the best... whereever you go, Alternative of Debug.Print() in .Net kumar_Chandan7-Dec-05 19:35 kumar_Chandan 7-Dec-05 19:35  Dear, In VB we have Debug.Print() which prints on Immediate window. In VB.Net do we have something which print on Immediate window. Now I am using Debug.WriteLine() which prints on Output Window. I want debug message to be printed on Immediate window. Thanking you. Regards, Chandan Kumar Gupta. Re: Alternative of Debug.Print() in .Net Dave Kreskowiak8-Dec-05 4:24 Dave Kreskowiak 8-Dec-05 4:24  There's nothing that targets the Immediate window. All the Debug outputs are sent to the Output window. This has nothing to do with VB itself, rather it's how the Debug class works. I don't know of any classes that will target the Immediate window. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome [Message Deleted] kumar_Chandan7-Dec-05 19:25 kumar_Chandan 7-Dec-05 19:25  [Message Deleted] Re: ListBox in .Net Gerben Jongerius7-Dec-05 21:52 Gerben Jongerius 7-Dec-05 21:52  I am presuming that the adding is going correctly. If that is the case then you can simply use the property SelectedItem or SelectedIndex to select the item in the second listbox. So an example is: <br /> lbBox2.Items.Add(lbBox1.SelectedItem)<br /> lbBox2.SelectedItem = lbBox1.SelectedItem // can be set and read<br /> Note that this only works if you put the reference of the first listbox in the second and not a copy. Hope that this helps you a little bit. Exporting data to msword sreejaps7-Dec-05 19:22 sreejaps 7-Dec-05 19:22  Hi I am working on a VB.net application, from which I need to export data to MS Word in a tableformat.I can export the data to MS Word. Now i want to Display it in a table format. Can anyone suggest any ideas for exporting Data to MS word. I couldnt find any helpful topics on net. I need it urgently Please help.. Thanks in advance... Re: Exporting data to msword uktrips0077-Dec-05 22:00 uktrips007 7-Dec-05 22:00  Dear sreejaps the best way to export ur data to ms word in tabular format is to create an html file and create table store ur data. but while saving u must save it with .doc extension.since word understand html formatting ur document in ms word will show ur data in tabular format.use the following code to create a file and open it in word format. code for writing in data dim fname as string dim ofile as filestream dim owriter as streamwriter fname = "search.doc" ofile = New FileStream(fname, FileMode.Create, FileAccess.Write) owriter = New StreamWriter("ur content in html formatting goes here") owriter.close owriter=nothing ofile=nothing code for opening it in ms-word Dim word_app As New Word.Application() word_app.Documents.Open( _ fileName:=Path.GetFullPath("search.doc"), _ ConfirmConversions:=False, _ ReadOnly:=True, _ AddToRecentFiles:=False, _ Format:=Word.WdOpenFormat.wdOpenFormatAuto) word_app.Visible = True Happy Programming Thanks n Regards Uttam Kumar :-> be the best... Re: Exporting data to msword sreejaps7-Dec-05 23:06 sreejaps 7-Dec-05 23:06  thank u so much .It helps me a lot Regards Sreeja SSTab Sasmi7-Dec-05 17:58 Sasmi 7-Dec-05 17:58  Can i add new tab in SSTab control at the run time Sasmi Re: SSTab Dave Kreskowiak8-Dec-05 4:18 Dave Kreskowiak 8-Dec-05 4:18  Yes. See the documentation[^] on SSTab, Tabs property on MSDN. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome The InterfacePrg service terminated unexpectedly. It has done this 2 time(s). miceisland7-Dec-05 15:57 miceisland 7-Dec-05 15:57  Need help, anybody know what is this message in the application log means. "The description for Event ID ( 105 ) in Source ( InterfacePrg ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: ." after this message comes up, then my services just suddenly terminated, then i have to restart my services again. program is created in VB6, running as services. Mike Reading Textfiles ADY0077-Dec-05 11:05 ADY007 7-Dec-05 11:05  Hello, I am saving a textfile from a form and I am saving it example: Name & "|" & Surname etc..! I am seperating each income with a "|"! Now how can i read The name then the surname! I dont want the '|' to be seen of course! I want to read behind the | and after the |! Help me please!! Adrian De Battista Re: Reading Textfiles Curtis Schlak.7-Dec-05 11:08 Curtis Schlak. 7-Dec-05 11:08  You might be interested in the String.Split() method. "we must lose precision to make significant statements about complex systems." -deKorvin on uncertainty Re: Reading Textfiles ADY0077-Dec-05 11:27 ADY007 7-Dec-05 11:27  But if i have more than 1 '|' what can i do!?? Adrian De Battista

Last Visit: 31-Dec-99 18:00     Last Update: 6-May-24 20:42 Refresh ᐊ Prev1...3742374337443745374637473748374937503751 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.