62,243
社区成员




userid = Session["userid"].ToString();
string strconn = ConfigurationSettings.AppSettings["connstring"];
SqlConnection conn = new SqlConnection(strconn);
SqlCommand cm = new SqlCommand("complain_", conn);
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.Add("@userid", SqlDbType.UniqueIdentifier,16, "userid").Value = Convert.ToInt32(Session["userid"]);
CREATE proc complain_
@userid uniqueidentifier,
@aa varchar(50)
as
insert into feedback (userid,aa) values ( @userid,@aa)
GO
user表:
CREATE TABLE [dbo].[user] (
[userID] uniqueidentifier ROWGUIDCOL NOT NULL ,
[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
) ON [PRIMARY]
feedback表
CREATE TABLE [dbo].[feedback] (
[feedbackID] uniqueidentifier ROWGUIDCOL NOT NULL ,
[userid] [uniqueidentifier] NULL ,
[aa] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
) ON [PRIMARY]
GO
System.Guid.NewGuid()