ASP.NET

Re: How to get the datakeys of GridView in second page?

20-May-09 21:00

DataKeys[index][0] in this index points ur row index and [0] points ur no.of datakeys u have...

if u give 2 datakeys named as sino and id

sino= Convert.ToInt32(SearchGrid.DataKeys[index][0].Value); //gives sino
id= Convert.ToInt32(SearchGrid.DataKeys[index][1].Value); //gives id

(or)

sino= Convert.ToInt32(SearchGrid.DataKeys[index]["sino"].Value); //sino
id= Convert.ToInt32(SearchGrid.DataKeys[index]["id"].Value); //gives id

Padmanabhan

meeram39520-May-09 23:13

meeram395

20-May-09 23:13

oh.. Thank you very much. the information is pretty clear. thanks

Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.

Re: How to get the datakeys of GridView in second page?

Ramesh Swaminathan20-May-09 19:53

Range values in Crystal Report

20-May-09 19:53

You are looping through GridViewRows collection, therefore use GridViewRow.RowIndex property to get the index of the row in the for loop. Also change your code like this

index = gvr.RowIndex;
Userid = Convert.ToInt32(SearchGrid.DataKeys[index].Value);

Girish48120-May-09 19:21

Girish481

20-May-09 19:21

Hello,

Visual Studio 2005
Default.ASPX
Two TextBoxes>>1.TextBox1 (To enter Start Roll Number)
2.TextBox2 (To enter End Roll Number)

Response.Redirect("Secm1998.aspx?startrol=" & TextBox1.Text & "&endrol=" & TextBox2.Text)

Secm1998.aspx>>1.CrystalReportSource1 2.CrystalReportViewer1
Secm1998.rpt

I wish to show only those records whose roll number (Oracle 10G Table) in the range of TextBox1 and TextBox2 in the CrystalReportViewer1.

For this:
How do i set CrystalReportViewer1.SelectionFormula as Rol (name of column in the table) in range of TextBox1 and TextBox2

Thanks & Regards
Girish Sharma

Re: Range values in Crystal Report

Ramesh Swaminathan20-May-09 19:36

Re: Range values in Crystal Report

20-May-09 19:36

Set the formula like this

"{Student.Rol} >= " + rollNumber1 + " AND ({Student.Rol } <= " + rollNumber2

Here rollNumber1 and rollNumber2 are values of TextBox1 and TextBox2 respectively

Girish48120-May-09 20:01

Girish481

20-May-09 20:01

Thanks for your reply and it worked fine; but one little question further:

Dim mySelectFormula As String = "ToNumber({secm98.rol}) >= " & Request.QueryString("startrol") & " AND ToNumber({secm98.rol}) <= " & Request.QueryString("endrol")
CrystalReportViewer1.SelectionFormula = mySelectFormula

Now it is asking username and password before showing the report; how do i set the username and password in the code.
Regards
Girish Sharma

Messagebox and alerts

jainiraj20-May-09 18:44

Re: Messagebox and alerts [modified]

20-May-09 18:44

In ASP.net how we show messagebox and alerts ti users when an error occurs????

deepthy.p.m20-May-09 18:50

Re: Messagebox and alerts

20-May-09 18:50

Use javascript

OR

u Can use

Response.Write("alert('Enter the message here');") in the code window.

But when u use Ajax controls Response.Write not possible

u can use label and write the msg in that label

modified on Thursday, May 21, 2009 12:56 AM

padmanabhan N20-May-09 18:52

Re: Messagebox and alerts

20-May-09 18:52

use java script or show the messages in validation summary (in Vlaidation summary there is a property called ShowMessageBox="True")

Padmanabhan

Ramesh Swaminathan20-May-09 19:10

validate Dropdownlist inside gridview using javascript

20-May-09 19:10

Alternatively you can display a javascript alert after a postback by

Page.ClientScript.RegisterStartupScript(this.GetType(), "testkey", " window.alert('Your Alert Message')");

deepthy.p.m20-May-09 18:42

Re: validate Dropdownlist inside gridview using javascript

20-May-09 18:42

I use ASP.NET + C#
In My form I have a Gridview inside gridview i use a dropdown list
In dropdownlist it contain --Select-- and other items

I want to add a validation to this dropdownlist so that the user must choose an item other than --Select--

I need to validate using javascript .How can i do that

padmanabhan N20-May-09 19:03

Re: validate Dropdownlist inside gridview using javascript

20-May-09 19:03

//if u have given selectedindex for your dropdownlist --select-- as 0

function error()
{
if ( document.getElementById('..._dropdownlist').selectedIndex = "0")
alert('select atleast one');
}

//but it will more easy if u provide a required field validator.

Padmanabhan

deepthy.p.m20-May-09 19:08

Re: validate Dropdownlist inside gridview using javascript

20-May-09 19:08

i will not work bcs i place the dropdownlist inside the gridview .

sidbaruah20-May-09 21:54

sidbaruah

20-May-09 21:54

Add a javascript function through attributes.add in cs

for(int i=0;i< gridview.rows.count;i++)

{
DropDownList ddl = (DropDownList)gridview.rows[i].cells[cellid].findcontrol('id');
ddl.attributes.add("onchange","return func("+ddl.clientid+");");
}

Send the row id from the cs file

function func(ddl)
{
//Do the validation in javascript
}

Hope that helps!!

I was born dumb!!
Laugh | :laugh:

Programming made me laugh Laugh | :laugh:

!!!
--sid--

Re: validate Dropdownlist inside gridview using javascript

harish mehra4-Jun-09 23:55

harish mehra

4-Jun-09 23:55

Please check yhe beolw script code
function check(id)
{
var n=document.getElementById("grd");
var namecontrol=id.name;
var myval=new Array();
var Arr=new Array();
myval=namecontrol.split("$")
var rowindex=myval[1];
var j=rowindex

if (document.getElementById("grd_"+j+"_ddl").value == '-- SELECT --')
{
alert("Please Select Sb Code..");
document.getElementById("grd_"+j+"_ddl").focus();
return false;
}
}

How to insert datas with comma in sql ???

JC.KaNNaN20-May-09 18:39

JC.KaNNaN

20-May-09 18:39

hi,

i have multi line text(ie..address)
for example,
insert into Db(address) values('" + txtaddress.text + "')
this address contain :-
Mr.Krish,
NH Road,
India.

its show error in comma operator.
so How to insert datas with comma operator ???
plz give solution for this..

Yours,
KaNNaN

-----------------------------------------------------------------
"Success is When Ur Signature Becomes An Autograph"

Mail To : foreverkans@gmail.com

Re: How to insert datas with comma in sql ???

deepthy.p.m20-May-09 18:46

20-May-09 18:46

user insert quary in stored procedure
or
use the insert command following like this
;
cmd.Parameters.AddWithValue("@RegFirstAddress", txtFirstAddress.Text);
cmd.CommandText = "insert into Tbl_Registration(RegFirstAddress) values (@RegFirstAddress)";
cmd.ExecuteNonQuery();

use of calender

jainiraj20-May-09 18:07

20-May-09 18:07

How can I use calender in asp.net?I know there is control named "calander" but that shows whole calender.What I want is that it show only a button on click a calander display.

Re: use of calender

padmanabhan N20-May-09 18:20

20-May-09 18:20

you can use ajax calendar extender, it will be useful for u..

<%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="cc1">
....
....
<asp:textbox id="txtDatetime" runat="server"> <asp:imagebutton id="ImageButton3" runat="server"
="" imageurl="~/Images/icon-calendar.gif" causesvalidation="False">
<cc1:calendarextender id="CalendarExtender1" runat="server" format="dd/MM/yyyy" targetcontrolid="txtDatetime" popupbuttonid="ImageButton3">

<cc1:maskededitextender id="MaskedEditExtender1" runat="server"
="" targetcontrolid="txtDatetime" mask="99/99/9999">

......
......

Padmanabhan

Re: use of calender

jainiraj22-May-09 1:02

22-May-09 1:02

But it is not working.Infact after writing this code my design of page is disappearing.

checkbox

jainiraj20-May-09 18:02

20-May-09 18:02

I have a password mode textfield and a check box and a button.After giving password in textfield when checkbox is checked i.e. do true then button is enabled.But problem is,then password doesn't exist in textfield.How i can retrieve that password when button is clicked.

Re: checkbox

padmanabhan N20-May-09 18:15

20-May-09 18:15

sorry its a default property for the password field......it will automatically clears the values when any event fires....

Padmanabhan

Re: checkbox

Ramesh Swaminathan20-May-09 18:40

GridView Control - EditItemTemplate Controls

20-May-09 18:40

In the page load event, write the following code,

yourPasswordTextBox.Attributes["value"] = yourPasswordTextBox.Text;

Juvil John20-May-09 17:03

Juvil John

20-May-09 17:03

Hi, I have a grid, which has an ItemTemplate and an EditItemTemplate, my concern is how do I get the controls in the EditItemTemplate, my grid columns looked like this...

<asp:TemplateField HeaderText="Price Type" HeaderStyle-CssClass="first" SortExpression="PriceType"><br />
                        <ItemTemplate><br />
                            <asp:Label ID="lbl_pricingtype" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "PriceType[0].PriceTypeDesc[0].Description")%>'<br />
                                ToolTip='<%# DataBinder.Eval(Container.DataItem, "PriceType[0].PriceType")%>'></asp:Label><br />
                        </ItemTemplate><br />
                        <EditItemTemplate><br />
                            <asp:DropDownList ID="ddl_pricingtype" runat="server" CssClass="first" Width="90px" onchange="ddl_pricingtype_change(this.value)"><br />
                                <asp:ListItem Text="Please Select" Value="-1"></asp:ListItem><br />
                                <asp:ListItem Text="0 - Price1" Value="0"></asp:ListItem><br />
                                <asp:ListItem Text="1 - Price2" Value="1"></asp:ListItem><br />
                                <asp:ListItem Text="2 - Price3" Value="2"></asp:ListItem><br />
                            </asp:DropDownList><br />
                        </EditItemTemplate><br />
                        <HeaderStyle CssClass="first" /><br />
                        <ItemStyle CssClass="first" /><br />
                    </asp:TemplateField>

Now I can get the value from the ItemTemplate label using OnRowEditing event but I can't seem to find the Dropdownlist control to set the selecteditem.

Re: GridView Control - EditItemTemplate Controls

padmanabhan N20-May-09 18:28