Data Lost on Multiple Request in Asp.Net Web site

Pnkl

10y1.2k.NET

Hello Guys,

I have Developed one website in Asp.Net 4.0 And Sql Server 2012 And I used 3-tier Data Access method but sometimes many requests are occur then data lost from Sql Server Db so why this happen?

If you have solution then reply me.

Below is my sample code

in DataClass.cs filldata method :

public static SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ConnectionString);

public static DataTable Filladptor(SqlCommand cmd)

{

DataTable dt = new DataTable();

cmd.Connection = cn;

SqlDataAdapter adp = new SqlDataAdapter(cmd);

try

{

//cmd = new SqlCommand();

if (cn.State == ConnectionState.Closed)

{

cn.Open();

}

adp.Fill(dt);

}

catch (Exception ex)

{

errmsg = ex.Message;

}

finally

{

cmd.Dispose();

if (cn.State == ConnectionState.Open)

{

cn.Close();

}

return dt;

}

IN Webconfig Connectionstring:

Thanks..

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pnkl10y ago
Hello guys

Please.., Reply me if you have any answer about my que?
Hemant Joshi10y ago
There is something called Session, if you are using it increase the session timeout using Session.Timeout = 60 (any value depending on you). If you are talking about sql connection then you need to check at first that connection is open or not, if it is close open it again.

conn.State = Connection.Open
Pnkl10y ago
Suppose Many Users Acces Website From Many Locations at time and continue accessing (30 minute or 60 minute) then sometimes data lost or connection lost from server so you have solution for that then help me to resolve it
Hemant Joshi10y ago
What do you mean by multiple requests, multiple requests means that you calling delete query multiple times or just you are opening and closing the connection multiple times.