put ajax 文件上传,Jquery/ajax 如何以put方式上传文件

我会带着你远行 2022-09-03 11:20 173阅读 0赞

用户提问

using System.Data.OleDb; using System.Data; namespace \_211 \{ /// /// DBQuery 的摘要说明。 /// public sealed class DBQuery \{ static OleDbConnection conn=DBConnection.getConn(); static DataTable dt; public static DataTable OpenQu...

推荐答案

using System.Data.OleDb;

using System.Data;

namespace \_211

///

/// DBQuery 的摘要说明。

///

public sealed class DBQuery

static OleDbConnection conn=DBConnection.getConn();

static DataTable dt;

public static DataTable OpenQuery(string sql)

OleDbDataAdapter da=new OleDbDataAdapter(sql,conn);

dt=new DataTable();

try

da.Fill(dt);

catch(Exception ex)

throw ex;

finally

da.Dispose();

return dt;

public static DataTable OpenTable(string TableName)

OleDbDataAdapter da=new OleDbDataAdapter("select \* from "+TableName,conn);

dt=new DataTable();

try

da.Fill(dt);

catch(Exception ex)

throw ex;

finally

da.Dispose();

return dt;

public static DataTable OpenTable(string TableName,int count)

OleDbDataAdapter da=new OleDbDataAdapter("select top "+count.ToString()+" \* from "+TableName,conn);

dt=new DataTable();

try

da.Fill(dt);

catch(Exception ex)

throw ex;

finally

da.Dispose();

return dt;

public static DataTable OpenTable(string TableName,string IndexColumn,bool IsAsc)

OleDbDataAdapter da=new OleDbDataAdapter("select \* from "+TableName+" order by "+IndexColumn+" "+(IsAsc?"Asc":"Desc"),conn);

dt=new DataTable();

try

da.Fill(dt);

catch(Exception ex)

throw ex;

finally

da.Dispose();

return dt;

public static DataTable OpenTable(string TableName,int count,string IndexColumn,bool IsAsc)

OleDbDataAdapter da=new OleDbDataAdapter("select top "+count.ToString()+" \* from "+TableName+" order by "+IndexColumn+" "+(IsAsc?"Asc":"Desc"),conn);

dt=new DataTable();

try

da.Fill(dt);

catch(Exception ex)

throw ex;

finally

da.Dispose();

return dt;

public static DataTable OpenTable(string TableName,string\[\] column,bool IsCondition)

string tempsql="";

for(int i=0;i

tempsql+=column\[i\];

if(i

if(IsCondition)

tempsql+=" and ";

else

tempsql+=",";

;

string sql="";

if(IsCondition)

sql="select \* from "+TableName+" where "+tempsql;

else

sql="select "+tempsql+" from "+TableName;

OleDbDataAdapter da=new OleDbDataAdapter(sql,conn);

dt=new DataTable();

try

da.Fill(dt);

catch(Exception ex)

throw ex;

finally

da.Dispose();

return dt;

public static DataTable OpenTable(string TableName,string\[\] column,string\[\] condition)

string tempsql="";

string tempsql2="";

for(int i=0;i

tempsql+=column\[i\];

if(i

for(int i=0;i

tempsql2+=condition\[i\];

if(i

OleDbDataAdapter da=new OleDbDataAdapter("select "+tempsql+" from "+TableName+" where "+tempsql2,conn);

dt=new DataTable();

try

da.Fill(dt);

catch(Exception ex)

throw ex;

finally

da.Dispose();

return dt;

public static DataTable OpenTable(string TableName,int count,string\[\] column)

string tempsql="";

for(int i=0;i

tempsql+=column\[i\];

if(i

OleDbDataAdapter da=new OleDbDataAdapter("select top "+count.ToString()+" "+tempsql+" from "+TableName,conn);

dt=new DataTable();

try

da.Fill(dt);

catch(Exception ex)

throw ex;

finally

da.Dispose();

return dt;

public static DataTable OpenTable(string TableName,int count,string\[\] column,string\[\] condition)

string tempsql="";

string tempsql2="";

for(int i=0;i

tempsql+=column\[i\];

if(i

for(int i=0;i

tempsql2+=condition\[i\];

if(i

OleDbDataAdapter da=new OleDbDataAdapter("select top "+count.ToString()+" "+tempsql+" from "+TableName+" where "+tempsql2,conn);

dt=new DataTable();

try

da.Fill(dt);

catch(Exception ex)

throw ex;

finally

da.Dispose();

return dt;

public static DataTable OpenTable(string TableName,int count,string\[\] column,string IndexColumn,bool IsAsc)

string tempsql="";

for(int i=0;i

tempsql+=column\[i\];

if(i

OleDbDataAdapter da=new OleDbDataAdapter("select top "+count.ToString()+" "+tempsql+" from "+TableName+" order by "+IndexColumn+" "+(IsAsc?"Asc":"Desc"),conn);

dt=new DataTable();

try

da.Fill(dt);

catch(Exception ex)

throw ex;

finally

da.Dispose();

return dt;

public static DataTable OpenTable(string TableName,int count,string\[\] column,string\[\] condition,string IndexColumn,bool IsAsc)

string tempsql="";

string tempsql2="";

for(int i=0;i

tempsql+=column\[i\];

if(i

for(int i=0;i

tempsql2+=condition\[i\];

if(i

OleDbDataAdapter da=new OleDbDataAdapter("select top "+count.ToString()+" "+tempsql+" from "+TableName+" where "+tempsql2+" order by "+IndexColumn+" "+(IsAsc?"Asc":"Desc"),conn);

dt=new DataTable();

try

da.Fill(dt);

catch(Exception ex)

throw ex;

finally

da.Dispose();

return dt;

public static DataTable OpenTable(string TableName,string\[\] column,string IndexColumn,bool IsAsc,int PageSize,int Page)

string tempsql="";

for(int i=0;i

tempsql+=column\[i\];