Welcome :Guest
Congratulations!!!

Top 5 Contributors of the Month
Mayuri
Sandeep Singh
stevemarkayden
kumarfurima
Preethi

### how to multiple condition in if statement in asp.net C#

sir

i am using if condition to find out a time

if(time=="08 AM)

{

response.write"shift A";

}

but problem is how can i put multiple condition in if like

if(time=="06 AM" and "08 AM" and "07 AM")

### Sharepoint: In Calculated Column, Code with multiple "IF" condition does not work.

Implemantation:ÃÂ ÃÂ CalculateÃÂ expected resolveÃÂ date exclude "Saturday" and "Sunday"ÃÂ ÃÂ based on Priority and Severity.Columns are:1. Priority:2. Severity:3. Raised on: Date record createdCode:ÃÂ Below is the code which contains multiple "If" conditions. For quick undersatnding, i separated major If condition. Below code does not work and sharepoint gives me Sytax error message. =IF(OR(Priority="Critical",Severity="Critical"),IF(TEXT(WEEKDAY([Raised on]+1),"dddd")="Saturday",[Raised on]+3,[Raised on]+1), ÃÂ  ÃÂ  IF(OR(Priority="HIGH",Severity="HIGH"), IF(TEXT(WEEKDAY([Raised on]+1),"dddd")="Saturday",[Raised on]+4, IF(TEXT(WEEKDAY([Raised on]+2),"dddd")="Saturday",[Raised on]+4,[Raised on]+2)) , ÃÂ  IF(OR(Priority="MEDIUM",Severity="MEDIUM"), IF(TEXT(WEEKDAY([Raised on]+1),"dddd")="Saturday",[Raised on]+5, IF(TEXT(WEEKDAY([Raised on]+2),"dddd")="Saturday",[Raised on]+5, IF(TEXT(WEEKDAY([Raised on]+3),"dddd")="Saturday",[Raised on]+5,[Raised on]+3)) ) , ÃÂ  IF(OR(Priority="LOW",Severity="LOW"), IF(TEXT(WEEKDAY([Raised on]+1),"dddd")="Saturday",[Raised on]+6, IF(TEXT(WEEKDAY([Raised on]+2),"dddd")="Saturday",[Raised on]+6, IF(TEXT

I am trying to receive and delete multiple FTP files from a remote FTP server using Script task Below is the code   Dim FTPConnMgr As ConnectionManager FTPConnMgr = Dts.Connections("FTP Connection Manager") Dim FTPClientConn As FtpClientConnection = New FtpClientConnection(FTPConnMgr.AcquireConnection(Nothing)) Dim FileTimeStampNew As String = "20100913021807" Dim remoteFileNames(0) As String remoteFileNames(0) = Dts.Variables("FtpRemoteDirectory").Value & "*" & FileTimeStampNew & ".*" 'Below hardcoded FileName works good. But the problem is there are lots of file in the FTP folder that I dont want to receive 'remoteFileNames(0) = Dts.Variables("FtpRemoteDirectory").Value & "Company_alpha_Full_20100913021807.xml" Dim localPath As String = Dts.Variables("FtpLocalDirectory").Value FTPClientConn.Connect() FTPClientConn.ReceiveFiles(remoteFileNames, localPath, False, False) FTPClientConn.Close() Dts.TaskResult = ScriptResults.Success End Sub End Class If i specifically mention the RemotefileNames this works fine but, when I say *.* it executes succefully but doesn't receives the file. Please advice how to receive multiple file based on a variable BR, AWM

### Run multiple MS SQL update queries

On satisfying the If condition, I need to run 2 MS SQL update queries. How can I accomplish this? I am using C# as the server side language. Any help is appreciative.

### How to check for space in a password regex having multiple condition

Hi
I have a requirment where in the password field should accept all keys except space, it should have atleast one number , length should be 6 to 50
I tried following but did not work
1) Regex = @"^.*(?=.{6,50})(?=.*\d)(?=.*[a-zA-Z]).*\$"

2) ^(?=[^\s])(?=[^\s]{6,50})(?=[^\s]*\d)(?=[^\s]*[a-zA-Z]).*\$

Following are my test input text ( test case no 2 is having space at end)

ÃÂ ShouldNOT654321-1
ShouldNOT654321-2
Should654321-3
ShouldNOT 654321-4
Should NOT654321-5
S houldNOT654321-6
ShouldNOT65432 1-7
S houldNOT 654321-9
Should654321
1Should654321

Rajendra Dewani

Regards Rajendra Dewani

### Multiple queries in a detail view

Hey ASP Guru's,
I am working on a form that has a details link(Details.aspx?id={0}&id2{1}).
Then on the Details.aspx, the 2 variables will be used in a
Store Procedure to create detailview. My store procedue on the Detail view page is a basic If Else statement. If ID2 = 1 then run this statement else run this statement.
This is the tricky part the If part runs a query on a different table then the Else Part. My 2 questions are: Can this be done? and Is there a better way?

Hey ASP Guru's,

I am working on a form that has a det

### Parameter queries running multiple times

Currently running SQL 2005 sp2 SSRS.  We were in the process of tuning a report's queries against DB2 when our DBA noticed in the tracing log that the queries used for the parameter list is ran 2 times for each parameter.  They are cascading parameters with a Date only, but we tested removing the dependancy and the parameter query still ran 2 times.  We tested setting all the default values for initially opening the report and after we just opened the report and it rendered, nothing else was touched, the parameter queries all ran 2 times.  Any idea of why this happens.  I tried to search for this and couldn't find anything.

Thanks.

### Web Form import into Excel with Multiple Queries - HELP!

Hello all, I'm new to forum but been using the site for some time (good information on here).  I am trying to export data from a .aspx web page into an excel sheet.  There are a couple of things.  The web address is static, doesn't change when tables a populated.  Also, there are multiple input selections to query the results.

I am trying to import flight information from all gateways for each day.  I am only concerned for the results coming from the "originating flight search" box.  I've been doing this manually for some time and the process takes several hours - its time to make it automated.

Basic excel layout:

### Can I write multiple queries in Execute SQL Task Editor at a time

Can I write multiple queries in Execute SQL Task Editor at a time???

Can I write these two queries???

mhassanshahbaz

### How do I handle IsSelected Condition in multiple DataTriggers case ?

Hi all,

I have a customize listBox in which I am defining a DatatTemplete for that ListBox, the code is something like:

```<ListBox Name="lstOfImages"
Background="Red" >

<ListBox.ItemTemplate>

<DataTemplate>

<Grid x:Name="mainGrid">

<Grid.ColumnDefinitions>
<ColumnDefinition Width="38"/>
<ColumnDefinition Width="*"/>
</Grid.ColumnDefinitions>

<Image x:Name="FirstCulomnPanel"
Grid.Column="0"
Height="40"
Width="38"
Source="ImagePath"
Visibility="Visible"
SnapsToDevicePixels="True"/>

<Border x:Name="SecondCulomnPanel"
Height="200"
Width="300"
HorizontalAlignment="Center"
Background="White"
VerticalAlignment="Center"
Grid.Row="0"
Grid.Column="1"
SnapsToDevicePixels="True"
```

### Multiple database support with Entity Framework

One of the features introduced in Entity Framework is being database independent. Which mean each database provider can support Entity Framework by implementing its provider.

This feature allows you build applications independent from the underplaying database provider. In this post I'm going to show how to build an application that support multiple databases using same conceptual model made by Entity Framework.

### Binding the multiple drop down boxes in GridView using JQuery in ASP.NET

Here is the code for binding the multiple drop down boxes in GridView using JQuery in ASP.NET

### Upload Multiple File using JQuery in asp.net

I have also explained how to check for file type, file maximum size limit using jQuery & also using server side validation code.

### Adding Multiple Columns and Rows in GridView without using a Database

This article describes on how to add multiple columns and rows in GridView without using a database. Basically the GridView will be populated with data based on the values entered in each TextBoxes on Button Click and retain the GridView data on post back.

### GridView Multiple Filter AJAX Control

This AJAX control enables the user to filter data within any column inside a GridView. The user can add multiple filters and can delete existing ones too.

### Multiple Column Dropdownlist for the ASP.NET DataGrid

Based on my previous control "Multiple Column DropDownList for ASP.NET", I received many emails asking for the same control to be used in the DataGrid for web applications. Here we go.. This control can be used as the regular MS DropDownList in the DataGrid and also as a regular dropdownlist. It has all the properties, like DataTextField, DataValueField, DataSource, SelectedIndex etc. The download file contains the samples both in VB.NET and C#. In this sample, I have used the Northwind database of SQL Server.

### ASP.NET Multiple Selection DropDownList with AJAX HoverMenuExtender

Recently, I was looking for a multiple selection dropdownlist control for my new project. After spending some time researching for it, I decided to put together all my finding in one web user control. This web user control consists of an ASP.NET AJAX HoverMenuExtender, JavaScript, StyleSheet and CheckBoxListExCtrl . The final product will work with or without a MasterPage and you can drag and drop more than one instances of the control on to the page.
Origin FLT# Dest Dep-Date Dep-time Arr-Date Arr-time A/C
 Categories:
 ASP.Net Windows Application .NET Framework C# VB.Net ADO.Net Sql Server SharePoint Silverlight Others All