bhavu's Q&A profile

• SQL Server Job Activity / Status with SMO

  Hi, I have created a small asp .net page that display the list of the SQL job in a table. I can retrieve the most part of the information (Job Name, Status, Last Job Status, Last Run Date, ...), but I have a problem with the information Next Run Date: it's always 0. Example of code: string strCon = ConfigurationManager .ConnectionStrings["SERVERNAME"].ConnectionString; SqlConnection sqlCon = new SqlConnection (strCon); ServerConnection serverCon = new ServerConnection (sqlCon); Server server = new Server (serverCon); foreach ( Job job in server.JobServer.Jobs) { // Retrieve job information ... DateTime lastRunDate = job.LastRunDate; DateTime nextRunDate = job.NextRunD ...Show All

• Visual Basic VB.Net IDE Crashes Often...

  I am having a problem where my VB.Net IDE crashes often throughout the day... I have a Client/Server application that I am developing, shared between the two is a ClassLibrary I developed. So my Client and Server project both have this ClassLibrary as a Project added to the main Solutions. This way if I am in either the Client or the Server code, I can immediately get access to the ClassLibrary code to make changes if needed. Now, my problem is that several times a day, when I attempt to open a form in Design view, I get a white screen with a pink bar on the top that says: One or more errors encountered while loading the designer. The errors are listed below. Some errors can be fixed by rebuilding your project, while others may ...Show All

• Visual Basic unique constraints

  how can i set  empid,logdate and loantype=1 as unique let say   empid            logdate             loanid              1000              1/1/01                1                1000            1/1/01             &nb ...Show All

• Visual C# List<> casting

  I have one property, this receive a object, ArrayList or List<>. How i can get the first item in this list In Array work's perfect, but, in List<> i don't know how to procced. See the code: private object pDataSource; public object DataSource { get { return this .pDataSource; } set { this .pDataSource = value ; if ( value != null ) { if (value.GetType().IsArray) { this .SelectedObject = ( value as object [])[0]; } if ( value . GetType ().IsGenericType) { Type t = value. GetType (). GetGenericArguments ()[0]; List <t> list = ( va ...Show All

• .NET Development Problem looping over rows created within the same loop

  I'm re-writing an application that was originally coded in Paradox. It was set up to add "events" to a table when other rows in the table contained a certain number of "points" or a certain amount of time had passed: i.e.: ID: 1 Event: Start Date TotalPoints: 0 PointReductionDate: null ID: 2 Event: Point Violation TotalPoints: 2 PointReductionDate: 9/15/2006 ID: 3 Event: Point Reduction TotalPoints: 1 PointReductionDate: 10/15/2006 ID: 4 Event: Point Reduction TotalPoints: 0 PointReductionDate: 11/15/2006 The setup is a lot more complicated than this (multiple reset types, multiple event types and exceptions, user can add events at any position), but this is the general idea. ID 3 and ID 4 need to be automatically generated whe ...Show All

• Visual C# closing a program completly

  The project I'm working on uses multiple forms and if the user goes to any of the other forms, then closes the program, it continues to run in memory. The code I'm using for the exit button is: this.Dispose(); this.Close(); Is there something wrong with this, or is there a better way to do it jkidd01 wrote: The project I'm working on uses multiple forms and if the user goes to any of the other forms, then closes the program, it continues to run in memory. The code I'm using for the exit button is: this.Dispose(); this.Close(); Is there something wrong with this, or is there a better way to do it When you use "this.Close()" than you tell your program to close "this" form onl ...Show All

• Visual Studio 2008 (Pre-release) MediaTimeline reports wrong timeline in Beta 2.

  Hi All, I try to display playback time for video file using MediaTimeLine, but in Beta 2 when CurrentTimeInvalidated occured, the CurrentTime for mediaClock always will be zero(00:00), is this a Beta 2 bug or the way I use MediaTimeLine is wrong The following code shows how I use MediaTImeLine: mediaTimeLine = new MediaTimeline(new Uri(filePath, UriKind.RelativeOrAbsolute)); mediaClock = this.mediaTimeLine.CreateClock(); mediaClock.CurrentTimeInvalidated += new EventHandler(ClipCurrentTimeInvalidated); mediaClock.Controller.Begin(); and the following code shows how I handle CurrentTimeInvalidated: void ClipCurrentTimeInvalidated(object sender, EventArgs e) { string ct = this.mediaClock.CurrentTime.ToString(); // Dis ...Show All

• Visual C++ Find all bad explicit pointer cast

  Hi, I try to migrate my software in 64-bit. I want to know how can I find all bad explicit pointer cast. Is there an option in VS2005 that can find all explicit cast with possible information lost. Thanks Eric A better option than the using the /Wp64 switch (which is based on heuristics) is to use the one of the 64-bit cross-compilers - these will issue a diagnostic if a pointer is ever truncated. ...Show All

• .NET Development A New "Syntax error in INSERT INTO statement"

  Hello, I have this code in a windows form where it has a comboBox to choose one of three tables from "material" Access database, and the user has two options of adding or deleting a row. My three tables are Customer, Material and Accessories. The insertion and deletion of Customer works just fine, but when I try to add a new row to Material or Accessories a syntax error in INSERT INTO statement is shown. I tried everything I know or could think of. Please If you can help me I would appreciate it so much. Here is the code: =================================== private void bindingNavigatorAddNewItem_Click(object sender, EventArgs e) { switch (comboBox1.SelectedIndex) { case 0: { customerAdd(); break; } case 1: { ma ...Show All

• SQL Server passing params to stored procedure customed delivery protocol

  Hi, I have created a customed delivery protocol for sending notifications to the DB using a stored procedure. I used the code shown in : http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.notificationservices.ideliveryprotocol.aspx#Mtps_DropDownFilterText it all works fine except for one problem - when I want to make a change in the parameters sent to the SP, I can't do it and the original data in the corresponding fields is passed.. I tried using a XSLT file for formatting the notification before it is passed to the delivery channel, placed it in the correct path and I can even see the formatted text in the "Notification Text" field in the "NSNotificationDistribution" view. but for some reason, ...Show All

• SQL Server Bug report

  Hi. Does any body know how to report a bug about reporting service Is there a mail for the developers or something like that Thanks. You can report bugs at http//connect.microsoft.com/. It will go directly into the internal defect tracking system used by the product teams inside MSFT. Hope that helps! ...Show All

• SQL Server Merge and Join

  Hi I am a newbie into the world of Microsoft SQL Server Integration Services 2005. I am trying to merge 2 tables using a specified join like equi-join and also having a complex set of critriea. And I know if I use the merge/merge join transformation it can't be done so how to go about doing that other than using the "Execute SQL Task" which doesn't help me in my next "Data Flow task" as an input. As i need the data derive from the complex sql as an input to other transformations. Hi Ken Hu could you be a bit more specific about what you are trying to achieve (eg: by giving us some pseudo-code ). This way more people will be able to give you bits of answers. cheers Thibaut ...Show All

• SQL Server configuration and deployment questions

  I've been doing some VB6 app development against a SqlExpress database, but have confusion with issues of deployment and configuration. It's my intention to distribute the app and db to client installations, both as stand-alone and network-ready shared access. Here's basically what's occurred thus far: The database originated as an Access mdb file. Downloaded and installed SqlExpress, Tools, Manager, and sample database(s). Used the Upsizing Wizard in Access to create a SqlExpress db. Attached to the database in Express Manager so I could examine and access the table data. Hit the data through the application with the following connection string: Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security Info=False;Data Source=.\sqlexpr ...Show All

• SQL Server SQLWB.EXE max cpu

  SQL Server Management Studio 2005 Windows 2000 when I "Open Table" to view all the records in a table, the cpu goes to 100% and the records are drawn very slowly - about the same speed as you read ! I have re-installed all the software and also tried service pack 1. SQL 2000 worked fine. any ideas thanks John, UK Microsoft SQL Server Management Studio 9.00.2040.00 Microsoft Analysis Services Client Tools 2005.090.2040.00 Microsoft Data Access Components (MDAC) 2000.085.1117.00 built by: (_sqlbld) Microsoft MSXML 2.6 3.0 5.0 6.0 Microsoft Internet Explorer 6.0.2800.1106 Microsoft .NET Framework 2.0.50727.42 Operating System ...Show All

• Visual Studio Express Editions split container problem

  I'm having a problem using the split container control. I add a SplitContainer to a new form, set the orientation to horizontal, and set the dock to fill. Then I add a web navigatior to either panel and set the dock to fill. When I resize the split container, and set the propety of split panel2 minsize property to 300 it is not allowing where as the split panel size is 1007,596 panel1 minsize is25 splitdistance is 4 it is showing an error and now allowing to do so ...Show All