.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


Posted By:      Posted Date: September 08, 2010    Points: 0   Category :Sql Server
Hello, I have these tables....   CREATE TABLE test( codeTest int IDENTITY(1,1), name varchar(100) not null, PCK varchar (15) not null, AK varchar (15) not null, testdate datetime not null, CONSTRAINT testPK PRIMARY KEY (codeTest), );   CREATE TABLE subtest( codeSubtest int IDENTITY(1,1), codeTest int not null, name varchar(100) not null, ps1 int not null, ps2 int, ps3 int, ps4 int, ps5 int, maximumpeek char(1), fullsocketsps1initial int, fullsocketsps2initialfull int, fullsocketsps1final int, fullsocketsps2final int, CONSTRAINT subtestPK PRIMARY KEY (codeSubtest), CONSTRAINT subtestFK FOREIGN KEY (codeTest) REFERENCES test (codeTest) on delete cascade, );   CREATE TABLE scheduler( codeScheduler int IDENTITY(1,1), codeSubtest int not null, ps int not null, step varchar(10) not null, task int not null, cycletime real not null, maxdelay bigint not null, maxexecutiontime bigint not null, maxcycletime bigint not null, lostscans bigint not null, inputtimeouts real not null, outputtimeouts real not null, comments varchar (50), CONSTRAINT schedulerPK PRIMARY KEY (codeScheduler), CONSTRAINT schedulerFK FOREIGN KEY (codeSubtest) REFERENCES subtest (codeSubtest) on delete cascade, );   I want to show, the maxcycletime when task=2 for every test: so this I can do it... SELECT    MAX (scheduler.maxexecutiontime) AS [MAX CYCLE TIME]   ,test.codeTest AS

View Complete Post

More Related Resource Links

Show web applications build version information



I would like to make the build information for the running web application but I dont know where I set or configure this nor do I know how to retrieve this information.

In a project you may set the  build information in the file AssemblyInfo.cs under the projects Properties folder. Here is a snippet of the AssemblyInfo.cs file:

// Version information for an assembly consists of the following four values:
//      Major Version
//      Minor Version 
//      Build Number
//      Revision
// You can specify all the values or you can default the Revision and Build Numbers 
// by using the '*' as shown below:
[assembly: AssemblyVersion("6.3.0")]
[assembly: AssemblyFileVersion("6.3.0.*")]

But there is no such file for an web application project, so I have to get this information from one of the compiled DLLs that is in the same assembly as my web application then? Or how is this done?


The reason I want this information is because my customer would like to have a webpage within the web application where he could see the current version. This is also nice to have when testing and debugging etc.




Collecting extra information using Create User Wizard

 I am trying to collect extra information about a user when the user account is created using the Create User Wizard. This info will be stored in a new table in the standard ASP membership SQL database. I have read several books and loads of online tutorials on the subject and they all take different approaches and seem to make the process hard work. Is there any reason why I can't add an SQL datasource and a number of textboxes  to the wizard step, 'connect' the values from the textboxes to the Insert Parameters and then put an Insert Statement in a suitable event handler to cause the insert? If this is possible what would be the best (ie simplest) way to 'connect' the textboxes to the insert parameters?   Regards Andy

Information Worker 2010 - Web applications do not show up

i have Information Worker 2010 VHD running on VMware-MacBookPro with 6Gb ram. I converted vhd to vmware and it runs fine but for watever reason am unable to bring up the various web applications in the VM. I can goto Central Admin but the web applications (each is configured with a host header) simply dont show up.  i googled for hrs and have tried DisableLoopback thread etc., checked dns entries but nothing helps. What am trying is definitely not to be done in a production env, which is running web app on local server. has anyone been able to bring up web apps successfully. 

How to show random information with C# from a SQL Database?

I have to do the following in my web page.  Any advice and how to do this please with C# I have a table where I have a column for different states (NY, NJ, etc).  People can join the group (in my page) for each state (the state where they live).  So I have to display the newest members for each state. So the way it should work is, every time the page is refreshed/reloaded it should show the state name as a header text and the first 5 newest members for that state.  This should be random, for example initially when the page is loaded say it will show state: New York and the 5 recent members like Stacy, Laura, Mike, Sam, Mathew. Then when the page is refreshed it will show another state like State: california and the recent 5 members All the information comes from the database How should I do this?

How can i pass function as parameter to show in gridview

Hello, I have one common Data Access function which returns output as dataset which is as below   Public Shared Function ExecuteDataSet(ByVal sql As String, ByVal type As CommandType, ByVal ParamArray parameters As SqlParameter()) As DataSetDim RetVal As Object = Nothing   Try Cmd = Cmd.Connection = OpenConnection() Cmd.CommandType = type Cmd.CommandText = sql Cmd.Parameters.AddRange(parameters) Sda = Ds = Sda.Fill(Ds)       New SqlCommand()New SqlDataAdapter(Cmd)New DataSetCatch ex As ExceptionThrow New Exception(ex.Message.ToString())Finally CloseConnection() Sda.Dispose() End Try   Return Ds End Function   this function normally i use to get data from database and returns to dataset   now,I want to created one more function which output type is gridview and its parameter is  dataset which i got output in previous funtion   i want like this public funtion BindDatatoGridView(ExecuteDataSet("SELECT...",commandType.text,Parameter....)) as GridView End Function   how can i solve this, please help me out

How can we show and hide iframes progarmmtically in javascript, calling the function from a seprate

I have currently placed 5 iframes inside 5 divs and i m trying to show and hide iframes by following code if (docid == idpath_array[1])             {                document.all("div1").style.display = 'block';                document.all("div2").style.display = 'none';                document.all("div3").style.display = 'none';                document.all("div4").style.display = 'none';                document.all("div5").style.display = 'none';            } but the problem is that after setting style of one div as display:none,I am not able to display the same div latter by setting display:block hence programmically I am not able to display an already hidden iframe by making display:block in div

Newsfeed does not show all types of information


Ok, so I have created two users, and user1 has added user2 as his colleague. User1 has everything checked off under "Activities I am following" in his profile, so intuitively, he should see everything that user2 does.

Logged in as user2, I do the following updates:


  • Create some notes
  • Create some tags
  • Add a picture
  • Add a blog post
  • Update the "says" field
  • Add some details to the pofile, e.g. phone number etc.


I then trigger the "User Profile Service Application - Activity Feed Job" service manually to see the changes.

The only things showing up in user1's newsfeed, are:

  • User2's notes
  • User2's "says" field
  • User2's profile details, e.g. phone number
The rest is mysteriously not showing. If I browse to user2's profile page, I can see his picture and blog posts under "Content", so the permissions are not the issue there. Under "Tags and notes", I see only notes, which may indicate a permission issue. However, the tags are not marked as private by user2.

We experience the same behaviour both on a release candidate installation and on the rtm version. I have tried to

Need function to format numeric information


I am working with ASP.NET with Visual Basic.  I have a field called "Amount" that contains numeric information (15000.000).  When I display this information in a field called "Sales",  I want it to appear as 15,000.00

What is the name of the function that I should use?




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

How to get more information about the exceptions that can happen in SharePoint 2010 projects?

In case there is an exception anywhere in the SharePoint 2010 project (most common place an exception would happen is during deployment of your SharePoint project, custom deployment configuration or custom deployment steps), there's a registry key EnableDiagnostics available for you to use.

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

Content page control passes as argument to javascript function


Here is the content page:


<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="JavaDynamicCopyValue.aspx.cs" Inherits="JavaDynamicCopyValue" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
 <script type="text/javascript" >
 function copyValue(input, output )
   ouput.value = input.value;
   return true;
 <asp:TextBox ID="txt1" runat="server" onchange="copyValue(this,document.getElementById('<%=txt2.ClientID%>'))"></asp:TextBox>
    <br />
    <br />
    <asp:TextBox ID="txt2" runat="server"></asp:TextBox>


I got a javascript run time error says output is undefined. if I view source of the page, the txt1 markup became:

<input name="ctl00$ContentPlaceHol

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?




Information about sessions


Some questions about sessions:

I know sessions information is stored in the form of cookie and you can use qurystring for that if you set cookieless session in web.config. But I don't exactly understand the scope of a session.

What I believe is when you login to a website, a session cookie is created and the scope of that session is within that page only. If you close the browser that session gets killed and when you open the browser again and go to that site then a new session is created ie a new session is created on every request. Is this correct?

But I have seen in many websites, even if you close the browser and open it again the session is not killed, how does that happen?

Can anyone clear out and explain the scope/lifetime of sessions


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