azadeh_1510
شنبه 08 تیر 1392, 17:41 عصر
با سلام
دوستان ممکنه راهنمایی کنین اشکال کار من کجاست که اسکریپتی که صدا زدم اجرا نمیشه.
کد برنامه:
using (connection)
{
SqlCommand cmd = new SqlCommand("Insert_Table_" + tableName + "", connection);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter tvparam = cmd.Parameters.AddWithValue("@myTableType", table);
tvparam.SqlDbType = SqlDbType.Structured;
cmd.ExecuteNonQuery();
try
{
SqlCommand command = new SqlCommand("sp_DeleteRows", connection);
command.CommandType = CommandType.StoredProcedure;
}
catch (SqlException ex)
{
Console.WriteLine("SQL Error" + ex.Message.ToString());
}
connection.Close();
}
خود اسکریپت هم این هست:
USE [azar1]
GO
/****** Object: StoredProcedure [dbo].[sp_DeleteRows] Script Date: 06/29/2013 16:25:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[sp_DeleteRows]
AS
BEGIN
DELETE FROM test
WHERE (NOT ([کد پرسنلي ] LIKE N'6%')) OR
([کد پرسنلي ] IS NULL)
END
دوستان ممکنه راهنمایی کنین اشکال کار من کجاست که اسکریپتی که صدا زدم اجرا نمیشه.
کد برنامه:
using (connection)
{
SqlCommand cmd = new SqlCommand("Insert_Table_" + tableName + "", connection);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter tvparam = cmd.Parameters.AddWithValue("@myTableType", table);
tvparam.SqlDbType = SqlDbType.Structured;
cmd.ExecuteNonQuery();
try
{
SqlCommand command = new SqlCommand("sp_DeleteRows", connection);
command.CommandType = CommandType.StoredProcedure;
}
catch (SqlException ex)
{
Console.WriteLine("SQL Error" + ex.Message.ToString());
}
connection.Close();
}
خود اسکریپت هم این هست:
USE [azar1]
GO
/****** Object: StoredProcedure [dbo].[sp_DeleteRows] Script Date: 06/29/2013 16:25:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[sp_DeleteRows]
AS
BEGIN
DELETE FROM test
WHERE (NOT ([کد پرسنلي ] LIKE N'6%')) OR
([کد پرسنلي ] IS NULL)
END