Re: How to insert datas with comma in sql ??? - ASP.NET Discussion Boards

First Prev Next

Re: Messagebox and alerts

Ramesh Swaminathan20-May-09 19:10

Ramesh Swaminathan

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')");

validate Dropdownlist inside gridview using javascript

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

deepthy.p.m

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

Re: validate Dropdownlist inside gridview using javascript

padmanabhan N20-May-09 19:03

padmanabhan N

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

Re: validate Dropdownlist inside gridview using javascript

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

deepthy.p.m

20-May-09 19:08

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

Re: validate Dropdownlist inside gridview using javascript

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

deepthy.p.m

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

jainiraj

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

padmanabhan N

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

jainiraj

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

jainiraj

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

padmanabhan N

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

Ramesh Swaminathan

20-May-09 18:40

In the page load event, write the following code,

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

GridView Control - EditItemTemplate Controls

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

padmanabhan N

20-May-09 18:28

refer and download from the following link :

GridView all in one[^]

Padmanabhan

Re: GridView Control - EditItemTemplate Controls

Juvil John20-May-09 18:29

Juvil John

20-May-09 18:29

what link?

Re: GridView Control - EditItemTemplate Controls

padmanabhan N20-May-09 18:37

padmanabhan N

20-May-09 18:37

there is a sample program in which using EditItemTemplates are given..

Padmanabhan

Re: GridView Control - EditItemTemplate Controls

Juvil John20-May-09 18:38

Juvil John

20-May-09 18:38

thanks dude. twas a great article.

Re: GridView Control - EditItemTemplate Controls

padmanabhan N20-May-09 18:44

padmanabhan N

20-May-09 18:44

its my own article.. if u like that then vote for that article...

Padmanabhan

Problem with ScriptManager.RegisterStartupScript

sarang_k20-May-09 16:59

sarang_k

20-May-09 16:59

Hi all,

Since i am using ajax,so to display the messages i am using ScriptManager.RegisterStartupScript. and i am getting messages but the problem is after getting message when i click ok other controls on the page doesn't work.

can any one tell me the solution for it.

Thanks in advance.

Re: Problem with ScriptManager.RegisterStartupScript

padmanabhan N20-May-09 18:43

padmanabhan N

20-May-09 18:43

// I am not sure how your code looks like, but i am using like this and it works fine for me.

ClientScript.RegisterStartupScript(this.GetType(), "Open", "OpenPopup('"+ ... +"')");

Padmanabhan

Global Coding Standard

Civic0620-May-09 15:01

Civic06

20-May-09 15:01

Is there a global coding standard for asp.net development? What is it called?

Re: Global Coding Standard

Yusuf20-May-09 15:56

Yusuf

20-May-09 15:56