|
Hello Friends,
I have a problem in redirect a page.i m using C#.net 2005 .i hv a dropdown list which is bind data from database Like State when i m selecting an item in dropdownlist then the corrospondin District should be come in the second dropdownlist. butit never comes.. there is a problem comes"The specified URL can not be found" I m writing the code below for beter understand.
I m also set the Autopostback property =true in dropdownlist.
protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
{
con.Open();
SqlCommand com = new SqlCommand("select State from StateInfo order by StateName asc", con);
dr = com.ExecuteReader();
while (dr.Read() == true)
{
drp_regionname.Items.Add(dr[0].ToString());
}
dr.Close();
}
}
protected void drp_regionname_SelectedIndexChanged(object sender, EventArgs e)
{
string RegionName = drp_regionname.SelectedValue.ToString();
SqlCommand com1 = new SqlCommand("select district from DistrictInfo where StateName ='" + RegionName + "'", con);
con.Open();
dr = com1.ExecuteReader();
while (dr.Read())
{
drp_unitname.Items.Add(dr[0].ToString());
}
dr.Close();
con.Close();
}
This code is running fine in local server but not running in Remote server..
Plz help me.......
Thanks ...
|
|
|
|
|
Could explain where is the problem ?
Where are you redirecting to another page ?
drp_unitname drop down list is not getting populated with items ?
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
from ur code it seems u r not redirecting ur page anywhere. the same page is posted back.
As far as the URL not found error , check the "REDIRECT" code u have written and see whether the target page u r specifying exists in ur website. could u post the conn string info as well as the redirect section of ur code.
Regards,
Rajeesh
Did u know-Maths Illiteracy affects 9 out of 7 people
|
|
|
|
|
Your code is filling drop down from database on PageLoad, if region name selection changes, it inserts additional data from the db (not clearing previous data from the drop down!, is it what you want?)
I don't see any redirection at all!
However, few tips:
1. in sqlcommand, always use Parameters instead of concatenated strings as a query, to prevent sql injection (security flaw):
SqlCommand com1 = new SqlCommand("select district from DistrictInfo where StateName = @RegionName", con);
com1.Parameters.Add(new SqlParameter("@RegionName", RegionName));
2. be sure you are closing connection to database when you don't need it anymore
3. use 'using' clause when possible, to ensure your IDisposible objects are going to be disposed in all cases (no need to call dr.Close(), as it is going to be called in Dispose() method:
using (dr = com1.ExecuteReader())
{
while (dr.Read())
{
drp_unitname.Items.Add(dr[0].ToString());
}
}
4. use exception handling, try {...} catch {...} blocks, at least in event handlers
|
|
|
|
|
Hi masters!
I've a table in Access that has 4 columns.
How can I add records to it without having to bind any control(s) (Text Box, Dropdown List, ...).
|
|
|
|
|
|
I am using a gridview where I have a lable bound column to keep unique ids. During DataRowBound event i hide the label column.
int labelColumn = 0;
e.Row.Cells[labelColumn].Visible = false;
I keep the above code snippet in DataRowBound of GridView1.
When try to use the label column value at client side, I am Unable to access the value. If i don't hide the column I am able to access label value.
Now i want to hide the label Column. How could i do?
I even tried by making the lable column width as 0px.
Thanks in advance. 
Muthu.G
|
|
|
|
|
pretty simple solution dear
use direct <%# Eval("columnname") % > as argument in javascript function or wherever you need to call the value of that label..... do not use any label or column in specific
cheers !
Ashish Sehajpal
|
|
|
|
|
Thanks for the reply dear.
i thing u mean to say, in DataBinding of label (that's in design mode),
for label just use Eval("columnname").
But will that solve the problem of hiding the label field at run time?
Plz be brief in ur ans.
Also how to use it as an arg of js function?
Muthu.G
|
|
|
|
|
using an HTML control is not the solution as per architecture...if there are 1000 records, there will be 1000 html control and every time you will be finding that control via javascript....
passing argument to javascript is very easy
onclick='functionname(<%# Eval("arg1")%>,<%# Eval("arg2")%> ) ;'
you can use any event i.e. onchange , onblur , ondoubleclick etc.....
it will outperform in terms of performance
Ashish Sehajpal
|
|
|
|
|
Thanks Ashish. got it...
Muthu.G
|
|
|
|
|
You can use hidden field html server control instead of label.
puranonnet@hotmail.com
www.ibrinte.com
|
|
|
|
|
Thanks a lot, that works fine. 
Muthu.G
|
|
|
|
|
Hi All,
I have a page that calls another with parameters (Eg: page2.aspx?show=pdf&w=100&h=200). My page2 contains textboxes and the drop downlist(with default value set to something else), when I enter the page2 I want to set the parameters to my textboxes and dropdown list. I used ddlEmbedDisplay.SelectedValue = show; but its showing the old default value after this statement, Could any one please tell me, my statement is right or wrong.
Any Ideas please!!!
Thanks,
Aruna.G
|
|
|
|
|
wrong...
mention the querystring collection instead
use
ddlEmbedDisplay.SelectedValue = request.queryString("show")
cheers !
Ashish Sehajpal
|
|
|
|
|
hi Aruna,
From ur query it seems u want to pass a value from one page to another and set that value as the selected Text of a dropdownlist on page 2 when page 2 loads. right?
heres how you can do it.its crude but still.
//Code on page 1
param1 = "Good Morning";
param2 = 300;
Response.Redirect("default2.aspx?param1=" + param1 + "¶m2=" + param2.ToString());
//code on page 2
String param1="";
String param2;
param1=request.querystring("param1");
param2=request.querystring("param2").tostring();
DropDownList1.Items.Add(param1);
DropDownList1.Items.Add(param2);
DropDownList1.SelectedIndex = DropDownList1.Items.Count - 1(when new items are added to a dropdownlist they get appended to the end of the list of items.1 denotes the last item,2 would be the second last item etc.)
Hope this helps
|
|
|
|
|
Hi all...
I have a login form (username and password), and I want to add a checkbox (remember me), how can I perform this cookie using ASP.NET (VB) ?
Thanks alot
Nour Abdel-Salam...
A Trainer and a Web Developer in Jedda Int'l Computer Center(JICC)
|
|
|
|
|
check this, might help
http://www.startvbdotnet.com/aspsite/forms/cookies.aspx
|
|
|
|
|
Thank you very much,
Luv you >>>
![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
Nour Abdel-Salam...
A Trainer and a Web Developer in Jedda Int'l Computer Center(JICC)
|
|
|
|
|
bit simple dear.
create a cookie (httpcookie)
name it
add key/value paris of inofrmation to it....
i.e. uid,"myuserid"
pwd,"mypwd"
add the cookie to response object....simple..
(u can also mention the time when the is gonna be expired)
Ashish Sehajpal
|
|
|
|
|
Simple, Simple, Simple
Another time, when you reply, give an example, and do not use i.e. or Simple
Nour Abdel-Salam...
A Trainer and a Web Developer in Jedda Int'l Computer Center(JICC)
|
|
|
|
|
hellllllll
u voted my message 1 and still ask help from me......
Ashish Sehajpal
|
|
|
|
|
Oh Baby...
I did, voted 1 (very bad)
Bye bye
Nour Abdel-Salam...
A Trainer and a Web Developer in Jedda Int'l Computer Center(JICC)
|
|
|
|
|
Hi, I would like to find out how I can send an email from an asp.net page. I would like the email to contain a message and a linkbutton which when clicked should redirect the user to another page in the website. The webpages will be loaded using FTP.
Please help?
Thank u in advance.
|
|
|
|
|
check this then work from here:
http://www.aspheute.com/english/20000918.asp
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
