各位大俠好,用VS2005編的winform程序中,怎樣寫數(shù)據(jù)庫的增刪改查等語句?看了幾個教程,寫的語句看不懂,同時也容易報錯.教程中的語句這樣寫的:#region 添加public int tb_EmpInfoAdd(tb_EmpInfo Empinfo){int intFalg = 0;try{string str_Add = "insert into tb_EmpInfo values( ";str_Add+=" '"+Empinfo.intEmpId+"','"+Empinfo.strEmpName+"','"+Empinfo.strEmpLoginName+"',";str_Add+=" '"+Empinfo.strEmpLoginPwd+"','"+Empinfo.intEmpSex+"','"+Empinfo.daEmpBirthday+"',";str_Add+=" '"+Empinfo.strEmpDept+"','"+Empinfo.strEmpPost+"','"+Empinfo.strEmpPhone+"',";str_Add+=" '"+Empinfo.strEmpPhoneM+"','"+Empinfo.strEmpAddress+"',";str_Add+=""+Empinfo.intEmpFalg+")";getSqlConnection getConnection = new getSqlConnection();conn = getConnection.GetCon();cmd = new SqlCommand(str_Add,conn);intFalg = cmd.ExecuteNonQuery();conn.Dispose();return intFalg;}catch (Exception ee){MessageBox.Show(ee.ToString());return intFalg;}}#endregion
2 回答
慕桂英3389331
TA貢獻2036條經(jīng)驗 獲得超8個贊
1.直接寫個函數(shù)傳參數(shù)
2.用存儲過程（這里我就不給你加事務處理啦）
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[RoleOperate]
-- Add the parameters for the stored procedure here
@RoleId varchar(64),--角色ID
@RoleName varchar(20),--角色名稱
@MaxYear int,--年限
@OperateType int,--操作類型1添加2修改3刪除
@yxshuju varchar(MAX) output
AS
BEGIN
SET NOCOUNT ON;
declare @vroleid varchar(50)
declare @vrolename varchar(20) --版本
declare @vmaxyear int --MAC
SELECT @vroleid=isnull([RoleId],'') FROM [dbo].[Sys_Role] WHERE [RoleId] = @RoleId
if @vroleid<>''
begin
if (@OperateType=1)
begin
return 0;
end
else
begin
if (@OperateType=2)
begin
update [dbo].[Sys_Role] set RoleId=@RoleId,RoleName=@RoleName,MaxYear=@MaxYear where [RoleId]=@RoleId
set @yxshuju='2';
end
else
begin
delete from [dbo].[Sys_Role] where [RoleId]=@RoleId
set @yxshuju='3';
return 3;
end
end
end
else
begin
if (@OperateType=1)
begin
insert into[dbo].[Sys_Role](RoleId,RoleName,MaxYear)values(@RoleId,@RoleName,@MaxYear)
set @yxshuju='1';
return 1;
end
else
begin
if (@OperateType=2)
begin
set @yxshuju='2';
end
else
begin
set @yxshuju='3';
return 3;
end
end
end
END
SET ANSI_NULLS ON
調(diào)用函數(shù)：
public static int RoleOperate(string RoleId, string RoleName, Int32 MaxYear, Int32 OperateType)
{
Int32 rValue = 0;
try
{
SQLHelper.ModelSql.Command.CommandText = "RoleOperate";
SqlHelper.SQLHelper.ModelSql.Command.CommandType = CommandType.StoredProcedure;
SqlHelper.SQLHelper.ModelSql.Command.Parameters.Clear();
SqlParameter roleid = SQLHelper.ModelSql.Command.Parameters.Add("@RoleId", SqlDbType.VarChar, 50);
roleid.Value = RoleId;
SqlParameter rolename = SQLHelper.ModelSql.Command.Parameters.Add("@RoleName", SqlDbType.VarChar, 50);
rolename.Value = RoleName;
SqlParameter maxyear = SQLHelper.ModelSql.Command.Parameters.Add("@MaxYear", SqlDbType.Int);
maxyear.Value = MaxYear;
SqlParameter operatetype = SQLHelper.ModelSql.Command.Parameters.Add("@OperateType", SqlDbType.Int);
operatetype.Value = OperateType;
SqlParameter yxshuju = SQLHelper.ModelSql.Command.Parameters.Add("@yxshuju", SqlDbType.VarChar, 300);
yxshuju.Direction = ParameterDirection.Output;
SQLHelper.ModelSql.Connection.Open();
SQLHelper.ModelSql.Command.ExecuteNonQuery();
rValue = int.Parse(yxshuju.Value.ToString());
}
catch (Exception ex)
{
rValue = -1;
}
finally
{
SQLHelper.ModelSql.Connection.Close();
}
return rValue;
}
森林海
TA貢獻2011條經(jīng)驗 獲得超2個贊
先說引號
上面這段代碼對數(shù)據(jù)庫進行了操作，那么就涉及到sql語句。C#操作數(shù)據(jù)庫時的sql語句是一段傳過去的字符串例如：select * from table1
你在查詢分析器里可以直接敲這行語句，但是從c#中傳過去的就是由引號括起來的字符串了也就是 string sql = "select * from table1";
那么我們?nèi)绻氚袰#里的一個變量a作為條件傳到sql中就要這么寫:
string a="table1";
string sql="select * from" + a; 這里a是變量，所以字符串拼接后的sql變量就為"select * from table1"了 同樣的道理，在C#中逗號，空字符串""就要這么寫才能和sql拼接起來
- 2 回答
- 0 關(guān)注
- 112 瀏覽
添加回答
舉報
0/150
提交
取消