i have the folllowing Query , and i want to do some thing like this, but i dont know if my query is right or wrong .DECLARE @Serial varchar(50)
select MyDate,MyName,@serial
from Names
where @Serial in
( if(MyDate>'10-10-2011') select '393939'))
as u Noticed i want to Set @Serial Column Result Based On MyDate Cloumn how i can do that?
I have a Grid View . It has two bound columns. I need to have a Serial Number column as the first column.
View 2 RepliesI have an sql table in which i have two columns enq_no and enq_serial.
for a particular enq_no, enq_serial should get incremented by one starting from 1.
What is the best approach to achieve this?
another issue is that after deletion enq_serial should get decremented by one.
How can i get this?
Is after delete trigger could be a good option?
If so? how can i get this with after delete trigger?
This is my Table structure:-Table1
Field1 Field2 Age
Dean Chen 20
Janel Wast 25
ann Miller 20
I used this select statement
select Field1+' - '+Filed2 from Table1
and i binded this in dropdownlist
now on selecting dropdownlist i need to show age in label. so how would be my select statement... to show age base on Filed1 and Filed2
i have table a with fourcolumns and more which need not be considered i would like the fourth column which has a special charcater ^ within it to act as row seperator such tht the values of 1,2,3 are comon for ALL THE ROWS BASED ON THE SPECIAL CHARACTER.
View 3 RepliesIn my web application i have statistics which shown for each user separately ie. posts made , posts made today , articles started by and so on...
Each user has his own special statistics.
What is more flexible and "right" to work with one huge DataTable in Cache with whole data from all users and then loop thought DataTable to find certain user data or to cache each user ie. cacheObj + userID...
I am using item template and eval function in the gridview to display the records. Can I add a coulmn which is not in the table?
I have to add some columns which is not in the table and assign the values from code behind to that particular column
How can I customize a cloumn in List view control and make it invisible in the page load event
View 8 RepliesI have a gridview which displays following columns:
TaskID, TaskDescription, IsComplete, DateOfCompletion
Now what I want to achieve is, when user clicks IsComplete checkbox, she must enter the date of completion. So, I want a validation (client side) on DateOfCompletion if the checkbox is selected (checked). And, I also want to use Validator Callout Extender
if possible.
How can I achieve this?
I have one asp.net dropdownlist which consist A,B values. If user Select A in dropdownlist i need to bind this query to Gridview. Select FirstSelection from Tablname else Select SecondSelection from Tablename. How to do so..?
View 7 RepliesI have the following code in my sql report:
[Code]....
What I want to do is display only those records where where sFileName does not exist.
Im trying to highlight a different element based on the result of a validator.
My form looks like this in structure:
LABEL TEXTBOX VALIDATION CONTROL
When the validation control becomes invalid, I also want the label to change colour.
There are examples of code on the MS website - here is a javascript sample:
[Code]....
isValid always defaults to false and therefore always displays red.
I am stored date in "smalldatetime" datatype as in databse.How can i particular textbox entered date(dd-mm-yyyy) used to fetch the row information from databse and shown in a gridview.
View 1 RepliesRate AnodeRate TotalRate
100 100 200
txtrate,txtanoderate n txttatalrate are added in ItemTemplate of gridview.
rate field is in database table while anoderate n totalrate not in database table ,also totalrate is readonly so that user can see only its addition,this addition will b passed to txtrate field n wil get bind that value in database. also i took
<asp:HiddenField ID="hdnTotalRt" runat="server" /> as it is readonly..
sample code:
enter code here
<asp:TemplateField HeaderText="Standard Rate">
<ItemTemplate>
<asp:TextBox ID="txtRate" runat="server" BorderWidth="0.5pt" Text='<%# Bind("rate") %>' BorderColor="green" BackColor="#ffffcc" Width="40px"></asp:TextBox>
[Code]....
It is showing me error as The name "txtRate"does not exist in d current context
I have a C# program used to build and deploy a suite of websites.
I would like to programatically interact with IIS so that it changes where the virtual directory for a test system points to based the result of the build.
Background: I use stored procedures exclusively for an ASP.NET application. I am using a DataReader to load a dataset object.
View 4 RepliesHow do i generate another computed column that will contail the result of GrandTotal/Total,
where GrandTotal is another value comes from computed column and the Total would be the sum of the Total within SchedularID.
And thats what i have done so far: [Code]....
i got a Gridview which is bound and draws its values from a DataTable.
My question is how can i sum the values of the p_price column and view the result on a label located on the same page?
I want to change text of text object in crystal report (.rpt file). The datasource for the report is a datatable which consists of a column named sale, if it is '0' then I want to display the text of text object as 'sale' and if it is '1' then I want to display the text of text object as 'lease'. how to add formula and based upon the result of formula I have to change the text of text object being displayed.
View 1 RepliesI want to set the coulms size of all the columns in the table in the DB based on the maximum width/size of one of those columns of that particular table That is if I have three columns Name(nvarchar 50), Address(nvarchar 70) and Description(nvarchar 100), then I want Name and Address to also be nvarchar 100, can anyone give me the code for the same in VB.
View 1 RepliesI am using serial port communication in my asp.net webform application...
[code]....
This method works when i send i single message... But when want to send sms in bulk opening and closing port everytime is not a good idea... So my question is it possible to use a serial port like session in c#?... When i open a port i want it to be open for 1 hour and then if my time expires i want to close the port and open it the next time...
I am working on a project where I have to design a front end(on C#) and have to display the data coming from PLC.
1. What name space I have to used.
2. What function I have to used for Serial communication.
3. What .dll file I have to add in my project.
I have an sqldatasource that loads, data from my server and puts it in a datagrid.
I have a Column named clnumber that has, the numbers 1,2,3
What I want is that each row have a different color depending on which number is in that datarow column
THIS IS THE CODE I USED
[code]....
I want to make the number for sales orders as an example:
SO/2011/001
(for
sales order
first)
SO/2011/002
(for
sales order
second)
How can I get the serial number when you add a new row in the table Add time in order to add the number in the second table
I mean I want in same the sqlcommand to insert and get the value of ( serial )..