Nobody1234's Q&A profile

• .NET Development Execute a list of SqlCommands

  My client/server architecture is designed in a queued fashion: the client may send many messages to the server, and from there, the server will create SqlCommand objects, and execute each one in SQL server. What I'd like to do is find a more efficient way to execute lots of commands; currently, I do: // open a connection SqlConnection connection = new SqlCommand(...); // create a command SqlCommand command = new SqlCommand("DoSomething" ...Show All

• .NET Development SQL syntax for query notification

  Does any one know if can use a function like getdate() in a select query For example: " select recid, mydata, mydate from dbo.testout where mydate < getdate()". Thank you ...Show All

• .NET Development how to show string of data in text box using parmeter query

  I am tryin to input an ID number and retrieve all the information from that particualr ID Private Sub btnSubmit_Click(Byval sender As System.Object By val e As System.EventArgs)Handles Button1.Click connClass.Open() Dim cmdStudents As New OleDb.Command Dim sStudents As String = Select Student Name, Information From ClassName Where Student ID = cmdStudents.CommandText = sStudents daStudents.SelectCommand = cmdStudents Dim cb ...Show All

• Visual C# How can I make Wizard?

  I want to make wazard same as PropertySheet or programming install dialog that use next, prev button. I look for TabControl, but I don't fine method. Could you help me Unfortunately WinForms doesn't include a standard wizard control as is (for some reason). You can generally find some pretty good open source wizards on CodeProject.com. Unfortunately, i couldn't locate the link to the last one that i us ...Show All

• Microsoft ISV Community Center Forums VLookup returns "Error 2042" when there is not match. How can I identify it pragrammaticaly?

  Hello all, I am new to VB so my question probably sounds silly! I would like to use VLookup function but I cannot handle the return value when the function does not find the parameter. I get a "Error 2042". I dont know its actuall format. Is it only a string I tried to check it with the Aplication.IsNA() and IsEmpty() message but they don't work correctly. Do you know how can I solve this problem Per our su ...Show All

• Visual Studio Express Editions Can't start setup process for Visual Studio 2005 Express(Beta 2)

  How I did(my OS is WinXP Prof with SP2): 1. Download full copy of Visual C# 2005 Express Edition Beta 2(492,204 KB) 2. Mount it as CD-image. All fine, I can read/launch files from packaging. 3. Launch setup.exe in root. 4. Little window appear in the center of display and show how files are copying in Temp-folder. 5. Next this window closed. And that's all. No error/warning messages, no info message boxes... Nothing. So all setup.exe done is c ...Show All

• .NET Development DG Bound TAB Controls

  Sometimes the adjacent bound TextBox/Combox controls shown on the Tab of the ADO.Net Form displays the proper Datagrid row cells contents correctly and other times, for a select row, the controls doesn't display anything for a particular DG row.  The base Tab (first Tab ) seems to display everything fine. Do I have to null out the controls before the selections Steve  ...Show All

• .NET Development Opening a file in Isolated Storage

  Hi, I have just started to use isolated stoage for something but already I'm a bit stuck. I store file attachments in a database, when my application needs to open one of these attachments I'm creating a copy of the file in Isolated Stoage, but what I then want to do is use Process.Start(<filename>) to invoke whatever app is associated with the file extention of the attachment. The problem is that I need the absolute path of the file. Is i ...Show All

• Windows Forms Called Forms referencing calling Forms controls

  I have a form A that calls the Form B. I know that if i put the modifiers of textbox in the Form A i can reference it from form B. But, all textboxes that i have in form A are created on the fly and i cannot use the&nbs ...Show All

• SQL Server Merge views with .nodes xml data type method

  I have two views listed below that get attributes at there respective levels ‘//BHILeads/Lead/Contact’ and ‘//BHILeads/Lead/PropertyInterest'.   What I would like to do is make one view, but I don’t know how.   I looked at the examples in AdventureWorks and they all use target name spaces.   Do I have to use target name spaces to merge these views         ALTER VIEW [dbo] . [Is_vwBHI_ ...Show All

• Windows Forms Control the size of the Context Menu Popup?

  I have a context menu: m_AddRowContextMenu = New DMS.ToolBox.ContextMenuStrip() Add some Items (200 maybe...): For i As Integer = 0 To 200 m_AddRowContextMenu.Items.Add("Item" & i.ToString() ) Next Show the context Menu: m_AddRowContextMenu.Show(Me, mousePoint) The popup is HUGE! I want to show about 20 Items, with scrolling. I can't figure out how to change the size of the popup. It makes i ...Show All

• Windows Forms Getting currently selected value from Dropdownlist box!

  Hi all! How can I get the currently selected value from a dropdownlist box and compare it with a result from a dataset specific field Thank you ! Thank you for your help but still I have a problem.Here is the code but it is giving me always the value at Index 1. I want to check the availability of the currently selected DDL value from the value returend in the Dataset and if it exist to appear as a selected value for DDL: string s ...Show All

• Windows Forms OutOfMemoryException error

  Okay, I know that this was discussed in another thread.  However, the problem I'm having is totally different.  My error occurs with almost any application.  I can open a project with VS 2003, a very simple one form like hello world.  ...Show All

• .NET Development Searches IN vb.net and access

  Im currently developing a booking system. I am the point now where the allocations are made. however i want to install a facility whereby the product cannot be booked by a customer if it is already booked for the particular day/week. How would go about doing this I know that i should do a DoWhile loop. But in doing so will it check all the entries of a given product in the booking table or stop at the first one it finds How would i code ...Show All

• SQL Server Strange cube processing error

  We have a bit of automation that creates a relational star-schema database and deploys and processes an SSAS2005 database (using an XML/A deployment script). Sometimes (but not always) during this process an error is thrown: Errors in the high-level relational engine. The following exception occurred while the managed IDbCommand interface was being used: A transport-level error has occurred when sending the request to the server. (pr ...Show All