Problem with SQL Sentence !!!!! - C# Discussion Boards

Re: Form return value and interface question

Robert Rohde30-Dec-05 2:09

30-Dec-05 2:09

Hi,

1. There are several prossibilities.
a) Show the Form as you would normally with ShowDialog and add a property to it so the result can be retrieved afterwards. This is like the built in dialogs of .Net work.
b) Define your own ShowXY function in your form which internally calls ShowDialog on himself and returns the wanted result:

public MyObject ShowMyForm(){
   if (this.ShowDialog() == DialogResult.Ok)
      return _myResult;
   else
      return null;
}

2. There are several way to do this. One is:

if (Array.IndexOf(t.GetInterfaces(), typeof(IMyInterface)) >= 0)
   Console.WriteLine("Interface implemented");
else
   Console.WriteLine("Interface not implemented");

Re: Form return value and interface question

john111333430-Dec-05 3:15

john1113334

30-Dec-05 3:15

thx, helped

Forms messaging

navvara the infantryman29-Dec-05 23:45

navvara the infantryman

29-Dec-05 23:45

Can forms return a value to, let's say the winmain function, or can something like SendMessage be used to send s message to another window's callback function? If so how?

m$: It is normal for your screen to go blank and for your computer to restart itself several times

Problem with InstallUtil

User 189529729-Dec-05 23:22

User 1895297

29-Dec-05 23:22

Hi all,

I've created a service that needs to log in a different log then the application log. Therefor I've added the following line of code:

System.Diagnostics.EventLog.CreateEventSource("ServiceOne", "ServiceOneLog");

But when I run the InstallUtil I can see that it automatically adds the eventsource in the application log.

Does anybody have an idea how to make sure that my logs are put in ServiceOneLog? Or is there a way to tell the InstallUtil to which Log he needs to add the source?

Thanks in advance,

Geert

Windows Forms Tab Control

Aryadip29-Dec-05 22:55

Aryadip

29-Dec-05 22:55

Hi all,

I'm trying to select a tab from the windows form's standard tab control on right clicking of mouse button.
The mouse event args gives me the location of the mouse pointer.
But the tab control doesn't expose any method or property to get the tab on which my mouse
pointer is hovering.

Has anyone of you faced similar problem like this ? Or atleast it will be nice if anyone can show me a pointer towards solving this problem.

Hoping to hear from you guys...

Thanks and regards,

Re: Windows Forms Tab Control

Darryl Borden30-Dec-05 3:54

Darryl Borden

30-Dec-05 3:54

You might try this approach...

You can get the coordinates of each tab on the DrawItem event. If you could save those locations and sizes of each tab every time the tab control is drawn, then in the mousedown event you can identify which tab was clicked on by referring to your saved information.

Good Luck!

Darryl Borden
Principal IT Analyst
dborden@eprod.com

Re: Windows Forms Tab Control

Curtis Schlak.30-Dec-05 4:46

Curtis Schlak.

30-Dec-05 4:46

The way to do it is to iterate over the tab pages and for each one call TabControl.GetTabRect. If your mouse coordinate exists inside the returned rectange, set that tab to the selected tab.

"we must lose precision to make significant statements about complex systems."
-deKorvin on uncertainty

Problem with SQL Sentence !!!!!

coloso29-Dec-05 22:52

coloso

29-Dec-05 22:52

Hi, I have a problem wiht a SQL Sentence, if I have got a field char(30) and this field of one table of my database have for example : "01/12/2005 10:12:25" my question is how can I do a selection if I want do a selection between 01/12/2005 to 31/12/2005 and show the result in a datagrid. I´m working with Sybase

I have tried:

Select * from Table where field between like "01/12/2005%" and
like "31/12/2005%"

Error

If I try

Select * from Table where field like "01/12/2005%"

The result is ok.

Any idea ?????? Any help ???? Any example ????
Thanks in advance.

Coloso

Re: Problem with SQL Sentence !!!!!

PrakashBhaskar29-Dec-05 23:11

PrakashBhaskar

29-Dec-05 23:11

Hi,
try with the following method
select * from <--table name-->WHERE <--field name--> Between "01/12/2005 00:00:00" AND "31/12/2005 23:59:59";

Thanks
Warm Regards
Prakash-B

Re: Problem with SQL Sentence !!!!!

coloso29-Dec-05 23:27

coloso

29-Dec-05 23:27

Thank you for you help.

I have try your code and the sentence select all the data, more dates are selected that I need.

01/01/2005 ...... 31/12/2005

I have find the same data in othe field in my table of type TimeStamp (Sybase) and with this code.

SELECT * FROM BatchHeader where StartTime between '2005-12-01 00:00:00' and
'2005-12-31 23:59:59'

it´s work fine. Thank you for the clue.

Coloso

Re: Problem with SQL Sentence !!!!!

leppie29-Dec-05 23:25

leppie

29-Dec-05 23:25

Why are you using 'like'? Sigh | :sigh:

^{xacc.ide-0.1.1 released! :) Download and screenshots}

Re: Problem with SQL Sentence !!!!!

PrakashBhaskar29-Dec-05 23:48

PrakashBhaskar

29-Dec-05 23:48

Hi,
There is no need to use like instead of this we can use between. In addition of date we have to use timestamp also. I think this might cleare you.

Thanks
Warm Regards
Prakash-B

Re: Problem with SQL Sentence !!!!!

leppie30-Dec-05 0:03

leppie

30-Dec-05 0:03

PrakashBhaskar wrote:
There is no need to use like instead of this we can use between. In addition of date we have to use timestamp also. I think this might cleare you.

Yes, I had no problem with that. D'Oh! | :doh:

^{xacc.ide-0.1.1 released! :) Download and screenshots}

Re: Problem with SQL Sentence !!!!!

J4amieC30-Dec-05 0:27

J4amieC

30-Dec-05 0:27

char fields will not order dates as you think - they will order them using a text search, not a date search, you must store the data in a date field of some sort.

Re: Problem with SQL Sentence !!!!!

Werdna30-Dec-05 7:02

Werdna

30-Dec-05 7:02

You can do:
select * from table where cast(myColumn as dateTime) between '2005-12-1' and '2005-12-31'
but that's for mssql, i'm sure there must be convert function in sybase

Images

Timothy_198229-Dec-05 22:31

Timothy_1982

29-Dec-05 22:31

Hi,

need some help here:

i would like to search for a group of pixels on an image, lets say the image is white of color, and has some red points on it, spread around the hole picture, now i would like to develop an application that can counts these dots. Later i want the user to select what he is looking for, dots, rectangles, circles,...

is this possible with GDI+ ? Or is there a library (free one please Smile | :)

) that i can use to start ? Or should i program the hole flow on myself Smile | :)

grtz & thx

Re: Images

Darryl Borden30-Dec-05 3:31

Darryl Borden

30-Dec-05 3:31

Bitmap bmp; //obtain this however you like

int x;
int y;
for (x=0;x

Re: Images

Timothy_198230-Dec-05 4:05

Timothy_1982

30-Dec-05 4:05

hm, that's not what i mean actually, sorry maybe i explained it wrong,

i won't be looking for single pixels, i will be looking for circles, rectangles,...

Re: Images

Darryl Borden30-Dec-05 3:33

Darryl Borden

30-Dec-05 3:33

Let me try that again - something did not come out right in the translation...

int x;
int y;
Bitmap bmp;

for (x=0;x

EnsureVisible for Panel

Greeky29-Dec-05 20:50

Greeky

29-Dec-05 20:50

How can i code EnsureVisible property of Listview for Panel ?

How to add IP address in Connection String ????

Abubakarsb29-Dec-05 20:43

Abubakarsb

29-Dec-05 20:43

Hello !

I am using following connection string to establish a connection to database in C#

OleDbConnection con=new OleDbConnection(@"provider=microsoft.jet.oledb.4.0;data source=..\..\Aesculap.mdb");

I want to access this database on my local network so please tell me how can i EMBED this connection string to add IP ADDRESS OF MACHINE WHICH HOLDS THIS DATABASE please tell me as soon as possible I will be gratefull to u..

Regards,

AbuBakar

Re: How to add IP address in Connection String ????

imsathy29-Dec-05 20:55

imsathy

29-Dec-05 20:55

give the ip in the datasource

OleDbConnection = new OleDbConnection("Integrated Security=SSPI; Packet Size=4096;Data Source=192.168.22.111;Tag with column collation when possible=False;Initial Catalog=ajaxbp;Use Procedure for Prepare=1;Auto Translate=True; Persist Security Info=False; Provider="SQLOLEDB.1";Workstation ID="PC-IN-33";Use Encryption for Data=False");

sathy

Re: How to add IP address in Connection String ????

Dave Kreskowiak30-Dec-05 4:26

Dave Kreskowiak

30-Dec-05 4:26

If you look at the OP's connection string, he's using an Access database.

You connection string you provided will only work with an SQL Server, not an Access database. You cannot use an IP address alone to get to an Access database. You must supply a fully qualified UNC path to the folder share when the database is stored:

    \\ServerName\ShareName\folder\folder\folder\database.mdb
 
    or
 
    \\IPAddressOfServer\ShareName\folder\folder\folder\database.mdb

Appropriate Window Networking share security must also be setup on that share and folder, depending on the type of clients that will use the database.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Question about Office programing

TofuBug2429-Dec-05 20:37

TofuBug24

29-Dec-05 20:37

Lately since upgrading to VS 2005 TS I've been playing around with the VSTO (the new version that ships with VS 2005) with much success and happiness. However I've run into what I think is a fundamental problem (and it may just be me but I have to ask)

I've created a couple C# Word documents and a couple C# Excel documents each has their own controls they are basically designed for automatic report's, receipts, etc generation without any user interaction.

Now I can run the Word or Excel "program" from VS and it works fine. Also I can open any of the Applicable documents in explorer and they work fine.

my problem is when I try to open them from another project the documents open but the controls are only visualy drawn none of their functionality seems to exist.

I've tried using the Process class to open both Excel or Word and the Documents themselves with the same results.

An example of one of the Excel documents i have is as follows:

when the Excel workbook loads it loads a non visable windows form (as a modal form to lock excel from user input) that when passed a single or a collection of Job's done to include the Job's Title, the hours spent and the Client's name the job was done for it then populates the spreadsheet with the values as well as calulates things like the total money owed for the hours worked, taxes, as well as things like populating clients into a dropdown list control for each job (when there are more than one client assigned to the same job) once the form is finished it closes returning control to the Excel workbook which then displays another windows form to save and or print the file (with a check box option to automate saving (by adding the date and time stamp to a generic filename) and printing.

So in my main program which holds several lists of jobs (which are housed in an sql server database) when the user selects one or a group of jobs from the DataGridView and selects the apropriate Generate Report File Menu option I need the program to load the appropriate Excel or Word document with the Controls intact so I can pass in the information needed.

I'm not sure if I'm completely missing something but I've googled and scoured msdn and i've yet to find an example of loading a compiled office project from another windows application so any help would be greatly appreciated

Thanks Everyone in adavance

Ryan,

I see 57005 people.

How to use IP address in Connection String

Abubakarsb29-Dec-05 20:24

Abubakarsb

29-Dec-05 20:24

Hello !

I am using following connection string in C# to establish a connection to a ACCESS Database

OleDbConnection con=new OleDbConnection(@"provider=microsoft.jet.oledb.4.0;data source=..\..\Aesculap.mdb");

I want to access this database over the network and want to use IP address of the System please tell me anybody HOW CAN I EMBED IP ADDRESS OF THE SYSTEM IN THIS CONNECTION STRING plz....

Regards

Abubakar

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