hi.. i m wrking on school fee collection software, now i want to save my 25 textbox value in database from column fee1_fee25.
when i code in protected void btnpay
i dont get txtbox.text.
so please help me how i sort oyt this problem.
their is the code:
aspx code:
string sttr;
string classbased;
int n=0;
int m = 0, l = 7;
double sum = 0;
int d;
int count=0;
string StId;
private void display()
{
con.Open();
string strdata = "select * from FEEHEAD ORDER BY ACT_CODE";
SqlDataAdapter da = new SqlDataAdapter(strdata, con);
DataSet ds = new DataSet();
da.Fill(ds);
Label28.Text = ds.Tables[0].Rows.Count.ToString();
d = Convert.ToInt32(Label28.Text);
PlaceHolder1.Controls.Clear();
int tblrow = d / 3 +1;
int tblcol = d / 8 +1;
Table tbl = new Table();
tbl.Attributes.Add("style", "width:100%");
PlaceHolder1.Controls.Add(tbl);
string strClass = "select * from FEE_CLW where CL='" + Label30.Text + "' ORDER BY FH ASC ";
da = new SqlDataAdapter(strClass, con);
DataSet ds1 = new DataSet();
da.Fill(ds1);
string strSch = "select * from Scholarship where ADM_NO ='" + txtAdd_no.Text + "' order by S1";
da = new SqlDataAdapter(strSch, con);
DataSet ds2 = new DataSet();
da.Fill(ds2);
for (int k = 0; k < tblrow; k++)
{
TableRow tr = new TableRow();
for (int j = 0; j < tblcol; j++)
{
if (m < d && l < 32)
{
TableCell tc = new TableCell();
Label lb = new Label();
lb.Text = Convert.ToString(ds.Tables[0].Rows[m][1]);
lb.Attributes.Add("style", "font-size:15px; margin-left:0px");
lb.Width = 150;
tc.Width = 300;
tr.Attributes.Add("style","margin-top:25px;");
TextBox txtbox = new TextBox();
txtbox.ID = "txtbox" + m;
txtbox.Width = 50;
txtbox.Attributes.Add("style", "margin-left:25px");
Label lb1 = new Label();
lb1.Text = Convert.ToString(ds.Tables[0].Rows[m][2]);
Label lb2 = new Label();
lb2.Text = Convert.ToString(ds.Tables[0].Rows[m][3]);
Label lb3 = new Label();
if (lblScholarShip.Text == "yes")
{
lb3.Text = Convert.ToString(ds2.Tables[0].Rows[0][l]);
}
string strTempFid = "Select * from TempFID Where Id='" + m.ToString() + "'";
cmd = new SqlCommand(strTempFid, con);
dr = cmd.ExecuteReader();
if (dr.Read() == true)
{
StId = dr["ID"].ToString();
}
dr.Close();
string strd = "select MONTHLY,CL_BASED from feehead where fee_head='" + lb.Text + "'";
cmd = new SqlCommand(strd, con);
dr = cmd.ExecuteReader();
if (dr.Read() == true)
{
sttr = dr["monthly"].ToString();
classbased = dr["CL_BASED"].ToString();
}
dr.Close();
if (txtWard.Text == "None")
{
if (txtMonth.Text.Contains("Apr-"))
{
if (classbased.Equals("True") && sttr.Equals("True"))
{
txtbox.Text = (Convert.ToInt32(ds1.Tables[0].Rows[m][2]) * Convert.ToInt32(Label27.Text)).ToString();
if (lb.Text == "BUS FEE")
{
txtbox.Text = (Convert.ToInt32(txtAmount.Text) * Convert.ToInt32(Label27.Text)).ToString();
}
}
else if (classbased.Equals("True") && sttr.Equals("False"))
{
txtbox.Text = ds1.Tables[0].Rows[m][2].ToString();
if (lb.Text == "BUS FEE")
{
txtbox.Text = (Convert.ToInt32(txtAmount.Text) * Convert.ToInt32(Label27.Text)).ToString();
}
}
else if (classbased.Equals("False") && sttr.Equals("True"))
{
txtbox.Text = (Convert.ToInt32(ds.Tables[0].Rows[m][4]) * Convert.ToInt32(Label27.Text)).ToString();
if (lb.Text == "BUS FEE")
{
txtbox.Text = (Convert.ToInt32(txtAmount.Text) * Convert.ToInt32(Label27.Text)).ToString();
}
}
else
{
txtbox.Text = Convert.ToString(ds.Tables[0].Rows[m][4]);
if (lb.Text == "BUS FEE")
{
txtbox.Text = (Convert.ToInt32(txtAmount.Text) * Convert.ToInt32(Label27.Text)).ToString();
}
}
}
else
{
if (classbased.Equals("True") && sttr.Equals("True"))
{
txtbox.Text = (Convert.ToInt32(ds1.Tables[0].Rows[m][2]) * Convert.ToInt32(Label27.Text)).ToString();
if (lb.Text == "BUS FEE")
{
txtbox.Text = (Convert.ToInt32(txtAmount.Text) * Convert.ToInt32(Label27.Text)).ToString();
}
}
else if (classbased.Equals("True") && sttr.Equals("False"))
{
txtbox.Text = ds1.Tables[0].Rows[m][2].ToString();
if (lb.Text == "BUS FEE")
{
txtbox.Text = (Convert.ToInt32(txtAmount.Text) * Convert.ToInt32(Label27.Text)).ToString();
}
}
else if (classbased.Equals("False") && sttr.Equals("True"))
{
txtbox.Text = (Convert.ToInt32(ds.Tables[0].Rows[m][4]) * Convert.ToInt32(Label27.Text)).ToString();
if (lb.Text == "BUS FEE")
{
txtbox.Text = (Convert.ToInt32(txtAmount.Text) * Convert.ToInt32(Label27.Text)).ToString();
}
}
else
{
txtbox.Text = "0";
}
}
}
else if (txtWard.Text == "EMP")
{
if (txtMonth.Text.Contains("Apr-"))
{
if (classbased.Equals("True") && sttr.Equals("True"))
{
txtbox.Text = (Convert.ToInt32(ds1.Tables[0].Rows[m][3]) * Convert.ToInt32(Label27.Text)).ToString();
if (lb.Text == "BUS FEE")
{
txtbox.Text = (Convert.ToInt32(txtAmount.Text) * Convert.ToInt32(Label27.Text)).ToString();
}
}
else if (classbased.Equals("True") && sttr.Equals("False"))
{
txtbox.Text = ds1.Tables[0].Rows[m][3].ToString();
if (lb.Text == "BUS FEE")
{
txtbox.Text = (Convert.ToInt32(txtAmount.Text) * Convert.ToInt32(Label27.Text)).ToString();
}
}
else if (classbased.Equals("False") && sttr.Equals("True"))
{
txtbox.Text = (Convert.ToInt32(ds.Tables[0].Rows[m][6]) * Convert.ToInt32(Label27.Text)).ToString();
if (lb.Text == "BUS FEE")
{
txtbox.Text = (Convert.ToInt32(txtAmount.Text) * Convert.ToInt32(Label27.Text)).ToString();
}
}
else
{
txtbox.Text = Convert.ToString(ds.Tables[0].Rows[m][6]);
}
}
else
{
if (classbased.Equals("True") && sttr.Equals("True"))
{
txtbox.Text = (Convert.ToInt32(ds1.Tables[0].Rows[m][3]) * Convert.ToInt32(Label27.Text)).ToString();
if (lb.Text == "BUS FEE")
{
txtbox.Text = (Convert.ToInt32(txtAmount.Text) * Convert.ToInt32(Label27.Text)).ToString();
}
}
else if (classbased.Equals("True") && sttr.Equals("False"))
{
txtbox.Text = ds1.Tables[0].Rows[m][3].ToString();
if (lb.Text == "BUS FEE")
{
txtbox.Text = (Convert.ToInt32(txtAmount.Text) * Convert.ToInt32(Label27.Text)).ToString();
}
}
else if (classbased.Equals("False") && sttr.Equals("True"))
{
txtbox.Text = (Convert.ToInt32(ds.Tables[0].Rows[m][6]) * Convert.ToInt32(Label27.Text)).ToString();
if (lb.Text == "BUS FEE")
{
txtbox.Text = (Convert.ToInt32(txtAmount.Text) * Convert.ToInt32(Label27.Text)).ToString();
}
}
else
{
txtbox.Text = "0";
}
}
}
else if (txtWard.Text == "IRRIGATION DEPTT.")
{
if (txtMonth.Text.Contains("Apr-"))
{
if (classbased.Equals("True") && sttr.Equals("True"))
{
txtbox.Text = (Convert.ToInt32(ds1.Tables[0].Rows[m][4]) * Convert.ToInt32(Label27.Text)).ToString();
if (lb.Text == "BUS FEE")
{
txtbox.Text = (Convert.ToInt32(txtAmount.Text) * Convert.ToInt32(Label27.Text)).ToString();
}
}
else if (classbased.Equals("True") && sttr.Equals("False"))
{
txtbox.Text = ds1.Tables[0].Rows[m][4].ToString();
if (lb.Text == "BUS FEE")
{
txtbox.Text = (Convert.ToInt32(txtAmount.Text) * Convert.ToInt32(Label27.Text)).ToString();
}
}
else if (classbased.Equals("False") && sttr.Equals("True"))
{
txtbox.Text = (Convert.ToInt32(ds.Tables[0].Rows[m][7]) * Convert.ToInt32(Label27.Text)).ToString();
if (lb.Text == "BUS FEE")
{
txtbox.Text = (Convert.ToInt32(txtAmount.Text) * Convert.ToInt32(Label27.Text)).ToString();
}
}
else
{
txtbox.Text = Convert.ToString(ds.Tables[0].Rows[m][7]);
}
}
else
{
if (classbased.Equals("True") && sttr.Equals("True"))
{
txtbox.Text = (Convert.ToInt32(ds1.Tables[0].Rows[m][4]) * Convert.ToInt32(Label27.Text)).ToString();
if (lb.Text == "BUS FEE")
{
txtbox.Text = (Convert.ToInt32(txtAmount.Text) * Convert.ToInt32(Label27.Text)).ToString();
}
}
else if (classbased.Equals("True") && sttr.Equals("False"))
{
txtbox.Text = ds1.Tables[0].Rows[m][4].ToString();
if (lb.Text == "BUS FEE")
{
txtbox.Text = (Convert.ToInt32(txtAmount.Text) * Convert.ToInt32(Label27.Text)).ToString();
}
}
else if (classbased.Equals("False") && sttr.Equals("True"))
{
txtbox.Text = (Convert.ToInt32(ds.Tables[0].Rows[m][7]) * Convert.ToInt32(Label27.Text)).ToString();
if (lb.Text == "BUS FEE")
{
txtbox.Text = (Convert.ToInt32(txtAmount.Text) * Convert.ToInt32(Label27.Text)).ToString();
}
}
else
{
txtbox.Text = "0";
}
}
}
else if (txtWard.Text == "SPL")
{
if (txtMonth.Text.Contains("Apr-"))
{
if (classbased.Equals("True") && sttr.Equals("True"))
{
txtbox.Text = (Convert.ToInt32(ds1.Tables[0].Rows[m][5]) * Convert.ToInt32(Label27.Text)).ToString();
if (lb.Text == "BUS FEE")
{
txtbox.Text = (Convert.ToInt32(txtAmount.Text) * Convert.ToInt32(Label27.Text)).ToString();
}
}
else if (classbased.Equals("True") && sttr.Equals("False"))
{
txtbox.Text = ds1.Tables[0].Rows[m][5].ToString();
if (lb.Text == "BUS FEE")
{
txtbox.Text = (Convert.ToInt32(txtAmount.Text) * Convert.ToInt32(Label27.Text)).ToString();
}
}
else if (classbased.Equals("False") && sttr.Equals("True"))
{
txtbox.Text = (Convert.ToInt32(ds.Tables[0].Rows[m][8]) * Convert.ToInt32(Label27.Text)).ToString();
if (lb.Text == "BUS FEE")
{
txtbox.Text = (Convert.ToInt32(txtAmount.Text) * Convert.ToInt32(Label27.Text)).ToString();
}
}
else
{
txtbox.Text = Convert.ToString(ds.Tables[0].Rows[m][8]);
}
}
else
{
if (classbased.Equals("True") && sttr.Equals("True"))
{
txtbox.Text = (Convert.ToInt32(ds1.Tables[0].Rows[m][5]) * Convert.ToInt32(Label27.Text)).ToString();
if (lb.Text == "BUS FEE")
{
txtbox.Text = (Convert.ToInt32(txtAmount.Text) * Convert.ToInt32(Label27.Text)).ToString();
}
}
else if (classbased.Equals("True") && sttr.Equals("False"))
{
txtbox.Text = ds1.Tables[0].Rows[m][5].ToString();
if (lb.Text == "BUS FEE")
{
txtbox.Text = (Convert.ToInt32(txtAmount.Text) * Convert.ToInt32(Label27.Text)).ToString();
}
}
else if (classbased.Equals("False") && sttr.Equals("True"))
{
txtbox.Text = (Convert.ToInt32(ds.Tables[0].Rows[m][8]) * Convert.ToInt32(Label27.Text)).ToString();
if (lb.Text == "BUS FEE")
{
txtbox.Text = (Convert.ToInt32(txtAmount.Text) * Convert.ToInt32(Label27.Text)).ToString();
}
}
else
{
txtbox.Text = "0";
}
}
}
else if (txtWard.Text == "FREE EDUCATION")
{
if (txtMonth.Text.Contains("Apr-"))
{
if (classbased.Equals("True") && sttr.Equals("True"))
{
txtbox.Text = (Convert.ToInt32(ds1.Tables[0].Rows[m][6]) * Convert.ToInt32(Label27.Text)).ToString();
if (lb.Text == "BUS FEE")
{
txtbox.Text = (Convert.ToInt32(txtAmount.Text) * Convert.ToInt32(Label27.Text)).ToString();
}
}
else if (classbased.Equals("True") && sttr.Equals("False"))
{
txtbox.Text = ds1.Tables[0].Rows[m][6].ToString();
if (lb.Text == "BUS FEE")
{
txtbox.Text = (Convert.ToInt32(txtAmount.Text) * Convert.ToInt32(Label27.Text)).ToString();
}
}
else if (classbased.Equals("False") && sttr.Equals("True"))
{
txtbox.Text = (Convert.ToInt32(ds.Tables[0].Rows[m][9]) * Convert.ToInt32(Label27.Text)).ToString();
if (lb.Text == "BUS FEE")
{
txtbox.Text = (Convert.ToInt32(txtAmount.Text) * Convert.ToInt32(Label27.Text)).ToString();
}
}
else
{
txtbox.Text = Convert.ToString(ds.Tables[0].Rows[m][9]);
}
}
else
{
if (classbased.Equals("True") && sttr.Equals("True"))
{
txtbox.Text = (Convert.ToInt32(ds1.Tables[0].Rows[m][6]) * Convert.ToInt32(Label27.Text)).ToString();
if (lb.Text == "BUS FEE")
{
txtbox.Text = (Convert.ToInt32(txtAmount.Text) * Convert.ToInt32(Label27.Text)).ToString();
}
}
else if (classbased.Equals("True") && sttr.Equals("False"))
{
txtbox.Text = ds1.Tables[0].Rows[m][6].ToString();
if (lb.Text == "BUS FEE")
{
txtbox.Text = (Convert.ToInt32(txtAmount.Text) * Convert.ToInt32(Label27.Text)).ToString();
}
}
else if (classbased.Equals("False") && sttr.Equals("True"))
{
txtbox.Text = (Convert.ToInt32(ds.Tables[0].Rows[m][9]) * Convert.ToInt32(Label27.Text)).ToString();
if (lb.Text == "BUS FEE")
{
txtbox.Text = (Convert.ToInt32(txtAmount.Text) * Convert.ToInt32(Label27.Text)).ToString();
}
}
else
{
txtbox.Text = "0";
}
}
}
lb1.Visible = false;
lb2.Visible = false;
lb3.Visible = false;
if (lb3.Text == "N")
{
txtbox.Text = txtbox.Text;
}
else if (lb3.Text == "H")
{
txtbox.Text = (Convert.ToDouble(txtbox.Text) / 2).ToString();
}
else if (lb3.Text == "Q")
{
txtbox.Text = (Convert.ToDouble(txtbox.Text) / 2).ToString();
}
else if (lb3.Text == "F")
{
txtbox.Text = ((Convert.ToDouble(txtbox.Text) / 5) + (Convert.ToDouble(txtbox.Text) % 5)).ToString();
}
if (txtMonth.Text.Contains("Apr-"))
{
if (sttr.Equals("True") || m.ToString() == StId)
{
txtbox.ReadOnly = true;
sum = sum + Convert.ToDouble(txtbox.Text);
}
else
{
txtbox.Enabled = false;
}
}
else
{
if (sttr.Equals("True"))
{
txtbox.ReadOnly = true;
sum = sum + Convert.ToDouble(txtbox.Text);
}
else
{
txtbox.Enabled = false;
}
}
tc.Controls.Add(lb);
tc.Controls.Add(txtbox);
tc.Controls.Add(lb1);
tc.Controls.Add(lb2);
tc.Controls.Add(lb3);
tr.Cells.Add(tc);
m++;
l++;
string z = txtbox.ID.ToString();
}
tbl.Rows.Add(tr);
TextBox1.Text = sum.ToString();
}
}
ViewState["dynamictable"] = true;
con.Close();
btnPay.Visible = true;
}
protected void btnPay_Click(object sender, EventArgs e)
{
}
database:
CREATE TABLE [DAYCOLL] (
[RECT_NO] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[RECT_DATE] [datetime] NULL ,
[STU_NAME] [nvarchar] (75) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[STUDENTID] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ADM_NO] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CLASS] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[SEC] [nvarchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ROLL_NO] [float] NULL ,
[PERIOD] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[TOTAL] [float] NULL ,
[Fee1] [float] NULL ,
[Fee2] [float] NULL ,
[Fee3] [float] NULL ,
[Fee4] [float] NULL ,
[Fee5] [float] NULL ,
[Fee6] [float] NULL ,
[Fee7] [float] NULL ,
[Fee8] [float] NULL ,
[Fee9] [float] NULL ,
[Fee10] [float] NULL ,
[Fee11] [float] NULL ,
[Fee12] [float] NULL ,
[Fee13] [float] NULL ,
[Fee14] [float] NULL ,
[Fee15] [float] NULL ,
[Fee16] [float] NULL ,
[Fee17] [float] NULL ,
[Fee18] [float] NULL ,
[Fee19] [float] NULL ,
[Fee20] [float] NULL ,
[Fee21] [float] NULL ,
[Fee22] [float] NULL ,
[Fee23] [float] NULL ,
[Fee24] [float] NULL ,
[Fee25] [float] NULL ,
[APR_FEE] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[MAY_FEE] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[JUNE_FEE] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[JULY_FEE] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[AUG_FEE] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[SEP_FEE] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[OCT_FEE] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[NOV_FEE] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[DEC_FEE] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[JAN_FEE] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[FEB_FEE] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[MAR_FEE] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CHQ_NO] [nvarchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Narr] [nvarchar] (70) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[TAmt] [int] NULL
) ON [PRIMARY]
GO