|
How can I put it into the button click code?
buttonClick()
{
} ;
Чесноков
|
|
|
|
|
Try this :
btn.Attributes.Add("onclick", "javascript:window.opener.location.href='page1.aspx'; return false;");
write this in page_load of Page2.aspx .
So that when btn is clicked it will refresh the page1.aspx
Hope it works now.
|
|
|
|
|
hi all,
I want to download the file from db which has been save in my application.I downloaded the file . but i want to open it as a pdf file.How to do that..
Here is the code i used to download.
if (e.CommandName == "ResumeDownload")
{
Cache["filename"] = e.CommandArgument.ToString();
String strRequest = Cache["filename"].ToString();
if (strRequest != "")
{
String path = Server.MapPath("Attachments\\" + strRequest);
FileInfo file = new FileInfo(path);
if (file.Exists)
{
Response.Clear();
Response.AddHeader("Content-Disposition", "attachment; filename=\"" + file.Name.ToString()+ "\"");
Response.AddHeader("Content-Length", file.Length.ToString());
Response.ContentType = "application/octet-stream";
Response.WriteFile(file.FullName);
Response.End();
}
else
ClientScript.RegisterStartupScript(typeof(Page), "alert", "<script>alert('File Not Found')</script>");
}
else
Response.Write("Please provide a file to download.");
}
|
|
|
|
|
Try changing the ContentType to application/pdf. I haven't tried this so there is every chance it won't work but you never know.
|
|
|
|
|
|
DoctorMick wrote: application/pdf
this wont work.. This will open a pdf but without any content.....
|
|
|
|
|
Hi everyone, I am trying to write a web method in my web service which will accept information in a hashtable and process it and again will return hashtable. I am trying to do this in C#. But it is throwing an exception that hashtable can't be serialized b'coz it implements IDictionary. Is there any solution.....
|
|
|
|
|
Yes it's write, Only serializable object can return the web method. So Implement this information in dataset and the finally return Dataset.
OR look into this Article
Hashtable becomes serialized[^]
|
|
|
|
|
Hello every one,
I want to create a stored procedure,which takes different parameters and insert the value in same table.
What should i do,how can i write this.
|
|
|
|
|
rinku soni 23 wrote: I want to create a stored procedure
wrong post...
rinku soni 23 wrote: What should i do,how can i write this
public static void insert(paramater1,paramater2,......,SqlConnection con )
{
try
{
SqlParameter[] param = new SqlParameter[6];
param[0] = new SqlParameter("@...", SqlDbType.VarChar);
param[0].Value = paramater1;
param[1] = new SqlParameter("@...", SqlDbType.Int);
param[1].Value = paramater2;
Sql.ExecuteNonQuery(con, CommandType.StoredProcedure, "Store procedure name", param);
}
}
catch (Exception ex)
{
throw ex;
}
}
|
|
|
|
|
Post this question in Database section.
|
|
|
|
|
|
First of all this is the Wrong Section to post this.
Are you talking about different types. If so use NVARCHAR as it takes most of the primitive data types like DateTime, Bit, Int, Float etc.
|
|
|
|
|
hii all...
i hav populated the two dropdown lists from database.
according to the item selected in the dropdown i want to change
the respective textbox value.I hav written code it works for first dropdown but not for second.whenever i change the item in dropdownlist2 it does not show any value in its respective textbox.
plz reply..
the code is:
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
PopulateDDL1();
PopulateDDL2();
}
}
public void PopulateDDL1()
{
SqlCommand cmd = new SqlCommand("Select * From [Vendor]", new SqlConnection(ConfigurationManager.ConnectionStrings["BillingSystem"].ConnectionString));
cmd.Connection.Open();
SqlDataReader dr;
dr = cmd.ExecuteReader();
DropDownList1.DataSource = dr;
DropDownList1.DataValueField = "VendorID";
DropDownList1.DataTextField = "VendorID";
DropDownList1.DataBind();
cmd.Connection.Close();
}
public void PopulateDDL2()
{
SqlCommand cmd = new SqlCommand("Select * From [Product]", new SqlConnection(ConfigurationManager.ConnectionStrings["BillingSystem"].ConnectionString));
cmd.Connection.Open();
SqlDataReader dr;
dr = cmd.ExecuteReader();
DropDownList2.DataSource = dr;
DropDownList2.DataValueField = "ProductID";
DropDownList2.DataTextField = "ProductID";
DropDownList2.DataBind();
cmd.Connection.Close();
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
string str = "Select * From Vendor Where(VendorID='" + DropDownList1.SelectedValue + "')";
SqlCommand cmd = new SqlCommand(str, conn);
SqlDataReader dr = null;
conn.Open();
dr = cmd.ExecuteReader();
while (dr.Read())
{
TextBox1.Text = dr["VendorName"].ToString();
}
conn.Close();
}
protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e)
{
string str = "Select * From Product Where(ProductID='" + DropDownList2.SelectedValue + "')";
SqlCommand cmd = new SqlCommand(str, conn);
SqlDataReader dr = null;
conn.Open();
dr = cmd.ExecuteReader();
while (dr.Read())
{
TextBox3.Text = dr["ProductName"].ToString();
}
conn.Close();
}
|
|
|
|
|
check whether you have given autopostback property to both the dropdown
|
|
|
|
|
yaa i hav made both dropdown autopostback property to true....
|
|
|
|
|
|
your code seems to be fine.... jus check whether u have values in the database......
|
|
|
|
|
Make sure you have wired the event up properly in your aspx page, i.e.
<asp:dropdownlist id="DropDownList2" runat="server" autopostback="true" onselectedindexchanged="DropDownList2_SelectedIndexChanged">
Also, put a breakpoint at the start of your DropDownList2_SelectedIndexChanged method to see if it is being called at all.
|
|
|
|
|
Is the AutoPostBack property of that dropdown set to True?
MP
|
|
|
|
|
|
i have done the same thing which u want i just use daset instead of datareader try it
protected void Page_Load(object sender, EventArgs e)
{
DAL Helper = new DAL();
Helper.ConnectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|Coupon Management.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
string query = "select CouponName from CouponType";
ds = Helper.ExecuteDataSet(CommandType.Text, query, null);
if (!IsPostBack)
{
ddlCType.DataSource = ds;
ddlCType.DataValueField = "CouponName";
ddlCType.DataTextField = "CouponName";
ddlCType.DataSourceID = String.Empty;
}
}
protected DataSet GetData(string sqlCommand)
{
da1 = new SqlDataAdapter(sqlCommand, cnx );
ds = new DataSet();
da1.Fill(ds );
return ds ;
}
protected void DropDownList1_TextChanged(object sender, EventArgs e)
{
cnx.Open();
SqlCommand ddlcmd = new SqlCommand();
commandText = "SELECT MAX(CouponTransaction.SerialEnd),CouponType.Price FROM CouponType INNER JOIN CouponTransaction ON CouponType.CouponTypeID = CouponTransaction.CouponTypeID WHERE CouponType.CouponName= '" + ddlCType.SelectedValue + "'GROUP BY CouponType.Price";
ds = new DataSet();
ds = GetData(commandText);
if (ds.Tables[0].Rows.Count!=0 )
{
txtSFrom.Text = ds.Tables[0].Rows[0][0].ToString();
Txtprice.Text = ds.Tables[0].Rows[0][1].ToString();
cnx.Close();
}
}
|
|
|
|
|
thanks ....
|
|
|
|
|
|
hi
I have windows vista and
when I debug my website project in visual studio,
my browser doesn't run.
after that i checked my IIS in control panel but again browser doesn't work.
THX.
|
|
|
|