ASP.NET Discussion Boards

Re: record deleting - java script.

Sonia Gupta26-Oct-07 2:22

Sonia Gupta

26-Oct-07 2:22

if u can please provide the code.
thanks .

Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1

Re: record deleting - java script.

Sathesh Sakthivel26-Oct-07 2:27

Sathesh Sakthivel

26-Oct-07 2:27

I cannot do your work Tell your problem in your code so that we can correct it and help you to solve your problem.

SSK.

Anyone who says sunshine brings happiness has never danced in the rain.

Re: record deleting - java script.

Sonia Gupta26-Oct-07 2:33

Sonia Gupta

26-Oct-07 2:33

The basic problem is , i am not being able to place , how i should delete the particular record from the database , when i click ok on the confirmation button.if u please provide the code?
Thank You

Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1

Re: record deleting - java script.

Imran Khan Pathan26-Oct-07 2:43

Imran Khan Pathan

26-Oct-07 2:43

if you call javascript on button click event then put code on button event.

Re: record deleting - java script.

Sonia Gupta26-Oct-07 3:35

Sonia Gupta

26-Oct-07 3:35

it is the window closing button, not the button control.

Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1

Re: record deleting - java script.

N a v a n e e t h26-Oct-07 2:28

N a v a n e e t h

26-Oct-07 2:28

Sonia Gupta wrote:
if u can please provide the code.
thanks .

Hey it's Satips. it have some limitations. He would be glad to provide link than code

My Website | Ask smart questions

Re: record deleting - java script.

Sathesh Sakthivel26-Oct-07 2:30

Sathesh Sakthivel

26-Oct-07 2:30

Cool Navaneeth.

SSK.

Anyone who says sunshine brings happiness has never danced in the rain.

Re: record deleting - java script.

Sonia Gupta26-Oct-07 2:35

Sonia Gupta

26-Oct-07 2:35

Navaneeth please provide any code or link .It is very urgent.

Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1

Re: record deleting - java script.

Sathesh Sakthivel26-Oct-07 2:36

Sathesh Sakthivel

26-Oct-07 2:36

We cannot provide code for this it is very simple.

SSK.

Anyone who says sunshine brings happiness has never danced in the rain.

Re: record deleting - java script.

Sonia Gupta26-Oct-07 2:42

Sonia Gupta

26-Oct-07 2:42

then give the code and prove it......Come on sir(Satips)SSK

Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1

Re: record deleting - java script.

N a v a n e e t h26-Oct-07 2:51

N a v a n e e t h

26-Oct-07 2:51

Sonia Gupta wrote:
and while i click the ok button , at that time , can i delete a particular record from the database

By confirmation button, do you mean a javascript confirm ? You can do this using a AJAX call. See the code below

if(confirm("Are you sure to close"))
{
    //Do a AJAX call to server and delete the record
    return true; //it will close the window
}

My Website | Ask smart questions

Re: record deleting - java script.

Sonia Gupta26-Oct-07 2:54

Sonia Gupta

26-Oct-07 2:54

ajax call ? how to do that ?Please help ....If u can please arranege code.Thank You

Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1

Re: record deleting - java script.

N a v a n e e t h26-Oct-07 3:00

N a v a n e e t h

26-Oct-07 3:00

Sonia Gupta wrote:
ajax call ?

Don't you heard that ? It's just javascript, calling server side methods. http://www.w3schools.com/ajax/default.asp[^] check this to get started.

Alternatively try redirecting to someother page and do the deletion over there. See the below code

if(confirm("are you sure"))
{
   window.location.href="YourDeletePage.aspx";
   return false;
}

On page_load of this delete page, do the deletion and close the window. But I am not sure on this method, just try your luck. But AJAX method will work as you expected. D'Oh! | :doh:

My Website | Ask smart questions

Re: record deleting - java script.

Imran Khan Pathan26-Oct-07 3:20

Imran Khan Pathan

26-Oct-07 3:20

N a v a n e e t h wrote:
if(confirm("are you sure"))
{
window.location.href="YourDeletePage.aspx";
return false;
}

Why are you return false here?

Re: record deleting - java script.

N a v a n e e t h26-Oct-07 3:24

N a v a n e e t h

26-Oct-07 3:24

Just to keep window active. else it will be closed.

My Website | Ask smart questions

Re: record deleting - java script.

Vasudevan Deepak Kumar26-Oct-07 3:16

Vasudevan Deepak Kumar

26-Oct-07 3:16

Sonia Gupta wrote:
ajax call

Check out a simple XMLHttp example here:

http://www.scss.com.au/family/andrew/webdesign/xmlhttprequest/[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

Re: record deleting - java script.

Imran Khan Pathan26-Oct-07 3:26

Imran Khan Pathan

26-Oct-07 3:26

When you click Ok then it return true.so you can run your code in code behind file and after that the form will be close.
if you have one button to close the window then you can write your code on that button event.it will run on Ok event of message.

Note: if you want to close the parent page then browser also fires one confirm message

bEst rEgard
pAthan

problem with databaseconnectivity in webservices

christefer26-Oct-07 1:56

christefer

26-Oct-07 1:56

hi this is RK iam working with webservics in asp.net in that iam trying to use databaseconnectivity iam passing this query in dataadopter " select dtlastupdated,dblvalue from dbo.tblPerodicTickerData where dtDateTime = between 2007-03-28 11:35:09.000 a.m And 2007-04-09 11:40:05.000 a.m"
while using this websrvice in asp.net page iam getting the error like this
"System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'between'."

whAT DO I DO TO RECTIFY THIS ERROR COULD U PLEASE KINDLY HELP ME

OK BYE

Re: problem with databaseconnectivity in webservices

kubben26-Oct-07 3:00

kubben

26-Oct-07 3:00

Change your select to:
select dtlastupdated,dblvalue from dbo.tblPerodicTickerData where dtDateTime between '2007-03-28 11:35:09.000' And '2007-04-09 11:40:05.000'

And I think it will work.

There is no = between and I removed the a.m and put quotes around the datetime values.

Hope that helps.
Ben

Re: problem with databaseconnectivity in webservices

christefer26-Oct-07 4:23

christefer

26-Oct-07 4:23

yes it is working thak u very much rightfrom morning onwards iam suffering with this problem once thank u very much

how to create button arrays [modified]

ajsgja26-Oct-07 1:49

ajsgja

26-Oct-07 1:49

i want to create a calculator..so i want to take an array of buttons for checking whether a button clicked is an operator ,digit,or anything else? can any body help me???????

-- modified at 9:27 Friday 26th October, 2007

Re: how to create button arrays

Imran Khan Pathan26-Oct-07 2:19

Imran Khan Pathan

26-Oct-07 2:19

call same event for all buttons and get clicked button id in the textbox.
for example

protected void calendar_Click(object sender, EventArgs e)
 {
    TextBox1.Text=((Button)Sender)).Text
 }

bEst rEgard
pAthan

please don't forget to vote on the post that helped you.

Re: how to create button arrays

Sonia Gupta26-Oct-07 2:21

Sonia Gupta

26-Oct-07 2:21

as u specified ver clearly that the sender contains the control information.
can i ask , what's the utility of eventargs here?

Soniagupta1@yahoo.co.in
Yahoo Messenger Id = soniagupta1

Re: how to create button arrays

Sathesh Sakthivel26-Oct-07 2:24

Sathesh Sakthivel

26-Oct-07 2:24

R u a Programmer or a Student.

SSK.

Anyone who says sunshine brings happiness has never danced in the rain.

Re: how to create button arrays

ajsgja26-Oct-07 3:29

ajsgja

26-Oct-07 3:29

just a beginer

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.