narasiman_jayachandran_2b5374's Q&A profile

• .NET Development insert rows from datagrid into database

  hi! in my datagrid there are multiple records that needed to be inserted to my database. my problem is that it would be inserted to only one row and it would depend on the id. for example: - the datagrid will have 3 columns (student id, subject, grade) the rows will be (2006-01, Math, 88), (2006-01, English, 87). - the database has 5 columns (student id, math, english, science, history) -- i need to insert the grade in their corresponding columns based on student id.  how could i do this i'm really confused right now and any help is appreciated.. hai, i am using datagrid control in this grid i am able to insert the controls dynamicaly like textbox,combo and checkb ...Show All

• SQL Server Column Expressions?

  Is there any way to use User Defined Functions in a column expression Somewhat of an answer can be found here http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=668775&SiteID=1 ...Show All

• Visual C# hcw file?

  Hi All, I just replaced my old PC, installed VS2005 on the new PC and moved my projects to it. One of the projects when I run it always says, the project is out of date and wants to rebuild it, after I OK that, another dialog another comes up and says, Windows cannot find 'hcw', make sure you typed the name correctly and then try again. Never seen this one before. I did search the project on my old PC for a file with a .hcw extension and there is none. Any help would be appreciated. Thanks Jeff Jeff, I'm pretty sure that HCW is the help workshop compiler. It's an authoring tool for creating HTML help (or .chms). It sounds like you have a post build step that is trying to invoke the ...Show All

• .NET Development How to avoid re-occurring Err "ORA-12154: TNS:could not resolve service name" (not a common oracle connection issue)

  How to avoid re-occurring Err "ORA-12154: TNS:could not resolve service name" (not a common oracle connection issue) I made a web application which uses oracle database. Below is the minimum code which explains how I am accessing the data. At a time the application working fine and I can access and do everything with database. Some other time database server is down for scheduled maintenance. If I try to run the application at this point of time it will raise err "ORA-12154: TNS:could not resolve service name" (I'm catching this exception and displaying a custom error message to users). After some hours the database server is up an running. Now if I run the application it should behave normal and give database access. But i ...Show All

• Windows Forms Toggle ToolStripSplitButton

  Hi, How can I create a ToolStripSplitButton that I can toggle (similar behaviour to the ToolStripButton) Sample or hint would be much appreciated. Regards, Ron2464. Hi Dave, By 'toggle', I mean that I would like to have the ToolStripSplitButton to stay 'pressed in' until it is clicked again, in the same way that the ToolStripButton can. Regards, Ron. ...Show All

• SQL Server Query Editor: how to display individual row vertically

  In query editor I displayed a single row from a table. The row is so long that I need to scroll horizontally back and forth to check out it's fields. Using t-sql (or otherwise) can I display the row like this: (vertically) \ Field Name 1: < data value 1> Field Name 2: < data value 2> Field Name 3: < data value 3> Field Name 4: < data value 4> etc. TIA, barkingdog Dog: If you are using SQL Server 2005, you ought to be able to use an UNPIVOT Dave ...Show All

• SQL Server Time without date

  Hi I know there is no time datatype, but I need to store a time. I want store shift payrate change over times, currently 06:00 & 18:00. What is the best way to do this Ultimately I want number of hours worked each day 00:00 to 06:00 & 18:00 to 00:00 (bonus rates) and 06:00 to 18:00 probably to the nearest 1/4 hour as a decimal number. I am expecting input via a form in a time format eg 6:30 Is the best solution just to store the times as the decimal value of 0.25 & 0.75 and convet my input to a deciaml format TIA Thanks, I hate hard coding values so what I want is to store our current shift payment change points. So if someone works 5am to 7pm they will have 2 hours (1 at ...Show All

• Visual C++ a sample program which use res protocol?

  I need a sample program which use res protocol, I hope that one expert can give me one example which use res: protocol, I appreciate your help. Hello Re: a sample program which use res protocol As I have said before ( http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=986755&SiteID=1 , http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=986762&SiteID=1 ) such questions are outside the scope of this forum - for the scope of the VC General forum please look at: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=19445&SiteID=1 For such issues please use the newsgroups at http://msdn.microsoft.com/newsgroups . OTP Thanks Damien ...Show All

• Visual Studio 2008 (Pre-release) My buttons are classic?

  First, Hello one and all! This is my first post here, so I'm sorry if this question has been answered before. I have searched , but not found an answer. I have been playing with the Style element in WPF, using XamlPad and a WPF Application created in VS2005 C# Express (Nov CTP VS Extentions). I don't know what I have done, but now my buttons have gone into the Classic style and I can't seem to get them back into the 'Normal' style. System: Windows XP SP2. Everything up to date. Release version of .Net V3.0 installed. Nov CTP of VS2005 Extentions Installed. Windows SDK V6.0.6000.0.0 installed. Here's what I did: Downloaded and installed the Segeo UI font, Changed my theme (Zune) to use Segeo UI for Title Bar and messagebox te ...Show All

• Windows Forms Aligning text in Label

  How to align text in a Label control to right I set the RightToLeft = True but it doesn't work! Thnk you! I will change the text of the label programatically. If i change the AutoSize property, will it resize correctly It does not reside in the same right position! Thnx! Kapalic ...Show All

• SQL Server How do I get Management Studio to not reset the selected database to Master when I open a new query?

  Hi there, I often have to run multiple SQL scripts against a single database. SQL Server Management Studio always reverts the selected database to Master whenever I open a different SQL file. This requires me to re-select the correct database, and if I forget, I end up running the script against the Master database. SQL 2000's query analyzer "remembered" your selected database and did not force you to re-connect each time. Is there any way to make SQL Server Management Studio act this way Thanks! Kiron Hi Sethu - thanks for the response. Unfortunately, this will reset the default database, as opposed to having the new query session just "remember" the database that was ...Show All

• Visual Studio Multiple project contexts per solution configuration?

  Hi! I am just improving the project config for a project of mine, and on the go I once had the situation that in the configuration manager, there were two project contexts assigned to one solution configuration. I could individually select which one is to be built or not, meaning that I could build two contexts with the same config. That was only a test case, and I have no idea how I achieved that and can't recreate it. I can't add a second project context to one solution config anymore. The table shown, listing all project contexts for a solution config (default: one is shown), suggests that there is a possibility to add a second context... but how http://www.intercomm.com/shrinker/temp2/projectcontexts.png Tha ...Show All

• Visual Studio 2008 (Pre-release) IIS 5.1 is not working with WCF

  Hi I have a Web Service and executing it via IDE build in Web server, every thing works fine. then i create a Virtual Directory on IIS and pointed it to the web Server folder, the URL address looks like http://localhost/Calculator_WS/service.svc , but now instead of executing the service and displaying the default page, IE shows me the contents of my .svc file that are <% @ServiceHost Language=C# Debug="true" Service="CalculatorService" CodeBehind="~/App_Code/Service.cs" %> Contects of web.config are < system.serviceModel > < services > <!-- Before deployment, you should remove the returnFaults behavior configuration to avoid disclosing information in exception messages --> & ...Show All

• Visual Studio Team System Team services and Sharepoint 3, .Net 3, Office 2007

  Anyone have experience using the new Sharepoint 3.0 and other recently released products (.Net 3.0, Office 2007, Vista) with Team System I'll be setting up a system in the next several days and would like to utilize use the latest and greatest for the target system. Jim I'd recommend taking a look at this blog post for information about when Team System will support "the latest and greatest" http://blogs.msdn.com/bharry/archive/2006/11/30/team-foundation-server-roadmap.aspx Today, your best course of action is to install WSS 2.0 and Office 2003 on Server 2003 and Windows XP. ...Show All

• Visual Studio 2008 (Pre-release) Set the Page "Window Height and Width" to Maximize

  how do i set the Page's Window Height and Width to Maximize on a Click Event right now when i click on a Button set to Page2. Page2 shows up but its resizing the entire program,window1's windowstate is set to Maximize. After i click the Maximize button twice it will finally maximize the entire program. I have the Frame's Margin at 0,0,0,0 right under the main Docuement Root,so everything on Page2 hides window1. I have a Frame inside Window1 that Navigates too Page2.xaml by a Button Click here is the Code i am using to navigate to Page2 from Window1:: Page2 pg2 = new Page2(); void ConfigButtonClick(object sender, RoutedEventArgs e)           &n ...Show All