object og = GridView_EmployeeTimeSheet.DataSource;
System.Data.DataTable dt = new System.Data.DataTable();
dt = (System.Data.DataTable)og;
But getting null in og(object) and at run time Gridview is showing its required data...
I'm looking for guidance of how to do some things for my application, I cannot resolve how to do the following:I have users and categories in a database, then I have a Master Table where these users combine with the categories creating rows, in this table there are other columns too.So for instance,
Master Table
User1 | Category2 | Date | Cost
john mainteinance nov1988 5000
along with more columns.
I managed to create the other tables so my application can capture this data, can add or erase users or categories, and everything still works great.The problem is that I need to generate reports from this Master Table, so for instance if I select john from a dropdownlist, I need to generate a report with all of its sells totals separated in categories, the thing is, I could just make a query asking for that, but the problem is that like I said you can add new users, new categories, or erase etc... so I just cannot get the logic to build something like a gridview and get what I want just passing the user name selected, and automatically getting me the total of all categories, no matter if later they add one, still comes back with the total of the new one, or if they erase one it will not display it etc...
If you could give me some general info of how to do it it would be appreciated, I'm thinking computed columns but I just don't know how to calculate ti.
I need your help on how to generate HTML reports in an asp.net application.The report content should be database driven. since we have faced so many problems with Crystal reports during the Deployment ,and also it takes some time to load data,rapidly it affects the performance of application.
View 1 RepliesI have looked through the website and google about crystal reports and MVC. It seems that crystal reports does not goes well with MVC framework. Is that true? If that's the case, what is the best solution for me? I am assigned to generate graphs and reports by getting data directly from a database (Oracle) and populate them into a report document. Other than crystal report, what can i use.
Is crystal report capable of generating graphs? or do I need to download other add-ons in order to have a graph generation on my reports.
How to generate script from a database with its data? I tried it, but it was not generated with data.
View 13 RepliesHow can I generate a script which contains all database tables, stored procedures, data, and etc. ? So that I can
use this script to create a database on the new server.
I am using MS SQL 2005.
I am having a field called Semester, i will enter it as 1 initially. Then it should automatically increase 1 semester every six months till sixth semester in the database (sql server 2005) is it possible?
View 5 RepliesWhile calling a crystal report from ASPX i get the following error message:
Error in File C:WINDOWSTEMPReport1 {CB17A4FE-ECB0-4461-AB9C-0E07F8CDDB1F}.rpt: Failed to retrieve data from the database. Details: [Database Vendor Code: 102 ]
I have tried to verify the database and then call it again but in vain.
I want to retreive some data from an SqlDataSource using it's Selected event I've tried
DataView dv = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty)
but here it's going into in infinite loop and then it gives me an StackOverflowException error in ASP.Net Development Server (my dev machine) and if I publish to IIS it requires me an user name and password to connect to server and gives an InternetExplorer error "Sys.WebForms.PageRequestManagerServerErrorException. An unknown error ... status code returned was 400. The SqlDataSource is in an UpdatePanel. Maybe this is why I get this.
retrieve data from sql server without using details or grid view.
i have a table in the SQL server called NewsTable which inculde the following fields: "titlename","bywho","datetime"."news"
anyway i need to retrieve the data from this table to my web page to appear this way ==> i am using C# by the way
TitleName
posted by bywho on datetime
News
I'm developing a web application with ASP.net and Sql Server 2005.
How i can retrive data from database on every seconds basis?
For your information , I have a Server application which will update hardware status (every seconds) into database and
my web client need to retrieve and display out the latest status (every seconds)
how one would retrive a value stored among several values in a single database field?
For example, the MS Customize CreateUserWizard walkthrough [URL] adds the ability to save the users preference for subscribing to a newsletter and allowing their info to be shared as 1 value in the comment column of the membership database. The result ofaspnet_Membership.Comment is Subscribe=TRUE&ShareInfo=FALSE.
My question is if Subscribe=TRUE&ShareInfo=FALSE is in one field of the database, how would you retrieve just the Subscribe=TRUE value from the field and use it to send a newsletter to the proper users while ignoring the ShareInfo=FALSE value?
I want to retrieve the data from the last record of a table. For eg: I have sorted the data in my table and want the value from the last record? How can I do that?
Is there a way to check that "saving" data to a table was successful and then do something after that?
How can i retrieve the data in linqdatasource in code behind?i have a dynamic database design with column storing the datatype eg. text, int, date.i need to retrieve the value in order to populate the control and bind it.
View 5 RepliesI need to retrieve data based on 3 different selections(current year, 5 years, 10 years). If the user select current year, then I need to pull data with the most up to date year, if the user selects 5 years, then I need to pull data for 5 years from the most up to date year in database. I am trying to accomplish this in sql due to using object DataTables in asp.net 3.5. I am able to do this with separate queries but I need to accomplish this with one query. I was going to use CASE statements but not really sure if I am approaching this correctly.
View 9 RepliesIs there any method by which we can retrieve random data from a dataset or rather directly from a table.
For example, I have around 30 questions in my table, I just wanted to display 20 among them and that too in a random order without the same item repeating. Can we achieve this using SP or through some Dataset manipulation?
I have a page in my website where there is very little code-behind. I only have two lines of code in Page_Load() and the rest of the code is declarative ASP.NET code. I have a FormView control which uses a SqlDataSource to get some order information. The SqlDataSource calls a stored procedure called usp_GetOrderDetails, here's the code for the SqlDataSource:
[Code]....
<truncated>
What I want is to grab the screenshotId from the SqlDataSource when the usp_GetOrderDetails stored proc gets called and populate it into a field on the page called screenshotId. I then want to use this screenshotId to get an image from the database based on Id. populating the screenshotId field. How do I do this - do I need to have something like OnDataBound or something like that?
I need to retirve data from two tables...when i click a value in dropdown list, i need to retrieve values from two tables based on that id( which i have selected in dropdown)..so when i have written query ( "Select assign_issue.issue_assigned_to, assign_issue.created_on,assign_issue.last_Date,
issue_register.issue_desc,issue_register.issue_Priority from assign_issue INNER JOIN Issue_register ON assign_Issue.Issue_ID = issue_register.Issue_ID where issue_register = '" + ddlissueid.selecteditem.text + "'")..query is executing ..when it comes to dr = cmd.executereader()..Dr is unable to read..it is showing false when i trace..unable to read into while loop.
I'm trying to make a dropdown list with data available based on the users login name. Heres what I have as my SQL Query in the SQLDataSource:
SELECT Client_Name, Client_ID FROM Client WHERE (Client_Name LIKE '%@Client_Name%')
So say if the login username is "User1" but the database client name is "User1 Steel" I want the dropdownlist to pull "User1 Steel" as the display and Client_ID as the value from the dropdown list.
I am in need to retrieve data from data base and display a field based on the drop down is selected
View 2 RepliesHow to retrieve the data from the session (Dataset) and save it into a database
[code]...
I coded in code behind to dynamically generate a gridview as the columns of the gridview changes based on user selection. In the gridview I have dynamically generated controls like textbox, dropdown list etc.I have a few filtering options about, for example: listbox which will postback on change and causes the gridview content to change as well.My problem is: since the controls are randomly generated and every postback will read dataset from database and reload, the naming of the controls are dynamically generated too.
View 10 Replieshow to edit data in grid view manually without auto generate in gridview + ajax.
View 4 RepliesI am creating a attendance database table in sql server2005.. i just want to generate the gridview as follows in form.aspx.. i am using vb.net generate the report in gridview..
Attendance table
employee name(varchar)- Its contain all the employees name
date(datetime)-Its contain dates
status(varchar)-Its contain the status of employee whether they are Present or Absent
I just need all the employee name (data) in one rows and dates in columns.. also i need the status of the employees inside this.. whether they are absent or present.
how i can generate a gridview with a fixed number of rows that is entered from a textbox
my gridview has a column with dropdownlists the others contains textboxes?