Forms Data Controls :: DataAdapter Displays One Location Before The Description ?
Jul 12, 2010
I have almost got this all working but one thing. What i am doing is SELECTING a number of details from a table which is for job vacancies. I am then displaying the job_name, a short description about the job and finally the location's the job is available in..If you look on this page:http://kidsunlimited.co.uk/vacancies_test.aspx
You will see a list of Vacancies shown BY job name. The problem occurs when the job is available in more than once location. Take a look at the Cook vacancy. It should be reading as Cook, then the description and then location which in this case there are 2.But instead it mixes them up and displays one location before the description and one after..This is the code i have :
I have a table in my database, in which a certain field holds the locations of text or doc files (the files are of a transcript for a chat session).
In the Gridview right now i able to show the link locations. But i want to have Hyperlink or Button in the links location in the Transcript Location fields.And on the click of which the txt or doc file opens up in notepad or microsoft word.
this is from the product details page and the description goes in a straight line always - i want to make the description a box and have lenght of 30 characters every line -- i want to modify the description not to be in a straight line
1. As per my knowledge we use dataadapters/dataset when we want to deal with the huge amount of column/data. Is there anyway that if I want to update one or two columns in a table without using dataadapter/dataset?
2. There is a way that without clicking a button we can get the data using objectdatasource, I mean to say that there is no vb.net data in the code behind then how to debug if there is not data in vb.net in code behind.
as you can see I'm a table adapter but is giving me the following error: i realy dont know what this error means - though i did a simular action using access DB (and it did work), where i had to user the following: using System.Data.OleDb; now because im using SQL DB im using: using System.Data.SqlClient; //sql server
i want the following in 1 div. say <div="topdiv">: i want to display on aspx page one image and its description fetched from database. i want to provide a next button at the side of it, onclick of this the next image and descriptn must be displayed without page being refreshed. i have another div (<div="divbottom"> which displays other information..
Above is the beginning of a ListView and its LinqDataSource. When the HTML displays, it picks up only the first record in the table but it's supposed to show a profile page for the user who is signed in (UserID == @UserID).
I'm using a gridview to show numerous artists. My query gets all the records I need, but when i bind it to the gridview the gridview shows only one record. I'm also using paging and sorting. The paging is not visible. The sorting works fine. But it still returns only one record. for example: first the record is Allan --> when i sort i get the record --> Zofie. This means that all my records are inside the gridview. Why does it only show one? My pagesize of the gridview is set on 10.
I have got a recordcounter above my gridview that shows the exact number of records that are present in the gridview for example (showing 1-10 out of 231 records).
My page has Grid View & ObjectDataSource to bind data. In page preRender event and not post back I updating the Panel to display data. Suprisingly, it displays duplicate data. I check my stored procedure and it returns Rows correctly.
I have a table in an SQL Server Express database. I created a content page and added SQLDataSource and a DetailsView. It looks great in Design View. I can see the border, titles and data fields plus the controls such as add and delete.
When I view in browser I only see the background and nothing else. If I change the background to white it doesn't display anything.
I belive the content page is ok because I can see text from <h3>Testing</h3>
I'm using Visual Studio.NET 2010 and .NET 4.0. I have SQL Server Express 2008.
The one wierd issue I was having was using a varbinary(MAX) field to use for jpg images. The DetailsView didn't seem to want to include it so I had to add it from Available Fields to Selected Fields.
Does anyone have an idea why nothing but the background displays in the browser?
I have a repeater that displays a list of job openings. I now need to modify the repeater and break out the job openings by category.
See below for the existing code for my repeater. I'm not sure how I need to modify my repeater to display the jobs under the appropriate categories.
I've added a new JobsCategory table to the database and added the foreign key relationship between my jobListing table and the jobcategory table.
I've created a new stored procedure to pull the jobs my category:
CREATE PROCEDURE [dbo].[GetJobsByCategory] @categoryId int AS BEGIN SET NOCOUNT ON SELECT j.JobID, j.JobTitle, j.URL, j.City, j.State, j.Country, c.CategoryName FROM ADPJobListing j INNER JOIN ADPJobCategory c ON j.CategoryID = c.CategoryID WHERE j.CategoryID = @categoryId END
In my typed dataset (tableadapter), I'll add a new query to the above stored procedure and finally in my business logic layer, I'll add a new method to call down into my data access layer:
[DataObjectMethod(DataObjectMethodType.Select, false)] public ADP.JobsDataTable GetJobsByCategory(int categoryId) { return this.Adapter.GetJobsByCategory(categoryId); }
How do I need to modify my repeater to display the jobs by category?
I have created a search page for web application that will allow a user to search the database based upon employee name or supervisor name. It is a multiple table database that is linked together by an unique employee number column, primary key in people and foreign key in supervisor. I have a parent/ child datalist used to display the record. When searching by the employee name it will return the record correctly if there is a record found. However, if I search by supervisor name and there is no match for the supervisor name, it will return all the records and create the parent datalist with all the employee details there, but the child datalist with the supervisor information is not display as there is no record with that supervisor name.
I ahve a gridview and itemtemplate in which I have an URL field from the database. When I clicl on this URL, it should open in another browser the URL that we clicked on.
In the ASPX.CS file I define a datasouce and manually populate it.
DataColumn MDC = new DataColumn(); MDC.AllowDBNull = false; MDC.AutoIncrement = true; MDC.AutoIncrementSeed = 1; MDC.AutoIncrementStep = 1; MDC.ColumnName = "B2"; MDC.DataType = System.Type.GetType("System.String"); MDC.Unique = false; MDT.Columns.Add(MDC); MDC = new DataColumn(); MDC.ColumnName = "PRPT"; MDC.DataType = System.Type.GetType("System.String"); MDT.Columns.Add(MDC); I then manually fill each row: DR = MDT.NewRow(); DR["B2"] = "Test1<br/>Test2"; DR["PRPT"] ="Test3<br/>Test4"; MDT.Rows.Add(DR);
When the Grid is viewed using IE - both the Header and the data rows properly display the cells with multiple lines. When displayed using Firefox or Safari - only the Header utilizes multiple lines - the data rows are on a single line ---- "Test1Test2" what needs to be done to display multiple lines in all three browsers.
I built a user control that displays a drop down list of states. I'm using it, but if I try to put it in a listview control, all I get is the frop down with nothing in it.
