Click here to Skip to main content
15,907,905 members
Home / Discussions / C#
   

C#

 
GeneralRe: Which ones are free databases? Pin
Luc Pattyn1-Feb-10 8:15
sitebuilderLuc Pattyn1-Feb-10 8:15 
AnswerRe: Which ones are free databases? Pin
Daniel Grunwald1-Feb-10 23:02
Daniel Grunwald1-Feb-10 23:02 
QuestionHide row in Tablelayoutpanel in c# Pin
anoopkamboj1-Feb-10 4:36
anoopkamboj1-Feb-10 4:36 
AnswerRe: Hide row in Tablelayoutpanel in c# Pin
Not Active1-Feb-10 4:40
mentorNot Active1-Feb-10 4:40 
AnswerRe: Hide row in Tablelayoutpanel in c# Pin
Dave Kreskowiak1-Feb-10 6:15
mveDave Kreskowiak1-Feb-10 6:15 
AnswerRe: Hide row in Tablelayoutpanel in c# [modified] Pin
Gerry Schmitz1-Feb-10 12:19
mveGerry Schmitz1-Feb-10 12:19 
QuestionLanguage of ColorDialog(ColorEditor) and FontDialog in PropertyGrid [modified] Pin
akamper1-Feb-10 3:30
akamper1-Feb-10 3:30 
QuestionSSHA how to encode a string in C#. Pin
AWriter1-Feb-10 2:35
AWriter1-Feb-10 2:35 
AnswerRe: SSHA how to encode a string in C#. Pin
Not Active1-Feb-10 3:53
mentorNot Active1-Feb-10 3:53 
AnswerRe: SSHA how to encode a string in C#. Pin
AWriter1-Feb-10 5:52
AWriter1-Feb-10 5:52 
GeneralRe: SSHA how to encode a string in C#. Pin
Garth J Lancaster1-Feb-10 10:30
professionalGarth J Lancaster1-Feb-10 10:30 
GeneralRe: SSHA how to encode a string in C#. Pin
AWriter1-Feb-10 21:17
AWriter1-Feb-10 21:17 
GeneralRe: SSHA how to encode a string in C#. Pin
Garth J Lancaster2-Feb-10 0:20
professionalGarth J Lancaster2-Feb-10 0:20 
QuestionWPF Books Pin
Sunil G1-Feb-10 2:25
Sunil G1-Feb-10 2:25 
AnswerRe: WPF Books Pin
Nagy Vilmos1-Feb-10 2:30
professionalNagy Vilmos1-Feb-10 2:30 
AnswerRe: WPF Books Pin
Richard MacCutchan1-Feb-10 3:01
mveRichard MacCutchan1-Feb-10 3:01 
AnswerRe: WPF Books Pin
Pete O'Hanlon1-Feb-10 4:13
mvePete O'Hanlon1-Feb-10 4:13 
QuestionGmail APi's Pin
Anil Kumar.Arvapalli1-Feb-10 2:13
Anil Kumar.Arvapalli1-Feb-10 2:13 
AnswerRe: Gmail APi's Pin
Not Active1-Feb-10 2:21
mentorNot Active1-Feb-10 2:21 
AnswerRe: Gmail APi's Pin
SergGM24-Nov-10 0:16
SergGM24-Nov-10 0:16 
GeneralRe: Gmail APi's Pin
Norbert Szenasi27-Dec-10 6:27
Norbert Szenasi27-Dec-10 6:27 
QuestionDExplore issue Pin
dwolver1-Feb-10 2:13
dwolver1-Feb-10 2:13 
AnswerRe: DExplore issue Pin
ricmil421-Feb-10 3:26
ricmil421-Feb-10 3:26 
QuestionNeed to Import table & query from one MS Access databas to another. Pin
honeyashu1-Feb-10 2:01
honeyashu1-Feb-10 2:01 
AnswerRe: Need to Import table & query from one MS Access databas to another. [modified] Pin
Dan Mos1-Feb-10 2:51
Dan Mos1-Feb-10 2:51 
Well you should post it in the DB forum/section.

Anyway here's one way how you could do it(the query):

OleDbCommnand cmd =  new OledbCommand(con);

//create a Select for example
cmd.CommandText = "CREATE PROC nameOfQueryHere(inName VARCHAR(50))
AS SELECT * FROM tblNameHere
WHERE tblNameHere.Name = inName";

//and create the query/proc by executing the command

cmd.ExecuteNonQuery();


Of course try catch and all that is up to you. I just posted an ideea.

[EDIT]The same technique for creating a table.
Use a command string in witch you create the table and execute it[/EDIT]

modified on Monday, February 1, 2010 9:07 AM

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.