C# + sql

t v

hello, i want to fill a grid with this code, without the WHERE condition my code works fine, but when i try to filter on username, it fails.

I made a Session Username and this is my code:

public ICollection<Aanvraag> GetAllAanvragen()

{

List<Aanvraag> result = new List<Aanvraag>();

using (SqlConnection connection = new SqlConnection(_connectionString))

using (SqlCommand command = new SqlCommand())

{

command.CommandText = "SELECT VID, State, Begindatum, Einddatum, WorkflowInstanceID, Opmerking, Type, Username FROM tblVerlofaanvraag WHERE Username = 'Session[username].ToString()'";

connection.Open();

command.Connection = connection;

using (SqlDataReader reader = command.ExecuteReader())

{

while (reader.Read())

{

result.Add(Aanvraag.CreateFromDataReader(reader));

}

return result;

}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

t v19y ago

command.CommandText = String.Format("SELECT VID, State, Begindatum, Einddatum, WorkflowInstanceID, Opmerking, Type, Username FROM tblVerlofaanvraag WHERE Username = \'{0}\'", HttpContext.Current.Session["username"]);

is the solution !
t v19y ago
ty, i would try this code but i get these errors:

Error 1 The name 'Session' does not exist in the current context
Error 2 The name 'username' does not exist in the current context

command.CommandText = String.Format("SELECT VID, State, Begindatum, Einddatum, WorkflowInstanceID, Opmerking, Type, Username FROM tblVerlofaanvraag WHERE Username = \'{0}\'", Session[username]);

plz help?
Mike Gold19y ago
I think the problem is with your statement:

command.CommandText = "SELECT VID, State, Begindatum, Einddatum, WorkflowInstanceID, Opmerking, Type, Username FROM tblVerlofaanvraag WHERE Username = 'Session[username].ToString()'";

try:

command.CommandText = String.Format("SELECT VID, State, Begindatum, Einddatum, WorkflowInstanceID, Opmerking, Type, Username FROM tblVerlofaanvraag WHERE Username = \'{0}\'", Session[username]);