string strSQL = "SELECT FAM, IM, OT, STATUS, LIMIT, CREDIT, DATECREDIT, DATE_SEND FROM ANKETAR WHERE CLIENTEMAIL=:CLIENTEMAIL";
if (sortExpression != null) strSQL += string.Format(" ORDER BY {0}", sortExpression);
else strSQL += string.Format(" ORDER BY DATE_SEND ASC");
OracleConnection con = new OracleConnection(conStr);
OracleDataAdapter da = new OracleDataAdapter(strSQL, conStr);
da.SelectCommand.Parameters.Add(":CLIENTEMAIL", OracleDbType.Char, 30);
da.SelectCommand.Parameters[":CLIENTEMAIL"].Value = WhoIs(conStr);
DataSet ds = new DataSet();
da.Fill(ds, "ANKETAR");
ClientsDataGrid.DataSource = ds;
ClientsDataGrid.DataMember = "ANKETAR";
ClientsDataGrid.DataBind();
|