Andrew Mackie's Q&A profile

• SQL Server WINS

  Does SQL 2005 require WINS You will probably have a WINS name, which is assigned to the Server but you don’t need a WINS service as SQL Server also runs on a single machine without any server services. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• .NET Development XML File Handling Using C#

  hi how can i check whether the XML file is exist or not. in case of existing how can i go to particular Node and Update it. i am finding tons of sample code for reading and writing XML files. but i have to check whether the file exist or not. pls help me out. Thanks and regards ranu. To check if the file exists you can use the System.IO.File.Exists method, that will tell you if a file exists. Then to update a particular node then one way is to load the data into an XmlDocument and use the SelectSingleNode method to retrieve the node you want, this uses an XPath query to obtain the node. Mark. ...Show All

• SQL Server fails using LoadFromSqlServer

  hi everyone, I'm trying to load a dtsx from my front-end app but says the following: pkg = app.LoadFromSqlServer(ActObject.packageName, "SRVDESASQL2005" , "usrSSIS" , "ninot" , Nothing ) ActObject.packageName = "\SSISdev" usrSSIS is a sql user which own enough permissions over MSDB Try returns me: "Specified package could not have been loaded in Sql Server" Any ideas I'm stuck. TIA ok, works I set this path:"Maintenance Plans\Tru_DevolucionesRecibidas" but another error raises (there is another post related with) Acquire Connection.   http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=646743&SiteID=1       ...Show All

• SQL Server Create login and user

  Hi, I’m new in this. I’m trying to create a user with the following code, but in the yellow part it throw an error saying the user can’t be created. Please if somebody can say what the problem is or correct the problem for me I will be thankful: Public Sub CreateUser() Dim conn As New ServerConnection( "STATION01\SQLEXPRESS" , "admin" , "a9078564" ) 'conn.DatabaseName = "VideoDB" Dim myServer As New Server(conn) If Not myServer.Logins.Contains(TextBox2.Text) Then Dim db_login As New Login(myServer, TextBox2.Text) db_login.LoginType = LoginType.SqlLogin db_login.Create(TextBox3.Text) ...Show All

• Visual Studio 2008 (Pre-release) WPF Overview for Executives

  An executive at my company expressed interest in WPF to me, but is not quite clear on what it provides over and above other UI platforms. If he knew what it is and can do, it would be easier for him to "sell WPF" to clients (i.e. provide me with the opportunity to work with WPF on the job!). Does anyone know of a good overview with images and/or videos which would help someone in that position gain a high-level appreciation for what WPF is all about I've looked around, but most of the things I've seen get too geeky and stray away from ways to justify including WPF in a new application's technology stack. Sure for experimentation and demos by all means use WPF and have fun - and its great if you have forward thinking bosses ...Show All

• Visual Basic whe "running programs that are aoutside my own."

  i wanna know were i can find someone to answer this question please. How to Run programs that are aoutside my own And could you tell the mod on the post i tould you above that this is not a duplicate post please because i came here to ask where to post the other and you tried to help me how was i suppose t know that it's embaracing to have a post locked down... (and a good one) ...Show All

• SQL Server Jump to URL

  Hi, In one CaseLog report i implemented the navigation i.e navigate to another report CaseDetail Casedetail displaying the case information for the given case.In CaseLog Report when we click on CaseID it navigate to the CaseDetail report by taking CaseID as parameter and display information about that case.For this navigation iam using Javascript.Window.Open("Path DisplayReports.Aspx Report=CaseDetail&caseID=" & FieldscaCaseID.Value In DisplayReports.Aspx we are checking If(Request.queryString["CaseID"]!=Null) { ReportParameter rp=new ReportParameter("CaseID",Request.Querystring["CaseID"].ToString()) } When we click on CaseID it is taking into another window an ...Show All

• Visual Basic how to use the progress Bar

  i have developed an application that copies records from one table in Database1 to another table in Database2. i want to use the progress bar to display the progress of the copying. please how do i do this Why would you have to do any threading.... If you want to copy the records from one dataset to another - then as long as you have specific actions which you can set the progressbar property at then you can do it all on the main thread.    Of course while the copy is going on the UI may become a little unresponsive - which if you wanted to remain responsive so you could do other things then a background thread may be a good idea - but if your simply wanting to show the progress after each row has been copie ...Show All

• Visual Studio Upgrade to VB.net 2005 gives - the given assembly name or codebase was invalid

  Just upgrading a VB.NET COM enabled DLL (class library) from VS 2003 to VS 2005 I am getting this error message... Error 1 'The given assembly name or codebase was invalid. (Exception from HRESULT: 0x80131047)' C:\company5\BusClassNET04\LC companybusinessclass5 The file LC does not exist Another similar project compiles OK so I am really confused as to why this is happening. I have tried shortening the assembly name. I don't really understand codebase but the text "codebase" does not occur in the entire project. Any help would be appreciated   I got the same error when I tried to add a business object as datasource item. The problem was a class in my project ...Show All

• .NET Development oracleCommand error

  someone..please tell me what is wrong with my code i get an error when trying to open the connection. but in my second form i could connect to the database. i just dont get what is my mistake in here... OracleCommand insert1 = new OracleCommand("insert into customer(cusnum, cusdt, cusid, cusstatus, cuscode, cusname, cussex) values (:p1, :p2, :p3, :p4, :p5, :p6, :p7)"); insert1.Connection = new OracleConnection(oracle); OracleCommand insert2 = new OracleCommand("insert into request(reqnum, reqcode, reqname) values(:p8, :p9, :p10)"); insert2.Connection = new OracleConnection(oracle); OracleParameter p1 = new OracleParameter(":p1", OracleType.Number); p1.Value = txt1.Text; OracleParame ...Show All

• Software Development for Windows Vista Visual StudioR 2005 Extensions for .Net Framework 3.0 RC 1

  First of all, congratulation for the delivery of RC1. We have only run it for couple of hours but it already looks very promising. On the RC1 SDK download page ( http://www.microsoft.com/downloads/details.aspx FamilyID=1BB19978-B14D-4748-8B3B-A296E7BFE27F&displaylang=en ), there is a link to download the VS2005 extensions. But the link is unavailable ( http://www.microsoft.com/downloads/details.aspx FamilyId=935AABF9-D1D0-4FC9-B443-877D8EA6EAB8&displaylang=en ). When can we expect this. Or is the June CTP release still the latest valid one Thanks! Marc MarcGBeauchamp wrote: First of all, congratulation for the delivery of RC1. We have only run it for couple of hours but it already loo ...Show All

• Windows Forms How to bind the textbox in windows forms with the column in dataset?

  Hi I have manualy created a dataset and datatable and created 2 colums. My question is How do I bind a control (textbox or control) in the windows form with colum in the datatable(manualy created) Advance thanks Vaish, MyCompanyTextBox.DataBindings.Add("Text", MyDataSet.Tables["MyTable"], "CompanyName"); MyAddressTextBox.DataBindings.Add("Text", MyDataSet.Tables["MyTable"], "CompanyAddress"); ~~Bonnie ...Show All

• Visual Studio 2008 (Pre-release) Suggestion: Can TextSearch be improved to support to search string of other language?

  Chinese seems not to be supported currently. Hope so. Chinese text are well supported, for instance: < Grid xmlns = " http://schemas.microsoft.com/winfx/2006/xaml/presentation " > < ComboBox IsEditable = " true " > < TextBlock TextSearch.Text = " 中 " > People's Republic Of China </ TextBlock > < TextBlock TextSearch.Text = " 美 " > United States of America </ TextBlock > < TextBlock TextSearch.Text = " 英 " > United Kingdom of Great Britain and Northern Ireland </ TextBlock > </ ComboBox > </ Grid > last time when I had problem with WPF's support of Chinese is that I tried to read ...Show All

• Visual C# Static constructors

  I have a class library assembly, and I would like some code to get executed whenever a referencing assembly uses it. Since it has no entry point (being a library) I've been trying to force static constructors to execute, but the behavior is that they only do so before the first property, or method is touched, or instance created. So... is there any way to force some code in an assembly to run when it is loaded into an app domain Thanks! Andrew Don’t know if this old topic mixed DDL loading issue help you a bit, it’s up to your decision. ...Show All

• Software Development for Windows Vista Get ExecutionContext from within a HandleExternalEventActivity Handler!

  Hello guys, My question is this... Lets suppose i have a nice HandleExternalEventActivity listening to an Event of a service that implements ExternalDataExchange, all the necessary things implemented. There is nothing wrong here... the workflow blocks when it reachs this activity, goes idle, then when the event fires the HandleExternalEventActivity handler receives the arguments passed by the publisher, etc... What i want to ask is this... If i want to retrieve a service that its added to the WorkflowRuntime by the host application from within the HandleExternalEventActivity handler how do i do this I tried to find a way but the only two ways that i know to get a service from inside an activity is by the ActivityExecutionCont ...Show All