private void bilno()
{
if (RadioButton1.Checked)
{
gen = TextBox1.Text;
}
else
{
gen = "No";
}
}
button click
try
{
bilnumber();
con = new SqlConnection(s);
con.Open();
string qry = "sectionexpenses";
cmd = new SqlCommand(qry, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@sectionname", SqlDbType.VarChar).Value = Sectionselect.Text;
// cmd.Parameters.Add("@Expensestype", SqlDbType.VarChar).Value = DropDownList1.Text;
cmd.Parameters.Add("@ExpensesName", SqlDbType.VarChar).Value = Ddexpenz.Text;
cmd.Parameters.Add("@Date", SqlDbType.VarChar).Value = TdATE.Text;
cmd.Parameters.Add("@BillNo", SqlDbType.VarChar).Value = bil;
cmd.Parameters.Add("@BillAmount", SqlDbType.Float).Value = bamountsave.Text;
cmd.Parameters.Add("@currentdate", SqlDbType.VarChar).Value = TextBox4.Text;
cmd.Parameters.Add("@partydetz", SqlDbType.VarChar).Value = DropDownList1.SelectedItem.ToString();
cmd.Parameters.Add("@bdate", SqlDbType.DateTime).Value = DateTime.ParseExact(TdATE.Text, "MM/dd/yyyy", CultureInfo.InvariantCulture);
int rs = cmd.ExecuteNonQuery();
if (rs == 1)
{
Response.Write("");
snoi.Visible = false;
Printdata.Focus();
}
else
{
Response.Write("");
}
}
catch
{
throw;
}
}
}
my proceudre
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[sectionexpenses]
(@sectionname varchar(30),
@ExpensesName varchar(max),
@Date varchar(30),
@BillNo varchar(max),
@BillAmount float,
@currentdate varchar(50),
@partydetz varchar(max),
@bdate datetime)
AS
DECLARE @Result int
BEGIN TRANSACTION
IF EXISTS
(
SELECT * FROM expenzsection WHERE sectionname=@sectionname
and partydetz=@partydetz and BillAmount=@BillAmount
)
BEGIN
SELECT @Result = -1
END
ELSE
begin
insert into Expenzsection(sectionname,ExpensesName,Date,BillNo,BillAmount,currentdate,partydetz,bdate)
values
(
@sectionname,@ExpensesName,@Date,@BillNo,@BillAmount,@currentdate,@partydetz,@bdate
)
SELECT @Result = @@ERROR
end
IF @Result <> 0
BEGIN
ROLLBACK
END
ELSE
BEGIN
COMMIT
END
RETURN @Result
if billno is yes means data is inserted sucessfully .............. billno is
NO means data are not inserted
ajeet mishraPosted May 9, 2015, 6:30 AM
point 2. You didn't use anywhere in your code to store ge variable value into database.
Therefor my advice to you please use ge variable in your code and then try to save.