Comments by Member 9956178

Member 9956178 12-Jun-13 6:50am View

Create a class Connect separetly for Connect
like this
ublic SqlConnection con;
public Connect()
{
con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString);
}
public void OpenCon()
{
try
{
con.Close();
con.Open();
}
catch (Exception)
{
con.Open();
}

}
public void CloseC()
{
try
{

con.Close();

}
catch (Exception e)
{
con.Close();
}
Then for Save
do using(Sqlconnection con = new Sqlconnection(Connect.getconnectionsource()))
{
// save method is correct
}
Keeping connection class sepate will help you in many ways!
...or if you do not want this..
You need to call Open() before Sqlcommand cmd = new sqlcommand(); statement

Member 9956178 12-Jun-13 1:33am View

I want a loop that searches from day 1 to 30/31/28 of a month
date is the first day of current month
dw returns 1 for sunday
so if dw is a sunday then count it
that's the logic
Its working well only in frist and second itration, moreover dw returns 4 for sunday in Vstudio (may be Int 32 is a prb i guess)

Member 9956178 6-Jun-13 4:58am View

I had done like this;in an alternative way.. and I wd also like to know how to use Editshowing event.. Prb is that whenever I clik button at run time
Edit showing event does not get fired!

Member 9956178 6-Jun-13 4:57am View

I had done like this;in an alternative way.. and I wd also
like to know how to use Editshowing event.. Prb is that when I clik button Edit showing event does not get fired!

Comments by Member 9956178 (Top 4 by date)