Keith Powers's Q&A profile

• Windows Forms Hidding rows in the DataGridView is too slow

  Hello all, Currently, I have a project that uses a dataGridView that contains some 10,000 rows of data. The user must have the ability to hide/unhide some or all of the rows. To accomplish this, I am setting the datagridView.dataGridViewRow.Visible property to true or false. This is done once for each row in the grid. This happens to work fine accept that it takes about 90 seconds to hide all of the rows. This is big trouble for me because my application may have several dataGridViews (and other views) sharing the same underlying data and the time cost must be paid for each one. My question is this... Is there a fast ...Show All

• SQL Server SSIS Send Mail task problem

  Hi, I have got the problem connected with Send Mail Task in SSIS. The general idea was: sending email alert to different email users. I tried to use Foreach Loop task which loops through dataset (where the emails are stored) and assign different email addresses to SSIS package variable. When I try to use this task inside Foreach Loop task I receive this error message: "Error: 0xC002F304 at Send Mail Task, Send Mail Task: An error occurred with the following error message: "The parameter 'address' cannot be an empty string." The SSIS package has variable (string) which is binded with ToLine - property of Send Mail task ...Show All

• SQL Server Query the Full-Text Words List?

  Hi Guys. I’m doing searches in a DB and am using the Full-Text Indexing. CONTAINS() will only process strings (words!) three letters or more in length. Even though it can do substring searching, it will only do this if it recognises the parameter as a word . So take this code for example:           Dim mySQLStatement As String = "SELECT TOP 100 Description, Price, Stock FROM Products WHERE "         x = Split (strString, " ")         For i = 0 To x.GetUpperBound(0)      & ...Show All

• Windows Forms opening a paticular cell in editMode when dg row is highlighted

  hiya, When the user clicks on a dgRow, I want to be able to be open the 5th cell (in editMode) of the selected dgRow.Ideally, I want the underlying datable to be updated if the user subsequently enters data in this cell and then moves focus to a different control on the winform.(I can do the update no prob, but I'm not sure which dg ...Show All

• Visual C++ Compiler does not find form class

  Hi, beside that the built in real time compiler an syntax checker in the formular designer for C++ projects ( VS 2005 beta 2 ) is buggy power 10 i have a little problem. Pls guys fix that!!! I#m crying sometimes I'm designing a little MDI app. So when i want to show an about form from the main formular the compiler says unknown structure for that class. But when i include the header of the about form class some really strange things are happening. Million errors are fireing and many control variables are doubled in the main class by the formular designer. When i use the namespace scope the compiler always says unknown class and so. So my qu ...Show All

• Visual Basic Control to generate SQL code

  Is there a control to allow users to create SQL queries - something like the Access or MSSQL query generator - or even better is it possible to use those controls You can use the SQL generator in Access only if you have a runtime distribution license or your users have the application. You should be aware that because of the potential of "Injection" attacks it is not a good idea to let your users have complete SQL control over the db. Happy Coding ...Show All

• .NET Development Need Help with reading a database file

  I am new to vb 2005, i used vb 6.0 and used dao more than ado. ADO seems to be more difficult, i purchased VB 2005 programming book from wrox and i am following their examples. but all i want to do is read a file in a sql2000 table and i can't. i am on their command object section which is as follows: dim sql as string = "select * from fwn_varstatweek" dim connectionstring as string = "initial catalog=pubs;data source=(local);integrated security=SSPI;" dim command as sqlcommand = new sqlcommand(sql, new sqlconnection(connectionstring)) command.connection.open() dim datareader as sqldatareader = command.executereader(comm ...Show All

• SQL Server Convert Binary to Ascii

  Hi Guys, I've got a question about how to convert binary to ascii. I'm using sql server 2k and reporting services. In the database i have a field with binary code in it and i want to convert it to plain text (ascii). Can anybody help me with a script,code, function, whatever.... Many thanx in advance. Gabs For the source of the field, replace the field name with a T-SQL statement. Use the CAST or CONVERT statements in T-SQL to take the field from binary to ascii. Buck ...Show All

• Visual Basic Copy and Rename a Table in MS Access using VB

  Hi all, I am trying to copy an existing MS Access table (with its structure only), and rename the original to some other name. Could someone share a piece of code that can perform the above operation, in VB Thanks for any assistance, MNRaghu Mike, Thanks for the reply. That's really useful. MNRaghu ...Show All

• Smart Device Development update date in .net compact framework[vb]

  hi all, I m using the datetimepicker control to display the date and time[assume user din modify it] ...but dont know how to update it...Can it be done by using a timer Can anyone show me the code Thanks in advance!!!   If you need to update the date/time displayed by the DateTimePicker periodically, then you can add an event handler to the Tick event of a Timer and set the Value property of the DateTimePicker using the DateTime.Now value. ...Show All

• Visual Studio Express Editions controlchars.tab !!!!!!

  I'm sure someone can solve my problem 'in the blink of an eye' ...... its messing with my head so please help. I want to apply Tab spacing in a textbox so why does the following code example display a 'tab symbol' within the textbox as opposed to applying tab spacing textbox1.text = "red" & ControlChars.Tab & "blue" thanks in anticipation. Coops hi, this code working fine with me Private Sub Form1_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load TextBox1.Text = "red" & ControlChars.Tab & " ...Show All

• Windows Forms how to embed child datagrid from its parent - pls read it in details !!

  I posted this earlier Posted: 07-07-2004 02:52 PM  Hi, All, posted a thread earlier regarding nested tables on .net data grid, guess, the simple goal that I am looking for is: for a .net datagrid on a win form app, how can I embed a child datagrid for each data row - so I can click one of the parent row column (e.g. first column of& ...Show All

• Visual Studio Express Editions Delete rows from DataGridView and Table Permanently

  Please, Could anyone help me or point me to an article or the Code necessary. I am having no luck solving this.   I need to delete a row from both a DataGridView and its binded Database table programmatically . I would attach the "delete code" to the Button on the form. I would point to the row in the GridView and press that button on the form. I cannot use the TableBindingNavigator because of other requirements. Also, I need to make sure that the deleted row stays deleted permanently. I have been battling with this and cannot seem to acheive a permanent delete. Every thing seems to delete correctly, but if I exit this form ...Show All

• Software Development for Windows Vista vista on inspiron 5150

  I have a beta version of windows vista and when i try to install it it will start to install the first part and then say that the system needs to restart to continue. so it restarts and instead of continuing the installation it boots to a black screen that says page fault and has a bunch of other numbers and leters. Does anyone have any idea how to make it install I have had Vista running on an Inspirion XPS for months without any problems...I have read in other posting that you should check your installation media and maybe try to DL and burn it again... You might also try another forum since this is a ...Show All

• Visual Basic Controls Flickering when drawed on the form

  Hello there :) This was a Problem in Visual Basic 2003 when having a Form with about 150 Controls the form simply consists of panels and those panels have Labels and controls beside hem the form itself has a background picture ,,, the Panels also have backimages the Problem is when the form is shown the controls are being drawn really slow ... (the form is 1024*768) that wasn't a Problem at all back in VB6 anyway I saw that Visual Basic 2005 has a New Future called DoubleBuffered but it isn't doing any difference at all ... what are your Suggestions :) Thank you very much in Advance ! tried it wihout luck (I' ...Show All