Tort's Q&A profile

• SQL Server EXECUTE SQL string with parameter and return value

  Hi all, I would like execute an SQL string who calls a stored procedure with param and return a value: declare @query nvarchar ( 50 ) set @query = 'sp_test 1' declare @resultat int exec @resultat = @query select @resultat Its returns a error message: "Could not find stored procedure 'sp_test 1'" The command exec ( @query ) works fine, but I can't retreive the return value and I can't do exec @resultat = ( @query ) How can I do Thanks, Aurelien Another exemple when using dynamic queries declare @query nvarchar(50) set @query = 'select ''' + 'sp_test 1' + '''' CREATE TABLE #resultat ...Show All

• Visual Studio Team System Timeouts during unit tests

  When I select a class to run everthing works fine. However when I select multiple classes to unit test, I am getting timeout issues. I can run the individual test for each class fine. Anyone know why it's timing out when I select a larger number of tests to run ( By large I mean around 200 ) It doesn't appear to be any one test. The same test will pass on one test run and timeout on another. Once I hit a test that'll timeout, all subsequent tests will also timeout. ...Show All

• SQL Server undo delete statement...is it possible

  I've made a very silly mistake. I was supposed to run this statement delete table_columns where col_id = 1223 but instead I mistakenly executed just the 1st line. I have no backups....is there any possible way to undo this before my boss finds out thanks.... I know that this advice doesn't help you with your current predicament, but it is often a good idea to issue a BEGIN TRANSACTION statement before performing manual data modifications. Once the data modification statement has completed you can then issue either ROLLBACK TRANSACTION or COMMIT TRANSACTION as appropriate. Chris ...Show All

• Visual Basic Form is Flicker when I draw many Buttons at Runtime

  I write Code about generate 200 buttons in panel and add into form. Because of a lot of buttons, you can see windows draw it (from left to right and top to buttom) If I want my form show all item in a same time, can I I use suspend and resumelayout command but it cannot work please suggest Private Function genPanelButton( ByVal ButtonWidth As Integer , ByVal ButtonHeight As Integer , ByVal NumOfWidth As Integer , ByVal NumOfHeight As Integer ) As Panel Dim ThisPanel As New Panel() ThisPanel.SuspendLayout() ThisPanel.Width = ButtonWidth * NumOfWidth ThisPanel.Height = ButtonHeight * NumOfHeight Dim ButtonSize = New Drawing.Size(ButtonWidth, ButtonHeight) For iH As ...Show All

• Windows Forms Grouping radio buttons

  I'm stuck on radio buttons in C# alas. I can group them by putting then in a Group box, that falls into place. But I want to treat them in code as a group too. I want to be able in one line of code to get the button which is selected, not have to scan through them all one by one. Can this be done Is the group of radio buttons itself available as an object that can be queried with regards to the status of the current seelction in that group There's actually nothing in Win32 to do this either. The only thing is in MFC and the ::GetCheckedRadioButton method--which just iterates a range of dialog ids and calls Win32's GetDlgButtonChecked... ...Show All

• Visual Studio Express Editions Internet Options

  How can i make a button that opens internet options in Visual Basic 2.How can i make a button for WebBrowser1 Online/Offline Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Process.Start( "inetcpl.cpl" ) End Sub ...Show All

• Visual Studio Express Editions How Do I Add a Find Feature to the BindingNavigator?

  The BindingNavigator does not have a Find method like the Recordset object does. I've added a Find Button and text box to the BindingNavigator, but I can't find a method to use to implement a Find feature (e.g., search for a last name). Below is the code I used in VB6. Can anyone help me with this one Thanks, Mike Private Sub cmdFind_Click() Dim Msg As String Dim strFind As String On Error GoTo PROC_ERR strFind = InputBox("Enter all or part of last name to find.", "Find Instructor") adoPrimaryRS.MoveFirst adoPrimaryRS.Find "LastName LIKE '" & strFind & "*'" If adoPrimaryRS.EOF Then Msg = "Record not found." MsgBox Msg, vbOKOnly + vbInformation ...Show All

• Visual Basic How to clear browser history

  Hello I am trying to figure out a way to clear browser history from my dektop application, ideally for both FF and IE. Anone know of a resource or some code to help me out Thanks! there was a topic about this a while ago and you cannot really delete the history in your application as Windows manages this, even if you delete the history files in the history folder in your user account folder, some files are not deletable and some are. ...Show All

• .NET Development How to obtain Module cctor?

  Hi, How to obtain module constructor with help of the Reflection For example, I have declared module constructor (.cctor at root of the module): .module TestLibrary.dll .imagebase 0x00400000 .file alignment 0x00001000 .stackreserve 0x00100000 .subsystem 0x0003 .corflags 0x00000001 .method public hidebysig specialname rtspecialname static void .cctor() { ldstr "Hello, world" call void class [mscorlib]System.Console::WriteLine(string) ret } But this module constructor is invisivle from Reflection. Assembly.ManifestModule.GetMethod(".cctor") always return null. Thanks. I don't know how to generate a module level cctor with C#. Maybe this code will give you some pointers: using System; using Sy ...Show All

• Visual Basic Total Newbie Question about query and reports

  I have a MS SQL database with one table and 5 columns, approximately 100 rows of data. Table is called Employees. Columns are called: ID, BDate, Age, Weight, Race I have created a form called Search with 2 text fields called txtID and txtWeight. It has a button that the user will use to activate the report. I want to create report that is generated based on a query that uses the txtID field as it criteria. How do I create that query that will take whatever is typed into the txtID field as its paramater. Thanks for all your help. Ok, I got a query running to a datagrid. How do I get multiple columns from more than one table to show up on the grid or preferrably a report. I have a rela ...Show All

• SQL Server trigger limitation column_bitmask

  Below is excerpt from the BOL regarding column_bitmask regarding creation of triggers. I see a problem - if I could have upto 256 column per table and updated_bitmask and column_bitmask are Integer data type, then interger can only be no more then 2^32, but we need to have up to 2^(column number - 1) which could be up to 2^255. We will get overflow error. Do I misunderstood something or there is a problem. We could use BIGINT but it only upto 2^62. We can not use any other data type because of bitwise comparison. Pleas help. Constantin IF ( COLUMNS_UPDATED ()) Tests, in an INSERT or UPDATE trigger only, whether the mentioned column or columns were inserted or updated. COLUMNS_UPDATED returns a varbinary bit pattern that in ...Show All

• Visual C++ infinite looooooop?

    hi i have this infinite loop     int array[5];  for (i=0;i<15;i++)  {    array[ i ] = 0; // here i becomes ZERO when i = 5  }     i am not understanding why this is infinite loop.. "i" is incrementing till 5 then suddenly it becomes 0.. and i mean i never goes beyond 5. so the infinite.. . can any one tell me why "i" becoming 0.. after 5 in the loop..   manish   ya my program has d error.. but why is it happening.. . i am very near 2 the answer .. iam using vc6 environment.. . here are two different codes    for (int i=0, array [ 5 ];i<15;i++)  {   array [ i ] = 0; ...Show All

• Visual Studio 2008 (Pre-release) How to cancel a context menu from opening in Windows app

  I'm working in a window app: 1) When user right clicks on a control to open the context menu, and before it opens I want to run logic to determin which menu items to enable and disable. What's the best event to do this in The only event I found that I could do this is the context menu loaded event. 2) After the right mouse click and before the context menu displays, if certain conditions exists I want to cancel the menu from opening as if it didnt exist. How can I do this Thanks. call the event on the control which has the context menu RichTextBox rtb = new RichTextBox(); ContextMenu contextmenu ; contextmenu = new ContextMenu (); rtb.ContextMenu = contextMenu; rtb . Conte ...Show All

• Visual C# library for smart card

  hi i'm not sure if this is the right place to ask this. where can I get c# smart card library, if there's any any help is greatly appreciated. thanks I hope you will find usefull informations on http://msdn.microsoft.com/library/default.asp url=/library/en-us/wcesmart/html/ceconSmartCard.asp Best Regards, Misa ...Show All

• SQL Server Execution plan surprise

  Hi, I have 2 tables: one with PK (+ Clustered index) on 3 columns and second with PK, FK on 3 columns (+ clustered index). So I join those tables on 3 columns. I want to do some improvement and add 1 colum (of int type) to each table and create relation one-to-many. So now i may join on 1 column.... I have indexes on those new columns of course. But I was surprissed but that join is slower ... On execution plan is showed that querry engine doesn't search newly added indexes, but old ones. And uses hash join (previously merge join). Where is problem Why sql server doesn't work on new indexes Because they aren't clustered and not PK Best regards, Walter Hi, I just know ... It was ...Show All