Re: pass in parameter from c# - C# Discussion Boards

Re: activex component can't create object on a small exe coded on vb dot net

9-Jun-09 20:29

Well, I would hope you've confirmed the ocx is present and registered.

Christian Graus

Driven to the arms of OSX by Vista.

"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.

I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp

alonchap9-Jun-09 20:32

alonchap

9-Jun-09 20:32

HE does not know what OCX , because his small app does not include anything in source

Re: activex component can't create object on a small exe coded on vb dot net

Christian Graus9-Jun-09 20:37

Re: activex component can't create object on a small exe coded on vb dot net

9-Jun-09 20:37

If his app doesn't have a reference to the OCX, how is he calling it ? If you don't know what the OCX is, why does your program require it ?

alonchap9-Jun-09 21:37

alonchap

9-Jun-09 21:37

There is no OCX inside his code.
Would be best if i could show you the code.

http://pastebin.com/d3971bd44

Thanks

Re: activex component can't create object on a small exe coded on vb dot net

saanj9-Jun-09 20:01

saanj

9-Jun-09 20:01

Yeah Chris, you are right. Thanks for pointing out and sorry from my side for the mistake.

Regards
Saanj

Either you love IT or leave IT...

pass in parameter from c#

Abdul Rahman Hamidy9-Jun-09 18:36

Abdul Rahman Hamidy

9-Jun-09 18:36

Dear All,
I have sql query which is

create proc sp_detail
(
@p varchar(max)
)
as
select * from tblName where code in (@p)

I am passing @p from c# application, but it doesent reterieve any data while there is data

cmd=new SqlCommand("sp_detail",p.con);
cmd.CommandType= CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@p",codes);
DataTable dtResult=new DataTable();
if (cmd.Connection.State!=ConnectionState.Open)
    cmd.Connection.Open();
dtResult.Load((cmd.ExecuteReader(CommandBehavior.CloseConnection)));

codes is a string which contains codes seperated by comma, as 28-2801,28-2802...
what is wrong here

Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan

Christian Graus9-Jun-09 19:10

9-Jun-09 19:10

This is a SQL question, really. You're passing the parameter in fine. If you enter your parameter as a variable and run the SQL, does it work then ? Might the issue be your parameter being escaped on the way in ?

Abdul Rahman Hamidy9-Jun-09 19:23

Abdul Rahman Hamidy

9-Jun-09 19:23

the thing is, if i use simpl select statement from c# application every thing works fine as
select * from community where code in ('28-2801','28-2802',...)
but when the store procedure is executed, i got the statement of that from profiler as follows
exec sp_details @p=N'28-2801,28-2802'

while these code exits in database, when i execute this statement from sql, it doesent retrieve a value while if i execute it like this
exec sp_details @p=N'28-2801'
then it returns a rows
with single code it retrieve data, but when passing it seperated by comma nothing is retrieved.
any error there?

Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan

Christian Graus9-Jun-09 19:24

9-Jun-09 19:24

The error seems obvious to me. Passing in your parameter means you specify the whole lot in one set of quotes, when you need to place quotes inside the string. So the value you pass in, needs to have those single quotes around each value, as in

Abdul Rahman Hamidy wrote:
'28-2801','28-2802'

and not

Abdul Rahman Hamidy wrote:
'28-2801,28-2802'

Abdul Rahman Hamidy9-Jun-09 19:44

Abdul Rahman Hamidy

9-Jun-09 19:44

i thought the same as you, but i have done following from sql server, still i am getting no records

<br />
declare @codes varchar(max)<br />
select @codes=cast(quotename('28-2801','''')+','+quotename('28-2802','''') as varchar(max))<br />
print @codes --prints '28-2801','28-2802'<br />
exec [sp_detail] @codes

this doesent work too.
i think first i have to execute the statement in sql server, then i can simply can execute from c#.
in above statement any thing goes worong?

Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan

Christian Graus9-Jun-09 20:39

9-Jun-09 20:39

hmmm.... perhaps there's a reason that I don't know why you can't pass in a string like that. Have you tried string mashing the sql in your proc, or just creating the SQL in code instead of using a proc ?

I think at this point you'd be better asking in the SQL forum ( where this question belonged from the start ), because that's where the SQL heavyweights will be hanging out .

problem with datatable.importrow

saurabh sahay11-Jun-09 5:37

saurabh sahay

11-Jun-09 5:37

Asking in the SQL forum would be best

prasadbuddhika9-Jun-09 17:58

prasadbuddhika

9-Jun-09 17:58

i'm trying to get a selected range of data from a data set into a new data set,i use an array(dr2) of data rows and from that i get one row at a time and add it to new datatable(dt2), after it is added to a data set.

DataSet ds2 = new DataSet();
            DataTable dt2 =new DataTable();

            for (int start = startindex ;start < startindex+5 ; start++)
            {
                DataRow dd = dr2[start];
                dt2.ImportRow(dd);
            }

            ds2.Tables.Add(dt2);

            return ds2;

but the problem is when the dataset is returned it has the table with correct no of row, but the rows contain no data, what might be the problem

Re: problem with datatable.importrow

prasadbuddhika9-Jun-09 18:07

prasadbuddhika

9-Jun-09 18:07

sorry to disturb you people , i just found the solution , i missed the clone the table ,
thanx.

Re: problem with datatable.importrow

saurabh sahay11-Jun-09 5:42

saurabh sahay

11-Jun-09 5:42

Perfect!!

WebCamLib Problem

S K Y9-Jun-09 16:55

S K Y

9-Jun-09 16:55

How can i use avicap32.dll. in example i found some one user WebCamLib....may i know how can i user it? what reference?

using WebCamLib;

how can i add WebCamLib to my reference?

A S E L A

Christian Graus9-Jun-09 17:07

9-Jun-09 17:07

Have you tried searching the web, or reading articles on this site ?

S K Y9-Jun-09 19:26

S K Y

9-Jun-09 19:26

yes, and i found

object selectUsingUI = System.Reflection.Missing.Value;			// = Nothing
			wiaRoot = (ItemClass) wiaManager.Create( ref selectUsingUI );	// let user select device
			if( wiaRoot == null )											// nothing to do
				return;

			// this call shows the common WIA dialog to let the user select a picture:
			wiaPics = wiaRoot.GetItemsFromUI( WiaFlag.SingleImage, WiaIntent.ImageTypeColor ) as CollectionClass;

can please explane what happen by this code.....

i can access the webcam. i want to show output in a picturebox now. later capture image.

A S E L A

S K Y9-Jun-09 20:30

S K Y

9-Jun-09 20:30

can't i use picturebox to camera capture other than using WIA dialog to show....???

A S E L A

How to create the winform with code not by the guide (project-->add-->windows Form) at desgin-time in c#?

saurabh sahay11-Jun-09 5:47

saurabh sahay

11-Jun-09 5:47

This article[^] will help

mctramp1689-Jun-09 15:39

mctramp168

9-Jun-09 15:39

How to create the winform with code not by the guide (project-->add-->windows Form) at desgin-time in c#? and how to add some button in the dynamic created winform?

Many thanks

Re: How to create the winform with code not by the guide (project-->add-->windows Form) at desgin-time in c#?

Christian Graus9-Jun-09 15:45

Re: How to create the winform with code not by the guide (project-->add-->windows Form) at desgin-time in c#?

9-Jun-09 15:45

I would recommend the Petzold book on Winforms, he creates everything in code. To add a button to a form, you create it, and add it to the controls collection of the form. Then you tell it where it sits ( x,y,width,height)

mctramp1689-Jun-09 16:32

mctramp168

9-Jun-09 16:32

Thank Christian Graus, Could you please tell me the full name of the book ? and in which place I can order it.

Re: How to create the winform with code not by the guide (project-->add-->windows Form) at desgin-time in c#?

Christian Graus9-Jun-09 17:09