consulta sql de interfaz c#
¿Privado?DataTable?ExecuteSelectAdapterSql(string?id)
{
string?sql?=?string.Format(@"select?XiaochuanInfo.Titile? from?XiaochuanInfo?where?id={0}", id);
DataTable?dt?=?new?DataTable();
// DataSet?ds?=? new?DataSet();
prueba
{
stringconnectionString?="Escribe la cadena de conexión aquí";
OleDbConnection?conn? =?new?OleDbConnection(connectionString)
cmd. =?conn;
cmd.CommandType=?CommandType.Text;
cmd.CommandText=?sql ;
OleDbDataAdapter?oda=?new?OleDbDataAdapter(sql,?conn);
dt.TableName=?" temp";
oda.Fill( dt);
//oda.Fill(ds);
}
captura (Excepción)
{
//return?null;
}
//return?ds.Tables[0];
return?