eldiener's Q&A profile

• SQL Server Missing ODBC drivers - please help!!

  Hi all For some reason, my Excel / Access drivers have disappeared from the list of available data sources when running the Import wizard or when trying to create a dts package. They are installed on the machine as I can see them through the ODBC Administrator. I have googled extensively, found some posts relating to TimeSlips (not relevant as not installed), re-installing MDAC. Having done all the relevant stuff (updating to latest MDAC), still not coming up. Installed SQL 2005 Management Studio thinking that may help. Still nothing.Can someone please give me some advice, APART FROM RE-INSTALLING OS. How does Import wizard pickup the available drivers, any registry settings... Currently running XP SP2 with all the latest updat ...Show All

• Visual Studio Express Editions DataGridView - Sort By Numerical Value not By Strings

  I have a DataTable that generates columns and rows based on text. The problems is that two of the rows are numerical values( Double, Integer) but there inputed as strings, so it sorts alphabetically and not numerically. How can i set it up to sort that way It wont let me change the type from string to anything else... Please Help Dim infotable As New DataTable infotable.Columns.Add( "Letter" , Type.GetType( "System.String" )) infotable.Columns.Add( "Frequency" , Type.GetType( "System.String" )) infotable.Columns.Add( "Percentage" , Type.GetType( "System.String" )) For number = 0 To 25 infotable.Rows.Add( New Object () {names(number).ToString, Fr ...Show All

• .NET Development FileStream and Sockets running slow...

  Maybe someone can shed some light here. I am using sockets and FileStream to send a file from client to server. Everything works fine, except it is REALLY slow. I mean like 2kb every 5 seconds. The basic rundown is: CLIENT: fs = new FileStream(@"c:\mailroot\MENU.pdf",FileMode.Open,FileAccess.Read); byte[] currentBuffer = new byte [16384]; fs.Read(currentBuffer,0,16384); return Encoding.ASCII.GetString(currentBuffer); SERVER: (Arg is the string of currentBuffer above) fs = new FileStream(@"c:\mailroot\temp_file.txt",FileMode.Create,FileAccess.Write); fs.Write(Encoding.ASCII.GetBytes(Arg),0,Arg.Length); Upon testing, I found that the read is quick, and the encoding is quick. Milliseconds. ...Show All

• Visual Studio Remote debugging - Security Exceptions

  I work with VS2005 / Framework 2.0. I installed the Remote debugger on a client machine (as application, not as service). Then I start the remote debug application. I configure the Debug Section of the dev-machine: - Start external program: \\remoteHostName\c$\Programme\_TEST\ConsoleApplication2.exe - Use remote machine: <The configured "ServerName"> Sample Code: using System; namespace ConsoleApplication2 { class Program { static void Main(string[] args) { string hostName = Environment.UserDomainName; Console.WriteLine(hostName); } } } When I get to the line "string hostName = Environment.UserDomainName;" I get an SecurityException: System.Security.SecurityException was unhandled Message=& ...Show All

• SQL Server SQL statment by asp.net

  is there any chance to use the follwoing script to add new record to the database " rs.addnew rs.("name")="Scot" rs.update " insted of the old fashion " insert into ...." Hi, you don’t use this old fashioned recordsets anymore. After reading / loading a table from from a data source e.g. SQL Server, you take the table and create a new row from a table and add / change values to the table. DataRow dr = dt.Rows.NewRow(); <--Whereas dt is the instance of the datatable from the server dr["Name"] = "Scot"; (...) da.Update(dt); <-- Whereas DataAdapter is the instantiated object to push the changes to the server. Afterwards you would do somet ...Show All

• Windows Forms Customise User Control

  I have four toolbox components that I "habitually" add to classes that derive from UserControl, and I'm thinking of adding two or three more - these are non visual things that reside in the component tray. What I'd prefer to do is to create a new UserControl base, with my components built in as properties. Can anyone point me in the direction of information of how to do this. I've tried putting a Control together with a Design Surface and a few other things . I'd also appreciate any recommendations on any books that cover the "Designer" elements of .NET. Thanks PhilD I thought I'd responded to Joey's post, I must have pressed the wrong button. I have no requirement for there ...Show All

• .NET Development VB.NET and MYSQL

  Hey guys: Where can i get help in order to connect VB.NET to a remote MYSQL database Framework : Net 2.0. Languaje : VB.NET OS : XP Profesional Database : MYSQL Imports : Systen.Data.Oledb String connection : Provider=Microsoft.Jet.OLEDB.4.0;Server= www.domain.com ;Data Source= Mydb ;Uid=xxx;Password=yyy;" Errror : No se pudo encontrar el archivo ISAM instalable Remote server is available. Same error is produced when try to connect to localhost Database is up and running Thanks in advance campo You won't be able to connect using the Jet OLEDB provider. Try using some of the MySQL options such as the ODBC driver, OLEDB provider or .NET library: http://dev.mysql.com/tec ...Show All

• Visual Studio 2008 (Pre-release) DwmEnableComposition(bool) Call Not Working on 5384

  Hey Guys, I'm trying to build a utility for Windows Vista using VS2005, and I'm trying to use P/Invoke to shut off Windows Aero using DwmEnableComposition. However, when I make the call, Aero doesn't shut off, and the state remains Active. Further, the HRESULT returned is 0, meaning (I'm assuming) that the call was successful. Can you guys help with this A snapshot of teh code is below. Thanks! <DllImport("dwmapi.dll")> _ Public Shared Function DwmEnableComposition(ByRef fEnable As Boolean) As Integer End Function Private Sub MenuItem_GlassDisable_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem_GlassDisable.Click Dim test As Boolean = False Dim result As Integer = ...Show All

• Visual Basic Generate form dynamically (for multiple records)

  I have a form where i add user info (GroupID and ProjectID). There can be more then one coders inside a group so i need multiple records against a groupID can it happen that i tell the form about the number of coders and it can create (dynamically) the textfields etc required to make so many enteries if my question is not clear please let me know, i shall try to elaborate as much as i can. thanx I choose, datagridview.. but then how can i add new records and remove records from data grid i tried inserting it.. then checking all the four checkboxes (in VS 2005 pro) but when i execute the program i cant add/delete any record any help ...Show All

• Visual C# VS ComboBox missing display

  I while back I wrote a C# program using (among other things) a downdown combobox with items loaded using the .Items.AddRange() function. All works fine on my computer, but on other computers (without the VS Developer software installed), the dropdown box comes up blank. One can still select the different items through the mouse scrollwheel, so I know the data is being loaded, but the dropdown window is blank. Some of our computers have both .NET Ver 1.1 and 2.0 installed, others don't (mine specifically doesn't). The program was developed with VS .NET 2003 software. All the computers are running XP Pro, similiarily configured (though mine's the only one with the VS software), and all have the latest OS updates (I just checked). Any i ...Show All

• Visual Studio Team System Custom Check-In Policy: interaction with IDE

  Hello, I'm writing a custom Check-In Policy inherited from PolicyBase class that parses source files for specific problems and outputs them as PolicyFailure objects describing the source file and line# where problem occur. When user double-clicks on my PolicyFailure, I want to open corresponding source file and position the cursor on the problem line. But I don't know how to get to the TextDocument and DTE2 objects from within PolicyBase.Activate method that handles the double-click action. Best regards, Sergei Almazov In the policy's initialize method it is passed an object called pendingCheckin that implements IPendingCheckin. IPendingCheckin implements IServerProvider. Use the GetService metho ...Show All

• Visual C++ DAMAGE: after Normal block (#53) at 0x01BB0BE0

  I am not a programer and don't know computers in depth, but I need help figuring out what is going on with my pc. I am getting the following message: Microsoft Visual C++ Debug Library Debug Error! Program: c:\\progra~1\Support.com\client\bin\tgcmd.exe DAMAGE: after Normal block (#53) at 0x01BB0BE0. Can someone steer me in the right direction That was a particularly arrogant responce, and not in the least bit helpful. Instead of being rude and dismissive you could have tried to help the persons problem. I have the EXACT same problem but on a different memory block(55) so it seems that it is not so esoteric. I will try to find another source of information, certainly not from Duck ...Show All

• Visual Basic Cannot add data to an SQL Server 2005 database

  I have a simple form to display customers and add new ones. I have the customers displayed using a datagridview and bound datacontrols to display details about them when a a record is selected. Anyway, I have an addition form for adding new 'Titles' for selection in a combobox. I have created a button to add text and a new ID in the table tblTitles. tblTitles looks like: TitleId | TitleDescription tblTitles is related to tblCustomers from the TitleID to the TitleId in the customer table. The code on the add title button is as follows. (Primary keys of each table is a GUID, "Sir" is just an example of a title) Me.TblTitlesTableAdapter.Insert(Guid.NewGuid, "Sir") Me.TblTitlesTableAdapter.Update(Me.NytdbDataSet) ...Show All

• Visual C# Get some properties of a control belonging to other Application.

  If I just have the HWDN of an application (Windows Form): Option A: Is it possible to get all the Windows Controls belonging to the application For example, if it has a Panel, is it possible to make a cast for knowing its properties Specifically, the properties Top and Left of the Panel. Option B: With the HWDN, is it possible to know the measures of the menu, borders and margins, and hence, it is possible to calculate the Top of the first component just below the menu Thanks ...Show All

• Visual C# check valid path

  Is there away to check a valid DOS path in c# ex: if the user types zzz:\test.txt and the path is invalid, return error message.   using VS2003 .NET1.1   Thank you, using File.Exists to check path validiy is a wrong idea and should never be used. It says MSDN here: http://msdn2.microsoft.com/en-us/library/system.io.file.exists.aspx See Under Remarks heading. You can use System.Text.RegularExpression.Regex class to do this but for that you need a Regex string which i belive can be easily found through google. Try something like this File path Regex, Path Regex etc. You'll need to write code like this: Regex fileRegex = new Regex(regexStringHere); Match mat ...Show All