Click here to Skip to main content
15,889,808 members
Home / Discussions / C#
   

C#

 
GeneralRe: Beginners help with classes Pin
PIEBALDconsult2-Dec-10 8:25
mvePIEBALDconsult2-Dec-10 8:25 
AnswerRe: Beginners help with classes Pin
#realJSOP2-Dec-10 3:21
mve#realJSOP2-Dec-10 3:21 
GeneralRe: Beginners help with classes Pin
kruegs352-Dec-10 3:45
kruegs352-Dec-10 3:45 
GeneralRe: Beginners help with classes Pin
Jeff Connelly2-Dec-10 4:53
Jeff Connelly2-Dec-10 4:53 
GeneralRe: Beginners help with classes Pin
DaveyM692-Dec-10 9:30
professionalDaveyM692-Dec-10 9:30 
AnswerRe: Beginners help with classes Pin
V.2-Dec-10 23:31
professionalV.2-Dec-10 23:31 
QuestionExecuteNonQuery Problem Pin
Erdinc272-Dec-10 1:40
Erdinc272-Dec-10 1:40 
AnswerRe: ExecuteNonQuery Problem PinPopular
Hiren solanki2-Dec-10 1:46
Hiren solanki2-Dec-10 1:46 
erdinc27 wrote:
for (int i = 0; i < table.Rows.Count; i++)
{
cmd.Parameters.AddWithValue("@cek_no", System.Data.SqlDbType.NVarChar).Value = table.Rows[i][0].ToString();


Creating a parameter inside loop indicates you are creating same parameter with the same name again and again.

So my advice would be to declare parameter outside a loop and then set values only of that inside loop.

E.G.

C#
cmd.parameters.add(\\add parameter name with datatype here);
Loop
{
   cmd.parameters["\\name of the parameter"].Value = \\Set value here.
}


Thanks.
Regards,
Hiren.

"The more we give of anything, the more we shall get back." - Grace Speare
(you can consider this quote while giving vote also)

Microsoft Dynamics CRM

GeneralRe: ExecuteNonQuery Problem Pin
Eddy Vluggen2-Dec-10 1:53
professionalEddy Vluggen2-Dec-10 1:53 
GeneralRe: ExecuteNonQuery Problem Pin
Erdinc272-Dec-10 2:05
Erdinc272-Dec-10 2:05 
AnswerRe: ExecuteNonQuery Problem Pin
musefan2-Dec-10 1:47
musefan2-Dec-10 1:47 
GeneralRe: ExecuteNonQuery Problem Pin
musefan2-Dec-10 6:25
musefan2-Dec-10 6:25 
QuestionError regarding crystal report? Pin
Tridip Bhattacharjee2-Dec-10 1:31
professionalTridip Bhattacharjee2-Dec-10 1:31 
AnswerRe: Error regarding crystal report? Pin
Hiren solanki2-Dec-10 1:50
Hiren solanki2-Dec-10 1:50 
QuestionWinForms VS. WebForms Pin
treuveni2-Dec-10 1:24
treuveni2-Dec-10 1:24 
AnswerRe: WinForms VS. WebForms Pin
Hiren solanki2-Dec-10 1:32
Hiren solanki2-Dec-10 1:32 
AnswerRe: WinForms VS. WebForms Pin
Sathesh Sakthivel2-Dec-10 1:50
Sathesh Sakthivel2-Dec-10 1:50 
GeneralRe: WinForms VS. WebForms Pin
Hiren solanki2-Dec-10 1:57
Hiren solanki2-Dec-10 1:57 
GeneralRe: WinForms VS. WebForms Pin
Ankur\m/2-Dec-10 2:44
professionalAnkur\m/2-Dec-10 2:44 
GeneralRe: WinForms VS. WebForms Pin
Chris Maunder2-Dec-10 12:24
cofounderChris Maunder2-Dec-10 12:24 
QuestionC# window app to listen multiple port simultaneously.. Pin
ayandelhi1-Dec-10 23:41
ayandelhi1-Dec-10 23:41 
AnswerRe: C# window app to listen multiple port simultaneously.. Pin
Luc Pattyn2-Dec-10 0:38
sitebuilderLuc Pattyn2-Dec-10 0:38 
GeneralRe: C# window app to listen multiple port simultaneously.. Pin
ayandelhi2-Dec-10 5:57
ayandelhi2-Dec-10 5:57 
AnswerRe: C# window app to listen multiple port simultaneously.. Pin
Luc Pattyn2-Dec-10 5:59
sitebuilderLuc Pattyn2-Dec-10 5:59 
GeneralRe: C# window app to listen multiple port simultaneously.. Pin
ayandelhi2-Dec-10 6:09
ayandelhi2-Dec-10 6:09 

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.