I have an SQL table which looks similar to the following:
Title | Author | Tags 'title1' 'author1' 'horror, steven king, clowns' 'title2' 'author2' 'childrens, roald dahl, chocolate'
Let's say I wanted to find the name of a book that has the tag 'clowns' in it...how can I do this? 'clowns' is a substring of the tag for 'title1'...but how do I search for substrings? I have tried to use the "LIKE" keyword but obviously it doesn't work in this situation.
I have a DataGrid that is populated with data from a DataTable.DataView. The data in the DataTable is created on the fly based upon the criteria returned from LINQ to SQL DataClass.When the Datarid is populated with data it shows the correct data, but the columns are too wide and there is no TextWrapping enabled.I do not know before the DataGrid has its ItemSource property bound to the DataTable how many columns of data will be but I need to set the property of any cells carrying text to have the wrap property enabled.
My tab control items contain three different pages.Clicking on tabitem ,they are visible,but when want to perform javascript event on page item then problem arise.javascript well works for only first tab control item,rest of them are not work.Show me the bellow error. Microsoft JScript runtime error: 'this.GetStateInput().value' is null or not an objec
I am using the validation controls, and I would like to display nothing for each individual control, but a message box summary. However, my validators are within a Repeater (see below) and each row can have up to 2 errors, and I want some way to be able to show in my summary whether ANY row has Error 1 or ANY row has Error 2. I.e. I want my summary to say 'The Grid contains Error 1 (new line) The Grid contains Error 2'. At the moment my summary gives me a separate line for each row where there is an error. Here is my code:
[Code]....
<asp:ValidationSummary ID="valSum" runat="server" ShowMessageBox="True" ShowSummary="false" DisplayMode="BulletList" HeaderText="The following errors have been made in the order numbers:" />
I have a single series bar chart created programmatically in codebehind which I would like to display the Y point value (somewhere above the bar, or maybe as a tooltip) when the user hovers their mouse over a bar. Is there a native onmouseover event for the bars of the chart, or is it something that should be added through series.MapAreaAttributes?
Edit After some experimenting I've found the points.tooltip attribute which I can add at the same time I add the point which will do what I want it to do, but it would still be nice to know if you can capture events for the bars, just for future reference.
I have to assign the individual color to Column bar chart i tried the below it is working
[Code]....
but i want loop through each chart series item and assign them a color from an array. Is it possible with MS Chart control iam using the Column Bar chart for displaying the data.
I also have a working application that popukates my datagrid with valid data rows from my DataBase. What I cant figure out is how to get each of the hyperlink lables to NAVIGATE to the correct and corresponding aspx page!
For example I have 5 rows in the datagrid and each row has its own hyperlink, each row contains contact and a short profile on 5 diffrent companies. For example when i click on let say row 3 that has (eg) Jimmy's Big Prawn's Restaurant listed in the the datagrid, I want to be navigated to a webform page dedicated to Jimmy's Big Prawn Restaurant.
[Code]....
I am guesing it has to do with the bolded text above, but "details.aspx" is just an empty webform, I would like the hyperlink to point to (eg) JimmBigPrawnRestaurant.aspx.
I would like to know if its possible to have different cultures for every UserControl, en-US culture in the first and he-IL or da-DK for the second one.
Am having a tough time isolating an individual element in an array in the "if" statement at the bottom. I'm trying to check and see if that value of the first element of the array is "1."
When I try to build I get an error on the line with the "if" statement:
Error 14 Cannot implicitly convert type 'object' to 'bool'. An explicit conversion exists (are you missing a cast?)
I have a database that is filled with documents. In the database there is the documents id, name and version. Two documents can have the same name and id but are seperated by different versions.For instance there can be two entries, id: A44, name: Dilbert was here. But they are version A and B.When retrieving these to a listview I wish to limit the documents shown to only one version. Doing so means that I am only to show one document with the same id. I only get the id and name to show in the listview so I thought that distinct might do the trick. But since the name can change throughout different versions this was no good.Basically I wish to retrieve all documents but with distinct id. How do I achieve this?
What I don't quite get is why the total database size is 642.56 MB when the size of the individual tables is so much smaller. We pay for the total amount, in chunks of 500 MB. I was trying to see which tables where causing the DB to be so big, but to me, it looks like it is not the size of the tables but something else.
What should I look at to figure out why we are taking up so much space? Am I not understanding how this works?
I've been reading and trying to figure out a way for half a day yesterday, and any solutions seems to fit to this. Overview: My solution is building up xml files from different folders on another server. After the xml is built up, I can run a "File Mapping" which will grab the appropriate information from the a specific xml selected with a dropdown and pass it to the asp:repeater. The binding is done on load, reading all the xml elements and passing it to a collection of object that will be bound to the repeater( results.DataSource = listOfObjects; results.DataBind(); )
Now here is the problem. In each row of the table there is columns containing static informations and the last cell of the row is an img button that represent a gray checkmark and that on click should change to green. However, onclick now I only change the data to the xml, and on next "File map" it'll be there. I cannot simply refresh the page, because it takes a fairly long amount of time to refresh because most of the times there is over 350 records to load and above that, you cannot simply refresh page because the page is call through ajax and a refresh will bring you back to the default.aspx. I've already built a function to get the param back through jQuery, however I really have no clue how to bind it to the image. Current line with image:
IsQAComplete being the bool used used for checkmark which is referring to the listObject. <--- the listObjects Collection remains unchanged Get what the checkbox state should be referring to xml file.
i have 2 tables assignment and feedback, in a gridview it displays all the assignments, the assignments then get feedback. im then wanting to change the view feedback button in the gridview depending on if there is new feedback for example:
the feedback table has a state field in it so when its 1 i want that image button to change to the one with the +
I am using a checkboxlist which I am populating from the database using Databind(). And i am having Dropdownlist in UpdatePanel to avoid postbacks which is also populated form database. Each Item in dropdownlist-> Associated to Many Items in Checkboxlist. Is there any way I can Make Associated listitems bold(to highlight them) on Dropdown Selected Index Changed Event so that user will know he has to select the highlighted checkboxes for the selected value in dropdownlist?I have tried using the listitem Attributes as well but it's not working. See the code below.
DataTable siteParams = new DataTable(); using (SqlConnection con = new SqlConnection(conString)) { using (SqlCommand cmd = new SqlCommand("siteParametersGetAll", con)) using (SqlDataAdapter da = new SqlDataAdapter(cmd))
Now, I want to be able to grab certain rows without using 0,1,2,3
i am working on asp.net3.5 c#,i want make the click event for a cell in grid view, actually i'm using data table and assign this to grid view,i want click event for a cell .is it possible?
I have a static collection of objects that will be frequently updated from multiple threads.Is it possible to lock individual objects in a collection instead of locking the entire collection so that only threads trying to access the same object in the collection would get blocked instead of every thread?If there is a better way to update objects in a collection from multiple threads, I'm all ears.
I have dropdown values like this : credit card, cheque, cash..etc. here i am showing "div" when iam click on cheque or hiding "div" when iam click on credit card,cash..etc.
i wrote Jquery validations for all controls in my page like this ...
[Code]....
if i select cheque in dropdown the validations should be fire other wise not, but now my page all validations fired when click on submit button?
I have an asp.net page with several list boxes. I would like to include some javascript on the page that allows a user to drag individual list elements from one box to another. On a normal web page, the script to do this is reasonably simple, however, with the element IDs generated by ASP.NET, I don't know what identifiers to have my script look up?
