Click here to Skip to main content
15,902,112 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: Is it possible to launch sub without autopostback in DDL? Pin
Dave Sexton5-Sep-06 0:23
Dave Sexton5-Sep-06 0:23 
GeneralRe: Is it possible to launch sub without autopostback in DDL? Pin
ii_noname_ii5-Sep-06 0:47
ii_noname_ii5-Sep-06 0:47 
GeneralRe: Is it possible to launch sub without autopostback in DDL? Pin
ii_noname_ii5-Sep-06 1:06
ii_noname_ii5-Sep-06 1:06 
QuestionType library exporter encountered a type that derives from a generic class Pin
rsegijn4-Sep-06 20:11
rsegijn4-Sep-06 20:11 
Questionclearing a data table Pin
MAJackson4-Sep-06 18:12
MAJackson4-Sep-06 18:12 
AnswerRe: clearing a data table Pin
S Douglas4-Sep-06 23:48
professionalS Douglas4-Sep-06 23:48 
GeneralRe: clearing a data table Pin
MAJackson5-Sep-06 11:57
MAJackson5-Sep-06 11:57 
GeneralRe: clearing a data table Pin
S Douglas5-Sep-06 14:14
professionalS Douglas5-Sep-06 14:14 
MAJackson wrote:
Thankyou


Your welcome.


MAJackson wrote:
Obviously I will have to learn SQL.


The basics; C.R.U.D. (Create, Read, Update, Delete)
C == Insert into Table (column) values ('value')
R == Select Column From Table
U == Update Table Set column='value'
D == Delete * From Table

All of those queries support the where clause, where is filtering for specific data.
There is lots to learn, I sugguest a good ADO.NET book and a TSQL book.


MAJackson wrote:
Especially since I want to reset the automatically generated key values to start from 1 every time. My guess is that I will have to remove the table from the database, and recreate it in code, each time I reload the table.


That's a lot of work and you loose all of that data, consider creating a seperate table with one integer column using that as the counter and every week resetting it back to one. When you need a new number read the current value increment by one and update it. Add a new counter column to your current schema and leave the primary key there to do its thing.


MAJackson wrote:
It was a case of loading the data by hand...over many weeks; or writing a program to do it...over many weeks...and getting a learning experience out of it. This way was a lot more fun.


Nothing like letting a computer do what it was designed to do. Smile | :)





I'd love to help, but unfortunatley I have prior commitments monitoring the length of my grass. :Andrew Bleakley:


QuestionHow I can get the text of a textbox that is on other app? Pin
Marco22504-Sep-06 14:54
Marco22504-Sep-06 14:54 
QuestionCalculating Date Pin
Nikhil Bandekar4-Sep-06 8:21
Nikhil Bandekar4-Sep-06 8:21 
AnswerRe: Calculating Date Pin
Guffa4-Sep-06 8:40
Guffa4-Sep-06 8:40 
GeneralRe: Calculating Date Pin
Nikhil Bandekar4-Sep-06 23:18
Nikhil Bandekar4-Sep-06 23:18 
QuestionCreate a Control Pin
Magno R. Vasquez4-Sep-06 8:13
Magno R. Vasquez4-Sep-06 8:13 
Questioninsert datatable into database Pin
playout4-Sep-06 7:30
playout4-Sep-06 7:30 
AnswerRe: insert datatable into database Pin
Dave Sexton5-Sep-06 0:44
Dave Sexton5-Sep-06 0:44 
QuestionWeb Part behaviour in Window Form Pin
Mohamed Ali Jinnah4-Sep-06 7:06
Mohamed Ali Jinnah4-Sep-06 7:06 
QuestionHelp with .NET Pin
Tommy4U4-Sep-06 6:22
Tommy4U4-Sep-06 6:22 
AnswerHelp with .NET Pin
Kanniah5-Sep-06 4:17
Kanniah5-Sep-06 4:17 
QuestionStamping PDF Pages Pin
Mansurali4-Sep-06 5:40
Mansurali4-Sep-06 5:40 
QuestionDatagrid display parent and child records (datarelation) Pin
Izak -4-Sep-06 5:07
Izak -4-Sep-06 5:07 
AnswerRe: Datagrid display parent and child records (datarelation) Pin
Dave Sexton5-Sep-06 0:46
Dave Sexton5-Sep-06 0:46 
GeneralRe: Datagrid display parent and child records (datarelation) Pin
Izak -5-Sep-06 3:15
Izak -5-Sep-06 3:15 
QuestionDeployment of A program in VB.Net Pin
FriendlySoluations4-Sep-06 4:35
FriendlySoluations4-Sep-06 4:35 
AnswerRe: Deployment of A program in VB.Net Pin
KreativeKai5-Sep-06 5:53
professionalKreativeKai5-Sep-06 5:53 
QuestionDeployment of A program in VB.Net Pin
FriendlySoluations4-Sep-06 4:32
FriendlySoluations4-Sep-06 4:32 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.