eglasius's Q&A profile

• Visual C# passing multiple parameters to a stored procedure in SQL 2005

  Hello, I am using VS 2003 connecting to a SQL 2005 Server. I am pretty new to working with stored procedures. I currently can successfully pass a single parameter to the procedure and have it execute correctly; however I am now needing to pass multiple parameters including integers and strings to the stored procedure and my book only shows passing one parameter. How can I efficiently pass multiple types of parameters Stored Procedure ...Show All

• Windows Forms NullReferenceException in Unknown Module when binding 2 checkboxes.

  Hi, I am getting a nullreferenceexception in Unknown Module, additional information: Object reference not set to a instance of an object when databinding 2 checkboxes in my form. This form is a secondary form called modally from the startup form. When I step through the code slowly, I don't get this error, I also don't get this error when I call show instead of ShowDialog. When I comment out one of the binding statements, I also no longer ...Show All

• Software Development for Windows Vista ASP.net and workflowaborted

  Hi, I have a state machine which works fine until it reaches the Completed State. At this point, it doesn't complete, but the runtime raises the workflowaborted event after a long period. Where's the problem I use SqlPersistenceService for persistence. Thanks Here is how I usually debug problems like this. Run the workflow in the debugger - but before do Ctrl-Alt-E - this brings up the exceptions di ...Show All

• SQL Server SQL Server Backups - Help please

  Hi, Sorry, If I have chosen the wrong forum could someone point me in the right direction. I am new to SQL Server 2005 (in fact also to Visual Studio 2005...). I am trying to find how I can simply create backup(s) - daily if possible of the new database I have created. I would also like to create a script of all the tables I have so far created including indexes etc... to be able to recover from any failure and or transfer data to anoth ...Show All

• .NET Development Winsock

  Are you using the System.Net namespace in the .Net Framework or some thirdparty components ...Show All

• Visual C++ BOOST with visual c++ 2005

  Has anyone been able to get the full BOOST suite compiled and working with vc++ 2005 (and as in full I mean threads, bgl, lambda, date and time etc) Arash Partow Just to keep you updated. The libraries folks are actually investigating the issue. Take a look at http://lab.msdn.microsoft.com/ProductFeedback/viewFeedback.aspx feedbackid=e08bd793-3fef-40ff-adda-ed313e0eafcc  where the bug was upda ...Show All

• SQL Server List all your connection managers

  Hello, I'm building a custom task which has a property ConnectionManager which obviously allows you to select which connection manager you're goinng to use. I know how to get the list of connection managers but how do I make them appear in a combo-box in the properties pane Anyone got some code for that Hopefully this is fairly trivial for you developer types out there. Thanks Jamie I believe that the key is the TypeConverter property of p ...Show All

• .NET Development ExecuteReader Error

  Can anyone tell me what is wrong with this code : SqlConnection con = new SqlConnection("Data Source=(local);Initial Catalog=Orders; User id=sa");     SqlCommand comm = new SqlCommand("Select * from cust", con); con.Open(); SqlDataReader dr = comm.ExecuteReader(); while (dr.Read()) {       Response.Write(dr.GetSqlValue(0).ToString());       Response.Write(dr.GetSqlValu ...Show All

• .NET Development DataTable as a Property of an object issue

  Hi Folks, Sorry for the newb question. I'm trying to expose a datatable as a property in a business object for the UI to bind to. I'm able to create controls at run time, fill and databind things ok, but when I try to update the info back to the DB nothing happens. I found that the member variable I use for the property isn't getting the updates from the property DataTable. I hope this makes sense. So when I call DA.Update nothing happens ...Show All

• .NET Development filtering rows in a dataset

  Hi, I am trying to filter rows in a dataset, using a dataview, and an input textbox for selection, anyone have any ideas that may be able to help here is a sample of the base code; Friend WithEvents PictureBox1 As System.Windows.Forms.PictureBox Friend WithEvents OleDbDataAdapter1 As System.Data.OleDb.OleDbDataAdapter Friend WithEvents OleDbConnection1 As System.Data.OleDb.OleDbConnection Friend WithEvents Loadbtn As System.Windows.Forms. ...Show All

• Visual Studio Team System Get all changesets number that linked to work items

  Hi, How can I get the list of all the changesets that linked to a specific work item with the API Thanks, Michael. It maybe something like this: for (int i = 0; i < workitem.Links.Count; i++) {   Link link = workitem.Links ;   ExternalLink elink = link as ExternalLink;   if (elink != null && elink.ArtifactLinkType.Name == RegisteredLinks.Changeset)   {     Console.WriteLine("{0} ...Show All

• Windows Forms Saving Local Files from my Program

  Hi all, I have a full-trust application that I have successfully deployed with ClickOnce. Deployment and updates work perfectly, so that's not what this post is about. My problem is ClickOnce-related, though, so I thought I'd post here rather than in the Windows Forms group. The application saves thumbnails of images from the web in a local folder, and references them by filename in a WebBrowser component (in <img> tags). Currently I'm ...Show All

• Visual Studio Express Editions whats better

  i have a project to create a form to order online and i want to use MS access fro the database what is better to use for web design vb or vb.net and how i can use ASP to connect between the forms and the database www.asp.net is the place to ask these sort of questions The answer is VB.NET. ASP is a disaster. ASP.NET is awesome. There is no comparison. ...Show All

• .NET Development Remotely accessing system certificate stores

  I am developing a C application to use SSL/TLS.  Using the samples provided by MS, I have been generally successful.  I am using a stand-alone CA at this time.  I have been able to run my server and client with a SSL connection on the same machine as well as 2 separate machines.  However, to get this to work I have had to install the certificates on the machine on which the program is running.  The issue that continues ...Show All

• SQL Server SQL 2005 Supports strongly typed variables/parameters?

  Hi, Does SQL Server 2005 support strongly typed variables/parameters i.e can we have a stored proc with input parameter that directly maps to a table column similarly also for local variables.. makes the tables the only point of change when datatypes in tables change Or as a workaround, can we define a UDT that can maps directly to a table column and then use that UDT in an SP parameter You define a UDT and ...Show All