Cornel Gav's Q&A profile

• SQL Server Problems with connecting to SQL Server 2005 Express

  Here's my code so far: [source]using System; using System.Collections.Generic; using System.Text; using System.Data.SqlClient; namespace Database { class Database_Main { SqlConnectionString ConnStr = new SqlConnectionString(); public Database_Main() { SqlConnection Connection = new SqlConnection(@"user id=Afr0;password=prins;server=(local);Trusted_Connection=yes;database=Nimdalin;"); Connection.Open(); } } } [/source] The message I get says that: "An error has occured while establishing a connection to the server." What could be the possible reasons for this Is there any way to configure ...Show All

• Visual Studio 2008 (Pre-release) [Feb CTP] endpoint configuration doesn't work anymore

  Hello, I unistalled the Jan CTP and then reinstalled the Feb CTP on a WinXP SP2 box. I then created the first basic service: namespace Service { [ServiceContract()] public interface INotificationservice { [OperationContract(IsOneWay=true] void Notify(string message); } } namespace Service { public partial class Form1 : Form, INotificationservice { ServiceHost host = null; public Form1() { InitializeComponent(); } private void stopButton_Click(object sender, EventArgs e) { if (host != null && host.State != CommunicationState.Closed) host.Close(); } ...Show All

• Windows Forms DataGridView.AutoSizeRowsMode

  I have a DataGridView on a form that is bound to a DataTable. I have a routine that formats the DataGridView the way I want it. This routine is used on other forms, as well. On this specific form, when I try to set a row's ErrorText, it doesn't show up. If I comment out the line to autosize my rows, the ErrorText starts to show up. I have this working on other forms, but this one isn't working as intended. I narrowed it down to the AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells line of code. However, I don't see any reason that these two should not work together on this form. All of the rows are coming in with only one line, non ...Show All

• Visual Studio 2008 (Pre-release) EntitySet<> and Query<>

  The EntitySet<> type is not a Query<> derived and so when it makes a query sentence throught it, is not translated to SQL, performing query in memory. This was projected thus Vitor If you think about it, it would almost have to go to the DB as you never know when something greater then 3 will hit the db, so the only way is to query the DB. This may be obvious to others, but I am starting to think you need to project *everything into business objects in your DAL, then bind to those objects or Linq query them if you want local query. So outside your DAL, you never see or use Dlinq DB objects. Seem reasonable Seems ...Show All

• Windows Forms How to show pdf document in windows forms created using c#?

  I whant to display pdf documents in windows forms.Is there any controls available for this. The WebBrowser control works - additionally I think there's a PDF Active X control put out by adobe.  Try right clicking on your toolbox, "choose items", select the "COM" tab then surf for the appropriate control.  ...Show All

• .NET Development Generating documentation for my XML

  I work on an application that has a steadily growing number of configuration settings that can be specified in the application .config file. I would like to create documentation for this XML, similar to what I see in the .Net Framework reference (example : http://msdn2.microsoft.com/en-us/library/ms228256.aspx). Are there any tools (with the .Net SDK, NDoc, etc.) that allow me to generate XML documentation similar to what I see in Microsoft's docs Thanks, Andrew Brown Asset Management International Hi Andrew, If your configuration settings grow steadily with time, then you should consider using the Conf ...Show All

• Visual C++ Header File Inclusion problem?

  Hi guys, Please take a look at this code. I have some problems, This is not the real code, but a sample. /************************************************/ //File:   SomeObject.h class CSomeObject:public CObject {       //.....code goes here } //End File //File:   SomeObject.cpp #include "someobject.h" CSomeObject::CSomeObject() {       //.....code goes here. } //End file /************************************************/ /************************************************/ //File:     UsingSomeObject.h class CUsingSomeO ...Show All

• Windows Forms Timer Issue

  Hey, Usually I am over moderating at ASP.Net, but today I have a question for you guys. I have a timer that just is not firing. Can anyone help Imports System Imports System.Collections Imports System.ComponentModel Imports System.Configuration Imports System.Windows.Forms Imports System.IO Imports System.Data Public Class Alert     Inherits System.Windows.Forms.Form     Private Timer1 As System.Timers.Timer ...Show All

• .NET Development Connecting to MSQL db

  Newby Here I am trying to set up a little form (on a Windows Form, using C#) I am trying to work it out, so for testing I created on the Form. 2 TextBox's and a Button What I want to happen, is someone types something in one text box, press submit, then the 2nd textbox will show the result from the MSQL table (mini Search Function) So far I have Added, under referenced System.Data.SqlClient then on the top of the form1.cs page (Code Section) I added using System.Data.SqlClient Then under the button_Click section I added System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection("SERVER=localhost;DATABASE=test1;UI ...Show All

• Windows Forms DataGridView KeyDown?

  (VS2005 - beta 2) Hello, is there anyway to capture a keypress or keydown event in the DataGridView   I know there's events called KeyDown and Keypress, but if the DGV is in edit mode, they never get caught.  My ultimate goal is to make it so pressing enter moves to the Cell to the right, instead of to the next row but I need to know what key is being pressed before I can do that. Thanks -Adam Hi Logan I would explain step by step You have to derive the datagridview class to do this. First you have to add a new class1.vb to your project and write some code in it: Public Class DGV ...Show All

• SQL Server Wierd results with != operator

  Hi all, I have a table - customer with a Column state_code varchar(5) and another valid( smallint) select count(1) from customer where state_code != 'U' -- for unknown and valid= 0 -- for valid Returns different counts each time, even when the data in the table is NOT Changing. something with != operator Thanks for your help ! Sri Can you post DDL and sample data to reproduce the problem   -- Adam Machanic Pro SQL Server 2005, available now http://www..apress.com/book/bookDisplay.html bID=457 --     < sri_t@disc ...Show All

• Visual C# Generics Question

  After some initial problems, generics work fine but i still have one little problem. The inheritance list of my object is very simple: i have a base class (MyObject) and some derived classes (MyObject1, MyObjet2,...). I have defined an ObjectList: public class ObjectList <TKey, TValue> : SortedList < int , V> where V: MyObject   For every derived class i have declared an ObjectList, and it works nicely. But i have a form with a combobox (in wich you can select on of the lists), a datagridview (in wich the objects of the list selected in the combobox are displayed) and a de ...Show All

• Visual Studio Tools for Office How to use InfoPath with VS .Net

  Hi All, I am new to use the InfoPath with Visual Studio .Net. Can any one send Help link. Thanks in advance Hi, Question 1: You can use the XML support in Excel to bind your spreadsheet to an XML file with a schema. Then, you can add logic in your InfoPath form to import the XML by specifying the XSD in your manifest.xsf file. Question 2: The short answer is that you can't.  Controls need to be added to the form at design time.  You can't manipulate UI controls by code behind. Hope that it helps. Regards, Franck Dauche ...Show All

• Visual Studio Team System Custom Rule: class data member should start with x_

  Hello, I'm getting trouble writing a rule that checks a class data member starts with "x_". Exemple: public class Thing{    private string x_ThingName = string .Empty;    private bool w_IsObsolete = false ;  //FALSE    public Product(){} } This is my test : if ( ! member . Name . ToString() . StartsWith( "x_" )){ failed = true ; } I think i don't use the correct object. Thanks This one was pretty difficult ... Thanks a loooooooot  !! ...Show All

• SQL Server function on indexed field

  Hi, I am using sql server 2000 SP1.    select * from document_display where upper(document_name) = upper(v_document_name) v_document_name is a variable. The table is over 200,000 records and presently has index on column document_name Could anyone help on how to improve the performance of above query   No, there are no function indexes in SQL Server.    Why is a non-case sensitive column too difficult to implement   All you have to do is:   ALTER TABLE document_display ADD document_name_ci AS (document_name)     COLLATE ...Show All