|
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
|
|
|
|
|
Access doesnt have stored procedures, it has queries and I dont think there is a built-in way of enumerating them.
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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...’
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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 />
sbRedirect.Append( STR_ASP_PARMS );<br />
<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 />
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 />
sbRedirect.Append( DF_MARKET_TYPE );<br />
sbRedirect.Append( STR_ASP_EQUALS );<br />
sbRedirect.Append( ddlMarkets.SelectedIndex );<br />
sbRedirect.Append( STR_ASP_DELIMITER );<br />
<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 />
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 />
sbRedirect.Append( DF_GROUP_CODE );<br />
sbRedirect.Append( STR_ASP_EQUALS );<br />
sbRedirect.Append( cbAbbreviation.Checked.ToString() );<br />
|
|
|
|
|
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());
|
|
|
|
|
Can someone help me in getting roll down menu code that supports righttoleft.
I would be very thank ful
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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 ?
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
There is the IncludeSubdirectories property that forces it to watch all levels below the one specified. I guess if you point it at the root of the drive you want to watch, it would work.
|
|
|
|
|
Hi,
I had made one logic by which i can able to delete the user selected colors.logic is that get the minimum and maximum value of R,G,B of each pixels and then remove that colors from whole pixels.Now here it's working fine but main problem of this logic is that as it's taking minimum and maximum value of R,G,B if user select the color in which there is one white color pixel of my logic taken white color value in min. value and so it removes all the colors from the image instead of selected color.
so i need to make some more improvement of this logic?can any one help out or guide me in changing this logic ?
i think here one idea can solve this problem.
thanks
|
|
|
|
|
Yepp, it probably can:
You need to split this up into different "filters".
The first thing you will need is a "Replace selected color" filter, which should replace one color with another. You could determine the "new" color using your logic, just like you calculated the "new" values for your pixels, just that you dont do this to every pixel in the picture, but only those that have exactly the same color values.
The second filter extends the first: "Replace colors", which should replace all colors in a certain range (e.g. "R245 to R255") with a given color (or simply "swap" R for B or something similar). In that case, you select one pixel, give a certain "range" (eg. +-10) and then select a "replace method" (so you can provide different methods).
Third would be a "grayscale replace" in which you split RGB channels and treat each channel seperately.
The fourth and last filter I can imagine is a RGB Filter. That means, my simply choosing a color (Red, Green or Blue) to remove, the image would be treated as a whole. You could (again) simply "split" the image and then only recombine G and B, with Red set to a "standard value" (e.g. 0) which then would yield a "red-free" version of your image.
Cheers
Sid
|
|
|
|
|
Hi,
I think this will not works becoz here as this is four layer filteration the performance gets effected tremandusly,but if you give some less layer filter but effective than it's good.
|
|
|
|
|
G'day folks,
well i am attempting to get an understanding on how to create the menuitems in a context menu on the fly. So far I have managed to actually achieve the menu items being created for the context menu. However, I have stumbled across one problem. Which is that how does one go about enhancing the event handler for the context menu to invoke individual actions for each of the menu items.
I have included a snippet of my code. In this sample example, I created a button, which essentially adds 4 menu items based on strArray to the context menu. Any recommendations on how to improve the context menu event handler so that when I click on menu item "A" in the context menu, the message box pops up.
Any recommendations will be appreciated.
thanks in advance.
string[] strArray = {"A", "B","C","D"}; //declared as global
private void contextMenu1_Popup(object sender, System.EventArgs e)
{
try
{
MenuItem miClicked = (MenuItem)sender;
string item = miClicked.Index.ToString();
switch(item)
{
case "A":
MessageBox.Show("A");
break;
case "B":
MessageBox.Show("B");
break;
case "C":
MessageBox.Show("C");
break;
case "D":
MessageBox.Show("D");
break;
}
}
catch
{}
}
//creating menuitems for context menu when the Push Button is pressed.
protected void button1_Click(object sender, EventArgs e)
{
for(int i=0;i
|
|
|
|