Error in objConexao = New SqlConnection(connString); ??

[vilmarbr]

Hi, All the time is showing me error at line: objConexao = New SqlConnection(connString); which says that I forgot the semicolon(;), but as you can see I did not forget it! See the whole routine bellow inside a .aspx page: <%@ Page Language="C#" Debug="true"%> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.SqlClient" %> public void Page_Load(Object Sender, EventArgs EA) { String connString,strSQL; SqlConnection objConexao; SqlCommand objCommand; SqlDataReader objDataReader; connString = "Server=Localhost; Database=Northwind; Uid=SqlService; Password=xx;"; objConexao = New SqlConnection(connString); objConexao.Open(); strSQL = "SELECT * FROM Products"; objCommand = New SqlCommand(strSQL, objConexao); objDataReader = objCommand.ExecuteReader(CommandBehavior.CloseConnection); While(objDataReader.Read = True) { lblSaida.Text += objDataReader["ProductName"] + " - " + objDataReader["UnitPrice"] + "<br>"; } objDataReader.Close(); objConexao.Close(); objDataReader = Nothing; objCommand = Nothing; objConexao = Nothing; } So, how can I solve it? ------------- Thanks, ========================= Vilmar Brazão de Oliveira

[Marcie Jones]

Hi Vilmar, "New" on that line should be lower-case: "new". C# is case-sensitive. The error message is not particularly helpful in this case. Hope that helps! Marcie CP Blog[^]

[vilmarbr]

Thank you guy, I had forgot that C# as Java, JavaScript, C, C++ are all case SENSITIVE! Regards, ========================= Vilmar Brazão de Oliveira