Comments by Deekshaa Singh Chauhan (Top 29 by date)

yes i have insuranceId as id and i have data wich is show in gridview bt that not delete

i want export database on my pc

Actually my database is here in mylittleAdmin and how export from here to my pc

double Quantity1 = texbox.text ;
there is throw error bcoz it take textbox.text as string

I did this but it is not giving the right result.

private void Totaltxt_KeyDown(object sender, KeyEventArgs e)
{
if (txttax.SelectedIndex > 0 && Totaltxt.Text != "" && Totaltxt.Text != null )
{
double Quantity1 = Convert.ToDouble(txtqty.Text);
double Price1 = Convert.ToDouble(qtytxtprice.Text);
double Price2 = 0;
double Quantity2;
//float q;
try
{
Price2 = Convert.ToDouble(Totaltxt.Text);
Quantity2 = Convert.ToDouble((Quantity1 / Price1) * Price2);
txtqty.Text = Quantity2.ToString("F2");
}
catch { }
}
}

i mean 60rs per kg ,then 51rs me koi buy karega to kya quantity hogi use kese calculate kare

what?

my software work in windows 7 bt it not working on windows xp

this following code check value but i'm confused where i placed this code



private void txtbill_Validated(object sender, EventArgs e)
{
if (txtbill.Text != "" )
{

SqlDataAdapter sda = new SqlDataAdapter("SELECT Billno FROM MainBillForm WHERE Billno = '" + txtbill.Text + "' AND Company_ID =" + GlobalVariable.companyId, con);
DataTable dt = new DataTable();
sda.Fill(dt);

if (dt.Rows.Count.ToString() != "1")
{

MessageBox.Show("Already Exists");
txtbill.Text = string.Empty;
}
else
{

}
}
}

it perfectly run but i want do check the textbox number is exists in database or not

it generate automatically but when i assign value using textbox it take that number as a assigning value and start increasing that number

I tested that this only show one row but why? where is problem

this code worked bt show only 1 row and sometime that give error in data grideview id column



DataTable dt = new DataTable();
{
SqlConnection con = new SqlConnection(strcon);
dataGridView1.DataSource = null;
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
con.Open();
SqlCommand cmd = new SqlCommand("select id,cmpny_dtl.c_name as c_name,cmpny_dtl.adrs as adrs,cmpny_dtl.GST as GST,t.State as state,cmpny_dtl.srvctax as srvctax,cmpny_dtl.adsnldtl as adsnldtl,cmpny_dtl.logo as logo" + " from cmpny_dtl join State t on t.State_ID = cmpny_dtl.state_id ", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
con.Close();
//dataGridView1.ColumnCount = 7;
//dataGridView1.Columns[0].HeaderText = "id";
//dataGridView1.Columns[0].DataPropertyName = "id";
//dataGridView1.Columns[0].Visible = false;
//dataGridView1.Columns[1].HeaderText = "c_name";
//dataGridView1.Columns[1].DataPropertyName = "c_name";
//dataGridView1.Columns[2].HeaderText = "adrs";
//dataGridView1.Columns[2].DataPropertyName = "adrs";
//dataGridView1.Columns[3].HeaderText = "GST";
//dataGridView1.Columns[3].DataPropertyName = "GST";
////dataGridView1.Columns[3].Visible = false;
//dataGridView1.Columns[4].HeaderText = "state";
//dataGridView1.Columns[4].DataPropertyName = "state_id";
//dataGridView1.Columns[4].Visible = false;
//dataGridView1.Columns[5].HeaderText = "srvctax";
//dataGridView1.Columns[5].DataPropertyName = "srvctax";
//dataGridView1.Columns[6].HeaderText = "adsnldtl";
//dataGridView1.Columns[6].DataPropertyName = "adsnldtl";
dataGridView1.DataSource = dt;
}






private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (dataGridView1.CurrentRow.Index != -1)
{
//if (dataGridView1.CurrentRow.Cells[10].Value != DBNull.Value)
//{
// byte[] img = (byte[])dataGridView1.CurrentRow.Cells[10].Value;
// MemoryStream ms = new MemoryStream(img);
// pictureBox1.Image = Image.FromStream(ms);
//}
//else
//{
// pictureBox1.Image = null;
//}

//id = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value.ToString());
CmpnyName_txt.Text = dataGridView1.CurrentRow.Cells[2].Value.ToString();
Adrs_txt.Text = dataGridView1.CurrentRow.Cells[3].Value.ToString();
CmpnyPhone_txt.Text = dataGridView1.CurrentRow.Cells[8].Value.ToString();
//Email_txt.Text = dataGridView1.CurrentRow.Cells[4].Value.ToString();
//Webst_txt.Text = dataGridView1.CurrentRow.Cells[5].Value.ToString();
//Pan_txt.Text = dataGridView1.CurrentRow.Cells[6].Value.ToString();
//Tin_txt.Text = dataGridView1.CurrentRow.Cells[7].Value.ToString();
SrvcTaxNo_txt.Text = dataGridView1.CurrentRow.Cells[6].Value.ToString();
AdsnlDtl_txt.Text = dataGridView1.CurrentRow.Cells[7].Value.ToString();
STATE_comboBox.Text = dataGridView1.CurrentRow.Cells[5].Value.ToString();
GST_textBox.Text = dataGridView1.CurrentRow.Cells[4].Value.ToString();
//id_txt.Text = dataGridView1.CurrentRow.Cells[0].Value.ToString();
SUBMIT_btn.Text = "UPDATE";

i want save state_id but show state name

this is not helpfull

there show only 1 form that font changed not in other form in other form only 1 label and buttons font change not entire form in this form all labels in 1 panel bt buttons outside of panel that font changed and 1 label font chenged from in panel.
where is problem i dont know!

i want create tools page in my billing application where i give change font,color,style and chnge any label name ,logo show not and all any other changes

i'm create a bill printout in report.rdlc , i want dynamically add or remove logo and also i want change bill templet color

i'm not understand how to start and do.
i tried but
private void button1_Click(object sender, EventArgs e)
{
FontDialog fontDlg = new FontDialog();
if (fontDlg.ShowDialog() != DialogResult.Cancel)
{

Bill_Report br = new Bill_Report();

br.Font = fontDlg.Font;
br.Show();

AdCmpny_dtls acd = new AdCmpny_dtls();
acd.Font = fontDlg.Font;
//acd.da
//textBox1.Font = fontDlg.Font; "=IIf(Parameters!Exist.Value,true,false) Parameters!ImgPath.Value + Fields!PersonalInfoEmployeePicture.Value

label1.Font = fontDlg.Font;

//textBox1.BackColor = fontDlg.Color;

label1.ForeColor = fontDlg.Color;

}
}

but here only when page show then changes perform but when page not show then not perform any change

I have taken a checkbox when checked in, then change automatically in all the pages.

like page size , font style ,color & chnge any label name