Click here to Skip to main content
15,920,576 members
Home / Discussions / C#
   

C#

 
GeneralRe: Getting the associated executable - regex help! Pin
benjymous26-Sep-07 0:27
benjymous26-Sep-07 0:27 
GeneralRe: Getting the associated executable - regex help! Pin
m@u26-Sep-07 2:15
m@u26-Sep-07 2:15 
QuestionHow can i change color of part of the text that will appear on Static Label ? Pin
Yanshof25-Sep-07 22:38
Yanshof25-Sep-07 22:38 
AnswerRe: How can i change color of part of the text that will appear on Static Label ? Pin
Christian Graus25-Sep-07 22:42
protectorChristian Graus25-Sep-07 22:42 
GeneralRe: How can i change color of part of the text that will appear on Static Label ? Pin
Yanshof25-Sep-07 22:50
Yanshof25-Sep-07 22:50 
GeneralRe: How can i change color of part of the text that will appear on Static Label ? Pin
Malcolm Smart26-Sep-07 3:48
Malcolm Smart26-Sep-07 3:48 
GeneralRe: How can i change color of part of the text that will appear on Static Label ? Pin
Pete O'Hanlon26-Sep-07 9:40
mvePete O'Hanlon26-Sep-07 9:40 
QuestionHelp access database and select statement Pin
KppsK25-Sep-07 22:35
KppsK25-Sep-07 22:35 
My application is connected with access database called BaseStudents!
This database have table with name: tblSudents. The first field in table
tblStudents is "StudentID" type:number(long int) and also primary key,
second field is "Name of Student" etc...
So my problem is, when my application will insert some data in table 'tblStudents'
it would look like this:

StudentID Name

1 Jack
2 Tom
3 Mike
4 Peter
5 Paul
6 Maria
7 Jean
8 David
9 Jesse
10 Vik
11 Alex
.....

Then, my application can delete from this table, but if someone
delete records with number: 2,3,4,5,6,7,8
the table 'StudentID' it would look like this:

StudentID Name

1 Jack
9 Jesse
10 Vik
11 Alex

Is there a way,when I delete records, the field 'StudentID'
to have a value: 1,2,3,4,5,...

I mean after deleting the table to look like this:

StudentID Name

1 Jack
2 Jesse
3 Vik
4 Alex

to renumber StudentID, to sequence number, not 1,8,9,10!


Second question:

I need help with select statement...
I know UPDATE,DELETE, INSERT, but SELECT with condition

like this(when I press button "Select", to execute code below)

"SELECT StudentID, Name, FatherName, LastName, years FROM [tblStudents]" + " WHERE Name=" +comboBoxName.Text+", FatherName="+comboBoxFatherName.Text+", LastName=" +comboBoxLastName.Text+", years=" +comboboxYears.Text+";";

So I want to select data who is equal from database tblStudents, and the data who user of my application
will pick from the comboBoxes.First, user pick value from comboBoxes, then press button "select"
and "selected" data should appear in dataGrid or dataView...

Is this correct?
Is this possible?

Please, if you have a free time and if you want to help me, reply to me...

All the best, from c# begginer to c# advanced...


sorry for bad english

kpp

AnswerRe: Help access database and select statement Pin
Christian Graus25-Sep-07 22:43
protectorChristian Graus25-Sep-07 22:43 
GeneralRe: Help access database and select statement Pin
KppsK25-Sep-07 23:17
KppsK25-Sep-07 23:17 
GeneralRe: Help access database and select statement Pin
leckey26-Sep-07 3:18
leckey26-Sep-07 3:18 
GeneralRe: Help access database and select statement Pin
Ri Qen-Sin30-Sep-07 2:45
Ri Qen-Sin30-Sep-07 2:45 
QuestionRead Large Text File Pin
satsumatable25-Sep-07 21:53
satsumatable25-Sep-07 21:53 
AnswerRe: Read Large Text File Pin
ESTAN25-Sep-07 23:42
ESTAN25-Sep-07 23:42 
AnswerRe: Read Large Text File Pin
benjymous26-Sep-07 0:30
benjymous26-Sep-07 0:30 
QuestionInput date in datagridview Pin
Thomas Ngoc25-Sep-07 21:44
Thomas Ngoc25-Sep-07 21:44 
QuestionTransfering Video File through Sockets Pin
DeepOceans25-Sep-07 21:37
DeepOceans25-Sep-07 21:37 
QuestionConnection pooling in multithreaded environment Pin
rakeshaparna25-Sep-07 21:20
rakeshaparna25-Sep-07 21:20 
AnswerRe: Connection pooling in multithreaded environment Pin
il_masacratore27-Sep-07 21:48
il_masacratore27-Sep-07 21:48 
AnswerRe: How to create Gantt Chart with Crystalreport in C# Winform? Pin
Malcolm Smart25-Sep-07 21:24
Malcolm Smart25-Sep-07 21:24 
GeneralTo the OP of this thread.... Pin
Malcolm Smart25-Sep-07 22:01
Malcolm Smart25-Sep-07 22:01 
GeneralRe: How to create Gantt Chart with Crystalreport in C# Winform? Pin
Malcolm Smart25-Sep-07 22:12
Malcolm Smart25-Sep-07 22:12 
GeneralRe: How to create Gantt Chart with Crystalreport in C# Winform? Pin
Pete O'Hanlon25-Sep-07 23:05
mvePete O'Hanlon25-Sep-07 23:05 
QuestionCreating a HTML file Pin
M. J. Jaya Chitra25-Sep-07 20:42
M. J. Jaya Chitra25-Sep-07 20:42 
AnswerRe: Creating a HTML file Pin
Sathesh Sakthivel26-Sep-07 0:27
Sathesh Sakthivel26-Sep-07 0:27 

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.