JustinM's Q&A profile

• .NET Development Modifying Access query from .NET

  We have application where we need to be able to update the access 2000 queries at startup of applications. How do I do that programatically The queries are stored in Access database. They are created directly in Access, but if any of the queries change after implementation, we need the ability to modify it from .NET. ...Show All

• Visual Studio Express Editions Sending e-mail within VB Express

  I am using and SMTP relay program on my machine "Free SMTP Server". I am using the following code to try and send an e-mail from my program: 'Create a new MailMessage object and specify the"From" and "To" addresses Dim Email As New System.Net.Mail.MailMessage( "myEmail@gmail.com" , "myEmail@gmail.com" ) Email.Subject = "test subject" Email.Body = "this is a test" Dim mailClient As New System.Net.Mail.SmtpClient() 'This object stores the authentication values Dim basicAuthenticationInfo As _ New System.Net.NetworkCredential( "myUserName" , "myPassword" ) mailClient.Host = "localhost&quo ...Show All

• Microsoft ISV Community Center Forums Count and display in cell

  Ok I have an Excel workbook that contains a schedule (51 worksheets total). Each cell has intials in it and if that person has taken a day off the cell is highlighted a certain color (yellow, rose, or red). What I need to do is have something that goes through and counts what intials have what color and then display in a cell the number. So: If cell contains "initials" and cell color is "color" Then count and display in "cell" Example: If cell contains "JJ" and cell color is "Yellow" Then count and display in "A2" I know it is possible to do this but I'm not sure how. Tiger I did not mean to post the same three times. Its ...Show All

• SharePoint Products and Technologies MOSS 2007 RSS Viewer's XSL Link not working

  Has anybody been able to get the MOSS 2007 RSS Viewer Web Part to work with the XSL Link I have an RSS feed file and a style sheet in the same anonymously accessible location. It works fine if I just point the web part at the RSS feed. If I try to use the XSL link, it fails every time with this error in the logs: RssWebPart: Exception handed to HandleXslException.HandleException System.ArgumentNullException: Value cannot be null. Parameter name: s at System.IO.StringReader..ctor(String s) at Microsoft.SharePoint.WebPartPages.DataFormWebPart.GetXslCompiledTransform() at Microsoft.SharePoint.WebPartPages.DataFormWebPart.PrepareAndPerformTransform() I started by using the default XSL copied from "XSL Editor..." in the web part. ...Show All

• .NET Development How to terminate Asynch call?

  Hi, How to terminate Asynchronous call. I am calling BeginAcceptTcpClient, there is no TcpClient available, i want to terminate (or stop) that thread. IAsyncResult ar = _tcpListener.BeginAcceptTcpClient(AcceptAsynCallBackResult, _tcpListener); Kindly suggest me how to go about Thanks & Regards, kalai Yes, the callback is called and it will throw ObjectDisposedException on EndAccept. class Program { static TcpListener listener = new TcpListener(347); static void Main() { listener.Start(); IAsyncResult ar = listener.BeginAcceptTcpClient(OnConnect, null ); Console.WriteLine( "Press ENTER to stop..." ); Console.ReadLine(); listener.Stop( ...Show All

• Visual Studio 2008 (Pre-release) XML Namespaces: Mapping to CLR Namespaces

  I found that I can do this: [assembly: System.Runtime.Serialization.ContractNamespaceAttribute("urn:hello:world", ClrNamespace="my.company.some.name.space")] for DataContracts in order to set the XML namespace (urn:hello:world) for all business objects namespace ( my.company.some.name.space ). Is there a way to do something similar if I am providing backwards compatibility to .ASMX pages I would like to NOT have to add [XmlRoot(Namespace="my.company.some.name.space")] to every DataContract. Thanks, Dave How is using svcutil applicable to adding an attribute to the DataContract in the service using System.Runtime.Serialization; [assembly: ContractNa ...Show All

• SQL Server How to make a File Share Subscription running on Vista?

  I recently migrate to Vista.   I had a bunch of reports with file share subscriptions that were running fine on XP.   After installing reporting services on vista (that part only was a challenge), I re-created my subscriptions using the report manager.   As expected, when a subscription is executed, the ‘last run’ column shows the last time the report output has been delivered to the file share and the ‘status’ column shows ‘New Subscription’.   I thought that this was the signature of a successfully configured subscription.   But surprisingly, there is nothing in the file share. The directory is empty.   Anybody has an idea why   Anybody knows how I could possibly find information on my ...Show All

• Visual C# remote database

  Hi can anybody know how to create a database on remote system using ado.net sqlserver and c# I tried like this SqlConnection _sqlConnection = new SqlConnection ( "Data Source = (192.168.1.77); Integrated Security=yes" ); SqlCommand _sqlCommand = new SqlCommand ( "create database employee;" , _sqlConnection); _sqlConnection.Open(); _sqlCommand.ExecuteNonQuery(); _sqlConnection.Close(); but it shows exeception like An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not o ...Show All

• SQL Server Moving reports backward from RS2005 to RS2000

  Is there a nice way to get reports from an RS2005 project into an RS2000 project I know this sounds like an odd request but I have built reports in RS2005 that need to be deployed to a server with only 2000 on it. I don't really want to have to go in and re-draw all those reports. Any ideas would be most appreciated! Thanks, Eva YAY!!!! Thank you, thank you, thank you! for taking the time to post that link. It worked like a charm and I just saved countless hours of work when this literally took seconds a report. You honest, really, and truly made my day Eva ...Show All

• Visual Studio Team System What three improvements would you suggest for DBPro setup process?

  1. Data Generation: To allow for "Test Data AS IS" to be Checked-In, Checked-Out, Shelved and Deployed- similar to Data Generation plans. Thanks, If you think about Data Compare and its ability to generate data diff scripts; and imagen you make this part of the build system, so you can generate a data diff script as part of the build; how much would that address your needs So you would keep the source data inside your project. During build we would compare this data with the target, the same way would do this for schema and generate diff script Deployment would execute the data diff script The result being that you have updated the information inside the table on the target ...Show All

• Visual Studio 2008 (Pre-release) Release build of .NET 3.0 has broken my application publishing

  Before uninstalling September beta version of WPF I was able to publish my application. Now, with the release version of WPF, after a complete rebuild, I get the following error when I try to publish the application: Error 2 SignTool reported an error 'Failed to sign .\bin\Release\MySample.publish\\setup.exe. SignTool Error: Signtool requires CAPICOM version 2.1.0.1 or higher. Please copy the latest version of CAPICOM.dll into the directory that contains SignTool.exe. If CAPICOM.dll exists, you may not have proper permissions to install CAPICOM. CAPICOM.dll does exist and its version is 2.1.0.2 (10/30/2006). Just in case, I manually registered the dll with regsvr32 but it made no difference. Does anybody know why this is ha ...Show All

• Visual FoxPro Visual Foxpro report writer

  I have a dbf with following fields bill no, bill date, cust name,item name,qty,rate,amount and i have 553 records. i want a simple report on 132 column stationary. i dont want totals also. (so no page footer or summary). i used visual foxpro report writer. but the report does not print with proper ejection i.e. second page starts printing from bottom of first page and third page prints from bottom of second page and so on. printer is absolutely fine because documents from excel and word print with proper page breaks. can anybody help The only setting you have is on th report PROPERTIES page. I don't believe there is a "custom" length setting any more - that relates to the days when you could create your lown loca ...Show All

• Visual Studio Express Editions vb 2005 or vc# 2005??

  I have the option of wither taking visual basic.net 2005 or visual c# 2005 in a college class (3 credits, 4 months long)..What should i take, i know how each looks and feels, however, i need some advice from the pros..I just want to make sure that whatever i pick up, it going to be a good choice...also, i hear a lot of neg remarks about vb6, i havent heard to much about vs 2005.. Thanks hi, vb and C# both of them target the same library FCL(framework class library) the only difference between them is the program syntax for example c# use if(Condition == true) { //do come code here } in vb you write it like if Condition = true then //do come code here end if but as Ahmed said C# is the .net fram ...Show All

• Windows Forms Q: Accessing a control from another thread

  Hello everybody. I have the following situation. On the main form I have a Button and a ProgressBar. When I press the button I execute the following lines: private void button1_Click(object sender, EventArgs e) { myClass o_myClass = new myClass(ref progressBar1); ThreadPool.QueueUserWorkItem(new WaitCallback(o_myClass.Work)); } And here is how the myClass looks like: public class myClass { ProgressBar m_progressBar; public myClass(ref ProgressBar progressBar) { m_progressBar = progressBar; } public void Work(object state) { int max = 30000; m_progressBar.Maximum = max; for (int i = 0; i <= max; i++) { m_progressBar.Value++; } } } After pr ...Show All

• Visual C++ Delete a certain tree node

  hi, now i facing a problem which i do not know how to solve it...:( My binary search tree structures stores a double number in every node, whereby a higher number is appended as right child and a less or equal number is appended as a left child. Now i want to write a function which deletes the node with the highest number in the tree. I started the function as follows: [code] template <class Item> void bst_remove_max(binary_tree_node<Item>*& root_ptr, Item& removed) // Precondition: root_ptr is a root pointer of a non-empty binary // search tree. // Postcondition: The largest item in the binary search tree has been // removed, and root_ptr now points to the root of the new (smaller) // binary search tree. Th ...Show All