Dottj's Q&A profile

• Windows Forms How to display two columns in dropdownlist of combo box?

  Hi I have a combobox to display the following in drop down list (I am using VB.net or VS 2005). Apple Peach Mango So How to make the dropdown list to display the following (Two Columns). (In access database you can add many colums to the combobox's dropdownlist) Apple | Fruit Peach | Grade Mango | Tropical After made the selction only the single column should display in the combobox Apple or Peach or Mango Advance thanks Hi,vaish,here is another demo which may suit for you a little more. I think  this demo can tell you  more details. =========================== "  The standard combobox doesn't support multiple columns. Use solutions on codeproject like Multi column Combobox vb.Net Multi Colum ...Show All

• SQL Server How to migrate from server to server.

  Hi, I could do migration from one database to another on the same server.But not sure how to do when it comes to server to server.Can anyone explain this Iam sending data from one database on one server to another database on another server..... In ssis when i try to put connection manager and refresh, the source server is not shown....what should i do pls help! Regards, pls help! Regards, sg. Hi jamie, iam connecting to the source database using a different server name.iam using OLEBD provider for Sqlserver.IAm adding different connection manager only. but it is giving the following error Test connection failed because of an error in initializing provider.[DBN ...Show All

• Visual C# WebBrowser hyperlink click events

  I am using a webbrowser control in my C# application. I would like to know if there is any way to capture the URL of the hyperlink that I click. I need to suppress the default navigation of the browser and process the captured URL in my own way with some modification. Any input on this would be greatly appreciated. Thanks, pravi Hi, you could capture clicked url in the WebBrowser's navigate event and cancel the default navigation to the target Url, something like in the following code: private void webBrowser1_Navigating( object sender, WebBrowserNavigatingEventArgs e) {     if (e.Url.AbsoluteUri == " http://www.yoursite.com ")     {   & ...Show All

• SQL Server Can a non-admin user generate a create database script?

  I am trying to generate the create database script using SMO. The issue is the user account which connects to SQL server is not SA, SMO fails to generate the "Create Database" script with error User ZZZ\User1 does not have permission to run DBCC SHOWFILESTATS. Is it possible to generate a "Create database" script using SMO when you are connecting to the SQL server using NON-ADMIN account The user login is a part of db_Datareader role on the database. I tried following grant permission to the concerned account at server level Grant view any database, grant view any definition and grant view server state. Still it fails. Any idea Adamus, just to test things, i made the user D ...Show All

• SQL Server How to store large chunks for binary data into the DB?

  From what I can see, the 'varbinary(max)' data type is not supported, and the 'image' data type is supposed to go away. Is there some other way to store large chunks (10MB to 100MB) of data into an SSEv DB If I have to use the 'image' data type to so this, does anyone have a code sample that would let me push an array() of numbers into an 'image' field, and unload an 'image' field into an array() TIA Pat OK, say you have huge files in the DB. Now, how you going to work with them Run DataReader and load them into memory How you going to update them Say, you need to change one bit in a huge file. With file system you open a file, seek to position and change this bit. With database you have ...Show All

• Microsoft ISV Community Center Forums use inputbox to choose cells for plots in excel

  Hi all, The below code would I like to change so I can use the inputbox arrays 'usr_choice_x' and 'usr_choice_y' (instead of the range "A68:B89" as it is now) for the plot. How do I do that Grateful for ideas usr_choice_x = Application.InputBox(Prompt:="Select x cells ", Type:=64) usr_choice_y = Application.InputBox(Prompt:="Select y cells ", Type:=64) Charts.Add ActiveChart.ChartType = xlXYScatterSmoothNoMarkers ActiveChart.SetSourceData Source:=Sheets("MDO_061013_LHS_HP").Range( _ "A68:B89"), PlotBy:=xlColumns ActiveChart.Location Where:=xlLocationAsObject, Name:= _ "MDO_061013_LHS_HP" With ActiveChart .HasTitle = False .Axes(xlCategory, xlP ...Show All

• Visual Basic Text File Parsing

  Sorry if this seems a little stupid, I'm an IT guy, not a programmer. heh. ok, I have a pretty large text file. about 8000 lines. It has a structure similiar to below: SectionName = { ["ItemName1"] = { ["Attribute1Name"] = "text value", ["Attribute2Name"] = int value, ["Attribute3Name"] = { ["SubAttribute1Name"] = "text value", ["SubAttribute2Name"] = int value, } ["Attribute4Name"] = "text value", } ["ItemName2"] = { ---similiar items as above, but not ...Show All

• Windows Forms .NET 1.1 or 2.0 ?!

  Hi Guys, Ive written an application that requires .NET 1.1 and works fine if you have it installed. My problem is that when people with .NET 2.0 try to install my application they are forced to install 1.1 by the installer. Is there a way to stop this as my application should work with either 1.1 or 2.0 Ideally I would like it to force people to install *any* version of .NET ... Thanks in advance Todd As far as I can tell this works. I tried a VS 2005 setup project with the launch condition wanting framework version 1.1.5555, and AllowLaterVersions=True. 1.1.5555 does not exist, but I do have the 2.0 framework and the setup started fine without asking for 1.1.5555. I think th ...Show All

• SQL Server Upgrade SQL 2000 SBS to SQL 2005 64 Bit

  I am in the beginning of upgrading a SQL 2000 DB on a Small business server to a 64 bit 2005 DB on a new box. Is my best method of upgrading to use the "copy" DB function in 2005 If so, what do I need to do to install the management tools on the 2000 box - since this is a 32 bit edition, and I have the 64 bit media You could take a backup on the 2000 server and restore it on your 2005 server. Create the same users on the new server that where on the old server. After restore run sp_change_users_login 'report' in Management studio or Query Analyzer. If names come up in the list you need to map the users in the database to the users in the 2005 server. Create a script that runs sp_change_users_lo ...Show All

• Visual Studio 2008 (Pre-release) PeerChannel - System.NullReferenceException on connect, intermittent

  We are seeing the following PeerChannel problem occur at connect time - intermittently, but daily for the customer. Null reference exception Occasionally, when someone connects, they get a null reference exception like the one shown below. A second attempt to re-connect works the majority of the time, but not from the same AppDomain (e.g. we have to shut down and re-launch the application program). System.NullReferenceException: Object reference not set to an instance of an object. Server stack trace: at System.ServiceModel.Channels.SocketConnectionInitiator.ConnectAsyncResult.StartConnect() at System.ServiceModel.Channels.SocketConnectionInitiator.ConnectAsyncResult..ctor(Uri uri, TimeSpan timeo ...Show All

• SQL Server How to import flat files into Microsoft SQL 2005 Express Edition automatically?

  Iam aware that Microsoft SQL 2005 Express Edition does not have agent or DTS capabilities, but how may I automate an import of flat files to the DB tables Must I use an external VB development of is there a way to schedule an import of flat files to Microsoft SQL 2005 Express Edition hi, Kraven3d wrote: Here is a sample of the data and what I need to do with it. 1ETTX800401V411TTX BNSF851293 1ETTX800913V411TTX BNSF840295 This data needs to be brought into the data base as: 1 ETTX 800401 V 411 TTX BNSF 85 1293 1 ETTX 800913 V 411 TTX BNSF 84 0295 The seperation will ALWAYS occur after the 1, 5, 11, 12, 15,19, 23, 25 & 29th characters. Do you have any idea how I can accomplish t ...Show All

• .NET Development colon

  Hi gurus I am new to c# or dot net i am having n xi interface which sends a soap msg to the webservice ( genrated by dot net ) . this soap message has a "ab1:" which is not accepted by the webservice and the receiption is failed . i would like to eliminate the "ab1:" from the soapmessage "ab1:acknowledgementsbase x mlns:ab1 = " urn:xxxxx.com/xi/utils.acknowledgements" Please advice on this its a burning issue right in my company thanks Hi first lemme appreciate the patience u r trying to help me and understand the problem. forget about XI interface, I have a soap that is sent to csharp or dotnet which is having a "ab1:" from the namespace . i need to eli ...Show All

• Visual Studio Team System source control

  does visual studio team system for database professionals incude source control if yes, is the source control at the database level meaning if someone goes into Management Studio will they "see" that a stored procedure is currently checked-out and then they cannot modify that sp. there needs to be something to prevent a dev or dba from going to SSMS. Until then there exists a hole in the source control process in VSTS for database code. ...Show All

• Visual Basic Missing A Namespace?

  I cant seem to find the Microsoft.VisualBasic.CompilerServices namespace, its just not there. any ideas i even repaired the framework Go to this page and we will have an answer: http://msdn2.microsoft.com/en-gb/library/microsoft.visualbasic.compilerservices.aspx ...Show All

• SQL Server ErrorColumn field from Datasource Error Output

  Hi, The problem is, ErrorColumn contains ID. Is the following code reference safe columnname = Me.ComponentMetaData.InputCollection.FindObjectByID(Row.ErrorColumn).Name Is there any possibility for FindObjectByID to return NULL Reference in any case Fahad349 wrote: Why I couldnt That sucks Because the column ID is the metadata ID of the column in the previous component, not the current component. So the ID being passed in isn't in the current component's metadata. Indeed it isn't the best situation. ...Show All