Comments by faizyab 2009 (Top 61 by date)

private void button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=DCID;Integrated Security=True");
con.Open();
string query = "insert into DSIIDC_Component_List (FARNo,User1,User2,User3,Date,ProductCategory,Model,PurchaseOrderNo,Make,InvoiceNo,SerialNo,BriefDetails,SystemTransferDetails,ProductCost,VendorName,WarrantyUpTO,AMCFrom,AMCTO,AMCWith,IssuedOn,WarrantyOnSite,WarrantyOFFSite,underAMCYES) values(@FARNo,@User1,@User2,@User3,@Date,@ProductCategory,@Model,@PurchaseOrderNo,@Make,@InvoiceNo,@SerialNo,@BriefDetails,@SystemTransferDetails,@ProductCost,@VendorName,@WarrantyUpTO,@AMCFrom,@AMCTO,@AMCWith,@IssuedOn,@WarrantyOnSite,@WarrantyOFFSite,@underAMCYES)";
SqlCommand cmd = new SqlCommand(query, con);

bool flag = Isexsist(txtfrano.Text);
if (flag)
{
MessageBox.Show("ID is already");
}
else
{



string FAR = "";
if (string.IsNullOrEmpty(txtfrano.Text) || txtfrano.Text[0] == ' ')
{
MessageBox.Show("F.A R Number is empty");
return;
}
else
{
FAR = this.txtfrano.Text;
MessageBox.Show("FAR Number" + FAR);
}


string model = "";
if (string.IsNullOrEmpty(txtmodel.Text) || txtmodel.Text[0] == ' ')
{
MessageBox.Show("Model is empty");
return;
}
else
{
model = this.txtmodel.Text;
// MessageBox.Show("model is" + model);
}


string purchaseorderno = "";
if (string.IsNullOrEmpty(txtpurchaseorderno.Text) || txtpurchaseorderno.Text[0] == ' ')
{
MessageBox.Show("purchaseorderno is empty");
return;
}
else
{
purchaseorderno = this.txtpurchaseorderno.Text;
// MessageBox.Show("purchaseorderno is" + purchaseorderno);
}

string invoicno = "";
if (string.IsNullOrEmpty(txtinvoicno.Text) || txtinvoicno.Text[0] == ' ')
{
MessageBox.Show("invoicno is empty");
return;
}
else
{
invoicno = this.txtinvoicno.Text;
//MessageBox.Show("invoicno is" + invoicno);
}








string serialno = "";
if (string.IsNullOrEmpty(txtserialno.Text) || txtserialno.Text[0] == ' ')
{
MessageBox.Show("serialno is empty");
return;
}
else
{
serialno = this.txtserialno.Text;
// MessageBox.Show("serialno is" + serialno);
}


string briefConfiguration = "";

if (string.IsNullOrEmpty(txtbriefConfiguration.Text) || txtbriefConfiguration.Text[0] == ' ')
{
MessageBox.Show("serialno is empty");
return;
}
else
{
briefConfiguration = this.txtbriefConfiguration.Text;
//MessageBox.Show("briefConfiguration is" + briefConfiguration);
}

string systemtransfer = "";

if (string.IsNullOrEmpty(txtsystemtransfer.Text) || txtsystemtransfer.Text[0] == ' ')
{
MessageBox.Show("serialno is empty");
return;
}
else
{
syst

"The parameterized query '(@WarrantyOnSite nvarchar(3),@WarrantyOFFSite nvarchar(4000),@un' expects the parameter '@ProductCategory', which was not supplied."this is error

this is a window form

Sir this is window form in C# . this is not a web page. how can we use jquery in this