如果你的TextBox里面没有输入任何值的话 那他的值就是空的
可以提交 执行
可以提交 执行
解决方案 »
- Surface平板开发问题,物体识别,取不到物体的Tag标签值
- commandbuilder 不能生成insertcommand
- 谁能重绘窗口的标题栏不闪烁???找到答案后100分献上!!!
- ******大家帮帮忙,哪位遇到过这样的错误----无法为字符 ' 找到匹配的引号字符。*****
- 有人可以帮我改一下代码实现我想要的功能吗?是关于DataGrid的
- C# 用OleDbDataAdapter 和DataSet 更新多条记录
- 在Visual Studio 2005里的类视图中创建实例总是失败
- 表转实体的问题
- winfrom调用wcf服务,调用服务登录后在wcf中如何记录当前登录的账号
- 做一个网上商店需要多长时间?
- 如何编程将一个数据库(Access)中的表复制到另一个Access数据库中去,谢谢!!
- 请问.net有没有类或者控件可以解析html文档???
并且在些这个方法的时候用的是存储过程
public String AddCompany(string UserName,string PassWord,string TrueName,string Sex,string CompanyName,string Telephone,string Fax,string Mobile,string Email,string Country,string City,string County,string Address,string Zip)
{ // Create Instance of Connection and Command Object
SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
SqlCommand myCommand = new SqlCommand("YulinCommerce_AddCompany", myConnection); // Mark the Command as a SPROC
myCommand.CommandType = CommandType.StoredProcedure; // Add Parameters to SPROC
SqlParameter parameterUserName = new SqlParameter("@UserName", SqlDbType.NVarChar, 16);
parameterUserName.Value = UserName;
myCommand.Parameters.Add(parameterUserName); SqlParameter parameterPassWord = new SqlParameter("@PassWord", SqlDbType.NVarChar, 16);
parameterPassWord.Value =PassWord;
myCommand.Parameters.Add(parameterPassWord); SqlParameter parameterTrueName = new SqlParameter("@TrueName", SqlDbType.NVarChar, 50);
parameterTrueName.Value = TrueName;
myCommand.Parameters.Add(parameterTrueName); SqlParameter parameterSex = new SqlParameter("@Sex", SqlDbType.VarChar, 8);
parameterSex.Value = Sex;
myCommand.Parameters.Add(parameterSex); SqlParameter parameterCompanyName = new SqlParameter("@CompanyName", SqlDbType.NVarChar, 50);
parameterCompanyName.Value = CompanyName;
myCommand.Parameters.Add(parameterCompanyName); SqlParameter parameterTelephone = new SqlParameter("@Telephone", SqlDbType.NVarChar, 50);
parameterTelephone.Value = Telephone;
myCommand.Parameters.Add(parameterTelephone); SqlParameter parameterFax = new SqlParameter("@Fax", SqlDbType.NVarChar, 50);
parameterFax.Value = Fax;
myCommand.Parameters.Add(parameterFax); SqlParameter parameterMobile = new SqlParameter("@Mobile", SqlDbType.NVarChar, 50);
parameterMobile.Value = Mobile;
myCommand.Parameters.Add(parameterMobile); SqlParameter parameterEmail = new SqlParameter("@Email", SqlDbType.NVarChar, 50);
parameterEmail.Value = Email;
myCommand.Parameters.Add(parameterEmail); SqlParameter parameterCountry = new SqlParameter("@Country", SqlDbType.NVarChar, 10);
parameterCountry.Value = Country;
myCommand.Parameters.Add(parameterCountry); SqlParameter parameterCity = new SqlParameter("@City", SqlDbType.NVarChar, 10);
parameterCity.Value = City;
myCommand.Parameters.Add(parameterCity); SqlParameter parameterCounty = new SqlParameter("@County", SqlDbType.NVarChar, 10);
parameterCounty.Value = County;
myCommand.Parameters.Add(parameterCounty); SqlParameter parameterAddress = new SqlParameter("@Address", SqlDbType.NVarChar, 50);
parameterAddress.Value = Address;
myCommand.Parameters.Add(parameterAddress); SqlParameter parameterZip = new SqlParameter("@Zip", SqlDbType.NVarChar, 50);
parameterZip.Value = Zip;
myCommand.Parameters.Add(parameterZip); SqlParameter parameterID = new SqlParameter("@ID", SqlDbType.Int, 4);
parameterID.Direction = ParameterDirection.Output;
myCommand.Parameters.Add(parameterID);
try
{
myConnection.Open();
myCommand.ExecuteNonQuery();
myConnection.Close(); // Calculate the Id using Output Param from SPROC
int Id = (int)parameterID.Value; return Id.ToString();
}
catch
{
return String.Empty;
}
}
}ALTER PROCEDURE YulinCommerce_AddCompany
(
@UserName nvarchar(16),
@PassWord nvarchar(16),
@TrueName nvarchar(50),
@Sex varchar(8),
@CompanyName nvarchar(50),
@Telephone nvarchar(50),
@Fax nvarchar(50),
@Mobile nvarchar(50),
@Email nvarchar(50),
@Country nvarchar(10),
@City nvarchar(10),
@County nvarchar(10),
@Address nvarchar(50),
@Zip nvarchar(50),
@ID int OUTPUT
)
ASINSERT INTO CMRC_Customers
(
UserName,
PassWord,
TrueName,
Sex,
CompanyName,
Telephone,
Fax,
Mobile,
Email,
Country,
City,
County,
Address,
Zip
)VALUES
(
@UserName,
@PassWord,
@TrueName,
@Sex,
@CompanyName,
@Telephone,
@Fax,
@Mobile,
@Email,
@Country,
@City,
@County,
@Address,
@Zip
)SELECT
@ID = @@Identity