ASP.NET

sathesh pandian20-Feb-07 0:50

sathesh pandian

20-Feb-07 0:50

you can use the datagrid column style like this.
Dim s As Unit

s.Pixel(12)

DataGrid1.Columns(1).HeaderStyle.Width = s

Sathesh Pandian

A kamath20-Feb-07 0:55

A kamath

20-Feb-07 0:55

Thanks,
but I am working with ASP.Net/C#
can u explain what kind of datatype is unit

Vsree20-Feb-07 18:32

Vsree

20-Feb-07 18:32

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 Smile | :)

~Vsree

adding a map to web form?

A kamath20-Feb-07 20:45

A kamath

20-Feb-07 20:45

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 />

shaik_aks19-Feb-07 23:52

shaik_aks

19-Feb-07 23:52

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?..

Re: adding a map to web form?

Sandeep Akhare20-Feb-07 0:02

Problem (Lost Focus Event in ASP.Net)

20-Feb-07 0:02

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

MissionSuccess19-Feb-07 23:36

19-Feb-07 23:36

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.

NanaAM19-Feb-07 23:54

NanaAM

19-Feb-07 23:54

use parseInt while adding
to=parseInt(From.value)+1

Nana

MissionSuccess20-Feb-07 0:30

20-Feb-07 0:30

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?

Sandeep Akhare20-Feb-07 1:06

20-Feb-07 1:06

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

MissionSuccess20-Feb-07 1:50

20-Feb-07 1:50

Thanks its working fine
except that error "document.form1 is null or not an object."

Sandeep Akhare20-Feb-07 1:57

20-Feb-07 1:57

HI its working fine in my machine i tested it then posted for you Smile | :)

Are you using FF ........
If problem is solved post it Smile | :)

<l>Thanks and Regards
Sandeep

Sylvester george20-Feb-07 1:58

Sylvester george

20-Feb-07 1:58

use like this

document.getElementById("form1")

Regards,
Sylvester G
Senior Software Engineer
Xoriant Solutions
sylvester_g_m@yahoo.com

Sandeep Akhare20-Feb-07 2:03

20-Feb-07 2:03

try this
this.document.form1.submit();
its same but also try it don't know Why its happening D'Oh! | :doh:

<l>Thanks and Regards
Sandeep

MissionSuccess20-Feb-07 2:10

Problem in ASP.NET Page when use Firefox

20-Feb-07 2:10

Thanks I have done that successfully.
I don't have to submit the form.

Once again
Thanks for the code..

Khan.Bangash19-Feb-07 23:18

19-Feb-07 23:18

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.

Sandeep Akhare19-Feb-07 23:54

19-Feb-07 23:54

Can you post the validation that you have done in javascript ? Smile | :)

<l>Thanks and Regards
Sandeep

Khan.Bangash20-Feb-07 0:18

20-Feb-07 0:18

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;
}

}

Sandeep Akhare20-Feb-07 0:27

20-Feb-07 0:27

Hi Your Javascript looks fine What type of error are you getting in FF ......
Can you post the Error

<l>Thanks and Regards
Sandeep

Khan.Bangash20-Feb-07 0:32

20-Feb-07 0:32

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.

Sandeep Akhare20-Feb-07 1:10

20-Feb-07 1:10

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 Smile | :)

<l>Thanks and Regards
Sandeep

Khan.Bangash20-Feb-07 4:10

20-Feb-07 4:10

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

Sandeep Akhare20-Feb-07 4:15