Interested to Buy Any Domain ? << Click Here >> for more details...
Drug names
- 1 Answers
- 4528 Views
- I also Faced
- E-Mail Answers
Answer / santro
/*pgDrugnames.aspx.cs*/
using System;
using System.Data;
using System.Configuration;
using System.Collections;
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 System.Data.SqlClient;
public partial class pgDrugnames : System.Web.UI.Page
{
string strConnectionstring;
SqlConnection con;
SqlDataAdapter da;
protected void Page_Load(object sender, EventArgs e)
{
strConnectionstring =
ConfigurationManager.AppSettings["strSample"];
con = new SqlConnection(strConnectionstring);
if (!IsPostBack)
{
BindDrugDetails();
}
Button2.Attributes.Add
("onclick", "javascript:return ConfirmDelete();");
Button5.Attributes.Add("onclick", "window.open
('ReportViewer.aspx','newwindow','width=800,height=600,resiz
able=1,scrollbars=1'); return false");
}
protected void ListBox1_SelectedIndexChanged(object
sender, EventArgs e)
{
TextBox1.Text = ListBox1.SelectedItem.Text.ToString
();
}
protected void Button1_Click(object sender, EventArgs e)
{
ListBox1.Visible = false;
Label1.Text = "Edit Mode";
TextBox1.Text = string.Empty;
TextBox1.Focus();
Button2.Enabled = false;
Button3.Enabled = true;
Button5.Enabled = false;
Button4.Text = "Cancel";
}
protected void Button4_Click(object sender, EventArgs e)
{
if (Button4.Text == "Cancel")
{
ListBox1.Visible = true;
Label1.Text = "view mode";
Button2.Enabled = true;
Button5.Enabled = true;
Button3.Enabled = false;
Button4.Text = "Close";
TextBox1.Text =
ListBox1.SelectedItem.Text.ToString();
}
else if (Button4.Text.ToUpper().ToString()
== "CLOSE")
{
Response.Redirect("Default.aspx");
}
}
protected void Button3_Click(object sender, EventArgs e)
{
con.Open();
string strmax;
int intMaxId;
strmax = "select max(drugid)+1 from drugmaster";
SqlCommand cmdmax = new SqlCommand();
cmdmax.CommandText = strmax;
cmdmax.CommandType = CommandType.Text;
cmdmax.Connection = con;
intMaxId=int.Parse(cmdmax.ExecuteScalar().ToString
());
con.Close();
con.Open();
SqlCommand cmdInsert = new SqlCommand();
cmdInsert.CommandText = "INSERT INTO DRUGMASTER
VALUES("+ intMaxId+",'"+TextBox1.Text.ToString() +"',1)";
cmdInsert.CommandType = CommandType.Text;
cmdInsert.Connection = con;
cmdInsert.ExecuteNonQuery();
BindDrugDetails();
TextBox1.Text = string.Empty;
}
protected void BindDrugDetails()
{
DataSet ds = new DataSet();
da = new SqlDataAdapter("select * from drugmaster
order by drugname", con);
da.Fill(ds, "drugname");
ListBox1.Visible = true;
ListBox1.DataSource = ds;
ListBox1.DataTextField = "drugname";
ListBox1.DataValueField = "drugID";
ListBox1.DataBind();
ListBox1.SelectedIndex = 0;
TextBox1.Text = ListBox1.SelectedItem.Text.ToString
();
}
protected void Button2_Click(object sender, EventArgs e)
{
string strDel;
int intDrugId = int.Parse
(ListBox1.SelectedValue.ToString());
strDel = "delete from drugmaster where drugid=" +
intDrugId + "";
SqlCommand cmdDel = new SqlCommand();
cmdDel.CommandText = strDel;
cmdDel.CommandType = CommandType.Text;
con.Open();
cmdDel.Connection = con;
cmdDel.ExecuteNonQuery();
Page.RegisterStartupScript("OnClick", AlertScript
("Record Deleted Successfully"));
BindDrugDetails();
}
string AlertScript(string message)
{
string strScript = "";
strScript = "<script>";
strScript = strScript + "alert( '" + message
+ "');";
strScript = strScript + "</script>";
return strScript;
}
}
/*pgDrugnames.aspx - source
<head runat="server">
<title>Untitled Page</title>
<script type="text/javascript" language="javascript">
function ConfirmDelete()
{
if(confirm('Are You Sure You Want to Delete?'))
{
return true;
}
return false;
}
</script>
</head>*/
| Is This Answer Correct ? | 0 Yes | 1 No |
What is the difference between Tinanium Debit card and Platinuim Debit card?
whatis type?
is a professor working in government college a gazetted officer?? someone plz rply soon
tell me about urself ? why didnt u join earlier when u came for the interview? where do you work and what is your job profile? you have done mass comm and MA in english, y did u join a call centre? is it serving your purpose? y arnt you trying in media and related fields? how much salary do you expect? what are your expectations from the co? why should we hire u? do you think you will be able to handle this profile? are you comfortable with travelling? If not, will you go in for other profiles that we have? good and bad things about you? how soon can you join? wil you need to give prior notics to your co b4 leaving you will not be on co. pay rols and no leaves. is that ok with you?
What is Micro-kernel? What are the benefits of Micro-kernel?
0 Answers Baidu, Sikkim Manipal University,
How long will it takes for Staff selection commission to declares the results for "Data entry operator 2009" results :-Let me know when SSC will declares this result?
Hi, I am Pragya Diwakar,Wanted to know the possible Interview questions asked during Syndicate bank for PO exam...can anyone forward the questions to me at Diwakar_pragya@yahoo.com.............thnx in advance!!
hi this is raju from hyderabad. i recently completed my mca.am trying for a job in software companies.. but am not getting right job.. my parents are suggested to prepare for group exams.is it right career for my qualification. Give you suggetions please..
Why you want to come in Marketing although you have done your MBA in Finance?
Merchant account holder seeking Call Centers to team up with. Merchant accounts in UK, Canada, and US. Call Centers anywhere welcome. Please contact us if interested.
How do you keep your fitness knowledge up to date?
hi im studing in MCA final yr. Now i need to do project. im more intrested on web... can any one suggest me which will be better 1 n more easy to do. As i dont know wht is the meaning of project atleast... n im very teens... so plz help me out....
Energy Oil Gas 
