I have a DropDownList which binds its SelectedValue to a field from an SqlDataSource. However, I need it to ignore the case when data binding, as if it's not in the correct case I recieve a lot of errors. Is this easily achievable?
View 1 RepliesIf a browser requests http://site.com/?q=abc
and gets a 301 redirect response to location http://site.com/?q=ABC (note case of querystring)
Is it possible for the browser to ignore the difference in case and re-request http://site.com/?q=abc, thus causing an infinite redirect loop?That's the scenario that appears to be happening according to the IIS logs. It seems to be isolated to Internet Explorer with some variation of the Ask toolbar installed (based on user-agent values). I even installed the Ask toolbar, but have not been able to recreate this scenario in any way.
I can't post the source code, but for those that want something, here's the general logic:
Page_Load(object sender, EventArgs e)
{
var q = Request.QueryString["q"];[code]...
As you can see, if this page is requested with ?q=abc it will be redirected once, but then it'll render as usual because the redirect goes to ?q=ABC.Is there any scenario where the browser (specifically IE with the Ask toolbar) could ignore the case of the redirect location, causing an endless loop?
how to Convert Uppercase to Lower case during Binding in datalist in Asp.Net.
we have data in uppercase in sql server database . Now we want to display data in datalist at aspx pages in lowercase.
we are using datalist where control is as
<asp:Label ID="lblAdd" runat="server"
Text='<%# Eval("c_Address", "{0:ToLower}") %>' ></asp:Label>
how to convert data into lower case while dispalying in datalist .
how can i access the my sqldatasource selected datasource for modification and adding for example new datacolumns before binding??where is the best place to perform these modifications ?i guess SqlDataSource1_Selected is the right place, but i don't know how ?
View 1 RepliesI'm still trying to understand and use Use Cases and Test Driven Development, but having a hard time crossing the line. I'm hoping someone can provide a good example of how setting a datasource and/or databinding a gridview could be accomplished using Test Driven Development.reate an aspx page and add the gridview control to it.create a method in the code behind called BindGrid(datacollection,gridview) that passes the collection and gridview to a method in a class outside my website so I can actually write the Unit test for the method, and returns a databound gridview.On the BindGrid method, I right click and select "Create Unit Test" which creates a new test project for me with an outline test for my BindGrid() method.Now I guess there are a number of test I could write, for example:testTrueDataCollectionBindstoGridView() to see if the collection datatype actually binds? I'm not sure the other test to write?This is how I currently understand I would go about TDD and Unit testing my example. It feels very clumsy and I'm hoping for some feedback as to what I'm doing wrong, and ideas for improvement.How would you go about writing a test for a collection binding to a control? For example say I wanted to bind a dictionary to a drop down list. What test should I be writing, and how would I go about writing them?
View 3 RepliesTwo ddl inside gridview. on selecting first ddl1 fill next ddl2 by passing selected value as parameter by executing the sqldatasource select command in codebehind.code:
GridViewRow gr = (GridViewRow)((DataControlFieldCell)((DropDownList)sender).Parent).Parent; //find the control in that DropDownList d1 = (DropDownList)gr.FindControl(ddl1); DropDownList d2 = (DropDownList)gr.FindControl(ddl2); SqliaDataSource.SelectParameters.Add("@name", d1.SelectedItem.Text.ToString()); dataView dv=(dataview) SqliaDataSource.select(DataSourceSelectArguments .Empty);
Error: There is no source code available for the current location. and Returns null value
I have a datasource that is connected to a stored procedure and I need to do a postback on the web page but do not want the sqldatasource to do a databind. What I am doing is when I change a dropdown box to fill in some textboxes with specific dates, I do this on a postback so the textboxes are filled in with the dates. But the SQLDatasource control data binds again and shows new results in my gridview.
Is there any way to prevent this so I can just postback to fill in the textboxes?
If I have two listboxes, with a button between them, how do I update the Items of ListBox2 if ListBox2's items are databound?
<asp:ListBox runat="server" ID="ListBox1" DataSourceID="DataSource1"
DataTextField="Name" DataValueField="ID" SelectionMode="Multiple" />
<asp:Button runat="server" ID="addButton" onClick="addButton_Click" />
[code]...
I want to create a generic page which contains a gridview and sqldatasource. I want to put these two controls on .aspx (C#) page but bind them at runtime. It should have selectcommand, updatecommand, deletecommand and insertcommand. Stored procedures are created for that. Help is needed to make it. .
View 1 RepliesI have my project set up with the virtual path "/MyVirtualPath", create the virtual directory in IIS 6 (W2003) and everything works fine. Then to work better with Google Analytics I change the virtual path "/myvirtualpath" and change all redicecciones and links to lowercase. also applies the class "lowercase route urls in aspnet mvc" and works perfectly.
The problem I had to modify the virtual directory in IIS, delete virtual path "/MyVirtualPath" and I created the new "/myvirtualpath", but in all cases I use tilde "~" or where I make a "RedirecToAction" (which should take "LowercaseRoute"), continues to maintain the virtual path "/MyVirtualPath". For example, if I see the HTML source code in the browser, see "/MyVirtualPath/Content/Site.css" instead of "/myvirtualpath/Content/Site.css. "
after I pass querystring parameter to page,page works as expected,but after that when I change my control parameter(dropdownlist selected value how can I set querystring to null or empty...
View 1 RepliesOnce sqldatasource has been setup, how does one bind web controls to the sqldatasource?
simple example binding 2-3 controls to a sqldatasource.
Is there a way I ignore all gridviews events (sorting, paginating) when using the back command (history.back)?
For example:
The user is sorting my grid and when he presses the back button or a link with history.back he goes to the previous page, not the previous grid state.
Im not using ajax or update panel, Im not allowed to. It's a regular grid in an aspx.
What's the difference between binding for example a column called ("Name") in both cases ? and is there's any performance difference ?1- Assigning the data in the mark-up
<asp:Label ID="Name_Lbl" runat="server" Text='<%# Eval("Name") %>' ></asp:Label>
2- defining a control object for every control inside the repeater ItemTemplate and find it and then assign the data in the column "Name" to ite.Item.FindControl("Name_Lbl")
I am making a website. It searches some data from database. When It fetch 1000 records, it runs very softly but when it fetches more then 10000 records then it doesn't display data for second page and I get a error that "Internet Explorer cannot display the webpage".
I also want to share the functionality of the site. It display only 10 records in the page and rest of data will be kept on the object. When user click on next page then it fetches data from that object only. It doesn't go back to database.
It workds nicely when it fetches 1000 records but it gives error when it fetches more then 10000 records.
I try to bind a detailsview to my SQL Server data base, but I dont know how to get specific field like this case. this is my C# code
[Code]....
this is my HTML code, in line 10 in wizard I can get "title" by using "<%# Eval("Title") %>" ,is that right? I want to get the same title but not in wizard
[Code]....
I am making a website. It searches some data from database. When It fetch 1000 records, it runs very softly but when it fetches more then 10000 records then it doesn't display data for second page and I get a error that "Internet Explorer cannot display the webpage".
I also want to share the functionality of the site. It display only 10 records in the page and rest of data will be kept on the object. When user click on next page then it fetches data from that object only. It doesn't go back to database.
It workds nicely when it fetches 1000 records but it gives error when it fetches more then 10000 records.
I am trying to tie a sqlDatasource to a Stored Procedure. The stored procedure looks like...
[Code]........
I have a textbox and a search button and I have a company name "aaa" in grid view
If I typed in textbox "aaa" and click on search button it works
but:
If I typed in textbox "Aaa" and click on search button it doesn't work
I want if i typed "aaa" or "Aaa" in both cases works as it is same word
I have a custom object that I'm throwing into the viewstate on an async postback. If I step through the code, I can put the object into the viewstate, then call the object from the viewstate and cast it with no problems. The code, when stepped through, has no issues whatsoever. However, when I go to FF and run it, I get "60|error|500|Error serializing value 'Case' of type 'Case.'" First thing that hits me as weird is that the value is being named as the type. It's not like value oCase (an instance of Case) of type Case. I've checked that all containing objects are set for serialization, compiled and rerun the web app.
View 4 RepliesWith reference to the following link: [URL] .....
I want to save data to a different table. My save is working fine but the challenge is that it saves empty cells as well.I will like to save only QTyDelivered cell with value. Any empty QTyDelivered cell should be ignored (which means the row of QTyDelivered cell that is empty will not be saved) .How can i achieve this?
I have a Formview where students put their information in such as name, address, etc. The text boxes are bound to my database, so once they are done, they choose to update, and my database is updated with their information. My problem is that the students often use All Caps to enter in their information.
I think I need the StrConv somehow, but I just can't seem to get this done. I've seen where it could be done with text boxes, but not when they were in a Formview using parameters.
My problem i am facing is that i do not know if it's possible to access a single field in my case sold from the following code.
[Code]....
What i want to do is have the checkbox true if the value of sold = yes and false if the value = no I have the checkbox ready on the asp.net side but just need for the checkbox to recognise the datafield, sold, and do and if check statement, is this possible if not i will work around it.
how we find the listview index of row in case of item databind
View 4 Repliesif we enter text without space in text box and then display it in gridview then it doesn't break in multiline and disturb all GUI. i try to set column width but it doesn't working.
View 6 Replies