I have a query that gets all item attributes using the query:
SELECT AttributeName, AttributeValue, ItemName from ItemAttributes
But I will need to write .Net code to cross-tabify this query's data.
How can I cross-tabify the above query using SQL Server code so AttributeName appears as table heading and AttributeValue, ItemName as column values?
I have this rows in my data base "ExamTable"How can I make the above rows like this?Could any expert tell me what I should to do in this case?
View 6 RepliesI'm using ASP.net membership system with SQL Server 2000 database. What I want to do is create a view (or stored proc if that's better) which will return a table with the following columns:
UserName | Role1 | Role2 | Role3 | .... | Role*N*
Where the columns (besides Username) are generated to include all the ASP.net Roles in the application.I need this to be generic (i.e. when I add a new Role, I want the procedure/view to compensate and list that new Role as a new column). I want the values in the Role fields to be 1 (True) or 0 (false) if a user in in that role. I can make a table that has such columns using Dynamic SQL to create the variable number of columns, but I cannot seem to populate them.
How can I accomplish this?Tables involved are shown below:
CREATE TABLE [dbo].[aspnet_Users](
[ApplicationId] [uniqueidentifier] NOT NULL,
[UserId] [uniqueidentifier] NOT NULL, [code]....
I want to do is create a simple page which allows a user to post data into a data table. It should not allow them to view, update or delete any data.
Is there a good online tutorial which would guide me through how to do this in Visual web developer 2008?
I have connected a db, and can add "SELECT" controls to view forms, but I need to be able to INSERT to the table.
I am running:
Windows Server 2008
MS SQL Server 2008
MS SQL Server Native Client 2008
I need to create an ODBC Data Name Source. The instructions on microsoft site are not explicit enough.
I have a a page where i am geting data in Dataset, Which I need to fill the data in text boxes.. For that i have created a property class. How can we connect to dataset to class.
DataSet ds = serviceCommonClient.GetDataSet(Session["ConnectionString"].ToString(), "sp_LoadBrokers", spParameter);
txtBrokerName.Text = ds.Tables[0].Rows[0]["tbr_Broker_Name"].ToString();
txtAddress.Text = ds.Tables[0].Rows[0]["tbr_BrokerAddress"].ToString();
txtZipCode.Text = ds.Tables[0].Rows[0]["tbr_Broker_Zip_Code"].ToString();
txtCity.Text = ds.Tables[0].Rows[0]["tbr_Broker_City"].ToString();
my query is SELECT a.HD, a.HEAD, a.SH, a.SUBHEAD, a.TRK, a.TRACK, a.TGT, a.TARGET, a.PDC, a.DT_RELEASE, a.STATUS, a.CO
FROM V_HIERARCHY1 a
my data is ,HR HR Rec Records Leave Leave Records HRL.0001 Policy and Process for leave record. 27.06.2010 30.06.2010 WIP Edlink
HR HR Rec Records Leave Leave Records HRL.0002 Quarterly Review 01.07.2010 04.07.2010 Planned Edlink
HR HR DB Database SAL Salary DDS.0001 Calculation of Monthly salary 08.08.2010 09.08.2010 WIP Edlink
HR HR Rec Records Ind Induction Records HRI.0001 Completion of dossiers. 08.07.2010 10.07.2010 WIP Edlink
HR HR DB Database Emp Employee HDE.0001 Offer letter 06.07.2010 09.07.2010 WIP Edlink
my outout is ,HR
REC
LEAVE
HR1
REC1
LEAVE1
I have a web page where a GridView will be shown with a column of different products and another column with checkboxes. Checking on the checkboxes will be equivalent to selecting the products. The selected products are saved to an arraylist. Then, the user has to click on a button located on the same page to analyze the selected products. On clicking the button, he/she will be directed to another page where a bar graph will be shown. The bar graph will be the result of having analyzed the products. How do I create the bar graph where the products are taken from the arraylist but I can make use of the datasource within the chart control to retrieve more detailed info(such as product sales) from the database, taking into account the products from the arraylist?
View 3 RepliesMore specifically, i'm trying to create a stored procedure that displays data from a table if the date column in the table matches a specific day of the week. (IE. Monday, Tuesday, ect...)
The date in my table is stored as MM/DD/YYYY.
I'm trying to create a class, DataCommon, to contain all my SQL Data manipulation functions. I've created a Subroutine called Init that initializes a SQLDataAdapter:
[Code]....
From my other classes I am creating an instance of DataCommon, calling Init, and calling another subroutine in DataCommon that pulls data from SQL and loads the data into my dataset. This part is working great -- no problems at all. I'm loading three different Datatables in the Dataset with no issues.
At this point, I'll perform my various manipulations on the datatables -- add/delete/modify rows -- again with no problems. All of this is creating postbacks...and this is where my problem begins. After I've done all my manipulations to the data and am ready to update my SQL tables, I have to re-initialize my SQLDataAdapter. I thought I could do something like:
[Code]....
But I get the error: Exception inserting Class. Thread was being aborted.
In my initial data load from SQL, each datatable is getting loaded from a single SQL table, so I was hoping to use the autogenerated Update/Insert/Delete statements by the SQLDataAdapter. As a test, as soon as I filled the dataset initially, I added a new row to one of the datatables and used the SQLDataAdapter.Update() method before a postback occurred, and it worked perfectly.
So, with all that being said, I guess my question is, how do I reconnect the table mappings between my SQLDataAdapter and dataset to autogenerate the updates after a postback occurs? I've tried researching this, but I get confused after reading about FillSchema vs TableMappings vs everything else I've read about.
I,am trying to create a self association relation for an organization chart data tree in Entity Framework,after trying different ways for prevention of exceptions like 3007 and etc. I found that when I put my foreign key in my POCO near Parent and Items navigation properties its work.but I think this is not correct that we have both ParentID scalar property and Parent navigation property. review this and tell me is it correct or not.I'm using VS 2010 RC and ofcource .net framework 4.0 RC
[Code]....
I have created normalised data tables to hold look up information (such as venues, players, teams etc) and want to dynamically update the 'matches' data table (my transactions) using webpages instead of running SQL queries.
What I want to do is select a name from a drop down list and then post the relevant ID associated with that name to my 'matches' table. At the moment I can only link to the value in the drop down list, i.e. the name which is incompatible with the validation which expects a primary key integer.
I'm sure this problem is a fairly common one but I haven't found the right answer on any of the tutorials or blogs, all of them assume that the data is de-normalised or describe things in more technical ways than I can yet understand. If anyone can point me to a 'how to article' or tell me what I am doing wrong, I would be grateful.
I'm new to ASP.net 3.5 and trying to create a test site so I can figure out how to use it in the real world. I have created a FormView (Formview1) based on a Client table using Linq Data Sources. The page includes a DropDownList to lookup Clients. I have added a list option (<asp:ListOption value="" Text="(Select Client)" and set AppendDataBoundItems=true so my added option is displayed. I decided to try to use Formview with only the Edit and Insert Modes, and I have set the Default Mode = Insert. When you open the page, a blank Client record is displayed.
The Client record contains serveral lookup fields and they have drop down lists for each. When I select a client from the Client DropDownList, is get the following message 'ddlClientType' has a SelectedValue which is invalid because it does not exist in the list of items I had this problem before and decided the best way to handle this (in the interim) was to turn off foreign key constraints for each of the lookup fields (e.g. ClientType) in SQL Server. That worked for 2-3 days. Now the problem has started again.
When I develop in other applications, I would simply create a lookup data source based on a Union Query with the actual data and a blank record. How can you do this using Linq DataSources. Can you get access and modify the queries?
in one on my page i am using to add the data from popup window to grid view without using the backend means databasethis is my popup window code
[Code]....
[Code]....
I want to develop some crosstab also know as pivot reports in Asp.net with x-axis and y-axis being dynamics, allowing grouping by row and column, for example: have products in y-axis and date in x-axis having in body number of sells of a given product in a given date, if date in x-axis are years, i want subtotals for each month for a product (row) and subtotals of sells of all products in date (column)
I know there are products available to build reports, but i am using Mysql, so Reporting Service is not an option. It's not necessary for the client build additional reports, i think the simplest solution is having a control to display such information and not using crystal report (which is not free) or something more complex, i want to know if is there an available free control to reach my goal.
How can i remove the default space between two pages in Crosstab report
View 1 Repliesi have web application it should create single HTML page . that one HTML page should send to the customers.how to create HTML page .i created one page but it retriveing single record from the databse values . my problem is i have to pull all the records from the database and papulate the HTML page. but i am getting only onerecord on that page.my code as follows
string type = ds.Tables[0].Rows[i].ItemArray[4].ToString();
string WAIVN = ds.Tables[0].Rows[i].ItemArray[0].ToString();
string status = "cdcr";
[code]....
but iam not getting all records only single record only iam retriving
I am using
3 textboxes
1 dropdown
2 Buttons ( Add Row , Submit )
1 GridView ( For Temporary Data Holding of above controls )
Now what i want is that when a user fills some data in textboxes and select something from dropdown , then clicks on Add Row , this temporary gridview shows that data in it ....
how to achieve it ?
In one of my application, I have around 2000 records which i am displaying in gridview with normal paging.
Now I want to change this paging facility and would like to show a "more" button at the footer(just like [URL] has). The moment user clicks it, the next set of data will be retreived. This will go on till all the records are fetched.
I wanted to create the Calendar with data from database.
I have a ItemId in the database with DateFrom and DateTo
ItemID DateFrom DateTo
1 10/01/2010 11/20/2010
2 10/14/2010 12/18/2010
I wanted to show these records in Calender. may be just view Only.
i have a dataset filled from the DB, let assume the data in the dataset is: -
[code]....
I want to know how we can create a table (or a layout consisting of div's) and poulate it with data from the database. We do this generally using data controls like gridview, datalist etc. But i am restricted by these controls like there is no inbuilt paging with datalist and there is no repeat column in gridview. I just want complete control over the layout as well as the data that goes into it.
I dont know how to do this. Is there anyway of doing it without using the data controls.
there are 5 records in xml and next set of 5 records to be inserted in a same xml using asp.net , but xml is a single file
whether we have to use batch files ?
i have two sqldatasource controls. one i use to display data in textbox's ,filter'd by a select parameter in page behind code. Once checked, i want to copy this data to the other datasource ,by selecting checkbox.Then display this data in detailsview control.
At present the two datasource controls declared , render data to the page simultaneously during pageload. I want to first check data in textbox's from first source, before second datasource is rendered to screen. note, both are filtered by a page variable. i wish to leave the textbox datasource control in situ, as other controls and code depend on it.The other detailsview datasource is my problem?
I have a lot of members data to enter into the ASPNETDB database. How can I read this data from an Access data file and input into the SQL database. All data is for user Names and Password,
View 1 Replies