Click here to Skip to main content
15,893,368 members
Home / Discussions / C#
   

C#

 
AnswerRe: Form Controls Pin
Robert Rohde13-Sep-05 8:40
Robert Rohde13-Sep-05 8:40 
GeneralRe: Form Controls Pin
deepscyberpulse13-Sep-05 16:40
deepscyberpulse13-Sep-05 16:40 
QuestionWindows Application Security - Best Practices Pin
AnneThorne13-Sep-05 8:07
AnneThorne13-Sep-05 8:07 
QuestionOracle Error Pin
Taurian11013-Sep-05 6:24
Taurian11013-Sep-05 6:24 
QuestionDROP TABLE execute Pin
zaboboa13-Sep-05 6:23
zaboboa13-Sep-05 6:23 
AnswerRe: DROP TABLE execute Pin
Mohamad Al Husseiny13-Sep-05 7:34
Mohamad Al Husseiny13-Sep-05 7:34 
AnswerRe: DROP TABLE execute Pin
Mohamad Al Husseiny13-Sep-05 8:04
Mohamad Al Husseiny13-Sep-05 8:04 
AnswerRe: DROP TABLE execute Pin
Colin Angus Mackay13-Sep-05 8:12
Colin Angus Mackay13-Sep-05 8:12 
It looks like you are stuck in the mentality of using DataAdapters for everything. Remember that they are just higher level wrappers around existing functionality that is exposed else where. You are creating larger bulkier objects to do work that can easily be achieved with smaller more dynamic objects.

You should just create a SqlConnection and SqlCommand object and call ExecuteNonQuery() on it. e.g.
SqlConnection conn = new SqlConnection(myConnectionString);
SqlCommand cmd = new SqlCommand("DROP TABLE ea_CashFlowTest", conn);
try
{
    conn.Open();
    cmd.ExecuteNonQuery();
}
catch(SqlException ex)
{
    // Do stuff to handle errors on the database.
}
finally
{
    // Make sure the connection is closed afterwards.
    conn.Close();
}


I hope this helps.


My: Blog | Photos

"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious


GeneralRe: DROP TABLE execute Pin
zaboboa13-Sep-05 9:12
zaboboa13-Sep-05 9:12 
QuestionAdding second header column to DataGrid Pin
zaboboa13-Sep-05 6:19
zaboboa13-Sep-05 6:19 
QuestionCalling a JAVA Webservice from .NET over http/1.0 Pin
Anonymous13-Sep-05 5:39
Anonymous13-Sep-05 5:39 
QuestionCalling a JAVA Webservice from .NET over http/1.0 Pin
SimonPust13-Sep-05 5:24
SimonPust13-Sep-05 5:24 
AnswerRe: Calling a JAVA Webservice from .NET over http/1.0 Pin
Andy Brummer13-Sep-05 6:27
sitebuilderAndy Brummer13-Sep-05 6:27 
QuestionCreate 2 forms from button press Pin
LiamD13-Sep-05 4:31
LiamD13-Sep-05 4:31 
AnswerRe: Create 2 forms from button press Pin
QuietKnight13-Sep-05 4:46
QuietKnight13-Sep-05 4:46 
AnswerRe: Create 2 forms from button press Pin
Dave Kreskowiak13-Sep-05 4:54
mveDave Kreskowiak13-Sep-05 4:54 
AnswerRe: Create 2 forms from button press Pin
LiamD13-Sep-05 21:28
LiamD13-Sep-05 21:28 
GeneralRe: Create 2 forms from button press Pin
Large Data File13-Sep-05 21:39
Large Data File13-Sep-05 21:39 
GeneralRe: Create 2 forms from button press Pin
LiamD14-Sep-05 0:31
LiamD14-Sep-05 0:31 
GeneralRe: Create 2 forms from button press Pin
Large Data File29-Oct-05 22:43
Large Data File29-Oct-05 22:43 
QuestionDrawing a polygon Pin
subramanyeswari13-Sep-05 2:33
subramanyeswari13-Sep-05 2:33 
AnswerRe: Drawing a polygon Pin
Dave Kreskowiak13-Sep-05 5:51
mveDave Kreskowiak13-Sep-05 5:51 
GeneralRe: Drawing a polygon Pin
subramanyeswari14-Sep-05 4:25
subramanyeswari14-Sep-05 4:25 
GeneralRe: Drawing a polygon Pin
Dave Kreskowiak14-Sep-05 12:42
mveDave Kreskowiak14-Sep-05 12:42 
QuestionHow do I tell .NET where to put my referenced DLLs when using "Copy Local" Pin
MaWeRic13-Sep-05 2:26
MaWeRic13-Sep-05 2:26 

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.