protected void btnSubmit_Click(object sender, EventArgs e)
{
if (drpRefMembers.Text == "SELECT")
{
MessageBox.Show("Please Select Reference Member!");
}
else
{
// dt=MDC.getDataTable("select * from ")
//string ttx = TranslateText("Hello");
string ssql = "";
ssql = "select * from Individual_App where PK_APP_ID=0";
DataTable dt = MDC.getDataTable("select * from Individual_App where PK_APP_ID=0");
DataRow dr;
dr = dt.NewRow();
// PK_C_ID int Unchecked
//TypeId int Unchecked
//TypeName nvarchar(100) Unchecked
dr["TypeName"] = "Form_D_Individual";
dr["Address"] = txtAddressEnglish.Text; // nvarchar(20t0) Unchecked
dr["AddressHindi"] = txtAddressHindi.Text; // nvarchar(200) Checked
dr["Tehsil"] = txtBlockEnglish.Text;
dr["TehsilHindi"] = txtBlockHindi.Text;
//Address1 nvarchar(200) Checked
//AddressHindi1 nvarchar(200) Unchecked
//Address2 nvarchar(200) Unchecked
//AddressHindi2 nvarchar(200) Unchecked=
//Address3 nvarchar(200) Unchecked
//AddressHindi3 nvarchar(200) Checked
//Address4 nvarchar(200) Checked
//AddressHindi4 nvarchar(200) Unchecked
//FK_CityId nvarchar(50) Checked
txtAnnualSale.Text = "0";
dr["CityHindi"] = txtCityHindi.Text; // nvarchar(50) Checked
dr["Landmark"] = txtLandMarkEnglish.Text; // nvarchar(200) Checked
dr["LandmarkHindi"] = txtLandMarkHindi.Text; // nvarchar(200) Checked
//District nvarchar(50) Checked
//DistrictHindi nvarchar(50) Checked
//Tehsil nvarchar(50) Checked
//TehsilHindi nvarchar(50) Checked
//StateiId int Checked
//CountryId int Checked
dr["RefMember"] = drpRefMembers.Text;
dr["MailId"] = txtMobile.Text;
dr["MobileNo"] = txtMobile.Text; // int Unchecked
dr["PaNNo"] = txtPANno.Text; // nvarchar(50) Unchecked
dr["TelephoneNo"] = txtPhone.Text;
dr["AdharNo"] = txtAdhaarNo.Text; // nvarchar(50) Unchecked
//VoterId nvarchar(50) Unchecked
dr["CreateDate"] = System.DateTime.Now; // date Unchecked
dr["UpdateDate"] = System.DateTime.Now; //date Unchecked
dr["IsActive"] = true; // bit Unchecked
dr["Name"] = txtEnglishName.Text;
dr["NameHindi"] = txtHindiName.Text;
dr["SurNameHindi"] = txtEnglishSurname.Text;
dr["SurNameEng"] = txtHindiSurname.Text;
dr["FatherName"] = txtFatherEnglishName.Text;
dr["FatherNameHindi"] = txtFatherHindiName.Text;
dr["FatherNameHindi"] = txtFatherHindiName.Text;
dr["State"] = txtStates.Text;
dr["City"] = txtCity.Text;
dr["Establish"] = ChkSthapna.Checked;
dr["Gst"] = chkGST.Checked;
dr["Gumasta"] = chkGumasta.Checked;
dr["Other"] = chkOther.Checked;
dr["Firm"] = txtFirm.Text;
dr["FirmAddress"] = txtFirm.Text;
dr["AnnualSale"] = Convert.ToInt32(txtAnnualSale.Text);
dr["WorkArea"] = txtWorkArea.Text;
dr["WorkArea"] = txtWorkArea.Text;
dt.Rows.Add(dr);
if (MDC.InsertData(dt, dr, ssql) == true)
{
MessageBox.Show("Record Saved Successfully...");
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (drpRefMember.Text == "SELECT")
{
MessageBox.Show("Please Select Reference Member!");
}
else
{
// dt=MDC.getDataTable("select * from ")
//string ttx = TranslateText("Hello");
string ssql = "";
if (txtEnglishName.Text.Length <= 0)
{
MessageBox.Show("Please Enter Name!");
return;
}
if (txtFatherEnglishName.Text.Length <= 0)
{
MessageBox.Show("Please Enter Father's Name!");
return;
}
if (txtAddressEnglish.Text.Length <= 0)
{
MessageBox.Show("Please Enter Address!");
return;
}
if (txtBuildingEnglishName.Text.Length <= 0)
{
MessageBox.Show("Please Enter Building Name !");
return;
}
if (txtMargEnglish.Text.Length <= 0)
{
MessageBox.Show("Please Enter Area!");
return;
}
if (txtChequeNo.Value.Length <= 0)
{
MessageBox.Show("Please Enter Cheque No!");
return;
}
if (txtBankName.Value.Length <= 0)
{
MessageBox.Show("Please Enter Bank Name!");
return;
}
if (txtChequeDate.Value.Length <= 0)
{
MessageBox.Show("Please Enter Date !");
return;
}
if (txtMohallaEnglish.Text.Length <= 0)
{
MessageBox.Show("Please Enter Colony!");
return;
}
if (txtLandMarkEnglish.Text.Length <= 0)
{
MessageBox.Show("Please Enter Land Mark!");
return;
}
if (txtBlockEnglish.Text.Length <= 0)
{
MessageBox.Show("Please Enter Tehsil!");
return;
}
if (txtMobile.Text.Length <= 0)
{
MessageBox.Show("Please Enter Mobile!");
return;
}
if (txtPhone.Text.Length <= 0)
{
MessageBox.Show("Please Enter STD Phone!");
return;
}
if (txtEmail.Text.Length <= 0)
{
MessageBox.Show("Please Enter Email ID !");
return;
}
if (txtPANno.Text.Length <= 0)
{
MessageBox.Show("Please Enter PAN CARD !");
return;
}
if (txtAdhaarNo.Text.Length <= 0)
{
MessageBox.Show("Please Enter Aadhar No!");
return;
}
if (txtFirm.Text.Length <= 0)
{
MessageBox.Show("Please Enter Organisation Name!");
return;
}
if (TextAddress.Text.Length <= 0)
{
MessageBox.Show("Please Enter Organisation Address!");
return;
}
if (txtAnnualSale.Text.Length <= 0)
{
MessageBox.Show("Please Enter Yearly Sales!");
return;
}
if (txtWorkArea.Text.Length <= 0)
{
MessageBox.Show("Please Enter Organisation Work Area !");
return;
}
if (txtUserName.Text.Length <= 0)
{
MessageBox.Show("Please Upload Image!");
return;
}
if (txtPassword.Text.Length <= 0)
{
MessageBox.Show("Please Enter Password !");
return;
}
if (txtConfirmPassword.Text.Length <= 0)
{
MessageBox.Show("Please Enter Confirm Password!");
return;
}
if (txtConfirmPassword.Text != txtPassword.Text)
{
MessageBox.Show("Password & Confirm Password must be same");
return;
}
//ANji
ssql = "select * from Individual_App where PK_APP_ID=0";
DataTable dt = MDC.getDataTable("select * from Individual_App where PK_APP_ID=0");
DataRow dr;
dr = dt.NewRow();
// PK_C_ID int Unchecked
//TypeId int Unchecked
//TypeName nvarchar(100) Unchecked
dr["TypeName"] = "Form_D_Individual";
// dr["UpperNameEnglish"] = txtSocietyNameEng.Text; // nvarchar(20t0) Unchecked
// dr["UpperNameHindi"] = txtSocietyNameHindi.Text; // nvarchar(200) Checked
dr["Address"] = txtAddressEnglish.Text; // nvarchar(20t0) Unchecked
dr["SurNameHindi"] = txtEnglishSurname.Text;
dr["SurNameEng"] = txtHindiSurname.Text;
dr["AddressHindi"] = txtAddressHindi.Text; // nvarchar(200) Checked
dr["Address1"] = txtBuildingEnglishName.Text; // nvarchar(20t0) Unchecked
dr["AddressHindi1"] = txtBuildingHindiName.Text; // nvarchar(200) Checked
dr["Address2"] = txtMargEnglish.Text; // nvarchar(20t0) Unchecked
dr["AddressHindi2"] = txtMargHindi.Text; // nvarchar(200) Checked
dr["Address3"] = txtMohallaEnglish.Text; // nvarchar(20t0) Unchecked
dr["AddressHindi3"] = txtMohallaHindi.Text; // nvarchar(200) Checked
dr["Address4"] = txtLandMarkEnglish.Text; // nvarchar(20t0) Unchecked
dr["AddressHindi4"] = txtLandMarkHindi.Text; // nvarchar(200) Checked
dr["Tehsil"] = txtBlockEnglish.Text;
dr["State"] = DrpState.Text;
dr["TehsilHindi"] = txtBlockHindi.Text;
dr["District"] = txtJilaEnglish.Text;
dr["PIN"] = DrpPinCode.Text;
dr["City"] = DrpCity.Text;
dr["ChequeNo"] = txtChequeNo.Value; // nvarchar(200) Checked
dr["BankName"] = txtBankName.Value; // nvarchar(200) Checked
dr["IsApproved"] = false; // nvarchar(200) Checked
// dr["City"] = DrpCity.Text;
if (txtChequeDate.Value.Length > 0)
{
dr["ChequeDate"] = Convert.ToDateTime(txtChequeDate.Value); //District nvarchar(50) Checked
}
//Address1 nvarchar(200) Checked
//AddressHindi1 nvarchar(200) Unchecked
//Address2 nvarchar(200) Unchecked
//AddressHindi2 nvarchar(200) Unchecked=
//Address3 nvarchar(200) Unchecked
//AddressHindi3 nvarchar(200) Checked
//Address4 nvarchar(200) Checked
//AddressHindi4 nvarchar(200) Unchecked
//FK_CityId nvarchar(50) Checked
dr["RefMember"] = drpRefMember.Text;
dr["CityEnglish"] = txtCityEnglish.Text;
dr["CityHindi"] = txtCityHindi.Text; // nvarchar(50) Checked
dr["Landmark"] = txtLandMarkEnglish.Text; // nvarchar(200) Checked
dr["LandmarkHindi"] = txtLandMarkHindi.Text; // nvarchar(200) Checked
//District nvarchar(50) Checked
//DistrictHindi nvarchar(50) Checked
//Tehsil nvarchar(50) Checked
//TehsilHindi nvarchar(50) Checked
//StateiId int Checked
//CountryId int Checked
dr["RefMember"] = drpRefMember.Text;
dr["MailId"] = txtMobile.Text;
dr["State"] = DrpState.Text;
dr["MobileNo"] = txtMobile.Text; // int Unchecked
dr["PaNNo"] = txtPANno.Text; // nvarchar(50) Unchecked
dr["TelephoneNo"] = txtPhone.Text;
dr["SurNameEng"] = txtEnglishSurname.Text;
dr["SurNameHindi"] = txtHindiSurname.Text;
dr["AdharNo"] = txtAdhaarNo.Text; // nvarchar(50) Unchecked
//VoterId nvarchar(50) Unchecked
dr["CreateDate"] = System.DateTime.Now; // date Unchecked
dr["UpdateDate"] = System.DateTime.Now; //date Unchecked
dr["IsActive"] = true; // bit Unchecked
dr["Name"] = txtEnglishName.Text;
dr["NameHindi"] = txtHindiName.Text;
dr["FatherName"] = txtFatherEnglishName.Text;
dr["FatherNameHindi"] = txtFatherHindiName.Text;
dr["FatherNameHindi"] = txtFatherHindiName.Text;
// ANji
dr["Firm"] = txtFirm.Text;
dr["FirmAddress"] = TextAddress.Text;
dr["BusinessDetail"] = txtDetail.Text;
dr["WorkArea"] = txtWorkArea.Text;
dr["District"] = txtJilaEnglish.Text;
dr["DistrictHindi"] = txtJilaHindi.Text;
dr["AnnualSale"] = txtAnnualSale.Text;
//sm
dr["Establish"] = ChkSthapna.Checked;
dr["Gst"] = chkGST.Checked;
dr["Gumasta"] = chkGST.Checked;
dr["Other"] = chkOther.Checked;
dt.Rows.Add(dr);
if (MDC.InsertData(dt, dr, ssql) == true)
{
MessageBox.Show("Record Saved Successfully...");
clearAll();
}
}
}
protected void btnSubmit_Click1(object sender, EventArgs e)
{
try
{
// dt=MDC.getDataTable("select * from ")
//string ttx = TranslateText("Hello");
string ssql = "";
// ssql = "select * from Society_App_FormC where PK_APP_IDFromC=0";
// DataTable dt = MDC.getDataTable("Select * from Society_App_FormC where PK_APP_IDFromC=0");
if (drpRefMember.Text == "SELECT")
{
MessageBox.Show("Please Select Reference Member!");
return;
}
if (txtNames.Text.Length <= 0)
{
MessageBox.Show("Please Enter Name!");
return;
}
if (txtNames.Text.Length <= 0)
{
MessageBox.Show("Please Enter Name!");
return;
}
if (txtEnglishName.Text.Length <= 0)
{
MessageBox.Show("Please Enter Name!");
return;
}
if (txtFatherEnglishName.Text.Length <= 0)
{
MessageBox.Show("Please Enter Another Name!");
return;
}
if (txtAddressEnglish.Text.Length <= 0)
{
MessageBox.Show("Please Enter Address!");
return;
}
if (txtBuildingEnglishName.Text.Length <= 0)
{
MessageBox.Show("Please Enter Building Name!");
return;
}
if (txtMargEnglish.Text.Length <= 0)
{
MessageBox.Show("Please Enter Marg Name!");
return;
}
if (txtMohallaEnglish.Text.Length <= 0)
{
MessageBox.Show("Please Enter Area!");
return;
}
if (txtLandMarkEnglish.Text.Length <= 0)
{
MessageBox.Show("Please Enter Land Mark!");
return;
}
if (txtBlockEnglish.Text.Length <= 0)
{
MessageBox.Show("Please Enter Tehsil!");
return;
}
if (txtMobile.Text.Length <= 0)
{
MessageBox.Show("Please Enter Mobile!");
return;
}
if (txtPhone.Text.Length <= 0)
{
MessageBox.Show("Please Enter STD Phone!");
return;
}
if (TextBox3.Text.Length <= 0)
{
MessageBox.Show("Please Enter Another Phone No!");
return;
}
if (TextBox4.Text.Length <= 0)
{
MessageBox.Show("Please Enter Another STD Phone!");
return;
}
if (txtEmail.Text.Length <= 0)
{
MessageBox.Show("Please Enter Email ID !");
return;
}
if (txtPANno.Text.Length <= 0)
{
MessageBox.Show("Please Enter PAN CARD !");
return;
}
if (txtAdhaarNo.Text.Length <= 0)
{
MessageBox.Show("Please Enter Aadhar No!");
return;
}
if (txtUserName.Text.Length <= 0)
{
MessageBox.Show("Please Upload Image!");
return;
}
if (txtPassword.Text.Length <= 0)
{
MessageBox.Show("Please Enter Password !");
return;
}
if (txtConfirmPassword.Text.Length <= 0)
{
MessageBox.Show("Please Enter Confirm Password!");
return;
}
if (txtConfirmPassword.Text != txtPassword.Text)
{
MessageBox.Show("Password & Confirm Password must be same");
return;
}
ssql = "select * from Individual_App where PK_APP_ID=0";
DataTable dt = MDC.getDataTable("select * from Individual_App where PK_APP_ID=0");
DataRow dr;
dr = dt.NewRow();
dr["TypeName"] = "Form_C_Society";
dr["Address"] = txtAddressEnglish.Text; // nvarchar(20t0) Unchecked
dr["AddressHindi"] = txtAddressHindi.Text; // nvarchar(200) Checked
dr["Tehsil"] = txtBlockEnglish.Text;
dr["TehsilHindi"] = txtBlockHindi.Text;
dr["UpperNameEnglish"] = txtNames.Text; // nvarchar(20t0) Unchecked
dr["UpperNameHindi"] = txtHindi.Text; // nvarchar(200) Checked
dr["Address"] = txtAddressEnglish.Text; // nvarchar(20t0) Unchecked
dr["AddressHindi"] = txtAddressHindi.Text; // nvarchar(200) Checked
dr["Address1"] = txtBuildingEnglishName.Text; // nvarchar(20t0) Unchecked
dr["AddressHindi1"] = txtBuildingHindiName.Text; // nvarchar(200) Checked
dr["Address2"] = txtMargEnglish.Text; // nvarchar(20t0) Unchecked
dr["AddressHindi2"] = txtMargHindi.Text; // nvarchar(200) Checked
dr["Address3"] = txtMohallaEnglish.Text; // nvarchar(20t0) Unchecked
dr["AddressHindi3"] = txtMohallaHindi.Text; // nvarchar(200) Checked
dr["Address4"] = txtLandMarkEnglish.Text; // nvarchar(20t0) Unchecked
dr["AddressHindi4"] = txtLandMarkHindi.Text; // nvarchar(200) Checked
//dr["Tehsil"] = txtBlockEnglish.Text;
// dr["PIN"] = txtPin.Text;
dr["State"] = DrpState.Text;
dr["RefMember"] = drpRefMember.Text;
dr["CityHindi"] = txtCityHindi.Text; // nvarchar(50) Checked
dr["CityEnglish"] = txtCityEnglish.Text;
dr["Landmark"] = txtLandMarkEnglish.Text; // nvarchar(200) Checked
dr["LandmarkHindi"] = txtLandMarkHindi.Text; // nvarchar(200) Checked
dr["ChequeNo"] = txtChequeNo.Value; // nvarchar(200) Checked
dr["BankName"] = txtBankName.Value; // nvarchar(200) Checked
dr["IsApproved"] = false; // nvarchar(200) Checked
if (txtChequeDate.Value.Length > 0)
{
dr["ChequeDate"] = Convert.ToDateTime(txtChequeDate.Value); //District nvarchar(50) Checked
}
dr["MailId"] = txtEmail.Text;
dr["MobileNo"] = txtMobile.Text; // int Unchecked
dr["PaNNo"] = txtPANno.Text; // nvarchar(50) Unchecked
dr["TelephoneNo"] = txtPhone.Text;
//anji
dr["MobileNo2"] = TextBox3.Text; // int Unchecked
dr["StdCode2"] = TextBox4.Text;
dr["AdharNo"] = txtAdhaarNo.Text; // nvarchar(50) Unchecked
dr["District"] = txtJilaEnglish.Text;
dr["DistrictHindi"] = txtJilaHindi.Text; //VoterId nvarchar(50) Unchecked
dr["CreateDate"] = System.DateTime.Now; // date Unchecked
dr["UpdateDate"] = System.DateTime.Now; //date Unchecked
dr["IsActive"] = true; // bit Unchecked
dr["Name"] = txtEnglishName.Text;
dr["NameHindi"] = txtHindiName.Text;
dr["FatherName"] = txtFatherEnglishName.Text;
dr["FatherNameHindi"] = txtFatherHindiName.Text;
dr["PIN"] = DrpPinCode.Text;
dr["District"] = txtJilaEnglish.Text;
dr["City"] = DrpCity.Text;
dr["FatherNameHindi"] = txtFatherHindiName.Text;
dr["UserName"] = txtUserName.Text;
dr["Password"] = txtPassword.Text;
dr["ConfirmPassword"] = txtConfirmPassword.Text;
dt.Rows.Add(dr);
if (MDC.InsertData(dt, dr, ssql) == true)
{
MessageBox.Show("Record Saved Successfully...");
clearAll();
}
}
catch (Exception ex)
{
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (drpRefMember.Text == "SELECT")
{
MessageBox.Show("Please Select Reference Member!");
}
else
{
// dt=MDC.getDataTable("select * from ")
//string ttx = TranslateText("Hello");
string ssql = "";
// ssql = "select * from Society_App_FormD where PK_APP_IDFromD=0";
// DataTable dt = MDC.getDataTable("select * from Society_App_FormD where PK_APP_IDFromD=0");
ssql = "select * from Individual_App where PK_APP_ID=0";
DataTable dt = MDC.getDataTable("select * from Individual_App where PK_APP_ID=0");
DataRow dr;
dr = dt.NewRow();
// PK_C_ID int Unchecked
//TypeId int Unchecked
//TypeName nvarchar(100) Unchecked
//Anji
txtAddressEnglish.Text = dr["Address"].ToString(); // nvarchar(20t0) Unchecked
txtAddressHindi.Text = dr["AddressHindi"].ToString(); // nvarchar(200) Checked
txtBlockEnglish.Text = dr["Tehsil"].ToString();
txtBlockHindi.Text = dr["TehsilHindi"].ToString();
drpRefMember.Text = dr["RefMember"].ToString();
txtCityHindi.Text = dr["CityHindi"].ToString(); // nvarchar(50) Checked
txtLandMarkEnglish.Text = dr["Landmark"].ToString(); // nvarchar(200) Checked
txtLandMarkHindi.Text = dr["LandmarkHindi"].ToString(); // nvarchar(200) Checked
txtState.Text = dr["State"].ToString();
txtCity.Text = dr["City"].ToString();
txtPinCode.Text = dr["PIN"].ToString();
txtEmail.Text = dr["MailId"].ToString();
txtMobile.Text = dr["MobileNo"].ToString(); // int Unchecked
txtPANno.Text = dr["PaNNo"].ToString(); // nvarchar(50) Unchecked
txtPhone.Text = dr["TelephoneNo"].ToString();
txtAdhaarNo.Text = dr["AdharNo"].ToString(); // nvarchar(50) Unchecked
//VoterId nvarchar(50) Unchecked
txtEnglishName.Text = dr["Name"].ToString();
txtHindiName.Text = dr["NameHindi"].ToString();
txtFatherEnglishName.Text = dr["FatherName"].ToString();
txtFatherHindiName.Text = dr["FatherNameHindi"].ToString();
txtFatherHindiName.Text = dr["FatherNameHindi"].ToString();
// Anji
//Sm
txtEnglishName.Text = dr["Name"].ToString(); // nvarchar(20t0) Unchecked
txtHindiName.Text = dr["NameHindi"].ToString(); // nvarchar(200) Checked
txtAddressEnglish.Text = dr["Address"].ToString(); // nvarchar(20t0) Unchecked
txtAddressHindi.Text = dr["AddressHindi"].ToString(); // nvarchar(200) Checked
txtBuildingEnglishName.Text = dr["Address1"].ToString(); // nvarchar(20t0) Unchecked
txtBuildingHindiName.Text = dr["AddressHindi1"].ToString();
txtMargEnglish.Text = dr["Address2"].ToString(); // nvarchar(20t0) Unchecked
txtMargHindi.Text = dr["AddressHindi2"].ToString();
txtMohallaEnglish.Text = dr["Address3"].ToString(); // nvarchar(20t0) Unchecked
txtMohallaHindi.Text = dr["AddressHindi3"].ToString();
txtLandMarkEnglish.Text = dr["Address4"].ToString(); // nvarchar(20t0) Unchecked
txtLandMarkHindi.Text = dr["AddressHindi4"].ToString();
txtBlockEnglish.Text = dr["Tehsil"].ToString();
txtBlockHindi.Text = dr["TehsilHindi"].ToString();
txtDetail.Text = dr["BusinessDetail"].ToString();
// drpRefMember.Text = dr["RefMember"].ToString();
txtCityHindi.Text = dr["CityHindi"].ToString(); // nvarchar(50) Checked
txtCityEnglish.Text = dr["CityEnglish"].ToString();
txtLandMarkEnglish.Text = dr["Landmark"].ToString(); // nvarchar(200) Checked
txtLandMarkHindi.Text = dr["LandmarkHindi"].ToString();
txtEmail.Text = dr["MailId"].ToString();
txtMobile.Text = dr["MobileNo"].ToString(); // int Unchecked
txtPANno.Text = dr["PaNNo"].ToString(); // nvarchar(50) Unchecked
txtPhone.Text = dr["TelephoneNo"].ToString();
txtAdhaarNo.Text = dr["AdharNo"].ToString();
txtDetail.Text = dr["BusinessDetail"].ToString();
txtWorkArea.Text = dr["WorkArea"].ToString();
txtAnnualSale.Text = dr["AnnualSale"].ToString();
if (dr["Establish"] == System.DBNull.Value)
{
ChkSthapna.Checked = false;
}
else
{
ChkSthapna.Checked = Convert.ToBoolean(dr["Establish"]);
}
if (dr["Gst"] == System.DBNull.Value)
{
chkGST.Checked = false;
}
else
{
chkGST.Checked = Convert.ToBoolean(dr["Gst"]);
}
if (dr["Gumasta"] == System.DBNull.Value)
{
chkGST.Checked = false;
}
else
{
chkGST.Checked = Convert.ToBoolean(dr["Gumasta"]);
}
if (dr["Other"] == System.DBNull.Value)
{
chkOther.Checked = false;
}
else
{
chkOther.Checked = Convert.ToBoolean(dr["Other"]);
}
//tny
//sm
//dr["Firm"] = txtFirm.Text;
//dr["FirmAddress"] = txtFirm.Text;
//dr["AnnualSale"] = txtAnnualSale.Text;
//dr["WorkArea"] = txtWorkArea.Text;
//dr["WorkArea"] = txtWorkArea.Text;
dt.Rows.Add(dr);
if (MDC.InsertData(dt, dr, ssql) == true)
{
MessageBox.Show("Record Saved Successfully...");
}
}
}