Comments by VINAY60 (Top 10 by date)

ya... sir.can you give details

are you satisfied to me details or not..?

Actually I have a website on medical software.whenever users download demo version of my software.more then users are fake with mobile contact no.now i want to use verification code for mobile no for all user.when user enter him mobile no then a code should be receive by user.and this code again enter in verify text box.then if this code accepted then download option come on the screen.

sir i want to know only that i have an application in asp.net using c#.it is website.this application runs on a local server.in this website i have a patient registration page at which we can register to any patient.after fill complete registration such as we press button for submit information,we have a output with crystal report but its create two or three patient registration on a single crystal report page.its takes two or more patient information from the database and display on crystal report whenever we fire the event on a button.on the button click i have multiple connection.like below code. we runs that application with more then 10 computer system.

protected void Button1_Click(object sender, EventArgs e)
{
using (MySql.Data.MySqlClient.MySqlConnection mycon19 = new MySqlConnection(WebConfigurationManager.ConnectionStrings["MoonrakerConnectionString1"].ToString()))
{
mycon19.Open();
NewOpdId = 0;
NewUhid = 0;
MySqlCommand cmd = new MySqlCommand("check_registration", mycon19);
if ((uhid.Text.Trim() == "") || (uhid.Text.Trim() == null))
{
NewUhid = 0;
F20U();
MySqlParameter pr = cmd.Parameters.AddWithValue("@pr_uhid", NewUhid);
MySqlParameter pr1 = cmd.Parameters.AddWithValue("@pr_uhid1", "insert");
}
if ((uhid.Text.Trim() != ""))
{
NewUhid = Convert.ToInt32(uhid.Text.Trim());
MySqlParameter pr = cmd.Parameters.AddWithValue("@pr_uhid", NewUhid);
MySqlParameter pr1 = cmd.Parameters.AddWithValue("@pr_uhid1", "update");
}
cmd.CommandType = CommandType.StoredProcedure;
DateTime? dtb = null;
if (popupDatepicker.Text != "")
{
dtb = Convert.ToDateTime(popupDatepicker.Text);
}
int? rele = null;
string reletext = null;
if (Religion.SelectedItem.Value != "")
{
rele = Convert.ToInt32(Religion.SelectedValue.ToString());
reletext = Religion.SelectedItem.Text;
}
int? occu = null;
string occutext = null;
if (Occupation.SelectedValue != "")
{
occu = Convert.ToInt32(Occupation.SelectedItem.Value);
occutext = Occupation.SelectedItem.Text;
}
if (Phone.Text != "") { phn = Phone.Text; }
if (Mobile.Text != "") { mob = Mobile.Text; }
if (Email.Text != "") { mail = Email.Text; }
if (bloodgrp.Text != "") { blgrp = bloodgrp.Text; }
if (middlename.Text != "") { midname = middlename.Text; }
if (lastname.Text != "") { lname = lastname.Text; }
cmd.Parameters.AddWithValue("@pr_name", fname.Text + " " + midname + " " + lname);
cmd.Parameters.AddWithValue("@pr_gender", Convert.ToInt32(Gender.SelectedValue.ToString()));
cmd.Parameters.AddWithValue("@pr_dob", dtb);
cmd.Parameters.AddWithValue("@pr_age", Age.Text);
cmd.Parameters.AddWithValue("@pr_blood", blgrp);
cmd.Parameters.AddWithValue("@pr_guardianname", father.Text);
cmd.Parameters.AddWithValue("@pr_adharno", aadhaar.Text);
cmd.Parameters.AddWithValue("@pr_marital", Convert.ToInt32(martitalstatus.SelectedValue.ToString()));
if (Category.SelectedValue.ToString() != "0")
cmd.Parameters.AddWithValue("@pr_patientcategory", Category.SelectedValue.ToString());
cmd.Parameters.AddWithValue("@pr_religion", rele);
cmd.Parameters.AddWithValue("@pr_occupation", occu);
if (income.SelectedItem.Text == "")
{ cmd.Parameters.AddWithValue("@pr_incom", d1); }
else if (income.SelectedItem.Text == "")
cmd.Parameters.AddWithValue("@pr_incom", d1);