Click here to Skip to main content
15,902,189 members
Home / Discussions / C#
   

C#

 
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 
GeneralRe: Help with drawing [modified] Pin
Johnny Jackson28-Apr-09 22:57
Johnny Jackson28-Apr-09 22:57 
GeneralRe: Help with drawing Pin
musefan29-Apr-09 2:27
musefan29-Apr-09 2:27 
QuestionCreating Excel Pin
justindhas28-Apr-09 0:08
justindhas28-Apr-09 0:08 
AnswerRe: Creating Excel Pin
Henry Minute28-Apr-09 0:24
Henry Minute28-Apr-09 0:24 
QuestionConverting Word 2007 document to HTML Pin
Sudhir Mangla27-Apr-09 23:29
professionalSudhir Mangla27-Apr-09 23:29 
QuestionVista UAC: run as another user with admin rights Pin
mSh198527-Apr-09 23:22
mSh198527-Apr-09 23:22 
AnswerRe: Vista UAC: run as another user with admin rights Pin
Johnny Jackson28-Apr-09 23:09
Johnny Jackson28-Apr-09 23:09 
AnswerRe: Vista UAC: run as another user with admin rights Pin
mSh198528-Apr-09 23:25
mSh198528-Apr-09 23:25 

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.