i was wondoring which thing is better from below two... first one- retrive data by creating webservice second one- create database connection from code behind call storeprocedure and retive data
View 6 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.
I have been asked to develop an ASP.Net application which will directly connect (store and retrieve) to the ACT! databse already functional. I am new to ACT and looking for a starting point to integrate it with ASP.Net application. In particular I am looking for answers to the following questions:1. What database technology is used by ACT? Is SQL Server? In that case, I should be able to connect just like any SQL Server database?2. Is there any class library or API for .Net from ACT which will help achieve this?3.
View 1 RepliesI have created a webservice which is publicly exposed. This publicly created webservice can be consumed in the application But my requirement is I have to create a webservice to expose the schema and cannot be consumed directly.How to consume the web service which is not exposed directly.
View 1 RepliesI need to write a web service which will generate excel file by using the records present in the database or depending upon the query fired.
So how should I try this?
I have to retrieve the data from the web service and this data should be kept in process's memory and use it where needed.Do not like to call web service every time.Is there any method to do this?
View 2 Repliesi am running with an unfamilier issue with jquery ajax and wcf service . i have created a simple wcf service and trying to show it on a asp.net label... the wcf service just returns a string which has to b shown on a label. the url has been set on jquery ajax url to call the wcf service using rest. but somehow i am not getting the desired thing done . the ajax cannot retrieve the data from the wcf service , here are the code snippets.
The Ajax Portion in default.aspx :
[Code]....
The Service Contract for WCF :
[Code]....
The implemented Method :
[Code]....
and the Web.Config :
[Code]....
can someone figure out here i am going wrong .... that the ajax is unable to retrieve the data from the above wcf Service .. its just a very basic and simple one .. but unable to figure out the Real Prblem.
I wanna connect to aspnetdb but it makes an error says "Login failed for user" this is the connection string in web config :
<add name="UserProfiles" connectionString="Data Source=KIA;Initial Catalog=aspnetdb;Integrated Security=True;"
providerName="System.Data.SqlClient" />
and this is my code:
SqlConnection connection = new SqlConnection();
SqlCommand ComNewCheckSum = new SqlCommand();
connection.ConnectionString = ConfigurationManager.ConnectionStrings["UserProfiles"].ConnectionString;
connection.Open();
ComNewCheckSum.Connection = connection;
ComNewCheckSum.CommandText = String.Format("select UserID from aspnet_Users where UserName = {0}", _UserName);
return Convert.ToInt32(ComNewCheckSum.ExecuteScalar());
how can i pass through error?
In asp.net(c#),I use Linqtosql.. how to retrieve data from database(table) and display in textbox...?
View 5 RepliesI have 5 radiobutton list and 5 checkbox list.Data come for this radiobutton list and checkbox list from the database.
now after user selecte items from this control i want to retrive back those data with the price from the database.further more I am creating string from this checkbox list to display image.the string came from radiobuttonlist and checkboxlist values.I
On my website, I'm using webservice to retrieve the data from (SQL Server) database. To improve performance, I like to use jQuery to retrieve the data from the webservice instead of using C#. The data values should be assigned to the drop-down list which I'm using in the aspx. Can anybody tell me how to do this? I'm a newbie to jQuery.
View 2 Repliesi got a Food table and a Notification table. each Food has an expiry date. I wish to put all foods which are going to expired into the notification table. since user can create new food anytime, how can i update the Notifcation table once got any new food (but with near expiry date) added? and how to make sure the Notification table retrieve the nearly-expired food everytime (mayb update once everyday??)
View 1 Repliesmy table name is "amountdetails"
it contains the following field "id","name","amount"
when the user enter the "id" in TextBox1 and click the button then the "name" and "amount" to that corresponding id should be dispalyed in the TextBox2 and TextBox3.
I have some problems in database connection and wonder if I have something wrong in my code. Please review. This question is related: Switch between databases, use two databases simultaneously question.
[code]....
A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. Cannot open database "db" requested by the login. The login failed. Login failed for user 'root'.
how can i retieve data from a database and store it in an array rather than in a datagrid or gridview.
View 3 Repliesi use a datatable to populate my gridview, how do i retrieve database to datatable's column?
View 3 RepliesFailed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. make sure the user has a local user profile on the computer. The connection will be closed.
After I formated my system, When I run my website on local IIS databases, aspnetdb.mdf don't seem to work. But works fine on local Cassini (VS).
But this problem is only with one of my new website , rest everything work fine.
Does it have anything to do with SQL Managment Studio? I din't take any backup of master database and all.
I have a application which connects to database. I have like 97 thousands data on the database. When I search something from front end and display those matching results on the browser, it crashes everytime (for huge number of data).
I'm using Dataset to retrieve data from database and display those matching results on Gridview(or repeater).
e.g. If I search 'abuse' it matches 65 thousands records and I can't retrieve and display those on browser, the browser crashes everytime.
I can search and display whole records without crashing the browser?
how can I retrieve data from a database when I press a button?
'Response.Write "<script type='text/javascript'>"
'Response.Write "$function btClick2(sql)"
'Response.Write "{"
'Response.Write "String sql = 'SELECT ID,CreateDate, UnitType, StationName FROM MyTable'"
'Response.Write "return sql;"
[code]....
This is just the part that is not working and I don't know if is correct!
When user upload new documents then this document goes for approval to supervisor and for this i use dropdowns ...when I use dropdown the exact result not occur and now i wat to approve/reject through checkboxes...
Here is code:
<table class="CSSTableGenerator" border="0" cellpadding="0" cellspacing="0" id="results">
<asp:Repeater ID="Repeater2" OnItemCommand="Repeater2_ItemCommand"
runat="server" onitemdatabound="Repeater2_ItemDataBound">
<HeaderTemplate>
[Code] ....
Now I want to use checkboxes, how I replace dropdown checkboxes in html and also in asp.net ....
I want to get data from the database and display it in gridview. The gridview should be editable. Meaning the user can add, edit and delete items/rows in the gridview. Everytime the user adds/updates/deletes an item, the gridview is also updated. However, these changes will only be saved to the database once the Save button is clicked.
View 3 RepliesI have a page where I will insert all the data into the database. The page where I'm having problems is when I select an item from the checkboxlist it only displays one item. The data which is displayed is only the one that was inserted with one selected item from the checkboxlist. The following code is the page I'm using to try to retrieve the data from the database. I am trying to do is when a user selects the first, second, or third, or fourth item. The corresponding data appears in the gridview. In my current code, the record which has one item selected appears. If the user has more than one selected it does not appear. It comes up as empty. Is there a way I can do it?
[Code]....
I am creating a kind of feedback website which has a feedback form on it. Each question is answered choosing from a radio button group. the answers to each question are (very good, good, bad, failed). I need to be able to create a table on the webform that will display the number of answers to each questions. for example, if the question is "Rate the use of this software" i need to be able to put in table format say 20 people said "very good", 30 said "good" etc. at the moment i only have one table to display the questions and answers and a date that will be used to select the date's report. so all the information i need is coming from this table. all i need to do is how to say like "SELECT Count* Question where Review date = "user entered date" and answer = "very good" etc.
View 4 RepliesI need to retrieve a table from MS SQL 2005 database using AJAX.
But I only know a traditional way using ADO.NET.
I have read some books and it said we need to use XmlHttpRequest to retrieve data from database but I don't really understand the concept.
While 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.