Answer Questions

• Christopher Scott VB.net connection to SQL server and inserting data

  SqlConnection = New System.Data.SqlClient.SqlConnection("workstation id=VANPC62757;packet size=4096;integrated security=SSPI;data source=MTLASR74;persist security info=False;initial catalog=vanLMS") SqlAdapter = New System.Data.SqlClient.SqlDataAdapter( ) i m trying to connect to a table in the Sql server lets say the table is called SQLTABLE do i need a dataset in order to insert stuff into sql server can someone show me a few sample line of how to insert data(or datatable) into the table in SQL server thx in advance what is the name of "InsertStoredProcedure" is it the name of the Sql table that i m inserting my data into ...Show All

• e.henriquez data storage

  As posted in another thread, I'm planning to build an accounting program. I'm wondering what would be the best way to store the data, using databases or perhaps XML There will be over 50 administrations and several users. Would one database per administration be most efficient considering one administration will usually be accessed by one user at a time Using XML probably means smaller file sizes and therefore less network traffic, but databases offer more functionality. Anyone has experience with this Any help would be welcome. Regards, Eric Eric, I think you need to read up on Databases. Specifically from what you ae saying it seems XML files are not the way to go. But It's ot clear what these ad ...Show All

• Mr Pro Tools What's the difference

  Ok folks, so I've got a program that runs code that has a FOTRAN dll that (thank god) I finally have working, for the most part.  At least it does when I pass it the path/name of a file that I've created using notepad.  Buuuut, that's not gonna cut it when it comes down to it.  What I've done is created a GUI that creates an input file for FORTRAN and all it does is write a line of text for each input in FORTRAN.  But when this VB written file,written using streamwriter or FileSystem.AppendText (I wondered if there might be a problem with the streamwriter making hidden characters but no), is passed to my FORTRAN dll and the methods native to the FORTRAN code attempt to consume the data, I run into an interesting problem ...Show All

• nsam Redirect XCOPY output from the console to a rich text box control

  Ok, this about has me tied in knots! I am trying to use xcopy in my program to copy files from one location to another location and have the info normally displayed in a console window redirected to a rich text box. I cannot get it to work. I don't get any errors. The code snippit is below. I can use "/K dir *.*" for the Arguments and it redirects fine. I am completely stumped. Dim myprocess As New Process Dim info As New ProcessStartInfo With info '.CreateNoWindow = True .FileName = "cmd.exe" .Arguments = "/K xcopy.exe C:\Test\Trash1 C:\Test\Trash2 /S /I /-Y" '.WorkingDirectory = Application.StartupPath .UseShellExecute = False .RedirectStandardOutput = True .Redirec ...Show All

• GrahamY Custom control problem

  This may well show my idiocy but here goes. I decided to build a custom control using visual basic in Visual studio 2005. I created a control library and built a control by dragging a Text Control from the tool bar. I managed to add the properties I wanted and modified the key down and key press events to accomplish what I wanted. The idea was of course to have this custom control available in many areas in a project. I then added the control library to the visual basic windows project. I am able to select the control from the toolbar in the project and add it to forms in the project. This all works (the control works as designed). The problem I have is when I add code to say the got focus event of the control in the project th ...Show All

• Johnny2006 cocatenate items from listbox

  I'm trying to figure out the correct code for joining the items of a list box into a single string. I know this must be elementary,,, So far, I've come up with this clumsy code: dim string as string = string.Empty for each me.listbox1.items string = string & me.listbox1... (I'm stuck here...) & ", " me.label1.text= string Help, please! Thanks in advance Thanks very much Your code seems far more elaborate then what I was trying. I suppose if I wanted to add 'Vbcr' to each item it would have to be like this: "sb.Append("," & vbcr), right Again thanks alex You can access the items in a list box by doing: for each item in listBox1.Items next This will iterate over all of the objects that ...Show All

• progfg MAIL MERGE VB.NET TO WORD (DATASET)

  Hi. Thanks in advance for any help. I have an application which is connected to an Access database. I run a query and I want to mail merge the "results" into Word. I have looked at other examples, but they include the actual location of the database. I need to basically send the contents of the dataset, after the query, to Word. If someone can help I would be grateful. Thanks. Thanks for the links Bruno Yu. I am running the application in vb.net (Visual Basic 2005 Express Edition). This is where my problem lies. I have looked at the link: http://support.microsoft.com/default.aspx scid=kb%3ben-us%3b301656 This is very useful and works fine on office xp. However, in the code, ...Show All

• sl0140 My.Settings Error 82 Reference to a non-shared member requires an object reference

  The specific error generated is "Error 82 Reference to a non-shared member requires an object reference." I was editing app.config to change values of my.settings for appropriate debugging, and now none of my settings can be referanced, and are completely messed up. I get a blue squiggly line calling me a retard at every referance I had to a setting before this. Any help in this matter is greatly appreciated. Did you solve this problem If so how I've got the same problem, only without editing the app.config. It was all fine, then blue lines come up and nothing is working :( I would recommend phrasing your questions more appropriately. Talking about retards is ...Show All

• mabxsi saving file to sql server.

  Hi, I couldn't update my data table. Everytime I debug my program, it's added into data table and show data successfully. When I exit my application, everything turned empty. Try Me .Validate() Me .CustomersBindingSource.EndEdit() Me .CustomersTableAdapter.Update( Me .NorthwindDataSet.Customers) MsgBox("Update successful") Catch ex As Exception MsgBox("Update failed") End Try lookup, Generally speaking, when you create a DataTable in DataSet, the table is stored in memory but not the real DBMS SQL Server. When you would like to modify your datatable, just use the DataAdapter. After the change in rows or columns, please don't forget to make the DataSet update. ...Show All

• Benwah424703 No Code is Executing on any event!

  I was working happily away on a project and all of a sudden, I ran it the form load event didnt fire. So I went to close the app with the close button on the form and that wouldn't work either. After adding a load of break points, I found that absolutely no code is being executed. I have tried deleting all the code from events and recreating them by double clicking the controls. But still no code is firing. I have tried cleaning the project and rebuilding, and I have tried deleting the debug directory to force it to recreate the build. I'm not getting any build errors and there are no errors in my code. My deadline is approaching! I hope someone can help, thanks! Try to create a simple windows applicati ...Show All

• nithinraj Performance- Code Snippet

  Hello, Any suggestions for improvement in this code snippet, performance wise [expecially since we have Generics in .net 2.0] Dim arr() As String = Split(PageRange, "-") Dim StartPage As Integer = CInt(arr(0)) Dim EndPage As Integer = CInt(arr(1)) The original value (PageRange) is a string to start with so no matter how you parse it you'll have to convert the values from strings to integers. Thanks for the responses. Split function by default returns a 1-dimensional string array. This forces me to declare my array variable as "string" although i know that my array only has integers. I think there is a performance penalty in doing the boxing from "string" to "int&q ...Show All

• Jedrzej Invisible starting form

  How can I make invisible the starting form of my application (in the form designer there is not the invisible property) thank you everybody! I won't argue with you...but a invisible window is better served as console application or service. I think you'd have to do this by begining your app from a Sub Main() so that you can instantiate the initial form, load it, then set it's visible to false. ok, i've already tryed something like that, but i did not know where is supposed to be the Main sub.. Set the Opacity on the WinForms property to 0 from 100 and watch the fun begin...<g> that's fine, thank you! thank yo ...Show All

• Pradeep Gupta Linking Two List Boxes

  Hi, I'm trying to link two list boxes. For example, in ListBox1 I have Balances, Centrifuges, and Mixers. Lets say when balances is selected, I want all of the models for balances to appear in ListBox2. All of my data is connected to an Access databse. Also Balances, Centrifuges, and Mixers are worksheets within a workbook and my models are column within balances, centrifuges, etc... How do I link them I'm a noob so use small words Thanks, Ok well i start of by saying i know nothing about programming in databases but i made a program that did a simaler thing. Ok well basically you need to creat an event to the 1st listbox sumthing like this. Private Sub ListBox1_SelectedIndexChanged( ByVal sender As ...Show All

• proecco Initialize an instance of an own class

  A question please. I instanced an own class and I set some properties, not all ones. When I ask: if myinstace.myproperty.trim() I get an error because I didn't set it. How can I initilize a property of a class if myproperty is string without initialize each property IF I do that, it is not enough... Dim myinstance As New ClassFormi Thanks... A simple example will show you two potential ways to remedy and show you why I'll explain why you are probably getting a problem You can add a default value on the field declaration - such as for Bar which will give it a default value. You could initialize a value in a constructor (whether it be a default constructor with now arguments, or ...Show All

• Thiago Tota Problems Retrieving Clipboard From a DLL Assembly, Anybody ?

  Hi, I have a problem trying to retrieve the clipboard from a dll even when the CopyToClipboard returns 1 (the data was succesfully copied to clipboard) anybody : Call pdfPage.CopyToClipboard(pdfRect, 0, 0, 100) Dim clipboardData As IDataObject = Clipboard.GetDataObject() If (clipboardData.GetDataPresent(DataFormats.Bitmap)) Then <<<----- Here's the problem because clipboard is empty Dim pdfBitmap As Bitmap = clipboardData.GetData(DataFormats.Bitmap) ....... The funny thing is that running this code in a windows.form works perfectly, can data be copied to the clipboard from a dll Thanks in advance for your help. George Basically this is how I copy it, and yes, ...Show All