.NET (Core and Framework)

26-May-09 0:39

the page should be totally logged out from the account and control should pass directly to the Login page

Re: Logout code in C#

annathor27-May-09 0:57

annathor

27-May-09 0:57

yes, I agree, the page should be totally logged out.

Logout code in C#

manjusha s26-May-09 0:23

26-May-09 0:23

Actually i have written

Response.Redirect("Login.aspx");

on logout button,but i want totally to be logged out from the account and the
control should pass to login page again..

Thanks in advance

Re: Logout code in C#

Henry Minute26-May-09 0:26

Form Disposal and Null Containers

26-May-09 0:26

Stop making a new thread, when you are replying to a previous post.
Use the Reply rollover on the response you wish to reply to.

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

Tristan Rhodes26-May-09 0:14

26-May-09 0:14

Hi Guys,

I'm trying to get my forms to clean up after themselves when i dispose them. The designer builds all the lovely disposal pattern stuff, with the body:

<br />
            if (disposing && (components != null))<br />
            {<br />
                components.Dispose();<br />
            }<br />
            base.Dispose(disposing);<br />

Which is all well and good, but as i add components to the designer, i would assume they would be placed in a container and cleaned up when the form disposes, however, the container is always null, and hence the dispose is never called.

Because of this my background worker keeps running and my underlying win32 api calls are never closed down.

While i can (and will) do this the manual way, is there any way to have the designer wire up that logic for me?

Regards

Tris

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

Carrier Bags - 21st Century Tumbleweed.

Henry Minute26-May-09 0:33

26-May-09 0:33

If this is a Windows Forms application and you are adding the components using the designer the necessary code for disposing them is generated automatically, or at least should be.

As far as a background worker is concerned, it is working in the background, in a different thread, and that will continue to run. Try handling the FormClosing event and stop the background worker there.

Tristan Rhodes26-May-09 1:29

26-May-09 1:29

Henry Minute wrote:
or at least should be.

Yeah, i thought the same, but it's clearly not doing any finalizing or disposing when i close the form. The app is quite complicated, a lot of components being shared between multiple forms, but some of the forms contain components only applicable in that scope, and the form gets re-used, so i don't want to do cleanup on close, but only on dispose which occurs when the app gets dismantled.

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

Carrier Bags - 21st Century Tumbleweed.

Henry Minute26-May-09 1:34

26-May-09 1:34

Ah.
I'm not sure of what happens in Dispose() when the control/component is referenced elsewhere.
You could try handling Application.ApplicationExit maybe?

Tristan Rhodes26-May-09 3:31

26-May-09 3:31

I've got the Close event handled in the application host form, and it disposes the primary application container, but i was hoping it would tidy up the various components in the nested containers / forms.

(And thinking about this gives me a headache...)

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

Carrier Bags - 21st Century Tumbleweed.

Pete O'Hanlon26-May-09 4:24

26-May-09 4:24

Sounds like you need to consider using a WeakReference or two.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

Tristan Rhodes26-May-09 23:49

multiplication of columns

26-May-09 23:49

[Edit] - Never mind, i didn't realize that WeakReference was a class. I thought it was just the opposite of tight coupling. :P

Now... coffee...

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

Carrier Bags - 21st Century Tumbleweed.

manjusha s26-May-09 0:01

Re: multiplication of columns

26-May-09 0:01

Actually multiplication of MemberCount and Commission Should be done and result should get displayed in MemberGrandTotal when we hit Show button....and as the registration forms get filled by the customer automatically the values in MemberCount should be increased and as per that result should get displayed...Also the values in MemberCount should remain same to values in Distributor..It should not exceed the count.

My code is as below...

String s = "Data Source=.\\sqlexpress;Initial Catalog=MLM;Integrated Security=True";

SqlConnection con = new SqlConnection(s);

con.Open();

DataSet ds = new DataSet();
int Level=1;

foreach (DataRow dr in ds.Tables[Level].Rows)
{

String s1="Select MemberCount,Commission,MemberCount*Commission from LevelCount ";

}

//DataSet ds = new DataSet();

SqlCommand com = new SqlCommand(s1, con);
SqlDataReader rs = com.ExecuteReader();

while (rs.Read())
{

Label10.Text = rs.GetInt32(0).ToString();

Label9.Text = rs.GetInt32(2).ToString();

Label11.Text = rs.GetInt32(0).ToString();

Label12.Text = rs.GetInt32(0).ToString();

Label13.Text = rs.GetInt32(0).ToString();

Label14.Text = rs.GetInt32(0).ToString();

Label15.Text = rs.GetInt32(0).ToString();

Label16.Text = rs.GetInt32(2).ToString();

Label17.Text = rs.GetInt32(2).ToString();

Label18.Text = rs.GetInt32(2).ToString();

Label19.Text = rs.GetInt32(2).ToString();

Label20.Text = rs.GetInt32(2).ToString();

}

//rs[5] = s;

com.ExecuteNonQuery();

//rs.Close();

con.Close();

and table is as follows....

Level Distributors MemberCount Commission GrandTotal MemberGrandTotal

1 5 5 25
2 25 10 250
3 125 10 1250
4 625 10 6250
5 3125 10 31250
6 15625 15 234375

Show

Thanks in advance......

Henry Minute26-May-09 0:20

Re: multiplication of columns

26-May-09 0:20

I am afraid that the code you have posted is so badly broken, that I am at a loss to know how to help you.

Also your explanation of your problem is not sufficiently clear to enable me to attempt an answer.

Please try to rephrase your question, so that someone who is not familiar with your application, can understand what it is that you require.

manjusha s26-May-09 0:35

26-May-09 0:35

multiplication of columns MemberCount and Commission upto Levels 1 to 6 is to be done and result should be displayed into the column MemberGrandTotal

Sql Query

srinisiv25-May-09 23:05

srinisiv

25-May-09 23:05

Hi Sir
I am new for .net.I'm Creating Student mark list program.
I have one doubt in sql.
for every sql operation i am opening sql connection after i'm closing the connection.
is this wright?due to this any problem will come?

Pete O'Hanlon25-May-09 23:46

25-May-09 23:46

The answer to this one is "It depends". Is your application a desktop application running a local database instance? If so, it may be acceptable to open up a connection and leave it open for the duration of your processing (with appropriate code in place to take care of database crashes). Is this running on an ASP.NET application? If so, you MUST release the connection as soon as practically possible.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

srinisiv26-May-09 0:14

srinisiv

26-May-09 0:14

Dear Sir
I'm Using .net windows application & local instance only.
I'n my project i did't write code for closing the database,it is always open only.
What is My problem is Yesterday i asked my Crystal report view (first time) taking long time.
U replayed "//
If your database connection has not been pooled, then the first preview will take a lot longer than the second time where it's pulled from the pool.//" like this .thats y i'm asking i want to close or not(my database connection)

Pete O'Hanlon26-May-09 0:31

26-May-09 0:31

Again - this is up to you. Basically, when you open up a connection the first time, this takes quite a while - if you open it again and it's in a connection pool, the connection is taken from the pool (assuming you supply the same credentials). If you leave the connection open, then the first time it will take a while, but the next time it will be a lot faster because you won't have the overhead of opening the connection.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

srinisiv26-May-09 0:49

srinisiv

26-May-09 0:49

Once again thnx for ur Replay Sir.
Sir
Crystal report Preview i want fast,For that tell any one simple way.
I'm Not too intelligent please solve my problem.

Insert query

manjusha s25-May-09 21:24

25-May-09 21:24

The data is not getting inserted into the database...
i have written the following code...

SqlConnection con = new SqlConnection("Data Source=.\\sqlexpress;Initial Catalog=MLM;Integrated Security=True");
con.Open();
SqlCommand com = new SqlCommand("Insert into RegistrationForm(UserName,Pin_ID,SponserName,Sponser_Pin,Registration_Date,Main_Sponser_Name,Placement_Info,Title,Maritial_status,MemberName,CompanyName,Date_Of_Birth,Age_In_Years,Mother_Name,Address,City,State,PinCode,Phone_No,Mobile_No,Email_Id,Pan_No,Nominee_Name,Relation_with_member,Nominee_Birth_Date,Age,DD_No,Bank_Name,Branch_Name,Enter_Login_Password,Confirm_Login_Password,Enter_Pin_Password,Confirm_Pin_Password)values('" + TextBox30.Text + "','" + TextBox31.Text + "','" + TextBox26.Text + "','" + TextBox27.Text + "','" + TextBox28.Text + "','" + TextBox29.Text + "','" + RadioButtonList1.Text + "','" + DropDownList4.Text + "','" + DropDownList6.Text + "','" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox5.Text + "','" + TextBox6.Text + "','" + TextBox3.Text + "','" + TextBox7.Text + "','" + TextBox8.Text + "','" + DropDownList5.Text + "','" + TextBox9.Text + "','" + TextBox10.Text + "','" + TextBox11.Text + "','" + TextBox12.Text + "','" + TextBox13.Text + "','" + TextBox14.Text + "','" + TextBox15.Text + "'," + TextBox16.Text + "," + TextBox17.Text + ",'" + TextBox18.Text + "','" + TextBox19.Text + "','" + TextBox20.Text + "','" + TextBox21.Text + "','" + TextBox22.Text + "','" + TextBox23.Text + "','" + TextBox24.Text + "')", con);

string s1 = TextBox30.Text;
string s2 = TextBox28.Text;
string s3 = TextBox1.Text;
string s4 = TextBox7.Text;
string s5 = TextBox8.Text;

string s6 = DropDownList5.Text;
string s7 = TextBox9.Text;
string s8 = TextBox27.Text;
string s9 = TextBox26.Text;

Response.Redirect("Welcomeltr.aspx?TextBox30=" + s1 + " &TextBox28=" + s2 + "&TextBox1=" + s3 + "&TextBox7=" + s4 + "&TextBox8=" + s5 + "&DropDownList5=" + s6 + "&TextBox9=" + s7 + "&TextBox27=" + s8 + "&TextBox26=" + s9);

com.ExecuteNonQuery();
//com2.ExecuteNonQuery();
con.Close();

Thanks in advance

Re: Insert query

Pete O'Hanlon25-May-09 22:00

25-May-09 22:00

Several things come to mind looking at your code.

1. This isn't the ASP.NET forum.
2. Your variable naming convention sucks. TextBox28? TextBox29? What do they mean? Please - give variables a more meaningful name.
3. Your code is wide open to SQL Injection attacks.
4. You do a redirect before you ever attempt the execute on the SQL.
5. Your redirect is using unencode URL entries - what happens, for instance, if TextBox30 is "Hello there'.!***"?

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.