mikemhc's Q&A profile

• SQL Server Manipulating SQL server databases dynamically

  Hi friends, I have problem in sending my T-SQL statements, which i generate dynamically with the help of "user entered attributes", to SQl Server. I need my T-SQL statements to get passed to the SQl Server ,which i enter in a "Rich text Box " in my appication that i develop using Vc# .net 2005,when i click a button which i placed in my "winform".And the queries Should be executed exectly as i ...Show All

• Microsoft ISV Community Center Forums Access/VBA add the value to ListBox every column

  Use a list box to display SSN, Hours, FullName, 3 columns get value from a recordset, List0 is ListBox created in Form of Access. use List0.AddItem myRs(0) & " " & myRs(1) & " " & myRs(2), all records are added into one column, i hope myRs(0) into Fullname, myRs(1) into SSN, myRs(2) into Hours seperately. and add SSN, Hours,FullName to the head for every column of listbox. How to implement it I shou ...Show All

• .NET Development Anyone know how to link the text boxes to the database

  I have 6 Textboxes...Job Location, Job Number, EMP ID, Equip type, Equip Brand, Equip ID.....Now i want to enter the data for these textboxes and have it entered to the database table after i click the button submit entry this table is  called show status with the field names the same as the textboxes...do i just work with the submit entry button or do i have to code all the individual textboxes Please HELP!!!...does anyone know how to d ...Show All

• Visual Basic Would there be any advantages if i changed from an access database to sql server?

  And would my old sql queries still work Thanks Mike SQL server is good for huge database, database that need speed, database that do not need to be installed with the client and when you have multiple people wanting to change the database at the same time. Your old queries might not work (depend on how complex they are). And in .NET you are sure to have to change your code because Access use System.Data.OleDb and SQL use Syst ...Show All

• Smart Device Development Connection error in SQLServer CE

  Hi, I'm trying to test a VB.net program which connects to my sqlserver CE database. I don't encounter errors while building the solution, but when it starts triggering the procedure via command button, i always encounter a "An unhandled exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in System.Data.SqlServerCe.dll". I can't find what's wrong in my code since i just copied it from one of the msdn technical documents. ...Show All

• Windows Forms dataGridView: nested obj., masked input

  hi, how to display nested obj. in datagridview class A { privete string _a; public string a1 { set .... get .... } privete B _b; public B b { .... } } class B { private string[] _b1; private string[] b1 {......} } my problem are 1. How to display all the strings in one row (including b1[1], b1[2], ...) 2. How to limit the input to only numberic digits (the attribute type is string but i want us ...Show All

• Visual Studio How to synchronize 2 VSS 2005 Servers

  Hi All Is anyone there who could give me a hint how to sync 2 SourceSafe Servers (or in detail: one project on Server A has to be synchronized with a copy on Server B). The script I wrote for that works fine until the project changes (adding files/projects), so I'd like to know if there are working solutions for synchronizing projects on 2 different VSS 2005 servers, or if I've to code a tool/script for that. Regards, Sebastian ...Show All

• Visual Studio Tools for Office A very technical (I think) VSTO startup question

  What is different on a system before VSTO customized document is loaded and after Let me explain. We've got a Word customization that takes 58 seconds to load the first time after a reboot, but only 18 seconds thereafter. Our customization is installed in the GAC, is NGEN'd, and rather large. We have a shimmed managed Word addin that starts .NET CLR with the STARTUP_LOADER_OPTIMIZATION_MULTI_DOMAIN flag so that multiple documents don't requ ...Show All

• Visual Studio Express Editions visual basic express or visual studio professiona? which one?

  I'm a developer who has downloaded vb express and sql server express for my home computer. I wanted to know if I should break down and buy visual studio 2005 professional or should I just stick with the express version of vb. My funds are very limited and my skills as a windows developer are still emerging. I'm not yet a great windows developer. I will use vb/sql express for personal projects and learning and possible small business applicat ...Show All

• SQL Server Error during database restore

  Hi, I'm trying to restore a database backup but I get this error.  What does it mean exactly Thanks! TITLE: Microsoft SQL Server Management Studio ------------------------------ Restore failed for Server 'WHIDBEY1'.  (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&ProdVer=9.00.1314.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationException ...Show All

• Microsoft ISV Community Center Forums Dialogsheets vs Userforms

  Hi all What are the disadvantages (or advantages ) of using dialogsheets rather than a UserForm in Excel 2002. Thanks Shasur Hi Shasur, Here's some information from our support engineer: For the diffrence between Dialogsheets and Userforms. They are for different use. Dialogsheet is a light weight simply form, for example, when you just need a win form but not want to build a entire application with lots o ...Show All

• SQL Server dynamic connection string

  hi all, i've been reading through the forum on this subject but couldn't find the solution. i'm using RS2005. it's mentioned that dynamic connection string is not applicable for shared data source. is there a workaround for this thanks! Dynamic connection strings cannot be used with shared data sources. Other suggestions can be found in this related thread: http://forums.microsoft.com/MSDN/ShowPost ...Show All

• Visual Studio 2008 (Pre-release) ComboBox bug

  This looks very much like a bug. ComboBox binding doesn't seem to work when the datasource is an ADO.NET DataTable. This code is based on the ExpenseIt sample where the binding is to a CLR class. < XmlDataProvider x:Key = " ComboItemsData " XPath = " /ComboItems/* " > < x:XData > < ComboItems xmlns = "" > < ComboItem Value = " 1 " Text = " Accepted " ...Show All

• Windows Forms TreeListViewItem Check

  Hi, I am designing a page where I have two controls . One is TreeListView and one is listbox. I like to populate the listbox with the data from Database based on treelistview item selected. I want to click/check on one of the checkbox in TreeListView and that is used as input to fetch data from database. Now my problem is when i click on a checkbox in treelistView the treeLIstViewItem checked property is not set till the TreeLIstView is displaye ...Show All

• .NET Development New Cryptographic features of .Net 2.0

  I'm looking for code about the new X509Certitficate2 class, and how to manage digital signatures to be compatible with CAPICOM thx rido For the beta release of the documentation, X509Certificate2 was called X509CertificateEX.  You can find the Beta docs here:  http://msdn2.microsoft.com/library/ms148409(en-us,vs.80).aspx . Stephen ...Show All