Answer Questions

• Chase Mosher datagridview sort, compare, sum

  I have a datagridview which is filled with values from a database. My code is supposed to step through and find all ingredients with the same names, sum their quantities and write the name and total to the datagrid. This should loop to eliminate all of the duplicates and then delete the initial data, leaving only the new summed totals with ingredient names. When two ingredients are encountered by my code the procedure does not properly sum all of the values. Im sure there is a better way to handle this! Thanks for any help. Me.DataGridView3.Sort(Column11, System.ComponentModel.ListSortDirection.Ascending) xcounter = (Me.DataGridView3.Rows.Count) counter = 0 ingredientsearch = " " temphaps = 0 Dim reduce ...Show All

• Sqnyy Using IsNullOrEmpty and SelectedValue

  I want to use a combobox to select an EmployeeId and pass the selectedvalue to a parameter for an SQL insert stored procedure. I want to set the combobox.selected value = (-1000) when the combobox.text is null or empty. I am having trouble setting the selectedvalue to this specific value. I have used the code below, however it does not seem to pass any value to the stored procedure: If String.IsNullOrEmpty(combobox1.Text.ToString) = True Then cmd.Parameters.AddWithValue("@intEmpId", "-1000") Else cmd.Parameters.AddWithValue("@intEmpId", combobox1.SelectedValue) End If Can someone help me out with this Thanks. Josh: A couple pointers first: combobox1.Text is alr ...Show All

• Coleby Code Compilation at Runtime?

  Is it possible to write a program that generates code at runtime, then compiles it into a DLL Try this sample program :-) Public Shared Function CompileExecutable(sourceName As String ) As Boolean Dim sourceFile As FileInfo = New FileInfo(sourceName) Dim provider As CodeDomProvider = Nothing Dim compileOk As Boolean = False ' Select the code provider based on the input file extension. If sourceFile.Extension.ToUpper(CultureInfo.InvariantCulture) = ".CS" provider = New Microsoft.CSharp.CSharpCodeProvider() ElseIf sourceFile.Extension.ToUpper(CultureInfo.InvariantCulture) = ".VB" provider = New Microsoft.VisualBasic.VBCodeProvider() Else Console.WriteLine( "Source file must have a ...Show All

• pvulcan VB.Net and bcp utility for SQL 2000

  Here is my code: Imports System.IO Imports System.Diagnostics.Process Module Module1 Public Class myGlobal Public Shared filename As String Public Shared serverid As String Public Shared driveltr As String End Class Sub movefile() Dim rv1 As New Process rv1.StartInfo.FileName = "bcp" rv1.StartInfo.Arguments = " deep_dive.dbo.dd_filelist in c:\" & myGlobal.filename & " -c -t -F4, -Smyserver -Usa -P" rv1.StartInfo.UseShellExecute = False rv1.StartInfo.RedirectStandardOutput = True rv1.Start() rv1.WaitForExit(5000) End Sub Can anyone tell me why it doesn't work Thanks, Paul Where is Global.FIlename being set does it wok when you run "b ...Show All

• Amos Soma Controlling a Windows Service from a Website

  I'm designing a web-based interface for a monitoring service. What I need right now is actually controlling the service (starting, restarting, and stopping) from this web page. I'm using Visual Basic .NET 2005 Professional as my code-behind. The website and the service are and will be running on different machines within the same network/domain. I'm already using the ServiceController class like so: Dim service As New ServiceController("Diagnostic Suite", "comp13") Select Case service.Status     Case ServiceControllerStatus.Stopped         Return "Running"     Case ServiceControllerStatus.Running         Return "Stopped"     Case El ...Show All

• xBitx Rich Text Box Cursor location

  Hi Guru's, I have a rich text box that i am appending text to all the time, and it ends up turning into a scrolling rich text box which is just great. However i would like it instead of just adding the text to the bottom, also add the cursor position to be with this new added text, so that the user doesnt have to scroll the box down to see the new text that has been added, is this possible Leads me to my second question, i have two functions which add text to this rich text box, Functions A and B is there a way to colour the text from function A to say Red and the text which gets added from Function B to say Blue Thanks in advance for your assistance. Dim MyCursorPosition As Integer ...Show All

• AlexZheng Capture Keys in Textbox, VB.net 2005:

  I'm working on learning VB.Net, using 2005, In VB 6, when you use a textbox: Private Sub txtPv_KeyPress(Index As Integer, KeyAscii As Integer) 'If the ENTER is pressed, then call the function to set the PV. If KeyAscii = 13 Then Call cmdSetPv_Click(Index) End If End Sub However, with VB.Net, when I select the "KeyPress" I get: Private Sub TextBox1_KeyPress( ByVal sender As Object , ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TextBox1.KeyPress End Sub I can't figure out how to capture the keys that were pressed using the arguments to the TextBox1_KeyPress Sub. All of the help that I can find tells me that the "KeyPress" is as: Private Sub Text1_KeyPress(KeyAscii As ...Show All

• inzel Sharing data between processes

  I need a easy way to communicate data between two exe programs that are both written in VB.net. The two programs will be running on a single system. I can make the process method work within VB.net but how can I communicate information between the two programs. The type of information that needs to be shared is about 50 string variables that each process would be modifying over a very short amount of time and sending to back and forth between each of the processes. I cannot use the client / server format with streams due to a DLL problem from a third party vendor that must be included within one of the processes. Any help would be appriciated. You should take a look at .NET Remoting. ...Show All

• agentf1 Storing an Array

  I want to store an array into a field of an Access Database, so that I can access the Array at a later date. I have create the database table using an OLE Object as the datatype for the field. I use the following code to store the array into the field named "array" Dim cnn As New Connection Dim rst As New Recordset Dim myArray() As Integer = {0, 1, 2, 3, 4, 5} rst.AddNew("array", myArray) rst.Update() This causes a {Type Mismatch} error on the rst.addnew line of the code. Any suggestions The field is defined as a "OLE Object" datatype A couple of issues: 1. you should use ADO.NET 2. The OLE Object type requires that you read and write the bytes of the object: ...Show All

• Cindy Zhong Intellisense problem: Type is not defined but build is successful.

  Hi, Some of the types in my project have squiggly underlines that indicate the types are not defined. The types are actually defined in the same namespace as the class where they are used. The project builds successfully despite the squiggly underlines. "Go to definiton" functionality of intellisense stops working for the class because of the error indicators. I have tried deleting the intellisense database file but to no avail. Does anyone have experience with similar problem The problem is not critical, however, very annoying. I am using MS Visual Studio 2005 Team Edition. Thanks. It says "Type 'LayerCollection' is not defined." while 'LayerCollection' is defined in the same namespa ...Show All

• Greenstrike OneTouch deployment: how to grand admin permissions

  Hi, All, I have published my vs 05 win app to a network location. When I run the install on client machine under user login, I got: Prereq uisite check for system component .Net framework 2.0 failed... Admin permissions are required to install. How do I grand my app the permssion so that I don't need to log in as admin at each cleint machine Thanks! Well, I found out you cann't. Have to login under admin and install the runtime 2.0, then do the regular install. This seems logical - in that the .NET framework is a shared resource on the machine and you dont want anyone to be able to just go start changing stuff in there because they are installing a ...Show All

• Will Merydith Problem in using Try/Catch/Finally

  A textbox(T_TextBox) is bound to a float-type number in a database. The innitial value of the textbox is from that column of the database. I used these codes in my program: Dim T as Double Try T = Double.Parse(T_TextBox.text) Catch MsgBox("Please enter a number for T.") Finally End Try The problem is: every time before I run the program, a message box saying "Please enter a number of T." shows up. This problem only happens at the very beggining. When I change the text later (I select another number from the database, and this is done through a combobox), this message does NOT show up. Anyone knows how to get rid of the msgbox at the begging Thanks, Lili I don't kno ...Show All

• mike6271 EventLog Frustrations [vs2003]

  I am attempting to have one of my applications write to a custom log, rather than the application log. I can write to a custom log no problem, if the source name has never been used before. I have setup the following code to recreate my problem. Any help would be great, as I thought I was making a two minute change, and eight hours later, I'm crazy! Private Sub btnCreateMessage_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) _ Handles btnCreateMessage.Click 'This call works WriteEntry("Test App", "Application") 'This call will result in the following message in the Application Log: 'The description for Event ID ( 0 ) in Source ( FileComposer ) cannot be found. ...Show All

• nhaas Array.BinarySearch Question

  Hi, i am tring to validate my user inputs by checking what Key they press, so on the KeyDown event, i did like: Private validDecKeyCodes As Keys() = {Keys.D1, Keys.D2, Keys.D3, Keys.D4, Keys.D5, Keys.D6, Keys.D7, Keys.D8, Keys.D9, Keys.D0} If Array.BinarySearch(validDecKeyCodes, e.KeyCode) < 0 Then e.SuppressKeyPress = True AlertMessage("Value entered is not a valid Decimal value (0 - 9)", control, "error") 'AlertMessage is a custom function End If i find that although i press "0", which is Keys.D0,in the Array, the result of binary search is -1, why is this so i thought if its -ve, is is because it is not found As long as the numerical values of D0 ... D9 ar ...Show All

• Bernaridho Place Points in audio.video files

  My multimedia teacher has asked us to find a term that means "to place points in the audio/video file" this term has the same number of letters as the word "redact" On the other hand, they might be elated about a "not business as usual" kinda question like this. While researching this question, I ran into a fascinating article about "placing points". Scary too. Doesn't get me closer to the crossword-puzzle clue though. My guess: re-edit.   nobugz wrote: On the other hand, they might be elated about a "not business as usual" kinda question like this... You've got to be kidding me.   Look at the other threads that get marked/locked and tell me how this one differs...  facin ...Show All