Bob Palank's Q&A profile

• .NET Development Serialization error with SqlConnection variable

  I'm getting a serialization error in ASP.NET when it tries to store one of my classes in the Session state. I marked the SqlConnection variable as non-serializable but it still tries to store it in the session state. My class looks like this: [Serializable] public class SqlServerDAL { [XmlIgnoreAttribute] private SqlConnection Connection; } Any ideas why this is happening even though I marked it with the XmlIgnoreAttribute Unable to serialize the session state. In 'StateServer' and 'SQLServer' mode, ASP.NET will serialize the session state objects, and as a result non-serializable objects or MarshalByRef objects are not permitted. The same restriction applies if similar serialization is done by the custom session state store in 'C ...Show All

• Visual Studio making, printing and emailing a crystal report

  ok so i have an application using Visual Basic .NET 2005 that gets information about a new employee... (the form i am working on right now is a new employee request) it populates an access database, I would like for it to also populate (i dont know if that is the right word) a crystal report so that i can print out that report as well as email it... my problem right now is that i have no idea how to make the report... i have been told that i can link it to the database and pull the fields from there but i dont know how to do that either... any help is very much appreciated... and if you need any clarification on what i am talking about... let me know... thx... Ian ...Show All

• .NET Development pass values between web pages

  I have 2 pages and I want to pass values from one to other. I looked at this link http://msdn2.microsoft.com/en-us/library/6c3yckfw.aspx and I found a solution. When I implement myself, I have some problem: Source page: ------------- public partial class TreeView : System.Web.UI.Page { public string SelectedNodeText { get { return TreeView1.SelectedNode.Text; } } } Target page: ------------- private string selectedNodeText; protected void Page_Load(object sender, EventArgs e) { if(Page.PreviousPage != null) { TreeView treeView1 = (TreeView)Page.PreviousPage.FindControl("TreeView1"); selectedNodeText = treeView1.SelectedNode.Text; BriefRiskDescriptionTextBox.Text = sel ...Show All

• Microsoft ISV Community Center Forums What MS development tool is best to solve this scenario?

  We have a file that is transfered from mainframe to SQL Server 2003 that is later uploaded into Oracle. Some records can fail during the upload and they are placed in an error file (Oracle bad file). I would like to develop a solution to read the error file records, display modifiable fields (not all fields) for each record. And to allow the user to change some values if need be. The user needs to also just select records to be reprocessed. The selected and/or updated records then need to be created in a file that will have the same name as the original upload file. This will allow Oracle to recognize it and be able to load it a second time. What is the best MS tool to use to develope this Is MS Access not powerful enough to handle thi ...Show All

• Windows Forms issues with 2003 bootstrapper - for the love of god please help me

  I am running vs2002. I have followed the directions and done every step on the microsoft site here: (http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnnetdep/html/vsredistdeploy1_1.asp _r=1) Everything looks right on directions and my dev machine: To install the .NET Framework with a Setup project Make sure that the Visual Studio .NET Framework Bootstrapper Plug-in is installed. Select the Setup project in Solution Explorer. On the Project menu, choose Properties . Set the Bootstrapper property to Windows Installer Bootstrapper . The .NET Framework redistributable will be packaged with the Setup.exe for the Setup project when it is built. Note The .NET Framework launch condition must also be en ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Point sprites in XNA

  I was wondering if i would be possible to display point sprites (in 3D) using the BasicEffect When I specify the position and the texture, I see colored points where the sprites should be (really the size of pixels). I guess the BasicEffect doesn't support point sprites, but because I cannot find the PointScaleA-C renderstates in XNA, I still have some hope. I found the PointSpriteEnable renderstate remained functional: setting this to false would draw black pixels at the position of my point sprites. Try something like this as a starting point: float4x4 View; float4x4 Projection; texture Texture; sampler Sampler = sampler_state { Texture = (Texture); MinFilter = Linear; MagFilt ...Show All

• .NET Development .Net Framework 3.0 hangs during setup

  I've tried both the web and full dowloads (dotnetfx3). Both fail at exactly the same point: the screen show "Setup is loading installation components. This may take a minute or two". The status bar gets to about the 100% point, but then remains that way. The last few lines of the log show: [02/25/07,11:35:08] WapUI: Entering CFeaturePage Create [02/25/07,11:35:08] WapUI: CFeaturePage::PopulateTree: Creating a new CComponent Object... [02/25/07,11:35:08] vs70uimgr: CUIMgr::ThreadUI(): Finished creating the page. [02/25/07,11:35:08] vs70uimgr: CUIMgr::ThreadUI(): Getting the Header. [02/25/07,11:35:08] vs70uimgr: CUIMgr::ThreadUI(): Finished Getting the Header. [02/25/07,11:35:08] vs70uimgr: CUIMgr::ThreadUI(): Current page does ...Show All

• Visual C++ Linker Error with STL on Release Mode

  Hi, I'm using Visual Studio 2003. Each time I use some STL library like string, fstream... I get many linking errors but only when compiling in Release mode. I get LNK2001 and LNK2019... I've been looking in the forum for some answers but I don't get it right. PLEASE, HELP Code will generate this error message if it references something (like a function, variable, or label) that the linker can’t find in all t1he libraries and object files it searches. In general, there are two reasons this error occurs: what the code asks for doesn’t exist (the symbol is spelled incorrectly or uses the wrong case, for example), or the code asks for the wrong thing (you are using mixed versions of t ...Show All

• SQL Server Cannot configure SQL Server Express 2005 for remote connections

  Hello. I have SQLEXPRESS 2005 installed on my laptop running Windows XP Home Edition with SP2. I have an application that can connect to the local instance with no problem. The other day, I tried to configure SQLEXPRESS 2005 for a remote connection from my desktop. To date, I have been unable to figure out how to do this. I have followed the instructions posted at various locations on the internet, but to no avail. While I can configure SQLEXPRESS 2005 to allow TCP/IP connections, I have been unable to restart the server. Here is the pertinent snippet from the error log: <time> Server A self-generated certificate was successfully loaded for encryption. <time> Server Error: 26024, Severity: 16, State: 1. 2006-08-14 21:02:27.18 ...Show All

• .NET Development Function and argument matching with regular expressions.

  I have strings like: MyFunctionCall(a.b(c.d.f, a).c,a.b.c.d) I would like to have a regular expression that can return if it is a function call, the name of the function and a list of the arguments to the function. I have started with: Regex regex = new Regex ( @"( <function>[A-Za-z]+)\(" + "\r\n" + @" ( >" + "\r\n" + @" [^()]+ " + "\r\n" + @" " + @"| \( ( <arguments>)" + "\r\n" + @" | \) ( <-arguments>)" + "\r\n" + @" " + @" )*" + "\r\n" + @" ( (arguments)( !))" + "\r\n" + @"\) | ( <function>[A-Za-z]+)" + ...Show All

• Visual C# System.Web.HttpException: Request timed out.

  The following program is to strip the string of its HTML tags. After running for several minutes, anyway, which is much longer than other normal program, then the error was complained finally. Why Thanks.   <%@ Import Namespace="System"%> <%@ Import Namespace="System.Text.RegularExpressions"%> <script language="C#" runat="server"> void Page_Load(object sender, EventArgs e) {      string temp = "<NOSCRIPT><IMG height=0 alt= src=HTMLfiles/s9.gif";      Response.Write(StripHTML(temp)); }     public static string StripHTML(string strHtml)   {    string [] aryReg ={           @"<script[^&g ...Show All

• SQL Server Format Date in Reports

  Dear friends I have a problem with the format date, because my database has the format yyyy/mm/dd and in the computer user's the default configuration of date is dd/mm/yyyy, the problem exists with the reports that have the parameter of date type, the users input dd/mm/yyyy and the report request error in the format. My question is, how do i make the any format input the users, i change in the report for this recieve the format yyyy/mm/dd, where is the parameter i have to change, the easy request is i have change the configuration of computer users, but i dont have this. Thank you You can do the conversion in the stored procedure using the CAST or CONVERT functions (or in the command text, depending on the command text). Or ...Show All

• Visual Basic While code not executed

  I have been staring on this code for a while and have been checking out watch window etc. I just don't get why the code doesn't go into the Bold area. Dim data(9,9) as integer Sub Vullen() Dim Rand As New System.Random Dim i, j, k As Integer Dim voorwaarde As Boolean Dim Imin As Integer For i = 1 To 9 voorwaarde = False For j = 1 To 9 Data(i, j) = Rand.Next(1, 9) While voorwaarde <> True Imin = i - 1 For k = 1 To Imin If Data(i, j) = Data(i, k) Then Data(i, j) = Rand.Next(1, 9) Else voorwaarde = True End If Next End While Next Next End Sub Yes it does, I thoug ...Show All

• SQL Server CanShrink Question

  Hello all, I have a report with a dataset similar to this: description0 35 description1 0 description2 0 description3 0 description4 0 description5 45 description6 0 description7 0 description8 50 description9 10 ..... I don't care to see the records with a zero numeric value so I've configured the two text boxes the list box to set their values to "nothing" if the numeric value is 0. I've also configured both text boxes canshrink property to true. When the report renders, I get this: desc. header numeric header ------------ -------------- description0 35 description5 45 description8 50 description9 10 .... I get one blank line where the grouping of 0 valued numeric records are. That tells me the cansh ...Show All

• Software Development for Windows Vista Application fails to start under Vista: "A referral was returned from the server." Manifest problem?

  I'm working on migrating a driver management application (written in Visual C++) to Vista. It requires access to HKLM, so it needs to run with admin access permissions. For testing purposes, we've been modifying secpol.msc to run it in admin approved mode, but obviously, that's not the right thing to do. The right thing to do, from what I can tell, is to add a <trustInfo> tag to the application manifest (which is embedded in the .exe as a resource). I did that, but now the application fails to start under Vista at all, with the error message "A referral was returned from the server." It still works fine under XP. The manifest is pasted below. Does anything look obviously incorrect If not, is there anything that could interact badly w ...Show All