Jeremy Schneider's Q&A profile

• SQL Server A transport-level error has occurred when sending the request to the server

  I've tried to search on the web for a solution for this error but i didn't find any working solutions for this problem. We have 2 servers. The first one is the server we use to develop our ASP.NET 2 application. On this server we don't have this error. On the other server (use by our client) we have this error sometime and i don't know why. Both servers have the same configuration and both application have the same web.config file. I've tried to add a try-catch and retry the query when the error occured. This seems to be working but we don't want to have to change all our connections and since we don't have this problem on the other server we want to find the source of the problem. Any idea Thanks ! The ...Show All

• .NET Development String and numbers

  Hi there. I would like to khow how can I use only numbers from the following string: T 30 35. From this string I want to use the two numbers as x = 30 and y = 35. T may be a dummy variable. I would appreciate if you could send me an example code. Thank you in advance. NM This is a BCL question I'd do this: public static List<int> ParseNumbers(string s) { string[] fields = s.Split(' '); List<int> results = new List<int>(); foreach (string field in fields) { int value = 0; if (int.TryParse(field, value)) results.Add(value); } return results; } This code assumes that the fields in the string are separated by spaces and that "T" is not a number. ...Show All

• SQL Server Prolonged execution for table UPDATE statement - not sure it finishes

  I am cleaning up a large database table that has Date keys instead of real DateTimes. To do this, I am running the following query... UPDATE MQIC.DBO.OBSERVATION_F SET MQIC.DBO.OBSERVATION_F.OBS_DATE = MQIC.DBO.DATE_D.ACTUAL_DATE FROM MQIC.DBO.OBSERVATION_F INNER JOIN MQIC.DBO.DATE_D ON MQIC.DBO.OBSERVATION_F.DATE_KEY = MQIC.DBO.DATE_D.DATE_KEY where Actual_Date is what is being stored, and the Date_Key is to be dropped. The particulars are this - Date_D table - 92,000 rows - 40 MB Observation_F - 20,000,000 rows - 3.2 GB This is being run on a remotedly hosted rack server with an AMD processor, 1 GB RAM, 60 GB harddisk space, 20 GB used. SQL-Server 2005 Express - SP1 If I do the same query as a SELECT statement... UPDATE MQI ...Show All

• Software Development for Windows Vista Problem encountered using Sample STS

  After running sample.htm, and try to send the self issued authentication managed card to the server. the following error occurs. Line 49: return GetResourceValue(claim); Line 50: } Line 51: throw new ArgumentException(String.Format("Claim {0} not found", uri)); Line 52: } Line 53: } [ArgumentException: Claim http://schemas.microsoft.com/ws/2005/05/identity/claims/givenname not found] Microsoft.IdentityModel.TokenProcessor.ClaimTextCollection.get_Item(String uri) in c:\Ronghwa\MS CardSpace\Simple STS\website\CardSpace\App_Code\TokenProcessor.cs:51 ASP.login_aspx.Page_Load(Object sender, EventArgs e) in c:\Ronghwa\MS CardSpace\Simple STS\website\CardSpace\login.aspx:26 Sys ...Show All

• SQL Server Sub Report Processing

  Can anybody give me a example of using subreport without a report viewer. Just i am exporting the report to PDF and Excel. I want to know how to bind the datasource to subreport. Call this event handler in Page_Load where you are providing main report. this .reportViewer1.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(SubreportEventHandler); private void SubreportEventHandler( object sender, SubreportProcessingEventArgs e) { e.DataSources.Add( new ReportDataSource( " SubReportDataSource " , SubReportDataTable)); } ...Show All

• Visual Studio 2008 (Pre-release) DLinq thread safety

  I am working on an application using both WCF and DLinq. As we all know, DLinq is not thread safe. Since DLinq supports lazy-loading, it is more difficult to control when the DLinq will get involved. There always will be more than one threads in WCF application. What is the best way to safely use DLinq I just wonder why DLinq itself is not thread safe. That is will be a lot easier for programmers. Keith Farmer wrote: I didn't promise (I'm not a PM). I merely suggested that it was something we recognize as highly desireable. :) Nonetheless - if they do instantiate quickly I'm giving you credit :) ...Show All

• Visual Studio 2008 (Pre-release) Problem locating ResourceDictionaries defined in external assembly

  Here is a setup: First project, A.B.Common includes two ResourceDictionaries defined in two separate files: Resources\First.xaml Resources\Second.xaml Build actions for those files are set as EmbeddedResource. This project produces A.B.Common.dll Also there is another project, A.B.Controls where custom controls reside. That project references A.B.Common . Part of this project is generic.xaml file, themes\generic.xaml . This file references ResourceDictionaries defined in A.B.Common : ... <ResourceDictionary.MergedDictionaries> <ResourceDictionary Source="/A.B.Common;Component/Resources/First.xaml" /> <ResourceDictionary Source="/A.B.Common;Component/Resources/Second.xaml" /> </ResourceDictio ...Show All

• Smart Device Development Breakpoints do not get hit...

  Hello,   a colleague has big troubles debugging compact framework 2.0 applications from his VS2005 environment (to be more specific: he has hijacked my PC because the troubles do not occur there ). The problem is that every CF2.0 application he runs will not break when run on a device, but the same application runs and hits the breakpoints on the device emulator. It doesn't matter if it is a big multi-project solution or just a simple little HelloWorld project, the debugger just isn't interested in breakpoints anymore.   We searched over this forum, but none of the solutions work for him. Some of the things we found and tried are: Deleting de bin/obj folders. Showing the Debug toolbar. ...Show All

• Visual C# how to reorder listView basied on BackColor?

  is it possible to reorder the listView items based on the BackColor of each row I want to keep all red rows on top regardless of its values. it might be a sily solution but you can try this. make the first colument of your list view a sorting column that is add only numbers in it. for example when you make the background color of a row to red make the first column property say '0'. so when you are done all coulumns having as background color of red shoud have the value 0 on their first columns. after that just sort the list view using this code ListView1.Sorting = SortOrder.Ascending; ListView1.Sort(); here the sample i tried using System; using System.Drawing; using System.Collections; usi ...Show All

• Visual Studio Express Editions how to retrieve data from listview to textbox?

  listview1 in Fullrowselect Id Number | Name 1 | a 2 | b 3 | c help! how can i retrieve the data from listview and display it in two textbox(txtboxID,txtboxName) Try something like this: private void listView1_SelectedIndexChanged(object sender, EventArgs e) { if (listView1.SelectedItems.Count > 0) { ListViewItem itm = listView1.SelectedItems[0]; textBox1.Text = itm.SubItems[0].Text; textBox2.Text = itm.SubItems[1].Text; } } ...Show All

• Visual Basic How event method is written for dynamically created controls

  In my application controls are created dynamically. I want to know how to write code for an event, for eg. KeyPress event Also how to a call parent form event, for eg. KeyPress event instead of its child control(dynamically created control) KeyPress event (VB 2005) You have two ways to do this. 1. Declare the control WithEvents and then you can use a Handles clause on your event handler. However you can't do this if you are declaring the control in a sub routine. Dim WithEvents T As TextBox Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load T = New TextBox Me.Controls.Add(T) T.SetBounds(50, 50, 200, 20) End Sub Private Sub T_KeyPress(ByVal s ...Show All

• Windows Forms Rogue objects in Form.Designer.cs file

  I've been developing an application in VS2005. I've noticed that my top level windows form contains instances of objects that I had expected to be deleted, they were child objects to a control layed down at design-time. How do I get rid of these Why haven't they been deleted with the parent object Confused! Michael ...Show All

• SQL Server Query timeout

  I need to figure out if my query is timing out due to row lock contention. The SqlException trapped in my client C# application contains Error Number 1205 but sometimes it contains -2. I guess the SqlCommand timeout and the server timeout are the two possibilities. Is there a definitive way to find out that the SqlException was thrown due to one of these two reasons Because if it's some other reason, I want to excute a different logic. Thanks, Madhav 1205 indicates transaction was aborted due to deadlock. Check out the following links on how to troubleshoot deadlocks: http://msdn2.microsoft.com/en-us/library/ms177433.aspx http://msdn2.microsoft.com/en-us/library/ms188246.aspx ...Show All

• .NET Development .NET Compact Framework Sockets Problem on the emulator

  Hello, I have been suffering a major problem while programming using the .NET compact framework 1.0 using Visual Studio 2003 and the Pocket PC 2002 emulator. My application is very simple, what I am trying to do is to establish a TCP/IP winsock connection between the Pocket PC emulator and an application running on my desktop. The connection works fine, and I am able to send data from the Emulator to the desktop PC. The problem though is in the reverse communication, that is I am unable to receive data on the emulator from the desktop application. I have seen online that this issue can relate to configuring the Pocket PC 2002 emulator to have an IP address, but I am unable to configure the ethernet settings on the emulator! ...Show All

• SQL Server Installing SSIS tutorials

  I feel stupid for asking this but I can't seem to find where to install the SSIS tutorials referenced in msdn.. specifically the "Deploying Packages Tutorial". In the SQL Server 2005 Developer Edition DVD that I have, I've chosen to install all of the samples etc. I have the AdventureWorks and AdventureWorksDW and a whole bunch of samples in "C:\Program Files\Microsoft SQL Server\90\Samples\Integration Services\Package Samples" but under the directory "C:\Program Files\Microsoft SQL Server\90\Samples\Integration Services\Tutorial\" I only have sample data for "Creating a Simple ETL Package". I know... feels like a dumb question but I have run the install wizard on both the dev edition dvd and the ...Show All