<%@ Page Language="C#" EnableViewState="false" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.SqlClient" %> <%@ Import Namespace="System.Net" %> <%@ Import Namespace="System.IO" %> <%@ Import Namespace="System.Web.Mail" %> Enquiry form


   Request a quote and get free information from <% DataTable dt = new DataTable(); string[] str; using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["AsappDatabaseConnectionString"].ConnectionString)) { SqlCommand cmd = new SqlCommand("select amc.companyid,ami.url from advtmailercompanies amc join advtmailerissue ami on ami.id=amc.issueid where ami.id= " + Request.QueryString["IssueId"].ToString() + "", connection); SqlDataAdapter adt = new SqlDataAdapter(cmd); adt.Fill(dt); } string CompanyName = String.Empty; foreach (DataRow row in dt.Rows) if (Request.QueryString[row["companyid"].ToString()] != null) { using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["AsappDatabaseConnectionString"].ConnectionString)) { if (CompanyName.Trim().Length > 0) { CompanyName = ""; break; } SqlCommand cmd = new SqlCommand("SELECT CompanyName FROM advtmailercompanies where companyid = " + row["companyid"].ToString() + "", connection); connection.Open(); CompanyName = cmd.ExecuteScalar().ToString(); connection.Close(); } } if (CompanyName.Trim().Length == 0) CompanyName = "this Company"; %> <%=CompanyName.Trim() %>
 Name  *
 Designation  *
 Company  *
 Location  *
 Contact No.  *
 Email Id  *
 Comments  *
Verification Code   
  Change Image
 
   
y>