Thank you very much. Both of you. I finaly solved the problem.

rzvme

Thank you. That worked. But now i get another error and i can't seem to determine the cause after i invoke adapt.Fill(ds); /*This is the code of the procedure*/ ALTER PROCEDURE dbo.uspGetBirthdayFriends @CRK INT, @BDATE SMALLDATETIME AS begin declare @ID int declare @BDATE smalldatetime select * from Friends where UserID=@ID and FBirthday =@BDATE end RETURN i get the following error "Procedure uspGetBirthdayFriends has no parameters and arguments were supplied." Thank you

rzvme

ALTER PROCEDURE [dbo].[uspGetBirthdayFriends] @CRK INT @BDATE SMALLDATETIME AS begin select * from Friends where UserID=@CRK and FBirthday =@BDATE RETURN end same error incorrect sintax near '@BDATE' must declare scalar variable "@crk"

rzvme

i thought about using stored procedures only i don't know exactly how to do this.(oracle fan) and by the way....even with the @ symbol in front of the parametername i still get the exact same error.

rzvme

public DataSet Get_Friends_Birthday(DateTime d) { User=0; DataSet ds = new DataSet(); SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=" + '"' + @"C:\Users\LadyLara\Documents\Visual Studio 2008\Projects\Private Notebook WebService\Private Notebook WebService\App_Data\Private Notebook Database.mdf" + '"' + ";Integrated Security=True;User Instance=True"); string scom = "SELECT FriendID, FFirstName, FLastName, FBirthday, FE_mail1, FE_mail2, FE_mail3, FE_mail4, FPhone_Number1, FPhone_Number2, FPhone_Number3, FPhone_Number4, UserID FROM Friends WHERE (UserID = "+"@IDUS)"+" AND (FBirthday = "+"@Date)"; SqlCommand sqlcom = new SqlCommand(scom,con); sqlcom.Parameters.Add("IDUS", SqlDbType.Int).Value=User.ToString(); sqlcom.Parameters.Add("DATE", SqlDbType.SmallDateTime).Value=d.ToString(); SqlDataAdapter adapt = new SqlDataAdapter(scom, con); con.Open(); adapt.Fill(ds); return ds; } when it reaches adapt.fill(ds) i get the folowing error. "System.Data.SqlClient.SqlException: Must declare the scalar variable "@IDUS"." Please Help!

rzvme

Please if you know how to copy items between 2 listboxes using a drag and drop operation help me out.

rzvme

how exactly do i use this??

rzvme

i don't want bytes i want bits(0 and 1)

rzvme

i tried with that but it retrives bytes (in ascii)

rzvme

and how exactly do i do this

rzvme

I need to be able to get every bit from a file (0 and 1). How do i do this. please help

rzvme

i want a label to show the current system time? is there a method/property i can use to get the system time??

rzvme

i am trying to print from a text box. the problem is that the text from the text box is divided into few very long lines and when i print them i get maybe half a line printed. What is the code that will a start a new line if the string witdh reaches the limit of the paper?

rzvme

how do i exit a function. in basic there is an axit statement , but i can'd find it in c#.

rzvme

How can i copy a column from one table to another (data and schema) at runtime in vs 2005? the data and schema are read from xml files -- modified at 8:44 Sunday 14th January, 2007

rzvme

but can i at least find out if the form is trying to get the focus so it can close, or another control is trying to get the focus?

rzvme

i have a disconected imviroment database application, and normaly i need some validation rules for the data-entry part. i am using the invalidate event to check if the data is in the correct format. the problem is i want to be able to close the form is the data is not in the correct format, but i am not able to because the control refuses to lose focus until the data is in the correct format. please help

rzvme

How can i block receiving data except from one specific IP address?? thank you

rzvme

Harta hr = this.ParentForm; hr.OnPaint1(); this code raises the folowing error Error 1 Cannot implicitly convert type 'System.Windows.Forms.Form' to 'THE_PROJECT.Harta'. An explicit conversion exists (are you missing a cast?) C:\Documents and Settings\Razvan\My Documents\Visual Studio 2005\Projects\THE PROJECT v2\THE PROJECT v2\Elemente.cs 48 23 THE PROJECT v2 i knew it was imposible for that to work but i need to call that method from the child form. Can somebody help me?

rzvme

i'm tring to scroll a picture box using the drag-drop functionality, i have a small panel and a big picturebox in it and i want the panel to scroll the piscturebox when i drag and drop it (exactly like in Acrobat reader). What code am i supose to write to meve the picture box?? and another question: say i want to center the panell view on o specific point on the picturebox, how do i do that?? -- modified at 9:16 Monday 6th November, 2006

rzvme