C# Discussion Boards - CodeProject

Re: passing multiple parameters to the query in C#

Megidolaon4-Mar-09 2:04

4-Mar-09 2:04

An easy way is to only pass one string that is the full query.
You simply construct it by using variables in C# to read the input and then adding it to the query string.
You might have to add brackets and commas to the query string after the variables have been added.

Re: passing multiple parameters to the query in C#

J4amieC4-Mar-09 2:29

J4amieC

4-Mar-09 2:29

Worst answer you could have given, you've just told the OP to take aa step backwards to dynamically-built sql queries rather than using parameters.

You should read up on SQL Injection attacks.

Re: passing multiple parameters to the query in C#

fly9044-Mar-09 5:14

fly904

4-Mar-09 5:14

In most of my code I pass the parameters as a variable to another function which would make the code look like this:

SqlCeParameter[] sqlParams = new SqlCeParameter[4];

sqlParams[0] = new SqlCeParameter("@uname", textbox1.Text);
...

comm.Parameters.AddRange(sqlParams);

hmmm pie

TcpChannel disconnect

yesu prakash4-Mar-09 0:15

yesu prakash

4-Mar-09 0:15

Hi,

I connect a TcTcpChannel by using the following code

chan = new TcpChannel(400);
ChannelServices.RegisterChannel(chan);
RemotingConfiguration.RegisterWellKnownServiceType(Type.GetType("ScreenCapture, ScreenCapture"), "MyCaptureScreenServer", WellKnownObjectMode.Singleton);

i how can i disconnect it in a click event?

Regards,
YP

Re: TcpChannel disconnect

stancrm4-Mar-09 1:25

stancrm

4-Mar-09 1:25

http://msdn.microsoft.com/en-us/library/system.runtime.remoting.remotingservices.disconnect(VS.80).aspx[^]

Specified argument was out of the range of valid values. Parameter name: index.

haleemasher4-Mar-09 0:09

haleemasher

4-Mar-09 0:09

plz help
i have a code for datagrid and i want to update it. it shows error
"Specified argument was out of the range of valid values. Parameter name: index."
plz check errors

try
{
ErrorMessage.Text = "";
SqlCommand updCommand = new SqlCommand();
updCommand.Connection = cnx;
updCommand.CommandText="UPDATE Student_Attendance Set Course_Id='" + ((TextBox)e.Item.Cells[3].Controls[0]).Text
+"',Std_Id='"+((TextBox)e.Item.Cells[4].Controls[0]).Text
+"',Class_Id='"+((TextBox)e.Item.Cells[5].Controls[0]).Text
+"',Total_Lectures='"+((TextBox)e.Item.Cells[6].Controls[0]).Text
+"',Attended_Lectures='"+((TextBox)e.Item.Cells[7].Controls[0]).Text +"'";
updCommand.CommandType=CommandType .Text;
cnx.Open();
updCommand.ExecuteNonQuery();
da1.Fill(ds);
Cache["studentdata"]=ds;
DataGrid1.EditItemIndex= -1;
bindGrid();
cnx.Close();
}
catch (System.Exception ex)
{
ErrorMessage.Text=ex.Message;
}

Re: Specified argument was out of the range of valid values. Parameter name: index.

Shyam K Pananghat4-Mar-09 0:24

Shyam K Pananghat

4-Mar-09 0:24

check whether a column exist in the given index.. It says that the collection object doesn't have any items for your given index..

Shyam..

My Blog dotnetscoups.blogspot.com

Process.start don't work

abbd3-Mar-09 23:41

abbd

3-Mar-09 23:41

hello

When i excute this command in MS-dos:

U:\\convert C:\\ARV\\pdf\\70863).pdf C:\\ARV\\jpeg\\70863).JPEG

it work, but when i do this:

<br />
 Process.Start("U:\\convert  C:\\ARV\\pdf\\70863).pdf  C:\\ARV\\jpeg\\70863).JPEG   ");<br />

there an error : the file is not found ,

Thank you verry mutch

Re: Process.start don't work

Calin Tatar3-Mar-09 23:48

Calin Tatar

3-Mar-09 23:48

C:\\ARV\\pdf\\70863).pdf and C:\\ARV\\jpeg\\70863).JPEG are args?
try
Process.Start("U:\\convert","C:\\ARV\\pdf\\70863).pdf C:\\ARV\\jpeg\\70863).JPEG");

Re: Process.start don't work

Thomas Krojer4-Mar-09 0:40

Thomas Krojer

4-Mar-09 0:40

ProcessStartInfo psi = new ProcessStartInfo(@"cmd.exe", @"/c dir c:\ /s");
Process.Start(psi);

How to run a class library?

YiXiang_893-Mar-09 23:02

YiXiang_89

3-Mar-09 23:02

What is the step to run a class library?
if my starting form is: Form1.cs

Can teach me?

Thank you

Re: How to run a class library?

Eddy Vluggen3-Mar-09 23:06

Eddy Vluggen

3-Mar-09 23:06

Applications run, class libraries don't. You can create an "exe" that will load your class-library and then shows your Form1.

Is there a particular reason why your project needs to be a class-library? If not, you can simply change the project type by changing the properties of the project. (Right click on your projectname in the solution-explorer, click properties, open the tabpage "Application" and change the "Output type" to "Windows Application")

Or,

Create a new application, reference your class-library and start your form from there.

Good luck Smile | :)

I are troll Smile | :)

Re: How to run a class library?

YiXiang_894-Mar-09 2:14

YiXiang_89

4-Mar-09 2:14

How to do this?
Create a new application, reference your class-library and start your form from there.

I need to use class library as i need to generate html to pdf.
Which i still finding help with

Thank you

Re: How to run a class library?

Eddy Vluggen4-Mar-09 2:29

Eddy Vluggen

4-Mar-09 2:29

1. Start Visual Studio
2. Open your project (Ctrl-Shift-O)
3. Go to the solution-explorer (Ctrl-Alt-L)
4. Right-click with your mouse on the node called "References".
5. From the popupmenu, select "Add Reference"
6. Go to the tabpage called "Browse", and locate your "assembly.dll" file.

Now you got the reference to the assembly, and you're set up to use any Forms defined in that library in your application.

You can "use" libraries in your project, you just can't "start" them like you would start, say, Microsoft Word.

YiXiang_89 wrote:
I need to use class library as i need to generate html to pdf.

Any prior experience there?

I are troll Smile | :)

Re: How to run a class library? [modified]

Megidolaon4-Mar-09 2:16

Megidolaon

4-Mar-09 2:16

That quetsion sounds supsiciously like a homework and you have no idea how to do it, but are too lazy to even give it a try. D'Oh! | :doh:

Anyway, I don't know how to debug libraries and I don't think it's possible.
You need to make some kind of test program where you reference the dll and which test its methods.

modified on Friday, March 6, 2009 6:03 AM

how to generate an MSI for my excel addin project in c#

abhiram_nayan3-Mar-09 22:57

abhiram_nayan

3-Mar-09 22:57

I have my excel addin project written in c#, i would like to generate an MSI for this. How can I achieve that?

Thank you.

Re: how to generate an MSI for my excel addin project in c# [modified]

Shyam K Pananghat3-Mar-09 23:18

Shyam K Pananghat

3-Mar-09 23:18

Create a setup and deployment project. and overrride the Installer class..
There you get the necessary methods to install, commit , or rollback the installation.

i belive the namespace is System.Configuration.Install

Shyam..

My Blog dotnetscoups.blogspot.com

modified on Wednesday, March 4, 2009 5:31 AM

Re: how to generate an MSI for my excel addin project in c#

abhiram_nayan3-Mar-09 23:38

abhiram_nayan

3-Mar-09 23:38

i already have my project developed as a new project--> extensibility--> visual studio add-in

I want to build an MSI of this existing project. Am sorry but, did you mean I should create a new project which is a setup and deployement project?

thank you.

please send any suggetion in project

mulla md fozail3-Mar-09 23:28

mulla md fozail

3-Mar-09 23:28

please if any suggetion ssend for me in project in c#

Automated email

1sabine83-Mar-09 22:48

1sabine8

3-Mar-09 22:48

Hi,
I need to create a C#.net console application that will send an email to some email addresses.
Can anyone give me the needed code for that?
Thanks in advance

Re: Automated email

Eddy Vluggen3-Mar-09 23:03

Eddy Vluggen

3-Mar-09 23:03

Google for "c# console mail" and check out the first two results $Shucks | :-\$

I are troll Smile | :)

Re: Automated email

Aman Bhullar3-Mar-09 23:05

Aman Bhullar

3-Mar-09 23:05

private void Sendmail(string strMailMessage, string strSubject)
        {
            MailMessage myMail = new MailMessage();
            SmtpClient objSMTP = new SmtpClient("mail.domain.com");
            string strEmail = "a@domian.com,b@domain.com"; //ConfigurationSettings.AppSettings["CNotifyEmail"];
            string[] arrEMail = strEmail.Split(';');

            foreach (string strMail in arrEMail)
            {
                myMail.To.Add(strMail);
            }
            
            myMail.From = new MailAddress("info@domain.com");
            myMail.Subject = strSubject;
            myMail.Body = strMailMessage;
            myMail.IsBodyHtml = true;

            try
            {
                //obClient.Send(myMail);
                objSMTP.Send(myMail);
                Console.WriteLine("@@@ Notification Send....");
            }
            catch(Exception ex)
            {
                Console.WriteLine(ex.ToString());
                Console.WriteLine("@@@ FAILED TO SEND NOTIFICATION....");
            }

        }

Re: Automated email

Shyam K Pananghat3-Mar-09 23:25

Shyam K Pananghat

3-Mar-09 23:25

Really good sample.. but remember you cannot catch an unsent or bounce mail info here.. Smile | :)

It's just about the C# runtime error Laugh | :laugh:

Shyam..

My Blog dotnetscoups.blogspot.com

Re: Automated email

Xmen Real 4-Mar-09 4:26

Xmen Real

4-Mar-09 4:26

Amandeep Singh Bhullar wrote:

string strEmail = "a@domian.com,b@domain.com"; //ConfigurationSettings.AppSettings["CNotifyEmail"];
string[] arrEMail = strEmail.Split(';');

if I'm not wrong then you are splitting a wrong char ';'

TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87֦ʻ6ϣN8ȤBcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKSQXUFYK[M`UKs*$GwU#(QDXBER@CBN%
Rs0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-iTV.C\y<pjxsg-b$f4ia>
--------------------------------------------------------
128 bit encrypted signature, crack if you can

Re: Automated email

Aman Bhullar5-Mar-09 4:45

Aman Bhullar

5-Mar-09 4:45

I am sorry.

But in my code the Comma seprated Email's are stored AppConfig file.
Actually there is ';' than ','

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.