I have the following class code to add support ticket:
MySqlConnection support_sql_connection = null;
MySqlCommand support_sql_command = null;
// MySqlDataAdapter event_log_sql_adapter;// DataTable data_table = null;// MySqlDataReader event_log_sql_reader = null;// MySqlDataReader sql_block_reader = null;// DataSet event_log_data_set = null;publicvoid add_support_ticket(string support_incident_title, string email_address, string support_ticket_description)
support_sql_connection = new MySqlConnection(ConfigurationManager.ConnectionStrings["SQLdb"].ConnectionString);
support_sql_command = new MySqlCommand("sp_add_support_ticket", support_sql_connection);
support_sql_command.CommandType = CommandType.StoredProcedure;
support_sql_command.Parameters.Add("param_support_incident_title", MySqlDbType.VarChar).Value = support_incident_title;
support_sql_command.Parameters.Add("param_email_address", MySqlDbType.VarChar).Value = email_address;
support_sql_command.Parameters.Add("param_support_ticket_description", MySqlDbType.Text).Value = support_ticket_description;
int result_rows = support_sql_command.ExecuteNonQuery();
HttpContext.Current.Session["message_title"] = "Thank you";
HttpContext.Current.Session["message_title_Color"] = Color.Blue.ToArgb();
HttpContext.Current.Session["message_text"] = "We have recieved your feedback and we will get back to you as soon as possible.";
HttpContext.Current.Session["message_button_title"] = "Back";
HttpContext.Current.Session["message_button_url"] = "Home.aspx";
if (!HttpContext.Current.Request.Path.EndsWith("Message.aspx", StringComparison.InvariantCultureIgnoreCase))
and I am calling it from the webform like this:
protectedvoid btnSend_Click(object sender, EventArgs e)
if (txtMessage.Text == "")
Session["message_title"] = "Error";
Session["message_title_Color"] = Color.Red.ToArgb();
Session["message_text"] = "Please enter your message.";
Session["message_button_title"] = "Back";
Session["message_button_url"] = Request.UrlReferrer.ToString();
create_support_ticket create_support_ticket = new create_support_ticket();
create_support_ticket.add_support_ticket(txtSubject.Text, txtEmailAddress.Text, txtMessage.XHTML);
but I am getting two rows added for every insert! Thsi first row is correct as per the passed information but the second row adding the Session["message_title"] as support_incdent_title and the Session["message_text"] as support_ticket_description and I really don't know how??
few days ago i asked a question How to pass dataset to google map api
i dont think that i should have chosen other question rather then this question to be asked but what you suggest which question should i asked?
In totl i got total price but i am not able to display it... Loop is not go in Else Loop.............
</td></tr><tr><td><%# Eval("cartdetail_pname")%></td><td><%# Eval("cartdetail_author")%></td><td><%# Eval("cartdetail_isbn")%></td><td><%# Eval("order_pid")%></td><td><%# Eval("order_date")%></td><td><%# Eval("cartdetail_qty")%></td><td>
protected void lstViewCart_PreRender(object sender, EventArgs e)
Label lblTot = this.ListView1.FindControl("lblGrandTotal") as Label;
if (lblTot == null)
lblTot.Text = totl.ToString();
Thanks for giving time to read my problem and also for your valuable suggestions.
Given that you know already the NAME and VALUE of the data to be written to the cookie,
Its not so difficult to check the length of the data (to be written) including the name and then subtract that from the maximum size allowable for the cookie and then you will know EXACTLY how space you have remaining (in the cookie) to work with.
We are in the process of developing an inventory tracking system and one part of this system is the automation of the Change of Location (COL) form. We have the database developed; we have the electronic form developed; we are now at a halt because we need this web service inorderto move forward.
1We are in need of a web service to transmit information between Sharepoint and an Infopath form.
2.We will set up your web service as a data connection and work with the form through this connection
My procedure return multiple result set. I need to assign it to generic list.
How can i work a generic list like dataset do?
I am using it in web service, so i avoid using dataset. I want the result in List<>
on Page2 load event through querystring i get the Document ID and Open the Document (PDF/IMAGE etc), My Problem is on this Page2, I want to have a button with back page link but the button does not show as the page is loaded, So is there any way to show back link along with the document.
To kill a DEER, You need Guns, knives, Ropes and many people to help But To kill
You need just ignorance and silence
I have a WCF serivce which is hosted in IIS. I want to have child config files for the wcf service so that I dont have to build different times to host in different environments like dev, staging and production.
I am not familiar with how to maintain child configuration files and access them in the web config file. If anybody can give me any idea or link with example, it would be helpfull for me.
I am also googling but anyone can give me any help its really thankful.
I am using this code to bind news to the repeater using XMLDataSource. I want to ask, is it possible to have multiple XMLDataSources bineded to the same repeater so it will have xmlNews1, xmlNews2, xmlNews3, etc?
hi,my webapplication has ben changed outputpath,but show error msg:"Could not load file or assembly" in runtime,why?
<addname="DirectRequestModule"type="Ext.Net.DirectRequestModule, Ext.Net"/> //Could not load file or assembly
<addname="WebSite.HttpModule"type="Framework.Common.HttpModule, Framework.Common"/> //Could not load file or assembly
This was working fine in windows 2000 server.
Now we are upgrading to windows 2003 server. In this it is not giving print.
Also I'm not getting any exception or any logs. Logs were created as everything working fine.
Also in 2003 server this is working from command prompt and
from console application also it is working, but when user logged in.
If no one is logged in again the print is not working.