ListView SelectIndex? - C# Discussion Boards

30-Mar-05 4:33

Hello,

Is there any way to get a list of stored procedures in an MS Access database?

Been searching for a while and found nothing Frown | :(

Thanks in advance

cobyjone30-Mar-05 4:59

30-Mar-05 4:59

Create a view in sql server around the following sql statement and select out of the view in access:

select name from dbo.sysobjects where xtype = 'P' and status >= 0 and name not like 'dtp%' order by name

Chals30-Mar-05 5:33

30-Mar-05 5:33

Excuse my ignorance, but how am I supposed to create a view in sql server working with MS Access?

Could you be more explicit please? Thanks

cobyjone30-Mar-05 7:13

30-Mar-05 7:13

Create a view using query analyzer. Grant select to public. Then access it via a function in vba or directly with a linked ODBC data source.

sql:
Create View storedproclist as
Select name
From dbo.sysobjects
Where xtype = 'P' and status >= 0 and name not like 'dtp%'

Go

Grant Select On storedproclist To Public

J4amieC30-Mar-05 9:27

J4amieC

30-Mar-05 9:27

Access doesnt have stored procedures, it has queries and I dont think there is a built-in way of enumerating them.

Chals30-Mar-05 10:46

Re: ListView SelectIndex?

30-Mar-05 10:46

Actually, since Access 2000, it does support stored procedures, you can create them through OleDbCommand objects. Problem is there seems to be no way of listing them, unless our cryptic friend's solution works. I yet have to try it.

ListView SelectIndex?

Skrekkur330-Mar-05 4:31

Skrekkur3

30-Mar-05 4:31

I need to make a specific index selected in the glacialist and Im just about to give up, Ive tried as I can using the SelectedIndices (both on the control itself and under Items on it) to make something selected but that seems to be readonly I've tried to do it by using
ListView .SelectedIndicies[0] = <anyint>,
ListView.Items.SelecetIndices[0] = <anyint>,
ListView.SelectedIndicies.add(<anyint> and
ListView.Items.SelectedIndicies.add(<anyint>

This doesn´t give me any errors if something is selected but it doesn´t seem to worj either, It reads from this correctly though.

I appriciate any help to get me on the right track on setting the selected Index

turbochimp30-Mar-05 6:18

turbochimp

30-Mar-05 6:18

The ListViewItems in the ListView have a Selected property that's read/write. Set the Selected property for the items individually.

The most exciting phrase to hear in science, the one that heralds the most discoveries, is not 'Eureka!' ('I found it!') but 'That's funny...’

al.exe utility

cobyjone30-Mar-05 4:13

30-Mar-05 4:13

I have a satellite assembly with all my resources. I need to append a resource file to that satellite assembly. I don't have all the other resource files that make up that satellite assembly, so I need to be able to just append it on the existing assembly. Any ideas? Thanks

Available com ports

Anonymous30-Mar-05 4:09

Anonymous

30-Mar-05 4:09

How to check what com ports are available currently in windows?
In C#, or how to use for example method "EnumPorts" from outside of .NET

Thanks

Constructing a URL?

fireloard30-Mar-05 4:08

fireloard

30-Mar-05 4:08

Which would be considered better practice? Although the first version is smaller the second one uses string builder and breaks it up so that it is easier to distinguish what is being added to the line and avoids hard coding in the actual program. So which would you normally do? Both of these create the same URL in the end.

Stringing it all together like this?

<br />
string strRedirect = "~/Maint/surcharge.aspx?" +<br />
	"StartDate=" + cpStartDate.SelectedDate.ToShortDateString() +<br />
	"&EndDate=" + cpEndDate.SelectedDate.ToShortDateString() +<br />
	"&Market=" + ddlMarkets.SelectedIndex +<br />
	"&GroupName=" + cbCustomer.Checked.ToString() +<br />
	"&GroupCode=" + cbGroupCode.Checked.ToString() +<br />
	"&Abbreviation=" + cbAbbreviation.Checked.ToString();<br />

Or using a string builder to create the URL like this:

<br />
private const string URL_SURCHARGE = "~/Maint/homepage.aspx";<br />
private const string STR_ASP_DELIMITER = "&";<br />
private const string STR_ASP_PARMS = "?";<br />
private const string STR_ASP_EQUALS = "=";<br />
<br />
private const string DF_START_DATE = "StartDate";<br />
private const string DF_END_DATE = "EndDate";<br />
private const string DF_GROUP_CODE = "GroupCode";<br />
private const string DF_ABBREVIATION = "Abbreviation";<br />
private const string DF_GROUP_NAME = "GroupName";<br />
private const string DF_MARKET_TYPE = "Market";<br />
<br />
StringBuilder sbRedirect = new StringBuilder( URL_SURCHARGE );<br />
<br />
// Add ASP parameter delimiter. Should be a ?<br />
sbRedirect.Append( STR_ASP_PARMS );<br />
<br />
// Start Date<br />
sbRedirect.Append( DF_START_DATE );<br />
sbRedirect.Append( STR_ASP_EQUALS );<br />
sbRedirect.Append( cpStartDate.SelectedDate.ToShortDateString() );<br />
sbRedirect.Append( STR_ASP_DELIMITER );<br />
<br />
// End Date<br />
sbRedirect.Append( DF_END_DATE );<br />
sbRedirect.Append( STR_ASP_EQUALS );<br />
sbRedirect.Append( cpEndDate.SelectedDate.ToShortDateString() );<br />
sbRedirect.Append( STR_ASP_DELIMITER );<br />
			<br />
// Market Type<br />
sbRedirect.Append( DF_MARKET_TYPE );<br />
sbRedirect.Append( STR_ASP_EQUALS );<br />
sbRedirect.Append( ddlMarkets.SelectedIndex );<br />
sbRedirect.Append( STR_ASP_DELIMITER );<br />
<br />
// Group Name<br />
sbRedirect.Append( DF_GROUP_NAME );<br />
sbRedirect.Append( STR_ASP_EQUALS );<br />
sbRedirect.Append( cbCustomer.Checked.ToString() );<br />
sbRedirect.Append( STR_ASP_DELIMITER );<br />
<br />
// Group Name<br />
sbRedirect.Append( DF_GROUP_CODE );<br />
sbRedirect.Append( STR_ASP_EQUALS );<br />
sbRedirect.Append( cbGroupCode.Checked.ToString() );<br />
sbRedirect.Append( STR_ASP_DELIMITER );<br />
<br />
// Abbreviation<br />
sbRedirect.Append( DF_GROUP_CODE );<br />
sbRedirect.Append( STR_ASP_EQUALS );<br />
sbRedirect.Append( cbAbbreviation.Checked.ToString() );<br />

Re: Constructing a URL?

cobyjone30-Mar-05 4:31

Roll down menus that supports RTL

30-Mar-05 4:31

The best of both worlds:

sbRedirect.AppendFormat("~/Maint/surcharge.aspx?StartDate={0}&EndDate=(1)&Market={2}&GroupName={3}&GroupCode={4}&Abbreviation={5}",
cpStartDate.SelectedDate.ToShortDateString(), cpEndDate.SelectedDate.ToShortDateString(), ddlMarkets.SelectedIndex, cbCustomer.Checked.ToString(), cbGroupCode.Checked.ToString(), cbAbbreviation.Checked.ToString());

Sunil Kumar Sharma from AsianCERC30-Mar-05 3:43

Sunil Kumar Sharma from AsianCERC

30-Mar-05 3:43

Can someone help me in getting roll down menu code that supports righttoleft.

I would be very thank ful

Outlook

Ph@ntom30-Mar-05 2:41

Ph@ntom

30-Mar-05 2:41

I have a requirement of Outlook integration in my C# Desktop application.

I tried the Outlook .Net Connector on CP. I changed the Outlook reference to Outlook 10.0, it run smoothly but whenever I tried to get the inbox mails, it always show one message with repition, instead of showing every message.

Could any one help me out.

Thanks.

The Phantom.

voice capture in C#

h_alipour30-Mar-05 1:31

h_alipour

30-Mar-05 1:31

i want to send voice over network in C# or VB.net.
but in .Net framework there is no facility for
handeling Sound Card except DirectX.DirectSound .
i'v been use it but there is a problem.
in DirectX when you change the control from the form
of your program the sound process will be stop.
this is becouse that i must use the

public void SetCooperativeLevel(
Control owner,
CooperativeLevel level
);
function.
I try API in .net but it has itself problems.
do you know any way that save me from this hell.
i want to capture the sound send it on the network and
then play it at the otherside.

Re: voice capture in C#

snouto30-Mar-05 9:51

snouto

30-Mar-05 9:51

please can you send me this namespace of directX please i need it badly my friend send it attached to my mail box at
either at
matrix_623@yahoo.com
snouto@phreaker.net

Thank you i will be very greatful for you cause iam developing one program with the same abilities you want and if i made any further progress i will send you the source code of my project if you want
Thank you my friend

Yours;
Snouto Override.

Miss With The Best And Die Like The Rest

Re: voice capture in C#

Christian Graus30-Mar-05 12:14

Christian Graus

30-Mar-05 12:14

You're not too bright, are you ? DirectX is free to download from the Microsoft site. It's far to big to fit in your inbox.

Christian

I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer

GDI+ questions

Sabry190530-Mar-05 0:22

Sabry1905

30-Mar-05 0:22

how to make an area in the form have an opacity less than the hole form?
and how to make the area of desktop behind this area accessable by
the user -(as it looks like a transparent area)- from within this area ?

Re: GDI+ questions

Christian Graus30-Mar-05 12:13

Christian Graus

30-Mar-05 12:13

ahmedsabry wrote:
how to make an area in the form have an opacity less than the hole form?

I doubt that you can, unless you make the whole form have the low opacity, and then draw the rest of the form on top. Windows needs to draw the form underneath and it can't do that if it's not at a low enough level.

ahmedsabry wrote:
nd how to make the area of desktop behind this area accessable by
the user -(as it looks like a transparent area)- from within this area ?

This has nothing to do with GDI+. I suspect you want the area to not be part of your window at all, which is quite possible. Look into irregular shaped windows.

Christian

I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer

Reference problems

spif200129-Mar-05 23:31

spif2001

29-Mar-05 23:31

Hi
I have made a dll given it a strong name and added it to the GAC.

Why can't I now add a reference in another solution to that dll via the add reference/ .Net tab?

TIA
-spif2001

Re: Reference problems

Roger Stewart30-Mar-05 4:01

Roger Stewart

30-Mar-05 4:01

Google is your friend.

How to display an assembly in the Add Reference dialog box[^]

Roger Stewart
"I Owe, I Owe, it's off to work I go..."

FileSystemWatcher

ppp00129-Mar-05 23:30

ppp001

29-Mar-05 23:30

Hi,

How can I use the FileSystemWatcher to watch the whole C drive file operation ? The class seem can only watch just one directory(the first level).

Thanks

Re: FileSystemWatcher

Sebastian Schneider29-Mar-05 23:45

Sebastian Schneider

29-Mar-05 23:45

You COULD recursively create FSWatchers for all directories, but I wouldn't do that.

I think that C# might not be the best language to do something as OS-close as this.

You probably will want to hook all calls to the HD, which suggests using C/C++ instead.

Actually, if you want this in C#, look for a way to get around having to watch the whole partition and only monitor certain directories.

I am not sure if there is a "file change notification"-Win-Message, but if there is, you might be able to watch for those instead, then reread the affected directory.

Cheers
Sid

Re: FileSystemWatcher

Chals30-Mar-05 4:37