netpicker9's Q&A profile

• Visual C# ConfigurationManager

  i have a problem with ConfigurationManager try { SqlConnection SqlCon = new SqlConnection(ConfigurationManager.ConnectionStrings["PPADB"].ConnectionString); //string mstrConnStr = ConfigurationManager.AppSettings["PPADB"].ToString(); } catch (NullReferenceException e) { MessageBox.Show(e.Message.ToString()); } my code in app.config <connectionStrings> <add name="PPADB" connectionString="Data Source=emr;Initial Catalog=PPA;integrated security=true;"/> </connectionStrings> how come i get an error of "Object reference not set to an instance of an Object". i already referenced System.Configuration Well, I gue ...Show All

• SQL Server TSQL and Bulk Insert

  I've been staring at two scripts for hours now. Save a few key strokes they are identical. One works perfectly and the other errors out. The first is: USE BLADeS_DW TRUNCATE TABLE ST_BLDS_TRNS GO DECLARE @Address varchar (500) DECLARE @fileName varchar (500) DECLARE @Command nvarchar(1000) SET @Address = '\\CRPSFOMSQ47\Incoming\BLADeS\' SET @fileName = 'FNIISA8N.' SET @fileName = @fileName + CONVERT(char(4),YEAR(getdate())) SET @fileName = @fileName + CONVERT(char(2),MONTH(getdate())) SET @fileName = @fileName + CONVERT(char(2),DAY(getdate())) SET @Command = 'BULK INSERT BLADeS_DW.dbo.ST_BLDS_TRNS FROM ''' + @Address + @fileName + ''' WITH ( FORMATFILE = ''\\crpsfomsq47\BulkInsert-Formatting\BLADeS_TRANS ...Show All

• .NET Development Why FileSystemWatcher reports the wrong file name?

  We are using FileSystemWatcher in our website project to monitor the configuration files. However, after a file is modified, the reported FullPath in is not the actual file name. E.g, there is a configuration file N:\SourceCode\...\DataCommand.config while the reported file name is N:\SourceCode\...\ve-32E1.tmp or N:\SourceCode\...\ve-32E2.tmp or even sometimes N:\SourceCode\...\DataCommand.config~RF20a125a3.TMP but never the right one. This issue is very confusing and makes a major component in the system stop functioning. So I really hope someone can explain why this is happening and what the walkaround is. Thanks very much. The project type is the latest VS2005 ASP.Net Web Application. Software env: windows 2003 ent, ...Show All

• .NET Development Just first access, SerializationException: Unable to find assembly

  Hello, I have seen different flavour of this problem in different places, but as far as I concern none of them has a solution for it. I am using Remoting, .Net2.0, and C#. The server components are running as Windows Service. Whenever the service gets started (restart or install) Only the first access to the service throws the following exception. SerializationException: Unable to find assembly The subsequents access are working fine. Any idea why this happens Many thanks, Thanks Gandolf. It works fine now, and I can see the error. It says: Using application configuration file: < config path > Using machine configuration file from: < Machine config path > Attempting d ...Show All

• SQL Server SQL Replication: 2005 (Publisher) and a 2000 (Subscriber)???

  Hi, I was wondering if it is possible to setup replication between a 2005 SQL Publisher and a 2000 SQL Subscriber Is there any special setup steps I need Thanks so much, David Hi David, Yes. It is possible. For things to consider, you may check out this document: http://msdn2.microsoft.com/en-us/library/ms143241.aspx . You would need a 2005 SQL distributor. Peng ...Show All

• Visual Studio Express Editions Saving data to my database server

  Why any data/record don't get saved to my database - I tried with SQL and Access -Even I replayed Tutorial video, and learning VB through the VB Ex.Edition 2005 several times. - Codes of TabelBindingSource, and TabelAdaptor are correct as standard. - Primery Key on the database has been set. Hope to get some help. Thanks First of all it's "code" and not codes. Obviously your code isn't correct it's not doing what you want it to. But no one can diagnose problems with code they can't see. ...Show All

• Visual Studio Crystal Report Design Problem

  Dear All, I have this problem of designing my report in Crystal Report. Basically my table structure is as below ID OutletID Type Serial 1 1 A 1112 2 1 B 1123 3 1 C 1200 4 2 C 1201 5 2 C 1202 I have the first field as a primary key followed by outletID and the third out is type. I want to desinging my report such as on the header I will have OutletID A 1112 B 1123 C 1200 - 1202 The problem is that for Type A and Type B I want to list as it is. But for only type C I want to put them i ...Show All

• SQL Server Insert row in table with Identity field, and get new Identity back

  I want to insert a new record into a table with an Identity field and return the new Identify field value back to the data stream (for later insertion as a foreign key in another table). What is the most direct way to do this in SSIS TIA, barkingdog P.S. Or should I pass the identity value back in a variable and not make it part of the data stream Regarding "Many a design has foundered on that assumption, as just the teensiest smidgin of parallelism soon throws that process out of synchronization." 1. If my job is the only one updating the table with the Identity column , and I'm not running multiple copies of my job, then I presume that parallellism can't hap ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Fullscreen problems....

  EDIT: I am using Beta 2. I use this as the constructor method... public Game1() { graphics = new GraphicsDeviceManager(this); graphics.PreferredBackBufferWidth = 640; graphics.PreferredBackBufferHeight = 480; graphics.PreferMultiSampling = true; graphics.ToggleFullScreen(); content = new ContentManager(Services); } Works great. But when I change the resolution to 800x600, all I get is a black screen. The loop is still running because I can still quit the program. I have also tried 1024x768, that works too. Thought maybe it was an aspect ratio problem, but they are all the same, 1.3333... I have tried turning the multisampling off to no avail. Didnt think that would be it anyways, I play World of Warcraft at 800x60 ...Show All

• Visual Studio 2008 (Pre-release) server.mappath equivalent in xaml

  I am converting aspx pages to xaml pages. so i need the equivalent method for server.mappath() in aspx. There isn't a straight analogy. In an XBAP or standalone WPF app, you can use the pack://siteoforigin:,,,/ Base Uri for your relative Uris, or the Application.GetRemoteStream(relativeUri).Stream. In loose or uncompiled XAML, when you use a relative Uri, it automatically corresponds to the site of origin location for Base Uri. ...Show All

• Visual C# Problem handling the window messages!

  I wrote this code: private const int WM_NCLBUTTONDOWN = 0xA1; private const int WM_NCLBUTTONUP = 0xA2; protected override void DefWndProc (ref Message m) { if (m.Msg == WM_NCLBUTTONDOWN ) { return; } } else if (m.Msg == WM_NCLBUTTONUP ) { return; } } base.DefWndProc(ref m) ; } protected override void WndProc (ref Message m) { if (m.Msg == WM_NCLBUTTONDOWN ) { return; } } else if (m.Msg == WM_NCLBUTTONUP ) { return; } } base.WndProc(ref m) ; } I was going to write a real event handler for minimize button click. When you click the minimize button ...Show All

• .NET Development Why are there extra items in List after Deserializing?

  Actually, I know why. What I need to know is the best way to get around this. Here's the deal: I have a class that exposes a List<>. In the constructor of this class, a couple items are added to the list. i.e. public class MyClass { private List<OtherObject> m_list; public List<OtherObject> List { get { return m_list; } set { m_list = value; } } public MyClass() { m_list = new List<OtherObject>(); //every instanced of this class starts with objects in the list m_list.Add(new OtherObject()); m_list.Add(new OtherObject()); m_list.Add(new OtherObject()); } } When serializing this object, everything looks c ...Show All

• Windows Forms DatagridView Header Column

  Hi, I want to place a pannel which contains one label, checkbox in the DataGridView header. Can any one have any idea how to do it. Thanks & Regards Maybe this will help. ...Show All

• Internet Explorer Development IE7 and ASP.NET 2.0 Website problems displaying

  HI all, I have a site in ASP.NET 2.0 and in IE6 it works perfectly but in IE7 it looks terrible. Panel controls are displayed over HTML tables GridViews are displayed over any other control etc... I have tried putting everything into a panel control and setting its height to 100% but it didn't help I have also tried putting the whole page into a table : <table height=100%><tr><td> whole page here </td></tr></table> but that didn't help either. It must be something to do with the IE7 I am running version : 7.0.5700.6 Thanks for any help ya same problem persisit with my application .please reply to this problem. i am waiting for your ...Show All

• SQL Server Specify cell background color for cell that contains subreport

  Hello. I have a subreport in a cell and I can't specify the background color of the cell. I have a "dummy" dataset in the subreport to always return data so that it appears grey, but the problem lies in when there is a carriage return/line feed. The next row will be white with color only where the subreport is located and not where other subreports in the same row are located with no carriage return/linefeed. Thanks! BJ I have it set in the subreport and it is fine when the subreport itself will bleed to the next line because it has a background color set. If I have a subreport in the same line as another, if the other bleeds to the next line and the other doesn't it will show a white backgroun ...Show All