|
Thanks,
but I am working with ASP.Net/C#
can u explain what kind of datatype is unit
|
|
|
|
|
hi
U can try like
<asp:TemplateColumn HeaderText="Description">
<HeaderStyle Width="25%"></HeaderStyle>
<ItemTemplate>
<asp:Label id="lblDescription" runat="server" Text= '<%# DataBinder.Eval(Container, "DataItem.Description") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateColumn>
Here in "DataItem.Description"-- Description is the fieldname as in table.Use what fieldname what u want to display.
"Width = 25%" means that that coulumn takes 25% of your grid's width..
Try this .Hope this helps U
~Vsree
|
|
|
|
|
Thanks.
I had given like this but it is not working.Description column has become empty. no values there
<br />
</asp:TemplateField><br />
<asp:BoundField DataField="OUTCOME" HeaderText="OUTCOME" SortExpression="OUTCOME" /><br />
<asp:TemplateField HeaderText="DESCRIPTION" SortExpression="DESCRIPTION"><br />
<HeaderStyle Width ="25%" /><br />
<EditItemTemplate><br />
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("DESCRIPTION") %>'></asp:TextBox><br />
</EditItemTemplate><br />
<ItemTemplate><br />
<asp:Label ID="Label1" runat="server" Text='<% DataBinder.Eval(Container,"DESCRIPTION") %>'></asp:Label><br />
</ItemTemplate><br />
</asp:TemplateField><br />
|
|
|
|
|
how do i add a UK map to a web form in asp.net 2.0.?. where can i get a map of UK with all the places in UK?., please help me in writing code to consider a place that is selected using the map?..
|
|
|
|
|
Depending upon the type of map file .........
might be Image control is usefull if the map file is compatible with it
<l>Thanks and Regards
Sandeep
|
|
|
|
|
Respected Gurus
I have two text boxes which retrieves the values of a financial year.
eg.2006-2007.
User will manually enter 2006 in first one and on LOST FOCUS of it second should fill with 2007.
Can any one give some javascript code to do it.
I m using...
function Getvalue()
{
var from;
var to;
from=document.all['txtFinYearFrom'];
to=from+1;
document.all['txtFinYearTo'].value=to;
document.Form1.submit();
}
HTML--------
<asp:textbox id="txtFinYearFrom" runat="server">
<asp:textbox id="txtFinYearTo" runat="server">
In Page load of my codebehind file--------------
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As ystem.EventArgs) Handles MyBase.Load
Me.txtFinYearTo.Attributes.Add("onfocus", "Getvalue();")
txtFinYearTo.Text = Request.Form("txtFinYearTo")
End Sub
After running it i get NaN in the desired textbox instead of 2007(2006+1).
Any Help.
|
|
|
|
|
use parseInt while adding
to=parseInt(From.value)+1
Nana
|
|
|
|
|
Now i m getting error....
function Getvalue()
{
var from;
int to;
from=document.all['txtFinYearFrom'];
//from=document.getElementById("txtFinYearFrom");
//to=parseint(from.value)+1;
to=(from.value)+1;
document.all['txtFinYearTo'].value=to;
document.Form1.submit();
}
wht to do?
|
|
|
|
|
Hi
try this
var element=document.getElementById("TextBox1");
var val=element.value;
var to =parseInt(val)+1;
document.getElementById("TextBox2").value=to;
document.form1.submit();
<l>Thanks and Regards
Sandeep
|
|
|
|
|
Thanks its working fine
except that error "document.form1 is null or not an object."
|
|
|
|
|
HI
its working fine in my machine i tested it then posted for you
Are you using FF ........
If problem is solved post it
<l>Thanks and Regards
Sandeep
|
|
|
|
|
use like this
document.getElementById("form1")
Regards,
Sylvester G
Senior Software Engineer
Xoriant Solutions
sylvester_g_m@yahoo.com
|
|
|
|
|
try this
this.document.form1.submit();
its same but also try it don't know Why its happening
<l>Thanks and Regards
Sandeep
|
|
|
|
|
Thanks I have done that successfully.
I don't have to submit the form.
Once again
Thanks for the code..
|
|
|
|
|
Hello,
I use a dropdown list in my page. When Some One Select Its Index the query change according to its Selected Index. i-e
if drpSearch.SelectedIndex = 1 then
query = "Select ........"
end if
if drpSearch.SelectedIndex = 2 then
query = "Select.........."
end if
if drpSearch.SelectedIndex = 3 then
query = "Select.........."
end if
It works Fine for IE, But In Internet Explorer it does not work. What can be the reason. Can any One Help me. Sory I m posting this 2nd time cuz I did not get any useful help yesterday.
Thankx in Advance.
|
|
|
|
|
Can you post the validation that you have done in javascript ?
<l>Thanks and Regards
Sandeep
|
|
|
|
|
Yes Sir this is my .js file coding.
function SelectKey()
{
var msg;
var drp;
var txt;
var txtt;
txt = (((document.getElementById("txtSearch").value) / (document.getElementById("txtSearch").value)) != 1)
txtt = (document.getElementById("txtSearch").value < 0)
drp = (document.getElementById("drpSelect").selectedIndex==3) || (document.getElementById("drpSelect").selectedIndex==4)
if (document.getElementById("drpSelect").selectedIndex==0)
{
msg="Please Select Search Key from Dropdown List!";
}
else if ((document.getElementById("txtSearch").value == "") && (document.getElementById("drpSelect").selectedIndex != 7) && (document.getElementById("drpSelect").selectedIndex != 10))
{
msg="Text Box is Empty!";
}
else if ((drp) && (txt))
{
msg="Invalid Character!";
}
else if ((drp) && (txtt))
{
msg="- Sign Not Allowed Here!";
}
else
{
msg="";
}
if(msg!="")
{
alert(msg);
return false;
}
}
|
|
|
|
|
Hi
Your Javascript looks fine What type of error are you getting in FF ......
Can you post the Error
<l>Thanks and Regards
Sandeep
|
|
|
|
|
the variable query do not get value in FF.
actually query gets value on the selected index selection. but when it is run in FF id doese not get value . Means it s empty.
|
|
|
|
|
Hi
i am trying to solve your problem but i am not finding any loop hole please post your code behind file also today we will solve this problem
<l>Thanks and Regards
Sandeep
|
|
|
|
|
sory sir i was out some where. my code behind file is here
Protected Sub btnSearch_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSearch.Click
Try
If (Conn.State <> ConnectionState.Open) Then
Conn.Open()
End If
If drpSelect.SelectedIndex = 1 Then
SelectQuery = "SELECT cust_order.order_id as order_id,customers.fname as fname , customers.lname as lname, cust_order.order_date as order_date,cust_order.order_status as order_status from cust_order,customers where customers.customer_id=cust_order.customer_id and customers.fname like '%" & txtSearch.Text & "%'"
End If
If drpSelect.SelectedIndex = 2 Then
SelectQuery = "SELECT cust_order.order_id as order_id,customers.fname as fname , customers.lname as lname, cust_order.order_date as order_date,cust_order.order_status as order_status from cust_order,customers where customers.customer_id=cust_order.customer_id and customers.lname like '%" & txtSearch.Text & "%'"
End If
If drpSelect.SelectedIndex = 3 Then
SelectQuery = "SELECT cust_order.order_id as order_id,customers.fname as fname , customers.lname as lname, cust_order.order_date as order_date,cust_order.order_status as order_status from cust_order,customers where customers.customer_id=cust_order.customer_id and cust_order.order_id = " & txtSearch.Text & ""
End If
If drpSelect.SelectedIndex = 4 Then
SelectQuery = "SELECT cust_order.order_id as order_id,customers.fname as fname , customers.lname as lname, cust_order.order_date as order_date,cust_order.order_status as order_status from cust_order,customers where customers.customer_id=cust_order.customer_id and customers.customer_id = " & txtSearch.Text & ""
End If
If drpSelect.SelectedIndex = 5 Then
SelectQuery = "SELECT cust_order.order_id as order_id,customers.fname as fname , customers.lname as lname, cust_order.order_date as order_date,cust_order.order_status as order_status from cust_order,customers where customers.customer_id=cust_order.customer_id and customers.zipcode ='" & txtSearch.Text & "'"
End If
If drpSelect.SelectedIndex = 6 Then
SelectQuery = "SELECT cust_order.order_id as order_id,customers.fname as fname , customers.lname as lname, cust_order.order_date as order_date,cust_order.order_status as order_status from cust_order,customers,biz_cust_extra where customers.customer_id=cust_order.customer_id and customers.customer_id=biz_cust_extra.customer_id and biz_cust_extra.comp_name like '%" & txtSearch.Text & "%'"
End If
If drpSelect.SelectedIndex = 7 Then
SelectQuery = "SELECT cust_order.order_id as order_id,customers.fname as fname , customers.lname as lname, cust_order.order_date as order_date,cust_order.order_status as order_status from cust_order,customers where customers.customer_id=cust_order.customer_id and cust_order.trans_status = 0"
End If
If drpSelect.SelectedIndex = 8 Then
SelectQuery = "SELECT cust_order.order_id as order_id,cutomers.fname as fname , customers.lname as lname, cust_order.order_date as order_date,cust_order.order_status as order_status from cust_order,customers where customers.customer_id=cust_order.customer_id and cust_order.trans_status = 0 and customers.fname like '%" & txtSearch.Text & "%'"
End If
If drpSelect.SelectedIndex = 9 Then
SelectQuery = "SELECT cust_order.order_id as order_id,customers.fname as fname , customers.lname as lname, cust_order.order_date as order_date,cust_order.order_status as order_status from cust_order,customers where customers.customer_id=cust_order.customer_id and cust_order.trans_status = 0 and customers.lname like '%" & txtSearch.Text & "%'"
End If
If drpSelect.SelectedIndex = 10 Then
SelectQuery = "SELECT cust_order.order_id as order_id,customers.fname as fname , customers.lname as lname, cust_order.order_date as order_date,cust_order.order_status as order_status from cust_order,customers where customers.customer_id=cust_order.customer_id and cust_order.trans_status = -1"
End If
If drpSelect.SelectedIndex = 11 Then
SelectQuery = "SELECT cust_order.order_id as order_id,customers.fname as fname , customers.lname as lname, cust_order.order_date as order_date,cust_order.order_status as order_status from cust_order,customers where customers.customer_id=cust_order.customer_id and cust_order.trans_status = -1 and customers.fname like '%" & txtSearch.Text & "%'"
End If
If drpSelect.SelectedIndex = 12 Then
SelectQuery = "SELECT cust_order.order_id as order_id,customers.fname as fname , customers.lname as lname, cust_order.order_date as order_date,cust_order.order_status as order_status from cust_order,customers where customers.customer_id=cust_order.customer_id and cust_order.trans_status = -1 and customers.lname like '%" & txtSearch.Text & "%'"
End If
selectcommand = New OleDbCommand()
selectcommand2 = New OleDbCommand(SelectQuery, Conn)
total = selectcommand2.ExecuteReader()
If Not total.Read() Then
lblMsg.Visible = True
Else
lblMsg.Visible = False
End If
With selectcommand
.Connection = Conn
.CommandText = SelectQuery
.CommandType = CommandType.Text
End With
adapter = New OleDbDataAdapter
adapter.SelectCommand = selectcommand
dset = New DataSet("quote")
adapter.Fill(dset, "quote")
orderDG.DataSource = dset
orderDG.DataBind()
txtSearch.Text = ""
drpSelect.SelectedIndex = 0
btnBack.Visible = True
totalreclbl.Text = dset.Tables(0).Rows.Count
Catch ex As Exception
Response.Write(ex.ToString)
Finally
Conn.Close()
End Try
End Sub
|
|
|
|
|
Did you Debug it ?
i think Query varaible can't be null only txtSearch.Text would show null ?
What you think ?
<l>Thanks and Regards
Sandeep
|
|
|
|
|
What is txtSearch.Text is it Text box or DropDown Control ?
<l>Thanks and Regards
Sandeep
|
|
|
|
|
Sorry i got your requirement
<l>Thanks and Regards
Sandeep
|
|
|
|
|
Sir txtSearch is a textbox where u have to type name , or order no etc. Dropdown list is drpSelect.
|
|
|
|