ASP.NET

7-Sep-06 2:22

hello,

i have Sql Script file. what i want when i click on button then query under sql script file execute automatically and Table must be created on specified location.

is it possible?

thanx

Any Suggestion.

Not Active7-Sep-06 2:30

Not Active

7-Sep-06 2:30

Yes

only two letters away from being an asset

Amit Agarrwal7-Sep-06 2:45

7-Sep-06 2:45

could u tell me how can i do it.
plz thanx

Not Active7-Sep-06 3:55

Not Active

7-Sep-06 3:55

Oh, I thought you just wanted to know if it was possible. OMG | :OMG:

That's a different question then.;P

only two letters away from being an asset

Ista7-Sep-06 3:34

Ista

7-Sep-06 3:34

just send it through as text or use SQLDMO

--------------------------------------------------------

1 line of code equals many bugs. So don't write any!!

My mad coder blog

Amit Agarrwal7-Sep-06 3:38

Concurrency problem in asp.net

7-Sep-06 3:38

ok
i will send it as a text.but how it will run. or execute.
and where i will defined the location for creating the tables.
thanx

Balji7-Sep-06 2:03

Balji

7-Sep-06 2:03

Hi guys,
I have an interesting scenario. I have a web application created with asp.net 2005. There will be more users who will be using my web application. User's can use the login page to log in to the application and use sign out to logoff the application. My question is :- if for example a user from a machine 1 with an ID "Shankar" has signed into the application by providing the correct credentials and the same user is signing into the application with the same credentials, but this time from a differant machine. How should i prevent this from happening. Please help me out of this problem.

Regards
Shankar

Jay_se7-Sep-06 2:24

Jay_se

7-Sep-06 2:24

Hi,

Follow the below link. It ll guide you towards the solution.

http://www.aspfree.com/c/a/ASP.NET/Preventing-Simultaneous-Logons/3/[^]

Regards,

Jay

Ista7-Sep-06 3:38

Ista

7-Sep-06 3:38

check the ip address when signing in

--------------------------------------------------------

1 line of code equals many bugs. So don't write any!!

My mad coder blog

todd.010111017-Sep-06 5:18

todd.01011101

7-Sep-06 5:18

I don't think the IP is the way to go. (due to NAT, etc..) The IP is unreliable.

Ista7-Sep-06 9:13

Ista

7-Sep-06 9:13

yes, and due to the architecture of the web. Knowing the actual computer ID is unreliable also.

But you can still trace the IP to the origination IP. It all depends on how much effort you want to use.( there are tons of utilities that can trace this) But, using whois you can trace down the ISP and they usually use the same patterns for IP's.

I was on a spam rampage and I can trace anyone back to thier orignal IP that the email was sent from. Even if its sent within IP hider types. And if this tells me thier ip location, so will the requesting machine.

all you really need is the ISP server name and a few other bits which are inside the request header. Everything is traceable. There maybe hurdle, but tons of sites in the UK tell you how to get past anyone of them.

IP or a mac address is your best bet. But, last time i looked at a header the mac address wasn't there. And due to security you wont be able to get it, unless you create an active x control to run on your page. Much like AJAX.

Nick

--------------------------------------------------------

1 line of code equals many bugs. So don't write any!!

My mad coder blog

Stucked with System.Net.Sockets.SocketException

Amit Kumar G11-Sep-06 9:42

Amit Kumar G

11-Sep-06 9:42

Shankar

We had the same sort of functionality in our application and we are storing ip, flag , domain name and checking with or conditions. If any conditions return true value we display message to user. But I am not sure how flexible you are for changing your application design,

Amit

David Clerk7-Sep-06 0:39

David Clerk

7-Sep-06 0:39

Hi,

We are using MySql Connector 1.0.7, .Net Framework 1.1 and MySql 4.0.12. We are getting following error very frequently.

To resolve this error we have also changed our hosting server which is of .Net Framework 2. So error is occurring for both Framework 1.1 and 2.

But still we are stucked with it.

///////////////////////////////////////////////////////////////////

Server Error in '/' Application.
A request to send or receive data was disallowed because the socket is not connected and (when sending on a datagram socket using a sendto call) no address was supplied

Stack Trace:

[SocketException (0x2749): A request to send or receive data was disallowed because the socket is not connected and (when sending on a datagram socket using a sendto call) no address was supplied]
System.Net.Sockets.Socket.Shutdown(SocketShutdown how) +1005764
MySql.Data.Common.SocketStream.Read(Byte[] buffer, Int32 offset, Int32 count) +68
System.IO.BufferedStream.ReadByte() +103
MySql.Data.MySqlClient.PacketReader.ReadHeader() +16
MySql.Data.MySqlClient.PacketReader.OpenPacket() +119
MySql.Data.MySqlClient.NativeDriver.Open() +653
MySql.Data.MySqlClient.MySqlConnection.Open() +142
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +86
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061

///////////////////////////////////////////////////////////////////

Is there anyone who can get me out of this problem ?

Thanks in advance.

Need help

Trehan7-Sep-06 0:10

Trehan

7-Sep-06 0:10

Hi Friends,

I have a ASP.NET application that stores session information in Shared class, now everytime a new user comes the old users session information is written by the new user information. I understand thats how Shared variables work, but what app domains? can't we use app domains to isolate each user.

Any hints will be highly appreciated......

ThX in advance
Amit

Guffa7-Sep-06 0:28

7-Sep-06 0:28

AppDomains has no bearing on your problem what so ever.

The Session object has a collection that you can use to store user specific data. Example:

// store a value<br />
Session["userid"] = 42;<br />
<br />
// retrieve a value<br />
int userId = (int)Session["userid"];

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

Coding C#7-Sep-06 2:03

Coding C#

7-Sep-06 2:03

Hi,

you can use either of the

Session Variables
or
Coockie

Hope this works

Nitin...

Guffa7-Sep-06 4:10

7-Sep-06 4:10

Perhaps you should reply to the original poster instead. Smile | :)

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

Trehan7-Sep-06 19:36

Trehan

7-Sep-06 19:36

Hi,

I guess i was not able to make myself clear, here is what i meant
There is a class that has userName and Password properties

Public Class A

Property UserName as string()
Get End Get
Set End Set
End Property

Property Password as String()
Get End Get
Set End Set
End Property

End Class

This class in used in another class as variable
Public Class B

Public Shared objUser as ClassA

End Class

Now when user logs on login page these properties are set liek this
ClassB.objUser.UserName="XYZ"
ClassB.ObjUser.Password="XYZ"

and now when another user logs in the same variables got reset like this
ClassB.objUser.UserName="ABC"
ClassB.ObjUser.Password="ABC"

Thats what i want to avoid, i know this is flaw in design but the application is already been developed and deployed and therefore i want to avoid the rework.

Any Suggestions welcome
Thx
Amit

Guffa8-Sep-06 8:33

8-Sep-06 8:33

You have deployed a multi user application that only supports a single user? Nice... Wink | ;)

You have to change the way you store the values to make it work. As you already have noticed, a static (shared in VB) variable only exists once throughout the application.

You could keep track of the separate values for each user on your own, but why not use the Session object when it is intended for this?

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

site tracking

Amit Agarrwal6-Sep-06 23:50

6-Sep-06 23:50

any body can tell is there any function by which i can measure the bandwidth

usage by user.

i found that there are some tools which provide this Facility.

but how can i achieve by myself.

plz guide me

any suggestion.

thanx

Session Problem

monika_vasvani6-Sep-06 23:48

monika_vasvani

6-Sep-06 23:48

Hi every1

I want to know if i am not mentioned session timeout in my web.config file,then what will be effect on my application?

My second question is:I have mentioned session timeout as 20min in web.config file.I am accessing my application but after every 20min it gives an error "session expired".My system is not ideal.For my point view session is expired when system is ideal but my application is not ideal.What is the options for that?I am using InProc state.
If u have any solution,pls reply me.

Thanks
monika

Re: Session Problem

Guffa7-Sep-06 0:17