ASP.NET

How do i add a record to SQL2005 ??

13-Nov-06 4:11

Hi.

u can get id of user when user disconnected application
call this javascript on onbeforeunload event on body

function EventClose(){
if((window.event.clientX<0) || (window.event.clientY<0)){
// get user id and store in hidden fild
}
}

u can store userid of user in database

Pathan

munklefish13-Nov-06 1:31

munklefish

13-Nov-06 1:31

Hi,

This is my first time of using an SQL(2005) database so please help me out.

How do insert data into a new record?? An example would be appreciated.

THANKS!

coolestCoder13-Nov-06 1:43

coolestCoder

13-Nov-06 1:43

Hi,

munklefish wrote:
This is my first time of using an SQL(2005) database so please help me out.

I hope you know how to write insert queries in other databases(SQL Server / Oracle). If you know the queries and how to execute them for other databases, then it is the same case here.

Hope i got your point ...

"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder

coolestCoder

munklefish13-Nov-06 1:45

munklefish

13-Nov-06 1:45

Thanks, that helped a great deal!

Why come on a help forum if youre just gonna be a smart ass?

Guffa13-Nov-06 2:35

Guffa

13-Nov-06 2:35

If you talk that way to people who try to help you, who do you expect to get help from in the future?

coolestCoders point is valid. For a basic insert statement there is no difference what so ever between SQL 2005 and other SQL based databases. If you don't know any SQL at all, a web search like "sql insert" would give you plenty of examples on how it's done.

A message board like this is not the best place to find information like that. As the question has been answered countless times before in articles, blogs, documentation and message boards, most of the time you will only be instructed to look at the available information. You will find that the message board will work much better for when you have a specific question.

---
b { font-weight: normal; }

munklefish13-Nov-06 2:38

munklefish

13-Nov-06 2:38

Ah right so telling me i should already know is a valid answer?

Dont think so or else i wouldnt be asking really would i.

RichardGrimmer13-Nov-06 2:47

RichardGrimmer

13-Nov-06 2:47

He's not just telling you that you should already know (which to be fair, you should if you want to be a programmer - INSERT statements are going to be your bread and butter), he's also telling you that a simple web search will sort you out....

People here will always be prepared to help, but you have to at least try to help yourself first. Google is your friend.

"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox

Folder creation in client...

Guffa13-Nov-06 3:23

Guffa

13-Nov-06 3:23

munklefish wrote:
Ah right so telling me i should already know is a valid answer?

I think that he made the assumption that you already knew something about SQL, as you asked specifically for SQL Server 2005. This assumption was of course not very well grounded, but that is because you provided very little information in your question.

Are you learning anything about how message boards work from this, or are you just trolling?

---
b { font-weight: normal; }

ManickaSudar12-Nov-06 23:57

ManickaSudar

12-Nov-06 23:57

Hai,

I want to create a directory in the system localharddisk through my Web application(C# Asp.Net) . I used this coding inside the button click event.

System.IO.Directory.CreateDirectory("c:\\FolderName");

While running it creates a folder successfully in my system. When i try to run this same application from another system(client), the creation process is happening in server only. I want to create the folder in that particular systems harddisk(ie,client). In What way i can implement it... Give the solution.........

Thanks......................

Thanks in Advance

Sandeep Akhare13-Nov-06 0:32

13-Nov-06 0:32

Write the javascript to create the folder it will create on client side not on server side

Suresh Pirsquare13-Nov-06 2:09

Suresh Pirsquare

13-Nov-06 2:09

I dont think that you can create a folder on client side using javascript.

Smile | :)

Regards,

Suresh Dayma

Everything Is Possible!

Sandeep Akhare13-Nov-06 3:06

13-Nov-06 3:06

Yes you are but i think we can create folder using Activex object

_AK_13-Nov-06 3:08

_AK_

13-Nov-06 3:08

yes by using activex objects in javascript you can probably create the folder on client side.

Best Regards,
Apurva Kaushal

Sandeep Akhare13-Nov-06 3:53

Alert message by clicking close control box

13-Nov-06 3:53

take a view of this code to create folder on client side using javascript

function CreateFolder()
{ var myPath
var oas = new ActiveXObject("Scripting.FileSystemObject");
myPath = "C:\\NUnit\\sandeep12345";
oas.CreateFolder(myPath);

alert("Helo");
//insert_filename(fn);
}

Imran Khan Pathan12-Nov-06 23:47

12-Nov-06 23:47

Hi friends

I want to disable close cotrol box of title bar

Or

i want to give alert message when user click on close control box to close form.

how can I do it?

plz reply me

its urgent.

Thanks

pathan

Sathesh Sakthivel12-Nov-06 23:51

Sathesh Sakthivel

12-Nov-06 23:51

you can do it by Javascriptt.

Regards,

Satips.

Imran Khan Pathan13-Nov-06 0:06

13-Nov-06 0:06

Hi.

But on which event i call javascript and which function is used for close control box

Pathan

Sandeep Akhare13-Nov-06 0:28

Re: Alert message by clicking close control box [modified]

13-Nov-06 0:28

ya Imran
you can do that by capturing the IE close event in the javacript

Sandeep Akhare13-Nov-06 0:59

13-Nov-06 0:59

yes write a function on body onbeforeunload

function unloadEvent()
{
if(window.screenLeft < 10004)
{
page refresh
}
else
{
close button is click do here what you want to do before closing
}
}

-- modified at 7:22 Monday 13th November, 2006

Imran Khan Pathan13-Nov-06 2:15