473,385 Members | 1,983 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

CLEAR the Table "login" on closing of the form

1
Trying to CLEAR the Table "login" on closing of the form...

Expand|Select|Wrap|Line Numbers
  1.  public void remTempData()
  2.         {
  3.             string delete = "DELETE * FROM login";
  4.             SqlCommand rMove = new SqlCommand();
  5.             rMove.Connection = access;
  6.             rMove.CommandType = CommandType.Text;
  7.             rMove.CommandText = delete;
  8.             rMove.ExecuteNonQuery();
  9.         }
  10.  
  11.   private void frmPN_FormClosed(object sender, FormClosedEventArgs e)
  12.         {
  13.           remTempData();
  14.           Application.Exit();
  15.         }
  16.  
please help
Oct 13 '11 #1
1 1587
GaryTexmo
1,501 Expert 1GB
You'll have to tell us what happens when you do this... does the table just not clear out? Are there any exceptions that happen?
Oct 13 '11 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: eap90210 | last post by:
Hi to all ng I 'm a non expert user og db2 and i made a program that it connect to db2 and after goes to a table, verify that exists a value and after return success or not. My problem is...
0
by: dixie | last post by:
I am using Jan Goyvaerts excellent HelpScribble program. I am having a problem though with running an external html file from the help file within Access. I click the button, the button moves...
0
by: Trokey | last post by:
Here's my setup: Component A: .NET exe acting as a .NET remoting server. The channel type is tcp. Component B: .NET assembly acting as a .NET remoting client with event handlers for server...
7
by: Mat | last post by:
I am developping multi-user windows application. i use Access database. user edit, add and delete data from database. Request: when an item is deleted ,added or modified by an user, all others...
5
by: Alien2_51 | last post by:
I have a problem with a ListBox control that is on a TabControl, it seems to be forgetting which items are selected in the list when I tab off the current tab, here's my winform code... I even...
3
by: ken | last post by:
Hello, I can't figure out how to solve this problem. I modified the timer example given in the help section. It increments a count every 3 millisecond in order to simulate a tank being filled with...
0
by: Eric | last post by:
Visual C++ 2005 Express MVP's and experience programmer's only please!... I need to get the number of lines in a textbox so I can insert them into a listview. The text comes from my database...
21
by: softwindow | last post by:
#include "stdio.h" #include "malloc.h" struct student{ int age; char *nms; struct student *next; }; struct student *create(){ int ags=0,size=sizeof(struct student); char *nms=" ";
2
by: Piojolopez | last post by:
Hello guys, I have a problem with this code, the program is the resolution of Sudoku grid, the grid in my program is a vector of STL,and i use a list of STL for the right solution for each cell, to...
4
by: muddy22 | last post by:
I'm only having a problem with a small part, i'm fairly new to computer programming and the program i'm using is Dev-C++. The part that i'm having a problem with is this: int WINAPI WinMain...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.