Johodefo's Q&A profile

• SQL Server can't get the complete list of tables owned by the dbo

  Hi, i am using sp_tables to get the list of the tables in the database owned by dbo The database i am trying to query would let me query all the tables present in the database.there are almost a 1000 of them(owned by dbo) .I can query them and i get the records.   But the execution of the stored procedure  "sp_tables"  would return only 10 or so  tables.I was puzzled by this.   can someone clarify this inconsistency.   thank you From BOL: Information Schema Views These views provide an internal, system table-independent view of the SQL Server meta data. Information sc ...Show All

• SQL Server Example code for consuming a SSIS datareader from ASP.net

  Hi, Does anyone have any or know of any demo code that shows how to consume data made available by a SSIS DataReader destination in an ASP.net app. Thanks in advance. -Jamie P.S. Doug if you're reading this, it'd be handy to have some examples such as this in BOL or maybe even something provided with the samples. Re: How do I consume a DataReader Destination in VB.Net - Microsoft Technical Forums ( http://forums.microsoft.com/msdn/ShowPost.aspx PostID=64798 ) Doug mentions a topic, although I cannot check it right now. ...Show All

• Visual Studio Express Editions Passing values to a function and returning value

  Still learning passing values. Could someone check my code so far and see if I am heading in the right direction I am getting value not declared errors and I see it, but not quite sure on where to declare them. Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim A, B, D As Integer A = 1 B = 2 D = 5 AddThem() MsgBox( "Sum is " & c) End Sub Public Function AddThem() Dim C As Integer C = A + B + D End Function The function must pass a value back to the functio ...Show All

• Windows Forms Beginners trouble

  Just trying my hand at my first Forms application, converting an old VB6 program I did a few years back. My problem is as follows I have 2 forms, the user selects a csv file in form1 and clicks a button, a new form, form2, then loads and performs 3 actions 1. Converts the csv to a dataset and then transfers the dataset using webservices 2.&nb ...Show All

• Windows Forms Securing a Database Connection String

  Hello.  I am developing a WinForms application that will be deployed using No-Touch deployment.  I am implemeting this via an application stub which uses Assembly.LoadFrom to load the main application.  I want to make sure that no one can read the database connection string.  I don't want to put it in the app.config file beause the file is do ...Show All

• Visual C# Authentication Method

  First, let me start off by confessing that I am a former VB programmer (Pre .NET days) that has not written a line of code in many years. Now I am trying to dust off the coding cobwebs, learn the .NET framework, learn C#, and adapt to a "true" Object-Orientated method of programming... All at the same time! Now that the laughter in the room has subsided, here is my question: I need to add a login/authentication routine to the database application I am working on. Once the user has been authenticated, I will need to pull in several user specific settings from the user database file. In the old days, I would have just create ...Show All

• Smart Device Development Once again Problems with SerialPort class

  Hi, we were thinking (hoping) that with SerialPort we get a class solving the problems with the Serial Communications on PocketPCs. But instead it works worse than our own implementation via PInvoke. On thing I allready showed there: http://forums.microsoft.com/msdn/ShowPost.aspx PostID=9794 Now we got a new one! On an IPAQ we have a bluetooth barcode reader. The serial port for BT is Com8 in this case. With our handmade Serial it is no problem to get strings form the BCR. When I use SerialPort an try to open Com8 (no Data from the BCR - just open) I get an "IOException" stating the following:   Stack ...Show All

• SQL Server IF statement with BEGIN END block

  I'm working on a stored procedure which includes an IF statement at the end of the procedure which appends my sql call with two lines. But I'm getting an error that probably comes from the fact that I have a nested BEGIN END block in my overall procedure. Can anyone tell me if my assumption is correct and help polish of the syntax The error I'm getting is: Msg 156, Level 15, State 1, Procedure payments_sp, Line 55 Incorrect syntax near the keyword 'AND'. and the sql code looks like this: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[payments_sp] -- Add the parameters for the stored procedure h ...Show All

• Windows Forms RichTextBox LoadFile Method with RichTextBoxStreamType

  VB 2005 Beta 2. I am loading a rich text box with the contents of a user selected file.  It appears that depending on which RichTextBoxStreamType I specify, I get a different resulting view in the rich text box for a specific file. For example, if I try to load a .txt file using RichTextBoxStreamType.RichText, I get an error of: System.ArgumentException was unhandled   Message="File format is not valid." If I try to load .rtf file using RichTextBoxStreamType.RichText, it seems to load fine (of course). It seems like I need to know the type of file it is before I load it into the rich text box.  How do I find the type of f ...Show All

• Smart Device Development Also Desinger Problem

  When I tried to create a Pocket PC project(C#), I got a designer error. And nothing has changed when I reinstalled Visual Studio 2005(RTM). ------------------Error Message--------------------- Retrieving the COM class factory for component with CLSID {05896690-9D15-48DC-8DCA-09B16493C596} failed due to the following error: 80040154. at Microsoft.CompactFramework.Design.CcDataStoreHelper.get_DataStore() at Microsoft.CompactFramework.Design.CcDataStoreHelper.get_Platform() at Microsoft.CompactFramework.Design.CcDataStoreHelper.GetPlatformProperty(String propertyID) at Microsoft.CompactFramework.Design.FormFactorInfoService.get ...Show All

• SQL Server Unable to install MS SQL Server..

  Dear Gurus.. I am having problem in installing the MS Sql Server on my System. Configuration: XP sp2, vss .net 2003 Problem is, system is giving the message (shown bellow), and i have the option to install only the SQL Client. Please help... Setup Message Microsoft SQL SERVER 2000 ENTERPRISE EDITION server component is not supported on this operating system. only client components will be available for installtion. enterprise only installs on Win 2000 server and Server 2003. need to install the msde, developer or personal. Go ahead and install the client tools then install this ...Show All

• Visual C# Cannot make a debug release anymore

  Today I switched my builds to release, to test the performance of my application. But now the configuration manager is greyed out, and i cant make any debug releases anymore :( Who can help me please I even restarted my computer, and i still can't build a debug build. but i can build a release build.. I really hope someone can help me! ...Show All

• Visual Studio Enhance the Unit test environment

  Hi, We are currently working with Unit Test in our development cycle and we would like to continue and even expand the ue of "Unit Test" into integration and even peformance. Using the VS Extensibility, will I be able to extend VS's unit testing capabilities Regards Martin It all depends on what you mean by extending unit testing. Do you want to add new files to the unit test project, add your own reporting output, etc Craig ...Show All

• .NET Development Regex problem iv vc 2003

  I need to use Regex object in my app I realized that if I need 2 RegexOptions so I have to put the 'or' operator betwwen them but when I do that I get an error: rror C2664: 'System::Text::RegularExpressions::Regex::Regex(System::String __gc *,System::Text::RegularExpressions::RegexOptions)' : cannot convert parameter 2 from 'int' to 'System::Text::RegularExpressions::RegexOptions'   the code with ||: CString strPattern = _T("<form[\\s\\S]* <.form>"); Regex* rx = new Regex(strPattern, RegexOptions::Multiline | |  RegexOptions:: IgnoreCase ); or with |: CString strPattern = _T("&l ...Show All

• Visual C# DLL Files

  Another question is that can we say that all default namespaces are specific(not default) according to themselves(their classes and members) ...Show All