swatts777's Q&A profile

• SQL Server Help with getting last record

  I'm looking for a way to get the last recordset from a column in my database. Can someone please help me I just need the SQL statement. Using ASP/ADO and MSSQL Thanks!! OK, well this is completely the wrong forum but I can probably help. If you can answer the following questions: What is the name of the table containing the data What is the name of the column that contains the value that you want Is it possible to order the recordset with an ORDER BY clause in order that the record you want is the last one (or even better - the first one) If so, what is that ORDER BY clause -Jamie ...Show All

• Windows Forms How do you use delegate for custom method?

  I lost my "cheat-sheet." Now I can't figure how to use a delegate to implement a method in a class supplied by another class. EDIT: Nevermind, I just decided to use the event delegation approach. However can you create a method that accept a method almost like the way a delegate is instantiated. MyDelegate d = new MyDelegate(p.InstanceMethod); Just trying to figure out how to send a callback procedure to a custom object. Basically, the parent object has the callback procedure/method but the child object has the async process. ...Show All

• Visual Studio Recent Projects not working in builder

  I realize this is not high priority but the Recent Projects is not working in the builder. this would be really nice to have. Again, it's working fine for me. It's using the built-in user setting stuff (Settings.Default). It also calls Settings.Default.Save() in the form closing event so changes to the list are saved. Eric ...Show All

• .NET Development Adding FullTrust doesn't work on network share location

  Hi, I have written a logic to give the FullTrust to the assembly if it is on the network share location. But the behavior of the execution of the assembly changes with the way I specify the URL path. For eg: If I give the UNC path as file://<machine-name>/TestProject/bin/ * then my application executes without any problem. But if I provide URL as file://<ip address>/TestProject/bin/* then application fails to execute. I found one more difference when I opened the .NET Configuration tool. If I go inside "Runtime Security Policy"->Machine->Code Groups->LocalIntranet_Zone, I see the entry for my app code group with permission set as FullTrust. This entry appears for both type of URLs. If I choose &qu ...Show All

• Visual Studio Express Editions SplashScreen

  How can create a splashscreen in C# Im having some trouble with my splashscreen to. I made my splashscreen from. then I used the codes you gave. I think Im doing something wrong. Heres my code namespace WindowsApplication1 { public partial class Form1 : Form { Splash splashscreen = new Splash (); public Form1() { InitializeComponent(); splashscreen.Show(); Application .DoEvents(); } private void Form1_Load( object sender, EventArgs e) { Thread .Sleep(2000); splashscreen.Close(); } I have the using System.Threading; in the beginning ...Show All

• Software Development for Windows Vista Problems Imapi v2 in WDK build 5600

  1.Regarding to "IDiscFormat2RawCD　Interface" When calling functions below, it occurs an error. put_RequestedSectorType() PrepareMedia() The target media is CD-R. Please advise! 2.Regarding to "IDiscFormat2TrackAtOnce　Interface" When calling functions below, it occurs an error. put_BufferUnderrunFreeDisabled() When using IDiscFormat2Data, it works OK. Please advise! Hi Kata, Can you please provide the function parameters you used, as well as the precise error code you received for each call This information is critical to understanding how to best assist you. Thanks, . ...Show All

• .NET Development Error during validating XML document

  I am getting "The operation is not valid due to the current state of the object." error during xml document validation. Background Information: I have a schema validation class with methods to accept xmldocument as stream, and schema namespace/location. When working with simple schema/xml it works fine. I am usign .net framework 1.1 Problem: When I have following XML, I get "The operation is not valid due to the current state of the object" error. <employee schema_version ="1.2" xs i : schemaLocation ="urn:test:employee employee.xsd" xmlns : xsi ="http://www.w3.org/2001/XMLSchema-instance" xmlns : emp ="urn:test:employee" xmlns:per="urn:test:person:per& ...Show All

• Visual C# How to: Create a Windows Forms Application from the Command Line

  Hi, I am new to Visual Studio. I tried a code example of the MSDN site. I have installed the .NET Framework 2.0 SDK and Visual Studio 2005 C# Express Edition and get the following error of the compiler: "...The type or namespace name 'ComponentModel' does not exist..." the same error with Frame and Window and Drawing. The code is as follows also find at the url: http://msdn2.microsoft.com/en-us/library/ms229597.aspx using System; using System.ComponentModel; using System.Drawing; using System.Windows.Forms; namespace FormWithButton { public class Form1 : Form { public Button button1; public Form1() { button1 = new Button(); button1.Size = new Size(40, 40); button1.Location = ...Show All

• Visual Studio Express Editions error posting

  Might as well pos this question also , why is it when I post a topic here - It says error sorry -ect ect . But my post is posted anyways weird . But I have to go back to the main forum index and find VBe forum again to find my post. ...Show All

• SQL Server AS2005: write a cube to a local .cub via xmla?

  Hi, i wonder if it is possible to write a cube (in AS2005) to a local .CUB file using xmla instead of the "old" CREATE GLOBAL CUBE statement ... I haven't found anything in the msdn ... perhaps I've been blind background of this question: http://forums.microsoft.com/msdn/ShowPost.aspx postid=463952&siteid=1 Thanks for your answers and for tolerating my bad english best regards, Sven Thanks for your quick reply! We used the Profiler before and found the xmla-statement that is used to create the new cube ... no problem so far; it creates a new database with the cube as we want it to be. But we didn't find the xmla-statement that writes the cube into the .cub file. The ...Show All

• SQL Server Updates too ineffiecient to call from C#

  I'm trying to analyze a 2-Table Select Statement and compare to variables. if x > y then do math and run an update command if y > x then do other math and run update command It's very slow.. about 1 record a second. I haven't used store procs yet, but from what I understand, should increase performance. However, I'm having a difficult time tracking down any examples of this simple procedure as a SPROC. I could try using Managed Code in SQL 2005 and writing the sproc in C#.. but that has a learning curve all it's own. Can someone either point me to a SPROC Tutorial online, or outline the basics for the above function above.. it's too late to go to Borders and the Library didn't have any SQL books not chec ...Show All

• SQL Server need help on T-SQL

  Hi guys, Assume I have the following rows in a table 'T' ================================= C_ID R_ID Created Date ================================= 345 294 2000-08-01 14:16:08.000 345 295 2000-08-01 14:27:13.000 345 296 2000-08-01 14:28:41.000 As you can see, I have different record for the same C_ID - 345. What I want is to retrieve the record with the minimum R_ID and minimum Created Date value of that C_ID. In other words I want to get the following record: 345 294 2000-08-01 14:16:08.000 I don't need the other two records. Can anybody tell me the T-SQL query to achieve this req. Thanks! Hi, I hope it should work. Select * from ...Show All

• SQL Server processing cube not pumping data

  I am trying to process a cube on a fact query that should return about 600M rows. When I run the processing, all Dimensions are processed successfully, and it starts processing the Facts, but no row count is shown indicating that it does not actually start streaming the data to Analysis Services. It has been running for 30 minutes and no count of processed rows has appeared. When I double-click the query and open the query in SQL Server Management studio it runs fine. Also I tried it with set rowcount 100000 and it starts streaming data to query output right away and gets to 100000 rows within a minute or so. So the query seems optimized and returns the data quickly. Also tempdb seems to be growing slowly. Does Analysis ...Show All

• Visual Studio Express Editions MDI Child Form Problem (not showing)

  I am having difficulty with a MDI child/parent relationship for my C# winforms project. I currently have a several controls (button, menu strip, etc.) that call the same function to open a new child form. The main form has the propery of MDI container as it was set on the properties window (not programmatically). However, when I click on the button, the form does not show up. If I make the form so it is not an MDI child (by commenting the second line of code below), it does pop up just fine...but that's not what I want. Here is the code that I have for the function. I have just recently added the .focus method because I saw that mentioned on another forum post and it didn't work. [code] frmSearch frmSearch = new frmSearch(); frmSearch.Mdi ...Show All

• Visual Basic Long Operation with SendKeys

  I am making an automated build tool to build code from a third party compiler. It doesn't have a command line feature so I'm using SendKeys to build the project. The problem is that it takes 15 minutes to build the project and SendKeys does not return until the build is complete. I can't even move the mouse. SendKeys is called from within a timer tick event. I Shell the third party tool but I have to wait about 10 seconds for the splash screen to go away and for it to finish loading. Why doesn't SendKeys return I use System.Windows.Forms.SendKeys.Send( "{ENTER}" ), not System.Windows.Forms.SendKeys.SendWait( "{ENTER}" ). Any suggestions Thanks for the help. ...Show All