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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

sqlexpr.exe command line parameters to show progress bar and not show OK confirmation at the end

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :Sql Server

Using SQL Server 2008 Express SP1 (sqlexpr.exe)

My command is sqlexpr.exe /X:C:\SQLInstall\

It works fine but shows the "Extraction Complete" message box at the end. If I change it to /Q /X:C:\SQLInstall\ then I do not see the progress bar or message box.

I wanted to set the parms such that I see the progress bar but do not see the Extraction Complete OK messagebox. How does one do that?


View Complete Post

More Related Resource Links

report manager parameters , back button do not show

Hi, not sure this is an expected behavior.  My drill through reports have parameters that are passed from the first report.  once drill through, somehow the parameters are not showing in report manager.  also the Back arrow is also missing from the second report.  is this expected?thanks

Show progress control


 Have following code snippet and my question is following:

The progress controls work fine when I "click" Button1 but does not for the "SelectedIndexchanged" in DropDownList1.

Can someone explain why. Thank you.

Mark up code:

form id="form1" runat="server">

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

<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<asp:AsyncPostBackTrigger ControlID="DropDownList1" EventName="SelectedIndexChanged" />
<asp:AsyncPostBackTrigger ControlID="Button1" EventName="Click" />
<asp:Label ID="Label1" runat="server" Text=""></asp:Label>

<asp:UpdateProgress ID="UpdateProgress1" runat="server">
<asp:Image ID="Image1" runat="server" ImageUrl="ajax-loader.gif" />
<asp:Label ID="Label1" runat="server" Text="Loading...."></asp:Label>

how to show specific data label or legend in the line chart


I have a line chart with date (X axis) for average numbers. I wanted to show only one number for the month at the chart or legend area. But i can show or hide whole data labels. Is it possible to have an expression box in chart area?

Thanks in advance,


Show Progress from DocumentPaginator GetPage Method.

I have a DocumentPaginator class that I created to print multipage documents.  It works great, but it often takes several minutes to print large jobs and there is no feedback to the user.  What is the best way to implement a progress meter from within the GetPage method?

FlowDocument: how to convert a Block item to Inline item so they can show at one line?



First, sorry for my poor English, I know this question may sound absurd, but there are many situations like showing several tables in one line, customized List Marker... which may need to show several Block items at one line.

Now I got 3 approaches,

1: use Floater or Figure, but they only provide basic functions for docking, so they cannot display more than 3 block decently, and when processing deeply nested lines, the result got so ugly and very difficult to coordinate.

2: use Table to layout the page, it do has a good result, but as it is a rule in both WPF and HTML that Table should be use to display Tabular data, it should not be used in layout.

3: use InlineUIContainer to wrap each Block in a Control which can display FlowDocument, this may be the worst option.

any ideas? thanks, in advance.

Can we show a line chart on multiple pages with page breaks? SSRS 2008


Hi there,

I am using SSRS 2008. I have a line chart which queries a huge dataset and shows the datapoints really close to each other that the labels and grid-lines are overlapping onto each other. http://oi54.tinypic.com/2vifrb9.jpg

Is there a way to split the chart and show it on different pages.? Thanks in Advance :)


show search result as default parameters when initiation of business data list



I want to show search result as default parameters when initiation of business data list.

Is there any solution to solve this problem. Thanks.

Edit/Display of Report/Properties/Parameters only 2 decimal places show need 4 decimal places


Does anyone know if there is a way to display 4 decimal places on an Overide Default of data type Float on the Report/Properties/Parameters page.  It accepts 4 decimals and that is what is used in report but when returning to this screen it only displays 2 decimals.

SSRS 2005

Can someone show me how to remove blank columns from a matrix report with parameters?


I have a drilldown matrix report with 5 parameters that I group on. The users have the option of selecting any of these parameters when they preview the report. They can also select No grouping as one of the parameter option.   When I run the report and select for example, 4 parameters and the No grouping option, I get blank columns.  When I select no grouping, no data is displayed.  As a result, I get blank columns.  Is there a way to hide the blank columns?  I would appreciate any suggestions.  See table example below:



Show confirmation dialog on list item edit

When users edit a  list item and click o.k.  How can I show a dialog box to confirm ( yes / no) the change. 

GridView control to show master-child or master-slave data, written in c#, asp.net

I previously made a master slave datagrid using Visual Studio 2003 .Net (original article) that would allow users to show data to clients using collapse and expand features. These features however did not carry over to gridview for many users. This tutorial will explaing how to create a collapsable/expandable gridview in frameworks 2.0 and higher

Show grand total running total in GridView Footer

In many scenarios we need to display Running total as well as Grand total in GridView footer. In this post i will try to explain in an easy way that how we can display running total & Grand total in a GridView footer combindly. To explain this solution using an example here i use a sales order report. The report contains all sales order amount in a tabular way. I will use a GridView to display sales order amount and use GridView footer to display Running total & Grand total. Let we have a customer table with id and name column plus an orders table with OrderID,CustomerID,OrderDate & Amount. Now our goal is to show all customers order with amount as well as page wise running total & grand total. Note that running total is necessary when you enable paging in a GridView where as Grand total is always you can consider.

datalist image slide show problem


hi friends

i am binding  images dynamically(back end)for a datalist .iam applying a slideshow for it .I am getting a problem to apply slideshow for dyanmically binded images.If the define in a div statically it working perfectly

for example pls go through my code below:

<script type="text/javascript">
$(document).ready(function() {
        fx: 'scrollLeft' // choose your transition type, ex: fade, scrollUp, shuffle, etc...

<div class="slideshow">
        <img src="images/30_dummy.jpg" width="200" height="200" />
        <img src="images/aquarius.gif" width="200" height="200" />
        <img src="images/star.gif" width="200" height="200" />
        <img src="images/the-proud-indian-flag-1.jpg" width="200" height="200" />

I above code works perfectly and the slide show e

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




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?




Can't get an Icon to show for Desktop shortcut and Program Menu



I've created a SetupWizard, but can't get it to show the Icon for the shortcut on desktop and program menu. The installation goes fine without any errors, the only problem is the icon.

I've made a shortcut of my exe file in the Application Folder and dragged the shortcut to the Desktop folder, then on the shortcut properties, I assigned it an icon picture located in Application Folder.

Any suggestions will be very much appreciated.


Why show only one record?



// Update these variables to values whatever you are storing in your table
        // If you are storing as CARD NUMBER, update this Card Number Attribute Name to CARD NUMBER
        string strCardNumberAttributeName = "Credit card number";
       // string strCardTypeAttributeName = "1";
        string strExpiryDateAttributeName = "Expiry date";
        DataTable dtPaymentDetails = new DataTable();

        string queryString = "SELECT tbl_Payments.PaymentId, tbl_PaymentDetails.AttributeName, tbl_PaymentDetails.Value, tbl_Payments.PaymentType FROM tbl_Payments INNER JOIN tbl_PaymentDetails ON tbl_Payments.ID = tbl_PaymentDetails.PaymentId WHERE ATTRIBUTENAME IN ('" + strCardNumberAttributeName +
                                   "','" + strExpiryDateAttributeName + "') ORDER BY PaymentId";

        string connectionString = "data source=.\\SQLEXPRESS;Integrated Security=SSPI;" +
                                           "AttachDBFilename=|DataDirectory|\\BurnbetDatabase.mdf;User Instance=true";
        using (SqlConnection connection = new SqlConnection(connectionString))
            SqlCommand command = new SqlCommand(queryString, connection);
            SqlDataReader reader = command.ExecuteR
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