protected void Button12_Click(object sender, EventArgs e)
{
string id;
id = TextBox1.Text;
SqlConnection tc = new SqlConnection("user id=XXXXXXX;" +
"password=XXXX;server=localhost;" +
"Trusted_Connection=yes;" +
"database=tc; " +
"connection timeout=0");
SqlCommand command = new SqlCommand("StoredProcedure1",tc);
command.CommandType = CommandType.StoredProcedure;
}
//my procedure
ALTER PROCEDURE dbo.StoredProcedure1
/*
(
@parameter1 int = 5,
@parameter2 datatype OUTPUT
)
*/
@time varchar(6)= XXXXX,
@fac varchar (6) = XXXXX
AS
Insert INTO timeInfo ( timeIN, facID) VALUES (@time, @fac)
/* SET NOCOUNT ON */
RETURN
Admin Edit: Please use code tags when posting your code. Code tags are used like so =>
Thanks,
PsychoCoder

New Topic/Question
Reply




MultiQuote



|