Thank you so much for all your help.
Yes, after changing Add to Insert, I had my expected result.
Thank you again.
ellen89
ellen89
Last Activity: Mar 27 '08, 05:11 PM
Joined: Nov 22 '07
Location:
-
Thank you for your reply.
I did following:
DropDownList1.D ataBind();
DropDownList1.I tems.Add(new ListItem("", ""));
it inserted the Blank Line at the Bottom of my list. Then I tried
DropDownList1.I tems.Add(new ListItem("", ""));
DropDownList1.D ataBind();
Now this time nothing happend.
Wondering to where...Leave a comment:
-
How to let the first Row in DropDown list being blank?(using sproc)
Hi All,
I have a dropdown list control, and its items are loaded from database during the page_load.
say, the values in the db table are not allowed to be NULL.
I want to have the first row in dropdown list being blank. It means the user has to click the dropdown arrow to see the items.
Thank you for your help in advance.
ellen89 -
I had solved this problem by using a VIEW table at SQL server to have FirstName and LastName at same column.
Thank you for all help.
ellen89Leave a comment:
-
Thank you!
Now the problem is I want to show the full name on the dropdown list, but the Name is stored in databas as FirstName & LastName (2 columns).
What should I put for DropDownList1.D ataTextField ?
I had tried DropDownList1.D ataTextField = "FirstName+ ' '+LastName", it gave run time error.
ellen89Leave a comment:
-
Sarah,
Thank you very much. I had tried, unfortunately, I have no lucky.
I am not sure the .DataMember property, NameList is my table name, with 2 columns (firstName, lastName).
Gusee I should not have the column name in my code because I am using stored procedure to get the result. This stored procedure is very simple and tested in sql server 2005.
Thanks again,
ellen89Leave a comment:
-
nateraaaa,
Thank you very much for your time.
Now I had another problem, my code is:
protected void Page_Load(objec t sender, EventArgs e)
{
if (!IsPostBack)
{
string cnString = ConfigurationMa nager.Connectio nStrings["TestConnection String"].ConnectionStri ng;
SqlConnection cnn = new SqlConnection(c nString);
...Leave a comment:
-
populate dropdown items via stored procedure
Hi All,
I am new to this field, and is using VS.2005, language is C#.
1) created a database "Test" in sql 2005, had a table "NameList", a stored proc "GetAllName "
2) created a new website, on .aspx page has a dropdown control "ddlName"
Wish could have help at following:
Now I want to all the names from NameList will be populated at 'ddlName"... -
populate dropdown items via stored procedure
Hi All,
I am new to this field, and is using VS.2005, language is C#.
1) created a database "Test" in sql 2005, had a table "NameList", a stored proc "GetAllName "
2) created a new website, on .aspx page has a dropdown control "ddlName"
Wish could have help at following:
Now I want to all the names from NameList will be populated at 'ddlName"... -
Appreciate your time.
For sure I will, this is a nice place.
ellen89Leave a comment:
-
Now this time it is working, when I tried:
[CODE=javascript]function DisplayAuthoriz edSigner(){
alert(getQueryS tring("AccountN umber"))
var strURL = "/modules/account/authorized_sign ers/content/authorized_sign er.htm"+"?Accou ntNumber=" + getQueryString( "AccountNumber" )
DisplayModalWin dow("", strURL, "408", "700")
}
...Leave a comment:
-
acoder,
Thank you for asking.
After I changed the code, the B.htm could not being displayed.
I had tried couple of different ways as following:
1) [CODE=javascript]function DisplayAuthoriz edSigner(){
var param
param = getQueryString( "AccountNumber" ))
alert(getQueryS tring("AccountN umber"))
var strURL = "/modules/account/authorized_sign ers/content/authorized_sign er.htm?AccountN umber="...Leave a comment:
-
acoder, thank you so much. I will try it next Monday.Leave a comment:
-
how to pass a var to a htm
Hi All,
I have the following situation:
There is a link at A.xsl page, onclick this link, would lead to B.htm; onclick=ViewNex tPage().
Also at A.xsl has a valiable "AccountNum ber" which I want to pass to B.htm.
in my .js file, I have:
[CODE=javascript]function ViewNextPage() {
alert (getquerystring ("AccountNumber "))
strURL="/.../B.htm"...
No activity results to display
Leave a comment: