Sandeep.rao's Q&A profile

• SQL Server How to sort that does not include duplicates in display?

  Hi everybody,    I like to asked anyone who is very good at sql to help me display this data in a table format that duplicate headings, subheadings or other columns won't appear twice or more. Can anyone help me I need to sort them and load them in a Datatable. Loop thorugh all records and display them in a label control created at run time. Thanks in advance. Sample Data: Topics Table TopicId  TopicLevel  Topic          ParentId 1           1        First      ...Show All

• Visual J# Data Base Mapping

  I had a program made in Java language and i want to convert it into j#(Use it in J# environment),this program contains database connectivity using java style.   try{    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");    conn=DriverManager.getConnection("jdbc:odbc:inventory","","");    s=conn.createStatement();    }catch(Exception e) {System.out.println(e.toString());} when i compile the progra produces errors , how can i map the connection strings to work  ("sun.jdbc.odbc.JdbcOdbcDriver") and ("jdbc:odbc:inventory","","") Hi, I copied pasted your code and compiled ...Show All

• Visual Studio Team System Event log error

  Hi, is there any reason I get lots of these in the application event log RTM workgroup edition. .NET Runtime Optimization Service (clr_optimization_v2.0.50727_32) - Failed to compile: Microsoft.ReportingServices.QueryDesigners, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 . Error code = 0x80070002 Event ID: 1101   Does the following help http://weblogs.asp.net/rajbk/archive/2005/11/14/430551.aspx Buck ...Show All

• Visual C# Is it possible to swap in DataGrid?

  Hi, Can you help me to switch the mode so that display of the data grid is swapped. say the given titles in column header has to be in the corresponding row header i.e. in column zero(vertically not horizontally). Is it possible to swap rows to columns and columns to rows in DataGrid A quick response will be helpful. Thanks in advance, ...Show All

• Windows Forms Binding a MonthCalendar Control to a DataTable of 'selected' dates

  I need to bind a MonthCalendar control to a DataTable which contains dates that represent 'OffDays' i.e. no work. I am hoping to do something like, a user can select (or un-selected) a date in the calendar and that will add or remove records from the DataTable. I notice that there are methods of the MonthCalendar control to Add or Remove bolded dates and that seems like it would work, except I can't DataBind that. Bolded Dates aren't a requirement, just something to visually distinguish the 'OffDays'. I don't develop WinForms much and I don't know much about the MonthCalendar. If anyone has ideas to simple databind here, it'd be GRE ...Show All

• SQL Server Time Intelligence gives this failure if X64bit installed on a different drive

  TITLE: Microsoft Visual Studio ------------------------------ Could not find a part of the path 'C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Templates\OLAP\1033\TimeIntelligence.xml'. ------------------------------ BUTTONS: OK ------------------------------ SQL Server is installed on D:\SQLServer2005 (x86). and the XML file is on the D: drive. Has anyone come across this Thanks for the response. There is a weakness is installing x64 SQL2005 EE to a different drive and directories. We can work around it but in the next release Microsoft should fix these anomalies. We need to choose t ...Show All

• .NET Development Data Acquisition

  Hi, I want to write a Web Service that offers information about current data, e.g. temperature, supplied via a sensor. Which approaches are there for solving that problem When there is e.g. an standard Windows application, that reads data from te COM port. How does the ASP.NET site or Web Service connect to the Windows application and receive the data I'm happy with every comment! ...Show All

• SQL Server Renaming table column by lookup to define source definition

  Hi, I'm looking for a way to redefine in a table the columns refered by another table to use as source (Exel / Flat file) withinh SSIS SQL 2005. Any idea ( mailto:cattel2000@icqmail.com Marco, I am not sure if I understood your question correctly. If you can explain the scenario further, it will help to understand the problem. But, if you are looking to update the meta-data of columns of a table at run-time, you may use "Derived column" task and 'replace column_name' option. You may use appropriate cast operators in the expression to match the data-types, if required. If the meta-data are incompatible, you will be better-off using 'add ...Show All

• .NET Development Typed DataSet custom code...

  In ADO 2.0, I see that typed datasets allow you to add code in partial classes to the generated datasets..   I would like to add an event handler     public partial class vgm {         partial class LanguagesDataTable {             void TableNewRowHandler(object sender, DataTableNewRowEventArgs e)             {                 languagesRow row = (languagesRow) e.Row;      &nbs ...Show All

• Visual C++ Question about interface method and implementation

  Hi All, I'm trying the Visual Studio 2005 Beta 2, especially for C++/CLI implementation in VC++.  I was wondering if someone could please help me with a question that I have. Any suggestions would be greatly appreciated. I've defined an interface like this: public interface class IMyInterface {     void TryAndTry(); }; and a class implementing this interface ref class MyClass: IMyInterface { public:     void TryAndTry()     {         Console::WriteLine("DONE");     } }; I've a test program that simply creates an instance of this class. When I com ...Show All

• SQL Server Help with query

  I have 3 tables: Words WordLists WordsInLists I need to make a query to select other words (distinct) that appear on the same list of a given word, so what I did was something like Select the top 50 lists where word XXX appears, put into a cursor and loop the cursor to list all the words that belong to the same list where word XXX is, this works fine, but the problem is that I obviously get different sets of results (one for each list in the cursor), how can I make to put all the results in the same resultset , is this possible without creating a temp table Thanks I ended up doing nested selects using t ...Show All

• Windows Forms Form event question please...

  Is there an event that fires when a form is minimized   I have a program that needs to execute code right before the minimize event occures. Thanks in advance, Devin Cool, that worked great.  Now if I can just figure out how D3D is crashing :( ...Show All

• Software Development for Windows Vista "Side by Side" error on vista.

  Hi, I couldn't find a similar question in the forum and hence this post: I am unable to run the unmanaged programs built in Visual studio 2005 on Vista. I tried a Win32 program, with the default project settings. When run on Vista, I get the following error: "The application has failed to start because its side-by-side configuration is in correct. Please see the application event log for more detail." Event viewer entry says: Activation context generation failed for "C:\Users\x\Desktop\unmanagedMovePeek.exe". Dependent Assembly Microsoft.VC80.DebugCRT,processorArchitecture="x86 ...Show All

• .NET Development Access database

  I have written a VB .NET 2003 program that accesses a Access DB. On my development PC it works fine. I created a setup program so that I can install this on other computers. Of source, I have to install the ..NET framework first. But when I run the program on the other PC it does not find the DB, even when it displays the correct file string. Here is what I tried and it does not work. the operating system are all xp sp2 connection string: Dim connString As String = "Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database L" & _ "ocking Mode=0;Data Source=" & path & "; ...Show All

• SQL Server Parameter Mapping in an Execute SQL Task

  I am trying to assign the same package variable value to three different parameters in a query. The variable contains the name of a database which the user will input during package execution. First I check to see if the database exists (if it does I drop it), then in either case I create the database. See code: if exists ( select name from sys.databases where name =   ) begin drop database ; end ; go create database ; go This is the error I am getting: [Execute SQL Task] Error: Executing the query "if exists  (  select name  from sys.databas ...Show All