C# Discussion Boards - CodeProject

Re: Setting the httprequestheader.date

Ravi Bhavnani30-Mar-09 12:00

Ravi Bhavnani

30-Mar-09 12:00

AFAIK, the Date (and Host) properties are set by the system and cannot be changed in code.

/ravi

My new year resolution: 2048 x 1536
Home | Articles | My .NET bits | Freeware
ravib(at)ravib(dot)com

Searching within datagridview

Martin3108830-Mar-09 6:18

Martin31088

30-Mar-09 6:18

Hey everyone,

I've got a datagridview linked to an access database with a seach function. It's working well, but with one problem. It only displays the row(s) when you search for the complete User Name. It would be a big time saver if the search would locate any row(s) which contains the txtSearchID, so you would not need to type out the whole user name every time.

At the moment I am using:

Command.CommandText = "SELECT * FROM Users WHERE [User ID] = '" + txtSearchID.Text + "'";<br />
OleDbDataAdapter Adapter = new OleDbDataAdapter(Command);<br />
Adapter.Fill(ds);<br />

I'm sure theres a simple answer, just can't quite figure it out.

Any help greatly appreciated

Martin

Re: Searching within datagridview

celso_cabaleiro30-Mar-09 6:34

celso_cabaleiro

30-Mar-09 6:34

In access try

Command.CommandText = "SELECT * FROM Users WHERE [User ID] = '*" + txtSearchID.Text + "*'";

Re: Searching within datagridview

musefan30-Mar-09 6:54

musefan

30-Mar-09 6:54

you will want to use 'LIKE' instead of '='

example...

Command.CommandText = "SELECT * FROM Users WHERE [User ID] LIKE '%" + txtSearchID.Text + "%'";

of course what you really want to do is...

Command.CommandText = "SELECT * FROM Users WHERE [User ID] LIKE '%@1'";
Command.Parameters.Add("@1", OleDbType.Char).Value = txtSearchID.Text;

Life goes very fast. Tomorrow, today is already yesterday.

Re: Searching within datagridview

celso_cabaleiro30-Mar-09 7:07

celso_cabaleiro

30-Mar-09 7:07

I think he is using an access database, not Sql Server.

Better than %, he must use *

Command.CommandText = "SELECT * FROM Users WHERE [User ID] LIKE '*" + txtSearchID.Text + "*'";

but use parameters it´s a good choice.

Re: Searching within datagridview

musefan30-Mar-09 7:12

musefan

30-Mar-09 7:12

I use % with access and it works fine. What does * do that is better?

Life goes very fast. Tomorrow, today is already yesterday.

Re: Searching within datagridview

celso_cabaleiro30-Mar-09 7:25

celso_cabaleiro

30-Mar-09 7:25

Nothing into access it's better, but the "Jet sql" suggest using like with * as wild pattern.

If you use %, the OleDb Provider make the translation for you.

If you try

select * from table where field1 like '%something%'

in the query panel of access you get an empty result.

Re: Searching within datagridview

musefan30-Mar-09 7:32

musefan

30-Mar-09 7:32

OK, well thanks for the info, is good to know Smile | :)

But either way in the context it is being used then it does not matter if use * or %

Life goes very fast. Tomorrow, today is already yesterday.

Re: Searching within datagridview

celso_cabaleiro30-Mar-09 7:41

celso_cabaleiro

30-Mar-09 7:41

Yes, it´s true, the performing is the same.

If you want to know more about old things like the tenebrous jet sql,
you have this
and about the wildcard characters here.

Unsure | :~

Printing

mark_w_30-Mar-09 5:59

mark_w_

30-Mar-09 5:59

I have an interesting problem, but have no idea where to start, any help/links etc most welcome

The problem:

I want to create an c# app that any other application (eg, Word, Excel etc ) can print to (so i assume it would be a printer driver?? or printer queue??)

Once the file has been printed to the c# app I will save it out as a file in a specific location (hopefully as postscript).

How do applications like word send a file to a print driver? is it as a postscript file?

Thanks in advance for any comments

Mark

Re: Printing

Yusuf30-Mar-09 6:14

Yusuf

30-Mar-09 6:14

mark_w_ wrote:
I want to create an c# app that any other application (eg, Word, Excel etc ) can print to (so i assume it would be a printer driver?? or printer queue??)

Well, you can not write printer app. There is no such thing. But you can write virtual printer driver. Then any application can use your driver to write (send) data to your driver.

You can not use C# to write printer drivers too. Too bad, you need Windows Driver Kit [^].

Yusuf

Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]

Re: Printing

mark_w_30-Mar-09 6:22

mark_w_

30-Mar-09 6:22

I was just looking at virtual print drivers, thanks for the link, I may have to write a bit of C++.

How to find status of usercontrol wether it is cleared or not

Narendra Reddy Vajrala30-Mar-09 5:40

Narendra Reddy Vajrala

30-Mar-09 5:40

Hi all,
i have a usercontrol array. In that whatever the control i want to delete am clearing that in delete button, using UserControl[i].Controls.Clear(), itz fine.
and finally..., i want to check everycontrol wether that was in clear mode or visible mode.

How to check?

Thanks In Advance
--Naren
Blush | :O

Re: How to find status of usercontrol wether it is cleared or not

musefan30-Mar-09 6:47

musefan

30-Mar-09 6:47

I dont understand what you are trying to do. Do you want to access a control after you have cleared it? If so then you cant because clearing controls affectively deletes them

If you want something else then please try to explain again

Life goes very fast. Tomorrow, today is already yesterday.

Re: How to find status of usercontrol wether it is cleared or not

Narendra Reddy Vajrala31-Mar-09 2:29

Narendra Reddy Vajrala

31-Mar-09 2:29

Actually i have a usercontrol with 4buttons(1 DeleteButton), 1 textbox

In my form am creating usercontrol array(more than one usercontrols), After clicking on delete of a perticular user control am clearing that usercontrol from my panel. but
After Clearing the controls not deleting from my panel.just making invisible(i observed in debugging that, in array list it is showing cleared control also)

i want to chcek each and every usercontrol(from array) wether that control was cleared or not.

i hope am clear with my description.
i tried on creating a bool property in my usercontrol, on clicking deletebutton am making false that bool value., while checking am checking that bool value wether true or false. if false it was cleared control.

any other way to achieve this?

--Naren
Blush | :O

How Syncronize..in C#???

VisualLive30-Mar-09 5:16

VisualLive

30-Mar-09 5:16

Hi ,
i-m looking around to work out a feature im my project but i did not see nothing about that or useful, i need to synchronize Window Media PLayer with a ListBox or better i wish show in a listBox the current song that WMP is playing in real time and when WMP change the song the list box will change in syncronize with WMP .
Do you know any way to work out this feature or have any idea to make me calm down?
Smile | :)

Thanks in advantage and have a happy day.

Nice Regards

Re: How Syncronize..in C#???

dan!sh 30-Mar-09 5:44

dan!sh

30-Mar-09 5:44

Does this[^] helps?

जय हिंद

Re: How Syncronize..in C#???

lisan_al_ghaib30-Mar-09 5:44

lisan_al_ghaib

30-Mar-09 5:44

Hi,
The idea is to read specific media player registers. to get current played song informations:
In .net you can use the RegistryKey class to have acces to registers:
Note: Reg path from WMP: Software\Microsoft\MediaPlayer\CurrentMetadata

RegistryKey regData = Registry.CurrentUser.OpenSubKey("Software\Microsoft\MediaPlayer\CurrentMetadata", false);
if (regData != null) //you have to do this check, to prevent from a null reference exception
{
string currSongTitle = regData.GetValue("Title", "No Title") as string;
//...
// Check google to see other WMP Keys...
}

Hope this help

Re: How Syncronize..in C#???

VisualLive30-Mar-09 6:04

VisualLive

30-Mar-09 6:04

Hi
first thanks for your fast reply,
i have 3 folders music(each week we will update music) and WMP will change each 4 hour a folder music with a Timer so i need a listbox that allow me to search a song and if i will change item automatically WMP will change song.
In my case can be useful RegistryKey class?
Sorry i'm beginner;
Nice Regards Smile | :)

upadated html format of google images seacrh result

yogesh_deshmukh30-Mar-09 4:54

yogesh_deshmukh

30-Mar-09 4:54

Regex imagesRegex = new Regex(@"(\x3Ca\s+href=/imgres\" +
@"x3Fimgurl=)(?<imgurl>http" +
@"[^&>]*)([>&]{1})" +
@"([^>]*)(>{1})(<img\ssrc\" +
@"x3D)(""{0,1})(?<images>/images" +
@"[^""\s>]*)([\s])+(width=)" +
@"(?<width>[0-9,]*)\s+(height=)" +
@"(?<height>[0-9,]*)");
this was the html formatt google were using but now it doesnt work as here imgurl reffere group of original image and images reffer thumbnail hight and wight .please help.........

Re: upadated html format of google images seacrh result

SeMartens30-Mar-09 5:10

SeMartens

30-Mar-09 5:10

Okay, well, so what is it you want to do? Extracting the image-Url from google as I can see it. Do you get an error?

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

Re: upadated html format of google images seacrh result

yogesh_deshmukh30-Mar-09 17:12

yogesh_deshmukh

30-Mar-09 17:12

No, sir actually i am talking about An API for Google Image Search which is avilable on codeproject.com as auther said whenever google would change its html formatt we have to upadate that parsing code....as now i thing google have updated their html formatt hence this apllication not running it desnt show bug/exception but i m not getting result even single image .as it was properly working before 20 day.
Please help....

Flv converter open data source???

omegazafer30-Mar-09 4:53

omegazafer

30-Mar-09 4:53

Hello Friends,
I want to convert video files to Flv format? Is there a sample code for this transaction except FFmpeg
to learn general aspect of converting?

Best Regards
Omegazafer

How to run windows service on remote server

tmieruch30-Mar-09 4:40

tmieruch

30-Mar-09 4:40

Hi everybody,

i've got an problem by starting an windows service on a remote server. This windows service should perform a database backup (from mysql to sql server) every day at a specified time (like a scheduler). I installed the service using installutil which is defined as local service with an automatically startup property. but every time i try to start this service manually the following error occurred:

Error 1053: The service did not respond to the start or control request in a timely fashion

I searched through the internet using msdn aso. but I only read about a bug in .NET Framework 1.0. I use .NET Framework 2 SP2 and also VS2008. Are there any problems if .NET Framework 3.5 is also installed?

Thx!!!

SHCameraCapture

Craigjw30-Mar-09 3:51

Craigjw

30-Mar-09 3:51

I am trying to develop a custom camera control, to use in my application. I access the camera with the SHCameraCapture api, however, this seems to give access to other functions within this dialog that I don't want the potential user to have access to, for example, changing the image resolution, saving the image to a location and sending via an SMS etc.

What I am after is a way to lock out all the other stuff that the camera api has, so that all the user can do is have access to 3 buttons, 'take picture', 'cancel' & 'ok'. How do I do this please, I have scoured the internet and all I can find is that there maybe a possibility to do it by having a C++ library using DirectShow within my C# application, which is most undesirable.

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