thegrave's Q&A profile

• Visual Basic Newbie need help with excel oleDB INSERT INTO COMMAND

  hi, I am working on a project and what i am trying to accomplish is i want this particular code to save the values from mutiple text boxes into a excel file. When i run the code I get a exception error mesaage that states, "Syntax error in INSERT INTO statement". P.S. Also I was wondering once i solve this problem, i have another problem i would like to solve that is, excel will hold a maximum of 256 sheets, and 65536 rows and i was w ...Show All

• Visual Basic [VB.NET VS2005] Multicolumn combobox

  Hello, I'm new with VB.net and I've found a code that I use to do a SQL query on ACCESSDB and it return me a datagrid. For Exemple, I do a query on my tbl_person : "SELECT id_person, person_name, person_birthdate FROM tbl_person" After that, I want to show this result in a combox box, but I don't find how to have 3 columns (id, name and birthdate) with the id hidden. Usually, I work with Access forms, but I want learn vb.net. ...Show All

• SQL Server missing SSIS configurations...pls help.

  http://img96.imageshack.us/my.php image=untitled5ia1.jpg how come my SQL 2005 surface area configuration don't have the configuration for SIS and other settings seems to be missing alot of settings...it only say SQL 2005 Express when I m using SQL 2005 enterprise.... It would indicate that you have not installed any other services. What OS is this, Enterprise requires a server OS. Check Services in Contr ...Show All

• Visual Studio Team System How to transition a team to TFS source control, etc.

  Our small team is using VS 2003 and Source Off Site (SOS). We plan to transition to VS 2005 and TFS. The transition is proving to be difficult and we now find ourselve strategizing about how to pull it off. Which course is preferred 1) Install VS 2005 and convert our solution to VS 2005 first while continuing to use SOS; then set up a TFS server later and figure out how to switch over to source control in TFS. 2) Set up TFS first, install VS 20 ...Show All

• .NET Development Using FtpWebRequest to check if a directory exists.

  I'd like to know if there is anyway i can use the FtpWebRequest class to check if a directory exists before creating it on the server. The reason i ask is because if you try to create a directory that already exists it throws a WebException and disconnects from the server. This gives a performance hit if we are trying to create alot of directories on the server that already exists due to the disconnects/reconnects. TIA, lushd ...Show All

• SQL Server Intallation Error

  i'm trying to install MS server 2000 components and I continuously get the same error. "A previous program installation created pending file operations on the installation machine.  You must restart the computer before running setup."  I've rebooted 100 times, turned the machine on and off, installed other programs, etc. and stil I get the error ONLY when I try to install the components. Please Help!!!! Try this. 1. Run comma ...Show All

• Windows Forms ownerdraw menus...

  Hi, I can find many c# ownerdraw menus that change the painting of the menu items. But I want to change the backcolor of the main menu, the color of the bar where the file names are written...  Can I do it  How  Any help Thanks ...Show All

• SQL Server String truncate error

  Yesterday my program was inserting and loading data in the database just fine, now when i try to do a myriad of things(make a paramatizsed search ad a favorites option) when ever i add data to the database i get a string trucate exception, basically its telling me the data im uploading is too large, problem is the feilds in the databse can take it.Its telling me the column im updating to has a string limit of 255 , but in reality the column its ...Show All

• Visual Studio Team System custom extraction rule to return collection.

  I am trying to find out how to return a collection type (array or arraylist) from custom extraction rule and use that collection in the coded script or declarative test. Also, when I tried to use my own custom extraction rule (called Class1), I am getting the following error message "Class1 Extraction Could not create instance of rule class 'Class1' :Object reference not set to an instance of an object." Bart, Try running yo ...Show All

• .NET Development how to get LAN Information - turnOn- turnOff time

  hello i want to get turn-on & turnoff time all the pcs connected to my lan i have IPs for all the connected nodes but dont know how to fetch information from the IPs... in future i want to get as many as information for each node so plzz let me know the right way .. i try WMI but its always says AccessDeny i dont have username password for all the nodes .. but i think i can connect to all the nodes from ip address & get in ...Show All

• .NET Development auto generated code for update cmd in visual studio 05

  hello everyone, I'm new to .net and have been using visual studios .net 05 and found it great to you use and I like the auto generated code it produces when using a datagrid. However my question is i'm reading data from database (MSSQL) in a datagrid i've modified the data grid to have an edit button which when clicked you can edit. However if I click on update it crashes and throws an exception is there something in .net that allows me ...Show All

• SQL Server SQL Server 2005 System Table (View?) Map

  Is there an estimate on the availability of the System Map for SQL2005 If it is already out there, would someone be so kind as to tell me how to get it Thanks, DO A poster that shows most of the SQL Server 2005 system views (catalog view and dynamic management views) and their relationships will be available in the December issue of SQL Server Magazine. Regards, ...Show All

• Visual Basic Any way to constrain generics to value types?

  Is there a way that I can constrain a generic type to only accept either integers or doubles  Seems like value types are altogether exluded from participating in generics but I wanted to make sure. Is this right Any reasons that explain this I'd like to write something like: Private Sub Foo(Of T As {Integer, Double})(ByVal Value As T ) Thanks in advance! Hi, what is near is that you can li ...Show All

• Windows Forms Assembly redirection during application launch using Reflection

  I am trying to launch a windows application App1.exe (based on .Net 1.1) using reflection from another windows application. App1.exe has an associated .exe.config in which I put assembly redirection for few assemblies. The assembly redirection is working fine when App1 is launched individually. But when launched using reflection, it is not working. It still expects the original version of assemblies. Is there a way to make it work Thanks. ...Show All

• Visual Studio Team System No effect of "define _CRT_SECURE_NO_DEPRECATE 1"

  For the moment I want to suppress all the deprecated insecure functions during static code analysis.  I've added this line in two separate files that get included in all source files: #define _CRT_SECURE_NO_DEPRECATE 1 to no effect -- the output still contains warning of these functions.  A colleague has resorted to #pragma to supress these warnings.  I'm curious as to why this doesn't work as documented in the help. Thanks. Sam ...Show All