Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / santro
/*DrugNames DalCls.cs*/
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using MySql.Data.MySqlClient;
using System.Windows.Forms;
using System.IO;
using MedWare;
/// <summary>
/// Summary description for DrugNamesDalCls
/// </summary>
public class DrugNamesDalCls
{
MySqlConnection mysqlcon = new MySqlConnection
(System.Configuration.ConfigurationManager.AppSettings
["strDrugs"].ToString());
public DrugNamesDalCls()
{
//
// TODO: Add constructor logic here
//
}
public void ErrorMsg(string strError)
{
string strErrorPath =
HttpContext.Current.Server.MapPath("Errordetails.txt");
using (FileStream fs = File.Open(strErrorPath,
FileMode.Append, FileAccess.Write))
{
using (StreamWriter sw = new StreamWriter(fs))
{
sw.WriteLine
("..........................................................
............................");
//sw.WriteLine("ApplicationName:" +
strAppUrl);
sw.WriteLine("Error:" + strError);
sw.WriteLine("Creation Date:" +
DateTime.Now);
sw.WriteLine
("..........................................................
............................");
}
}
}
//FUNCTION FOR INSERT TRANSACTION.
public int InsertDrugName(string pstrDrugName)
{
int irec = 0;
string strDate=DateTime.Now.ToString();
//string strIns = "INSERT INTO DRUGNAME VALUES('" +
pstrDrugName + "')";
string strIns = "INSERT INTO DRUGNAME (DrugName)
values('" + pstrDrugName + "')";
try
{
irec = new DrugNamesDblCls().InsDelUpdate
(strIns);
}
catch (Exception ex)
{
ErrorMsg(ex.Message);
}
return irec;
}
//FUNCTION FOR UPDATE TRANSACTION.
public int UpdateDrugName(string strDrugName, string
DrugNameID)
{
int irec = 0;
string strUpdate = "UPDATE drugname SET DRUGNAME='"
+ strDrugName + "' WHERE DRUGNAMEID=" + DrugNameID;
try
{
irec = new DrugNamesDblCls().InsDelUpdate
(strUpdate);
}
catch (Exception ex)
{
ErrorMsg(ex.Message);
}
return irec;
}
// FUNCTION FOR DELETE TRANSACTION.
public int DeleteDrugName(string strDrugNameID)
{
int irec = 0;
string strDel = "DELETE FROM drugname WHERE
drugname='" + strDrugNameID + "'";
try
{
irec = new DrugNamesDblCls().InsDelUpdate
(strDel);
}
catch (Exception ex)
{
ErrorMsg(ex.Message);
}
return irec;
}
}
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
IF WE PURCHASE FLEX AND SUPPLIERS PRODUCE BILL & CHARGED 4% VAT THEN WHAT WILL BE TDS STATUS.
You are request to reply these quieries, are below mentioned statement are true? (1) Deduction in respect of maintenance including medical treatment of a dependent who is person of disability shall be allowed to a non resident in India. (2) Only 35% of income from growing and manufacturing of rubber is liable to tax. (3) A business loss can be setoff against income from speculation business but loss in respect of speculation business can only be set-off against income of another speculation business. (4) Remuneration received by Member of Parliament are taxable under the head “profit and gains from business or profession. (5) Zero coupon bond shall be treated as “short term capital asset” if held for more than 12 months but not more than 36 months.
Hi, I am a trader/distributor by name M/S.ABC reg.under Kerala vat and dealing in trading/stockist of computer goods. One of our dealer reg under Kerala vat M/S.DEF got an order to supply computer goods to an Kerala state govt dept. M/S DEF places an Order to us and directs us to raise bill as below and deliver the goods at end customer point throughout Kerala USING OUR INVOICE . BILL FROM:M/S/ABC (REG UNDER KERALA VAT) BILL TO M/S.DEF (REG UNDER KERALA VAT) SHIP TO KERALA STATE GOVT DEPT. (M/s.ABC charge full local tax on Inv. and ship the goods as above to end customer Kerala govt dept.) Clarification required as per VAT act of Kerala. 1.)Is it correct to carry out transaction as ABOVE as three parties involved? 2.)During transit will my shipment will be seized by flying squad or enforcement team and raise objection for improper invoice even though charged full local tax rate applicable on goods? 3.)Under Kerala vat act is there any sales tax exemption available to carry out sale of computer goods TO KERALA GOVT DEPT? 4.) What is form 16 will it be useful to carry out ABOVE such billings and shipment to diff part of Kerala govt dept. Friends pls. share your expertise on the above and revert to my e- mail id. Tks and Regards, Angeline
i'm working in a company my consolidated salary is Rs. 15000/- per month. can i Lodge complain in Labour department, and how much the limit of salary
How to break service bond
What are the duties of the position for criminal affairs?
Briefly describe a technical project that you found challenging or rewarding?
explain the NRI Accounts available for non resident indians with relative benefits: which account is most appropriate for the NRI.
can any one tell me how to get usa address using passport number or social security number.Please help me This is urgent
If burcation of material and labour may not be possible to bill on the customer, under which scheme of VAT[WCT] in the State of Gujrat such incidence of WCT is complied with?
Sir my question is on service Tax. We have deposited the amount under wrong code. The basic amount of service tax Rs.7500/- on Clearing & forwarding Agency (code 00440045) was wrongly deposited in the interest code (00440046). Do we have to deposit service tax again or this amount can be transfered to service tax account.
where can i find indian patnership act on the net?
A doctor is asked by a patient's family member to kill the patient as they are in a lot of pain. Would this be murder?
if accendent happaned of car & container. the containar escape after heatting to car but car driver dont have driving licence so it will clame for insurance or not & is required FIR for insurance claim????????????????
Why do ask we about child labour? why sould not we ask about child basic development? when we have education cess, why the amount not been ment for the development of child labour? when we have a system to eradicate child labour? Why that force is not child thier to put them in kind of bostal school? why the parent should not be punished for the child labour
