Click here to Skip to main content
15,912,504 members
Home / Discussions / .NET (Core and Framework)
   

.NET (Core and Framework)

 
QuestionRSA Keys Pin
smalltime26-Sep-10 20:36
smalltime26-Sep-10 20:36 
AnswerRe: RSA Keys Pin
Heinzzy2-Oct-10 9:15
Heinzzy2-Oct-10 9:15 
Question.NET 2-3 day training in NYC? [modified] Pin
Mihai Pruna24-Sep-10 5:30
Mihai Pruna24-Sep-10 5:30 
AnswerRe: .NET 2-3 day training in NYC? Pin
Richard MacCutchan24-Sep-10 5:52
mveRichard MacCutchan24-Sep-10 5:52 
AnswerRe: .NET 2-3 day training in NYC? Pin
Abhinav S24-Sep-10 7:17
Abhinav S24-Sep-10 7:17 
QuestionI have a column called bookedhalls, the value will be stored as Balaji-A,Balaji-C as text, i need to select that row i written query like select * from function where bookedhalls like '%Balaji-A,Balaji-C,% if i interchanged to '%Balaji-C,Balaji-A,% i Pin
sr15923-Sep-10 21:52
sr15923-Sep-10 21:52 
AnswerRe: How to select only particular text in column data Pin
Richard MacCutchan23-Sep-10 22:13
mveRichard MacCutchan23-Sep-10 22:13 
Answerbad table structures Pin
T M Gray24-Sep-10 11:46
T M Gray24-Sep-10 11:46 
Your database is not designed correctly if you are storing multiple pieces of data in one column. BookedHalls should probably be a separate table. So the functions table has all the other details of the function including an ID. Then the bookedHalls table has the function ID in it. Then you say select * from function where functionID in (select functionID from bookedHalls where hallName like '%Balaji-A%' or hallName like '%Balaji-C%').

And actually even that is sloppy database design. There should be a halls table and it should contain a hallID, then the bookedHalls would have just a functionID and a hallID. That way your application can have a drop-down with all of the valid halls. And if you got fancy you could even do lookups to make sure a hall isn't in use for a function at the same time.

This kind of thing is referred to as data normalization. You should study it if you are going to create databases.

Please read the guidelines on how to ask a question. That subject line is awful.
QuestionEditions in VSTS Pin
NetQuestions23-Sep-10 3:15
NetQuestions23-Sep-10 3:15 
AnswerRe: Editions in VSTS Pin
Pete O'Hanlon23-Sep-10 4:26
mvePete O'Hanlon23-Sep-10 4:26 
AnswerRe: Editions in VSTS Pin
The Man from U.N.C.L.E.23-Sep-10 6:29
The Man from U.N.C.L.E.23-Sep-10 6:29 
QuestionVSTS - fill in the blanks Pin
NetQuestions23-Sep-10 2:38
NetQuestions23-Sep-10 2:38 
AnswerRe: VSTS - fill in the blanks Pin
The Man from U.N.C.L.E.23-Sep-10 2:50
The Man from U.N.C.L.E.23-Sep-10 2:50 
GeneralRe: VSTS - fill in the blanks Pin
NetQuestions23-Sep-10 3:08
NetQuestions23-Sep-10 3:08 
GeneralRe: VSTS - fill in the blanks Pin
The Man from U.N.C.L.E.23-Sep-10 3:20
The Man from U.N.C.L.E.23-Sep-10 3:20 
AnswerRe: VSTS - fill in the blanks Pin
Pete O'Hanlon23-Sep-10 3:01
mvePete O'Hanlon23-Sep-10 3:01 
GeneralRe: VSTS - fill in the blanks Pin
NetQuestions23-Sep-10 3:10
NetQuestions23-Sep-10 3:10 
Questionadding a panel to a form. Pin
bimbambumbum22-Sep-10 13:53
bimbambumbum22-Sep-10 13:53 
AnswerRe: adding a panel to a form. Pin
bimbambumbum22-Sep-10 14:03
bimbambumbum22-Sep-10 14:03 
AnswerRe: adding a panel to a form. Pin
Luc Pattyn22-Sep-10 14:04
sitebuilderLuc Pattyn22-Sep-10 14:04 
GeneralRe: adding a panel to a form. [modified] Pin
bimbambumbum22-Sep-10 14:42
bimbambumbum22-Sep-10 14:42 
AnswerRe: adding a panel to a form. Pin
Luc Pattyn22-Sep-10 15:28
sitebuilderLuc Pattyn22-Sep-10 15:28 
GeneralRe: adding a panel to a form. Pin
bimbambumbum22-Sep-10 17:04
bimbambumbum22-Sep-10 17:04 
AnswerRe: adding a panel to a form. Pin
Luc Pattyn22-Sep-10 17:13
sitebuilderLuc Pattyn22-Sep-10 17:13 
GeneralRe: adding a panel to a form. Pin
bimbambumbum25-Sep-10 4:46
bimbambumbum25-Sep-10 4:46 

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.