ALTER PROCEDURE dbo.InsertNewPoll
@varquestion nvarchar(500)
AS
begin
INSERT INTO Polls
(Question, Active)
VALUES (@varquestion, 1)
select (Poll_ID) from Polls where Question=@varquestion
end
public IDataReader InsetNewPoll(string Appquestion)
{
Database db = DatabaseFactory.CreateDatabase("Jaam_e_JamConnectionString");
System.Data.Common.DbCommand dbCommandWrapper = db.GetStoredProcCommand("InsertNewPoll");
db.AddInParameter(dbCommandWrapper, "@varquestion", DbType.String, Appquestion);
db.ExecuteNonQuery(dbCommandWrapper);
IDataReader Reader = db.ExecuteReader(dbCommandWrapper);
return Reader;
}
protected void btnsavequestion_Click(object sender, EventArgs e)
{
DataManipulate OInsetNewPoll = new DataManipulate();
IDataReader PollReader=OInsetNe ...
Go to the complete details ...