62,046
社区成员
发帖
与我相关
我的任务
分享
OracleDataAdapter da = new OracleDataAdapter(com);
da.Fill(Table);
OracleCommandBuilder ocb = new OracleCommandBuilder(da);
da.Update();
OracleDataAdapter da = new OracleDataAdapter(com);
da.Fill(Table);
OracleCommandBuilder ocb = new OracleCommandBuilder(da);
public void UpdateDataTable(DataTable DT,DateTime date)
{
OracleConnection Con = new OracleConnection(getConnectionStr(date.ToString("yyyy-MM-dd")));
string strSQL ="select * from QZDATA.QZ_CP_312_90_DAYRANGE where STATIONID=:stationId and POINTID=:pointId and ITEMID=:itemId and STARTDATE>=:startDate and STARTDATE<=:endDate";
if (Con.State == ConnectionState.Closed)
{
Con.Open();
}
try
{
SqlCommand Cmd = new SqlCommand(strSQL, Con);
//传参数这里应该怎么写
SqlDataAdapter Dad = new SqlDataAdapter(Cmd);
Dad.Update(DT);
Con.Close();
}
catch (SqlException ex)
{
throw ex;
}
}
public DataSet CreateCmdsAndUpdate(string connectionString,
string queryString)
{
using (OleDbConnection connection = new OleDbConnection(connectionString))
{
OleDbDataAdapter adapter = new OleDbDataAdapter();
adapter.SelectCommand = new OleDbCommand(queryString, connection);
OleDbCommandBuilder builder = new OleDbCommandBuilder(adapter);
connection.Open();
DataSet customers = new DataSet();
adapter.Fill(customers);
//code to modify data in dataset here
adapter.Update(customers);
return customers;
}
}