.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Sharon Maxwell
Post New Web Links

QUESTION: how build/create sql reports via a C# application using own user interface:

Posted By:      Posted Date: October 26, 2010    Points: 0   Category :Sql Server
 

Hello all,

I would like to know if it is possible to create my own user interface, to enable me to print / create my own sql reports using the "sql reports builder". The C# user interface would simply add the various fields and parameters that one would normally add if you run the sql report builder by itself.

Is this possible? And if so could someone please point me in the right direction / site tutorials to do so/

Many thanks and kind regards

Geo

 

 

 




View Complete Post


More Related Resource Links

Reporting: Deliver User-Friendly Reports from Your Application with SQL Server Reporting Services

  

SQL Server 2000 Reporting Services--a server-based reporting platform built on the .NET Framework and integrated with SQL Server 2000--lets you easily add reporting from diverse data sources. Using Visual Studio and Reporting Services you can integrate reports from any data source that has an OLE DB, ODBC, or ADO.NET provider into your Web applications. This article explains how it's done.

John C. Hancock

MSDN Magazine August 2004


Create user account for web authentication from non-web/local application

  
Hi, I have an application which is installed on local pc and is using SQL db. It is a client management system where I want to add capability to register new clients and give them access to my web site which is sharing the same SQL database with local application. At the moment clients can register on the web site and I have ASP.NET authorisation system set up with aspnetdb_user, aspnetdb_membership and etc tables. But sometimes it happens that I need to register clients on my local application on PC and ideally would like that registration to create online account for the client as well. Then I want to be able to send him user id and password by email and let him know that he has been registered in my database and online account is ready for him as well. Basically I want to have full synchronization between asp.net membership service and local application through SQL db. As I said both online and local apps are shareing the same SQL database. I would like to know if it is possible at all and what would be the best practice to implement it. Thank you.  

Site Usage Reports web User Interface not working

  

When we go to a subsite of a web application, we get the message: "No data is available for this report. Usage analysis might have been enabled recently, or there might have been insufficient usage to report in any values for the report"

We have followed the instructions to configure the site usage reports on the farm and have checked to see whether the reports feature is activated etc. We do have the logs folder location at default path and have ensured the wss_adm groups have the appropriate permission. We also have logs turned on at the iis web app area.

This problem is farm wide and occurs on the different web applications we have in the farm.

so plz any help???


Site Usage Reports web User Interface not working

  

When we go to a subsite of a web application, we get the message: "No data is available for this report. Usage analysis might have been enabled recently, or there might have been insufficient usage to report in any values for the report"

We have followed the instructions to configure the site usage reports on the farm and have checked to see whether the reports feature is activated etc. We do have the logs folder location at default path and have ensured the wss_adm groups have the appropriate permission. We also have logs turned on at the iis web app area.

This problem is farm wide and occurs on the different web applications we have in the farm.

so plz any help???


Cannot create a connection to data source ... Login failed for user: BUT not for all reports!

  

SQL Server 2008 using Report Builder v2.0  (Microsoft SQL Server Reporting Services Version 10.0.2531.0)

We have several reporting service apps with many reports in each one. There is a set of 4 reports that all report on similar info (but grouped differently) that can be run by me and other network administrators but not any "regular" users. On these reports only, they are getting "Cannot create a connection to data source ... Login failed for user...". As I've said there are other reports that regular users can run just fine!? ALL reports use the same Shared Connection Data Source on the server that is set up as Windows Integrated Security. The Data Source's Security allows Domain Users to browse.  

I've uploaded a test report to SSRS whos SQL is "SELECT 'test' as testField" and that's it: and is connected to this same Data Source and users still get the Login Failed error... even tried creating and using a new Data Source that points to the same SQL Server DB to no avail. Examining the rdl's XML doesn't reveal anything either.

Reporting Server is a different machine than the SQL Server DB holding the data.

The only clue is that working reports were created a year before now.


Create Work flow application integrating with domain user and asp.net web pages

  

Hi, I am WF 4.0 learner. I want to create a work flow application where there will be a request web form to fill out the information lets say request for Books order. There will be couples of primary approver who can approve or reject that request. If approve by primary approver it goes to seconday or final approver who also can do approve or reject the request. Only after appove by secondary approver the flow will be successfully end.

In this flow, all users from the domain can request. some users will be primary approver and some are secondary approvers. Can we develop this scenario in WF 4.0? Your idea will be most welcomed. Thanks


support and search

create custom application page with a ribbon and user control webpart

  

i am in stress how to start this what should be the first step

i want to create custom application page with a ribbon and some user
control web part to show document item properties.

Please help me regarding this

 

thanks in advance 

Regards 

WasiKhan


wasikhan junior software ENG

How to create 3 tier application using LINQ

  
As you know that in 3 tier architecture there are three layers

User interface layer. (Is our Form in Windows application and .aspx page in Web application)
Data Access layer. (Which provides interface between Business logic layer and Database)
Business Logic layer.(Which stores your application logic)

Create Web Site vs Web Application

  

I follow the tutorial and creted a web site for my company sales system. One of my collegue mention we use the wrong templet, we should use Web application for company application.


Should i continue using web site or change to web application? We are creating application for company sales, inventory, hr ,etc where possible more than 1000++ user. And during month end, it will be high traffic and transaction. can Web Site Template with BLL and DAL handle it? or i just need a powerful server?



how to get an array of all the asp.net textbox control inside create user wizard control?

  

Hi,

How can I get all the textboxes inside a create user wizard control using getElementsByTagName().

Below is my JQuery code:

<script type="text/javascript">
        function addLoadEvent(func) {
            var oldonload = window.onload;
            if (typeof window.onload != 'function') {
                window.onload = func;
            } else {
                window.onload = function() {
                    oldonload();
                    func();
                }
            }
        }


        function prepareInputsForHints() {
            var inputs = document.getElementsByTagName("asp:TextBox");
            for (var i = 0; i < inputs.length; i++) {
                inputs[i].onfocus = function() {
                    this.parentNode.getElementsByTagName("span")[0].style.display = "inline";
                }
                inputs[i].onblur = function() {
                    this.parentNode.getElementsByTagName("span")[0].style.display = "none";
                }
            }
        }
        addLoadEvent(prepareInputsForHints);

    </script>


 

<asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
       

form feild hints are not displaying for textboxses inside create user wizard?

  

Hi,

I'm using following JS code to display input hint box besides the textbox whenever that asp.net textbox receives focus. 

I'm doing this for a registration form and all of the textboxes are inside the asp.net create user wizard control.

<script type="text/javascript">
function addLoadEvent(func) {
  var oldonload = window.onload;
  if (typeof window.onload != 'function') {
    window.onload = func;
  } else {
    window.onload = function() {
      oldonload();
      func();
    }
  }
}

function prepareInputsForHints() {
	var inputs = document.getElementsByTagName("TextBox");
	for (var i=0; i<inputs.length; i++){
		// test to see if the hint span exists first
		if (inputs[i].parentNode.getElementsByTagName("span")[0]) {
			// the span exists!  on focus, show the hint
			inputs[i].onfocus = function () {
				this.parentNode.getElementsByTagName("span")[0].style.display = "inline";
			}
			// when the cursor moves away from the field, hide the hint
			inputs[i].onblur = function () {
				this.parentNode.getElementsByTagName("span")[0].style.display = "none";
			}
		}
	}
addLoadEvent(prepareInputsForHints);
</script>
span.

Web Site to Web Application Question

  

I've been building web sites and for my next project I will be creating a web application.  I use a 'BasePage' class in all my projects but, since web applications do not contain the 'App_Code' folder, what is the best place/practice for the 'BasePage' class?

Thanks,

TML


create user wizard login error message dont show in a message box?

  

hi

 

i am using create user wizard and capturing other information within content template when a new user

registers. Some of the textboxes are binded to required field validators.

 

there is a validation control on the page and ShowMessage box is True.

If they dont complete some of the text boxes then the message box pops Up with the error message.

It does not however include information errors like "User already exists" or Email address already exists

from the create user wizard membership  UserName and Password Textboxes

 

is it possilbe to hook all of these up so I get one message box with all errors including membership ones?

 

thanks

 


database interface design question

  

For handy database interface, is it good to use SqldataSources exclusively intead of EntLib functions?

Thanks for any feedback.


Create a user friendly pop up window

  

Hello friends I am new to asp.net programming. While working with windows form(windows application) i have created a window for editing purpose(just like popup window ) which contains three bounded dropdown list a button and a gridview. After making selections from the drop down when we press button the corresponding result should display in a grid.After that when you click on the grid row it will load the corresponding datas in my form. i want to create such control in asp.net . i have to use jquery or ajax.And this pop up window i have to use more than twenty times in my application.am using VS2008 ASP.NET and C# 3.5 . Plese suggest me what to do. Thanks in advance


A Challenging Question for Advanced user....

  

Using  dot net How will you release .exe applicattion for 1000 clients.this question was asked by manager but i could not answer him.tell me if you can!!!


Cutting Edge: Build Rich User Interfaces with jQuery

  

In this month's installment we build modal and modeless dialog boxes in jQuery and explain how to post data from them to the Web server.

Dino Esposito

MSDN Magazine May 2009


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend