how do you generate source code for the automatic generation for receipt numbe

how do you generate source code for the automatic generation
for receipt number

Question Posted / arul

1 Answers
4794 Views
Infosys, I also Faced
E-Mail Answers

how do you generate source code for the automatic generation for receipt number..

Answer / raviarsenal

C # in form load paste this code

try
{
SqlConnection con = new SqlConnection
(@"Data Source=.\sqlexpress;Initial
Catalog=Hospital;Integrated Security=True");
con.Open();
q = "select Billno from PatientBill";
SqlCommand cmd = new SqlCommand(q, con);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
bill = Convert.ToInt32(dr
["Billno"].ToString());
}
txtbillno.Text = (bill + 1).ToString();
dr.Close();
cmd.Dispose();
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Programming Languages AllOther Interview Questions

This is the portal and portlet interview question API: is JSR 168 API Server: is ibm web sphere portal server6.0 IDE: is RAD 7.0 Question:In normal struts what is the actionservlet? Ans:org.apache.struts.action.ActionServlet. But What is the actionservlet in strutsportlet?

1 Answers CTS, IBM,

___ method used to move a recordset pointer in nth position in DAG.

1 Answers

what is encapulation?

4 Answers Syntel,

I want to pass .pdf files as OlE Object to crystal report through VB6. Please any one guid me...

0 Answers

why we use new keyword for object

4 Answers TCS,

What is test execution and when will we start execution please send me one example for this question

0 Answers

write a program on c(or)c++(or)java language i.e if i have 5 numbers like (10,24,3,9,15) i want to display highest number from these numbers