Bondforever's Q&A profile
SQL Server Parameter Mapping in an Execute SQL Task
I am trying to assign the same package variable value to three different parameters in a query. The variable contains the name of a database which the user will input during package execution. First I check to see if the database exists (if it does I drop it), then in either case I create the database. See code: if exists ( select name from sys.databases where name = ) begin drop database ; end ; go create database ; go This is the error I am getting: [Execute SQL Task] Error: Executing the query "if exists ( select name from sys.databas ...Show All
.NET Development I have trouble updating a table in my SQL database from my updated Dataset
Hi, I populate my dataset, that has more than one table, the first time using dataadapter and a view like this: cm.CommandText = "SELECT * FROM vwFeat where SubNmbr=5142062279" da.SelectCommand = SqlSelectCommand1 da.Fill(ds, "TblFeat") Then, I update my dataset "ds" with an internal process by adding, deleting and updating rows (for now i m interested in updating rows) Please how do I update that first table "TblFeat" in my SQL server database from my modified dataset "ds" Thanks a lot, ...Show All
.NET Development Windows Event Viewer
HI, I developed an application in C# and would like to display the errors of my application into Windows Event Viewer. Can anyone help me out. Thanks This can achieved using the System.Diagnostics.EventLog.WriteEntry() method. More information at: http://msdn.microsoft.com/library/default.asp url=/library/en-us/cpref/html/frlrfsystemdiagnosticseventlogclasstopic.asp ...Show All
Windows Forms Hoe to get menustring for ownerdraw menu
Hi all, I am trying to get the menu string of the owner draw menu createdin the C# application. Iam using the GetMenuString API to get the menus text property. But I could not. Can any one please help me to get menu string through API. If I create windows menu bar(make ownerdraw property to FALSE) , then I could able to get the str ...Show All
SQL Server installation bug found SQL Server 2005
Hi! I had the earlier builds and this did not happen but: just downloaded SQL Server 2005 (RTM) from msdn When selecting to install integration services (amoungst other options), whilst installating it gives me an error saying I do not have admin privledges to install one of the .NET libraries/runtime files I cannot remember the file name at all im afraid. Error: 0x80131501 So I cancelled the install and just installed everything but the integration services... and it works fine now. I do not know if this is a bug but just thought I would let you know Issue resolved. see my new thread about installation issue resolved http://forum ...Show All
Windows Forms ToolStrip items disappeared
All items on my ToolStrip control just disappeared. I can access the items in code but they are not visible on the ToolStrip control. Neither at design time nor at run time I can see them. Just clean ToolStrip. I just wonder if there is a way to get them all back without recreating I have solved it. I found out that when the very first ToolStripItem gets added to a ToolStrip control the Designer adds ToolStrip.Items.AddRange() statement. The statement is located where the ToolStrip properties are set. I didn't find such a string so I had to add it and all started working. I still have no idea why the Desinger deleted the line ...Show All
Visual C++ Progress Bar assistance
I am new to using Visual C++. I used a Control box in the Resource view tab to create the progress bar in the dialog box. This puts all the information in one file. In another file, I want to update the same progress bar so that it looks like it is downloading. How do I do that I've tried everything I could think of which is not much since I am new to this and they don't work. For example: one file Progress.cpp: Member variable,m_pBar, is what I created for Progress Bar using the class wizard. It was automatically put in this file. Update.Cpp I want to update the progress bar in Progress.cpp so that it looks like I am downloading while I ...Show All
.NET Development send byte[] and recive byte[] System.IO;
ok,, i have the next problem... i am creating a client server program ,,, i allready know how to send text trough tcp with a networkstream.. then a streamreader and a streamwriter... it works good with text... but the problem is when i try to send a byte [] ,,, i have a image and i use a memorystream to convert it to a byte [] and i want to create the image in the server when i got he image,, i allready know how to do that... what i dont know to do,, is how can i send a byte [] im trying to send the image this way,, when i allready have the byte [] i do this: //here i call a function that returns me a byte[] of the image byte[] con ...Show All
Visual Basic Special Directories
Is there a way to find the path to a users start menu (in order to install shortcuts). I tried special directories but I couldn't find it. Thank you. The following will get you the user start menu Function ReturnUserStartMenu() As String Dim DirInfo As System.IO.DirectoryInfo = System.IO.Directory.GetParent(My.Computer.FileSystem.SpecialDirectories.Programs) Return DirInfo.FullName End Function This is using My.Computer.FileSystem.SpecialDirectories.Programs which gets you the users Start menu Programs Folder ...Show All
Visual Studio Express Editions capture Control-Enter keystroke
In one of my programs I use e.KeyCode = Keys.Enter to tell when the Enter key is pressed while the focus is on a textbox. I want to be able to capture when ControlEnter is pressed. In the IntelliSense picker there is an option for CTRL modifier, but nothing for CtrlEnter. So how do I combine the two to capture a ControlEnter keystroke I tried e.KeyCode = Keys.Control + Keys.Enter but that doesn't work. Thanks... How about: If e.Modifiers = Keys.Control And e.KeyCode = Keys.Enter Then Debug.WriteLine( "you pressed control enter" ) ...Show All
.NET Development Saving my data to file?
I have a whole bunch of different objects that I want to save to file. Is there an easy way to do it And if so, can I have a nudge in the right direction Thanks, Devin A sample is here (using XML serialization): http://www.codeproject.com/csharp/xml_serializationasp.asp ...Show All
.NET Development HTTP GET inside Visual Basic .Net 2003
I can only use SOAP and HTTP POST method for the Web Services request and response. How can I use HTTP GET method Hello Xa, Douglas is right. Take a look at the following article for more information: 819267 INFO: HTTP GET and HTTP POST Are Disabled by Default http://support.microsoft.com/ id=819267 Cheers, -Todd Foust ...Show All
Windows Forms Custom control in a column of a Listview
Hi, I want to have some customized controls in a column of a Listview control (of course when the view is set to deyails). The custome control might be a comboBox or some images or a textbox. Thanks in advance. Kundan Hi all I'm interested in the same subject as I needed to add some controls to the columnHeaders of the listview. I had made some success in that but with problems. First I increased the height of the columnHeader by using the sendmessage API to retrieve the handle of the columnHeader using the ( LVM_GETHEADER) then calling the SetWindowPos to change the height. then I used the ...Show All
Windows Forms showModalDialog Form Problem
I have two web forms Form1 & Form2 Form2 is called from Form1 as a showModalDialog from a javascript function var WinSettings = "resizable:no;dialogHeight:600px;dialogWidth:600" var result = window.showModalDialog("Form2.aspx",null, WinSettings); Form2 has a Listbox, a Label and button. The SelectedIndexChanged() method of the listbox (autopostback set to tr ...Show All
.NET Development C#/VB.NET on linux
Hi, I have windows forms application writed in C# and VB.NET. How can I run it on linux Thank's Alexei Hi, In addition to what JBrown said, the .net framework is some-kinda ms-os dependent. I mean yes, you could run your program in a Linux OS. But not all .net functionalities are present. And as the previous post said " MS is not supporting the building of the .Net CLR for any non-MS OS " yes this is true, and by that, non-ms .net framework would always be 1 version behind... cheers, Paul June A. Domag ...Show All
