Click here to Skip to main content
15,917,328 members
Home / Discussions / C#
   

C#

 
AnswerRe: Formula Translation Pin
CPallini28-Apr-09 1:58
mveCPallini28-Apr-09 1:58 
GeneralRe: Formula Translation Pin
punitxsmart28-Apr-09 2:09
punitxsmart28-Apr-09 2:09 
GeneralRe: Formula Translation Pin
CPallini28-Apr-09 2:12
mveCPallini28-Apr-09 2:12 
QuestionMSBuild / Microsoft.Build... nyaaargh! Pin
Wenff28-Apr-09 1:32
professionalWenff28-Apr-09 1:32 
AnswerRe: MSBuild / Microsoft.Build... nyaaargh! Pin
SeMartens28-Apr-09 1:41
SeMartens28-Apr-09 1:41 
AnswerRe: MSBuild / Microsoft.Build... nyaaargh! Pin
Wenff29-Apr-09 6:00
professionalWenff29-Apr-09 6:00 
QuestionDataGridView index problem = VS2008 C# Pin
DlogDash28-Apr-09 1:08
DlogDash28-Apr-09 1:08 
AnswerRe: DataGridView index problem = VS2008 C# Pin
musefan28-Apr-09 2:20
musefan28-Apr-09 2:20 
GeneralRe: DataGridView index problem = VS2008 C# [modified] Pin
DlogDash28-Apr-09 11:27
DlogDash28-Apr-09 11:27 
QuestionRegular Expression validator for currecny Pin
Member 254517628-Apr-09 1:03
Member 254517628-Apr-09 1:03 
AnswerRe: Regular Expression validator for currecny Pin
musefan28-Apr-09 2:16
musefan28-Apr-09 2:16 
GeneralRe: Regular Expression validator for currecny Pin
Member 254517628-Apr-09 2:20
Member 254517628-Apr-09 2:20 
GeneralRe: Regular Expression validator for currecny Pin
musefan28-Apr-09 2:48
musefan28-Apr-09 2:48 
GeneralRe: Regular Expression validator for currecny Pin
Member 254517629-Apr-09 18:00
Member 254517629-Apr-09 18:00 
QuestionAbout the certification validation period Pin
Roshanakak28-Apr-09 0:56
Roshanakak28-Apr-09 0:56 
QuestionUsing Block - Call Function Pin
dataminers28-Apr-09 0:46
dataminers28-Apr-09 0:46 
I write ExecuteDataSet function;

public DataSet ExecuteDataSet(string commandText, string tableName, SqlParameter[] parameters)
{
try
{
OpenConnection();
using (SqlCommand command = new SqlCommand(commandText, this.connection))
{
command.Parameters.Add(AddParameter(command, parameters));

using (SqlDataAdapter dataAdapter = new SqlDataAdapter(command))
{
DataSet ds = new DataSet();
dataAdapter.Fill(ds, tableName);
CloseConnection();
return ds;
}
}
}
catch (Exception ex)
{
//Exception Log
CloseConnection();
return null;
}
}


I wan to call AddParameter() fuction in the using block. Bu I get error.

private SqlParameterCollection AddParameter(SqlCommand command, SqlParameter[] parameters)
{
foreach (SqlParameter param in parameters)
{
command.Parameters.Add(new SqlParameter(param.ParameterName, param.Value));
}

return command.Parameters;
}

How can I do?

AddParameter() using in a lot of function. If I write foreach loop in the using block so code is repated a lot.
AnswerRe: Using Block - Call Function Pin
SeMartens28-Apr-09 0:51
SeMartens28-Apr-09 0:51 
QuestionHelp with drawing Pin
Johnny Jackson28-Apr-09 0:10
Johnny Jackson28-Apr-09 0:10 
AnswerRe: Help with drawing Pin
Henry Minute28-Apr-09 0:32
Henry Minute28-Apr-09 0:32 
AnswerRe: Help with drawing Pin
Bharat Jain28-Apr-09 0:34
Bharat Jain28-Apr-09 0:34 
AnswerRe: Help with drawing Pin
Rob Philpott28-Apr-09 0:56
Rob Philpott28-Apr-09 0:56 
GeneralRe: Help with drawing Pin
Johnny Jackson28-Apr-09 1:40
Johnny Jackson28-Apr-09 1:40 
GeneralRe: Help with drawing Pin
musefan28-Apr-09 2:04
musefan28-Apr-09 2:04 
GeneralRe: Help with drawing Pin
Johnny Jackson28-Apr-09 20:15
Johnny Jackson28-Apr-09 20:15 
GeneralRe: Help with drawing Pin
musefan28-Apr-09 22:01
musefan28-Apr-09 22:01 

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.