JED_'s Q&A profile
Visual Basic Server Explorer Differences between 2003 and 2005
On 2003 in servers explorer besides databases it also showed servers, the local machine for example where you could see events logs, services and run WMI queries. Does this feature still exists on VS2005, I thought it was a setting but cannot find it anywhere. Maybe just blind Thanks Perhaps you are using VS2005 standard version. You must have the professional version to use these features regards ...Show All
SQL Server Error detaching sql express database using SMO
I am using SMO to provide a backup/restore feature. The restore code looks like this: try { // Initialise server object. Server server = new Server(serverName); server.ConnectionContext.ConnectionString = connectionString; // Check if database is current attached to sqlexpress. foreach (Database db in server.Databases) { if (String.Compare(db.Name, destinationPath, true) == 0) { Console.WriteLine("Detaching existing database before restore ..."); server.DetachDatabase(db.Name, false); break; ...Show All
Visual Studio Express Editions visual basic 2005 express
I had started developing a database application in VB.net 2003 where the database is MS Access 2003 (the MDB is 2000 file format). I migrated to VB-2005 Express and it tells me that my MDB file format is not recognized What can I do about this without redoing my MDB in another version Please and thank you. Luis hi, Is your problem solved Thank you, Bhanu. ...Show All
SQL Server Add a DateLoaded column to input data
OK, I *know* this is trivial, and please feel free to giggle, but after years of DTS 2000 my poor brain can't make all the jumps neccesary to cope with SSIS 2005. I have a Transfer data task. Source input (non SQL Server) has x columns, SQL Destination has x+1 columns, where the extra column is a non-null smalldatetime column DateLoaded. This will be populated with the Date & time the row was added. In DTS I do this either by adding a GetDate() equivalient to the Source SQL statement (which I can't do in this case) OR by an ActiveX script to put DATE()+TIME() in the final column in the Transfer pane of the designer. This must be ea ...Show All
Windows Forms Winform app looping... how can I find out where?
Hi, I have a winform app that is occasionally going into a loop and taking up 99% of CPU. I have stepped through it with the debugger multiple times and I simply can't work out why it's doing it and it only seems to do when I run it stand-alone (ie: not via VS.Net)... what I want to know is how I could catch the app doing this and then throw an error showing me where it is in the program. Failing that are there any tools that "profile" the running app so I can try and work out where the blockage is TIA for any suggestions or help... Mike Thanks for that - in the meantime I think I've found the pr ...Show All
SQL Server Datafields in report header
Hi. I want some information stored in the database to be shown on the top of each page in my report. But in the report designer I get an error message if I try to drop a table in the header, and if I try to assign the value of a textbox in the header to e.g. "First(Fields!sometable.Value)", I get a runtime-error in the preview that says "... Fields cannot be used in page headers or footers". How can I do this Regards, Tomsi Hi Tomsi, you can not place a databound field in the page header directly. Instead, you can place it in the body of the report and ...Show All
.NET Development movie play list
Hi All I am using Windows Media Player embed on my site. Can you show me how to make a play list ore menu that will play in the same Windows Media Player. Thank you leecsone. ...Show All
Windows Forms how can I know if an item exits into as string ?
Public Fields() As String = New String() {"Identif", "model", "serial", "number"} thank you You can use the IndexOf method to "search" an array like this. ...Show All
Windows Forms Problem with windows themes and child forms
Hi, First of all, forgive me if I don't use the correct terms, I'm quite new with windows forms and all (and I'm not english ^^) I have a main windows form. Inside, I want to have 2 other forms. I want those forms to be "cropped" to the main windows (I don't want MDI windows, I want the child forms to stay inside the main form) I somehow managed to do that, but now, I have a weird problem with the windows themes : when a child window is minimized, the theme is correctly applied to its header bar, but when it's maximize or normal, then the theme is not applied. Here is a screenshot to show what happens : http://paicky.free.fr/prob ...Show All
SQL Server SSIS Requests...
May be it's too late, but I think this requests could be scheduled at least for a SP1 if it's not possible for the RTM. 1) Execute Task without debugger: it would be very nice to be able to execute a single task without going in debugging mode. Just as you would ask "Start Without Debugging CTRL+F5" but for a single task 2) Customize default properties for task and component: when you drag a task on the package you get a default value for the properties that you could want to change; often I need to change the same property in the same way each time (for example I'd like to set the Batch Size for a OLE DB destination to 1000 instead than 0 ...Show All
Visual Studio ReportViewer control print preview shows too many pages.
Hello I am experiencing some problems with the print preview. My report contains only one table witch spans usually over 20 pages. In normal mode everything seems to be working fine, but when I switch to print preview the page count doubles and every other page is left blank (headers and footers are okay). I tried to manipulate the paper size without success. I am using VS 2005 Beta 2. Thanks for your help. Piotr, I've experienced this too. I solved it by creating a new blank report and copy/pasting all objects from the old report to the new one. There must be some Crystal reports code in there somewhere. ;- ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Texture does not appear to load...
I'm trying to load an .X file with textures, but my code does not seem to be loading the textures with the mesh. I poked around in the texture variables in break mode, and all the indices have the Nothing value. I have the images in the same folder as the .x file. I'm using VB Express 2005 and the October SDK. Here is the code for loading the file. Dim materials As ExtendedMaterial() = Nothing _MeshSkyBox = Mesh.FromFile( "C:\...\RPG\Resources\skybox.x" , MeshFlags.SystemMemory, _Device, materials) If Not (materials Is Nothing ) AndAlso materials.Length > 0 Then _MaterialSkyBox = New Mater ...Show All
Visual Studio 2008 (Pre-release) XLinq and Common Namespace Support
I've been reading through the XLinq Overview and looking at the XLinqIntro sample. It strikes me that that it might be handy for XLinq to provide an XNamespaces static class with common namespaces like so: public static class XNamespaces { public const string Xmlns = "http://www.w3.org/2000/xmlns/" ; public const string Xsd = "http://www.w3.org/2001/XMLSchema/" ; public const string Xslt = ...; public const string Xlink = .. public const string Wsdl = ...; ... public static string EncloseInCurlies(string namespace) { return "{" + namespace + "}"; } } This obviously isn't a huge deal but it does ...Show All
SQL Server What is faster: DataReader or DataSet or something else?
Hi, I need to read 250,000 records and show this information. I am using DataReader and it takes 8 seconds. I need to raise it to 0.8 seconds atleast. What is faster: DataReader or DataSet or something else Thank's Alexei Hi, My computer has 512 MB of memory. My application must run on 256MB at clients computers. Thank's Alexei ...Show All
Visual Basic Tabbed Browsing in VB .Net
Hi, I have a question regarding tabbed browsing. I am writing my own custom web browser in vb .net studio 2005. I can create, dynamically at runtime, additonal tabs on a tab control, which will - in each - have a dedicated webbrowser control. So what will happen is 5 search engines will be searched and the results be placed in seperate webbrowsers under 5 dynamically-created tabs. The user can then tab throw each set of results. The problem is, I cannot crack for the life of me the creation of the dynamic webbrowser controls in line with creating the tabs. I will need to send a URL to each webbrowser too, to show the resulting searc ...Show All
