i am developing a windows application with VS 2005 a i need to populate a combo box with the column value from my table in the database i'm using a stored procedure and anytime i try de code in visual studio i do have a violation of primary key constraints error but when i execute the stored procedure in my query analyzer, it returns the real values please can someone tell why this is happening?? Jondo

i'm using SQL SERVER 2005 enterprise edition and no has moved de server and besides other computers that are connected to the server are all working apart from this particular one.

please can anyone help with out?? I'm trying to login to a window based application developed with VB.NET and after entering my username and password on the login page, i saw the following error message after waiting for some time;

A connection was successfully established with the server,
but then an error occured during the pre-login handshake.
(Provider:TCP provider, error 0 - The specified network
name is no longer available) Source: .NET sqlclient Data Provider

someone help me out :( Jondo

Select SUM(fees) FROM TABLENAME WHERE headname = 'jan' OR 'feb' OR 'march' NOTE: The (fees) in the query is the name of the column and the "TABLENAME" should be replaced with the table you want to perform de query on. NOTE ALSO: that SQL SERver is not case sensitive Jondo

select MS.MadeByID, CT.TimeInterval, PS.TimeInterval From MeterSettings AS MS INNER JOIN ConsumerType AS CT ON MS.ConsumerTypeID = CT.ID INNER JOIN PowerSanctioned AS PS ON MS.AllocatedPowerID = PS.ID WHERE MeterID = enter meterID This should be able to select the MadeByID from the MeterSettings table, check and fetch the TimeInterval with the same ID From ConsumerType table and finally gets the TimeInterval From the power sanction table

select MS.MadeByID, CT.TimeInterval, PS.TimeInterval
From MeterSettings AS MS INNER JOIN
ConsumerType AS CT
ON MS.ConsumerTypeID = CT.ID
INNER JOIN PowerSanctioned AS PS
ON MS.AllocatedPowerID = PS.ID
WHERE MeterID = enter meterID

This should be able to select the MadeByID from the MeterSettings table, check and fetch the TimeInterval with the same ID From ConsumerType table and finally gets the TimeInterval From the power sanction table REad More on Joins Jondo

You must use a schema or database name to differentiate the different table E.g schemaname.tbPayRate or Databasename.SchemaName.Tablename you First declare a variable and set the what u r select to the value of the variable as shown below Declare @tbPayRateID varchar(50) set @tbPayRateID = (Select MAX(id) AS ID FROM schemaname.tbPayRate Where Employee = 5 Try this out

what do mean by non client area? is it the code Side of the form? Cos i don't really understand what u mean by Non Client area

Please can some describe how to programmatically populate a combo box at runtime in a windows application using C#? :confused: