请教个CommandTimeout = 0;的用法？

WL798 2008-10-27 05:24:59

在SqlCommand中使用正常
public bool CunCuGuoCeng_Date4(ref SqlConnection myConn, string min, DateTime begin, DateTime end, String st,String st1)
{
SqlCommand TongYong = new SqlCommand(min, myConn);
TongYong.CommandTimeout = 0;
TongYong.CommandType = CommandType.StoredProcedure;
TongYong.Parameters.AddWithValue("@begin", begin);
TongYong.Parameters.AddWithValue("@end", end);
TongYong.Parameters.AddWithValue("@st3", st);
TongYong.Parameters.AddWithValue("@st4", st1);
try
{
TongYong.ExecuteNonQuery();
}
catch
{
return false;
}
return true;
}

但在 SqlDataAdapter中不能使用
public bool TY4_CunCuGuoCeng(ref SqlConnection myConn, ref DataSet ds, string min, DateTime d1, DateTime d2,string str,int int1)
{
SqlDataAdapter da = new SqlDataAdapter("sp_TY4", myConn);
//da.CommandTimeout = 0;
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.AddWithValue("@min", min);
da.SelectCommand.Parameters.AddWithValue("@D1", d1);
da.SelectCommand.Parameters.AddWithValue("@D2", d2);
da.SelectCommand.Parameters.AddWithValue("@str", str);
da.SelectCommand.Parameters.AddWithValue("@int1", int1);
try
{
da.Fill(ds, "UserTable");
}
catch
{
return false;
}
return true;
}

这个语法该怎么写呢？

...全文

488 2 打赏收藏转发到动态举报

写回复

2 条回复

切换为时间正序

请发表友善的回复…

发表回复

trylose 2012-05-25

打赏
举报

回复

da.SelectCommand.CommandTimeout

cpio 2008-10-28

打赏
举报

回复

da.SelectCommand.CommandTimeout = 0;

风暴 Eshava.Storm-.Net的一个简单的带对象关系映射器特征 Eshava.Storm是一个，您可以将其添加到项目中，以扩展IDbConnection接口。它提供了4个帮助器：执行查询并将结果映射到强类型列表 public static Task < IEnumerable>> QueryAsync < T>( this IDbConnection connection , string sql , object parameter = null , IDbTransaction transaction = null , int ? commandTimeout = null , CommandType ? commandType = null , CancellationToken cancellationToken = default ) 用法示例：

引用pgsql.dll这个文件 Imports Npgsql Public Function Npgsql_API() Dim conn As NpgsqlConnection = New NpgsqlConnection("Server=192.168.120.249;Port=5432;User Id=admin;Password=admin;Database=DATANAME;CommandTimeout=300") Dim Sql2 = "select default_code from product_template where default_code='80202003-04'" Dim dt As DataTable = New DataTable() Dim da As NpgsqlDataAdapter = New NpgsqlDataAdapter(Sql2, conn) da.Fill(dt) Form1.DataGridView1.AutoGener

SqlDataAdapter SqlConnection nwindConn = new SqlConnection(“Data Source=localhost;Integrated Security=SSPI;Initial Catalog=northwind”); SqlCommand selectCMD = new SqlCommand(“SELECT CustomerID, CompanyName FROM Customers”, nwindConn); selectCMD.CommandTimeout = 30; SqlDataAdapter custDA = new SqlDat

using System; using System.Collections.Generic; using System.Text; using System.Web; using System.Configuration; using System.Data; using System.Data.SQLite; namespace DAL { public class Sqlite { ///

/// 获得连接对象 ///

/// public static SQLiteConnection GetSQLiteConnection() { return new SQLiteConnection("Data Source=" + System.Web.HttpContext.Current.Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["db"].ToString())); } private static void PrepareCommand(SQLiteCommand cmd, SQLiteConnection conn, string cmdText, params object[] p) { if (conn.State != ConnectionState.Open) conn.Open(); cmd.Parameters.Clear(); cmd.Connection = conn; cmd.CommandText = cmdText; cmd.CommandType = CommandType.Text; cmd.CommandTimeout = 30; if (p != null) { foreach (object parm in p) cmd.Parameters.AddWithValue(string.Empty, parm); //for (int i = 0; i < p.Length; i++) // cmd.Parameters[i].Value = p[i]; } } public static DataSet ExecuteDataset(string cmdText, params object[] p) { DataSet ds = new DataSet(); SQLiteCommand command = new SQLiteCommand(); using (SQLiteConnection connection = GetSQLiteConnection()) { PrepareCommand(command, connection, cmdText, p); SQLiteDataAdapter da = new SQLiteDataAdapter(command); da.Fill(ds); } return ds; } public static DataRow ExecuteDataRow(string cmdText, params object[] p) { DataSet ds = ExecuteDataset(cmdText, p); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) return ds.Tables[0].Rows[0]; return null; } ///

/// 返回受影响的行数 ///

/// a /// 传入的参数 /// public static int ExecuteNonQuery(string cmdText, params object[] p) { SQLiteCommand command = new SQLiteCommand(); using (SQLiteConnection connection = GetSQLiteConnection()) { PrepareCommand(command, connection, cmdText, p); return command.ExecuteNonQuery(); } } ///

/// 返回SqlDataReader对象 ///

/// /// 传入的参数 /// public static SQLiteDataReader ExecuteReader(string cmdText, params object[] p) { SQLiteCommand command = new SQLiteCommand(); SQLiteConnection connection = GetSQLiteConnection(); try { PrepareCommand(command, connection, cmdText, p); SQLiteDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection); return reader; } catch { connection.Close(); throw; } } ///

/// 返回结果集中的第一行第一列，忽略其他行或列 ///

/// /// 传入的参数 /// public static object ExecuteScalar(string cmdText, params object[] p) { SQLiteCommand cmd = new SQLiteCommand(); using (SQLiteConnection connection = GetSQLiteConnection()) { PrepareCommand(cmd, connection, cmdText, p); return cmd.ExecuteScalar(); } } ///

/// /// /// /// /// /// /// public static DataSet ExecutePager(ref int recordCount, int pageIndex, int pageSize, string cmdText, string countText, params object[] p) { if (recordCount < 0) recordCount = int.Parse(ExecuteScalar(countText, p).ToString()); DataSet ds = new DataSet(); SQLiteCommand command = new SQLiteCommand(); using (SQLiteConnection connection = GetSQLiteConnection()) { PrepareCommand(command, connection, cmdText, p); SQLiteDataAdapter da = new SQLiteDataAdapter(command); da.Fill(ds, (pageIndex - 1) * pageSize, pageSize, "result"); } return ds; } } }

本文实例讲述了C#访问SqlServer设置链接超时的方法。分享给大家供大家参考。具体实现方法如下：下面这段代码设置超时时间为60秒，默认为30秒 using (connection) { SqlCommand sqlcommand = connection.CreateCommand(); sqlcommand.CommandTimeout = 60; //默认时间为 30 秒 sqlcommand.CommandText = sqlText; ... 希望本文所述对大家的C#程序设计有所帮助。您可能感兴趣的文章:

110,534

社区成员

642,575

社区内容

发帖

与我相关

我的任务

社区管理员

加入社区

近7日
近30日
至今

加载中

查看更多榜单

社区公告

让您成为最强悍的C#开发者

试试用AI创作助手写篇文章吧

+ 用AI写文章