Write a stored procedure - C# Discussion Boards

Ranjan Banerji7-Jul-06 19:57

7-Jul-06 19:57

I am building a BHO that is meant to popup a IHtmlPopup window on a mouse over image event. All the code works fine if the image is in the main Window.

However if the image is in a frame then I get the following error:

{"Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))"} System.Exception {System.UnauthorizedAccessException}

This happens when I try to create the Popup Window or access its Document

I have tried getting the parentWindow from the Frame's document and from teh main document.

<br />
//IHTMLWindow4 parentWindow = (IHTMLWindow4)FrameDocument.parentWindow;<br />
IHTMLWindow4 parentWindow = (IHTMLWindow4)PageDocument.parentWindow;<br />
//This line will work, but if you look at the Document Property, you will see the exception<br />
IHTMLPopup popUp = (IHTMLPopup)parentWindow.createPopup( ref argIn );<br />
//This line will throw the exception<br />
IHTMLDocument2 popupDoc = (IHTMLDocument2)popUp.document;<br />

Any ideas?

-- modified at 2:32 Saturday 8th July, 2006

how to fit the page size according to the monotor size

ayyp7-Jul-06 18:48

ayyp

7-Jul-06 18:48

hi all,i designd a web page using 17inch monitor.when i access this page throug 14inch monitor the page displayed with scrollbars (contain horizantal and vertical scroll bars).so i am forced to use the scroll bars to view the full page.Is there any way to fit the page according to the monitor size...(with out having scroll bars)..... Smile | :)

Regards,
ayyp

Re: how to fit the page size according to the monotor size

Ennis Ray Lynch, Jr.7-Jul-06 20:52

Ennis Ray Lynch, Jr.

7-Jul-06 20:52

Using javascript screen.x and screen.y will give the screen resolution which I think will solve your problem. If you want you can deliver different formatting based on different resolutions. The old school of thought was to design for 800x600 but now I think there is a larger target res.

Also, consider using well designed CSS as it is better to make a good layout than to hard code for every possible resolution. I mean what will happen when your users are accessing the webpage using a handheld?

A man said to the universe:
"Sir I exist!"
"However," replied the Universe, "The fact has not created in me A sense of obligation."

-- Stephen Crane

Re: how to fit the page size according to the monotor size

ayyp7-Jul-06 20:58

ayyp

7-Jul-06 20:58

s u r correct,i never thing about handhelds...any how thanks for u r reply,as u told i try it with css Smile | :)

Regards,
ayyp

DateTime comparision

_tasleem7-Jul-06 15:05

_tasleem

7-Jul-06 15:05

i had inserted datetime values in databse using c#.using code like DateTime.now,now i want to comapte valus using betwwen operator of SQL
i.e where dbtime between '" + dtp1.value + "' AND '" + dtp2.value + "' but it does not show any record i think critera of where class did not match.
i had inserted in databse like '" + DateTime.now+ "'
how to compare them so that it show correct result

Tasleem Arif

Re: DateTime comparision

Ashwani Mahotra7-Jul-06 19:05

Ashwani Mahotra

7-Jul-06 19:05

1> First,Check what kind of datatype you are using in database for this field.Make sure that the datatypes of the two in front end and back end are same.
2> If it is dateTime in the database then use
where dbtime between "+ #dtp1.value# +" AND "+ #dtp2.value# +" in the query string . instead of using
where dbtime between '" + dtp1.value + "' AND '" + dtp2.value + "'

i.e. You are trying to compare string type values. You should mot use
'"+ dtp1.value +"', instead you should use "+#dtp1.value#+".
also, you can use DateFormat function, if the format of the two dates are not same.

3>If you are using string type in database then you should not use dtp1.value.

Ash

Re: DateTime comparision

_tasleem8-Jul-06 1:41

_tasleem

8-Jul-06 1:41

it did not work her is more precise description
str="INSERT INTO tblHistoryLog(UserId,UserAction,TableName,ActionDate,TrDoneOn) VALUES('" + CheckValues.strUserId + "','NEW RECORD','USER TABLE','" + DateTime.Now + "','" + cmbTAUserId.Text + "')";
where ActionDate datatype if datetime.
i had inserted record in the table and inserted properly.

the query that uses the comparison
"SELECT * FROM tblHistoryLog WHERE (ActionDate BETWEEN #"+ dtpTo.Value +"# AND #"+ dtpFrom.Value +"#)"
but it gives the no result
i had tried to use this but it does not compile so i had to use above
"+ #dtpTo.Value# +" AND "+ #dtpFrom.Value# +"

Tasleem Arif

Write a stored procedure

Ennis Ray Lynch, Jr.7-Jul-06 20:57

Ennis Ray Lynch, Jr.

7-Jul-06 20:57

It looks as if you are passing an SQL string. I am one of those freaks that insist on SP. Also you can make a command object with your query string and include parameters as in:

sqlString = "SELECT * FROM customer WHERE creationDate BETWEEN @startDate AND @endDate";

Then you can append parameters to the command and execute it.

(btw, don't quote me on this I am not on a machine with a devel environment write now or I would have posted compilable code)

A man said to the universe:
"Sir I exist!"
"However," replied the Universe, "The fact has not created in me A sense of obligation."

-- Stephen Crane

Re: Write a stored procedure

Paul Conrad7-Jul-06 21:24

Paul Conrad

7-Jul-06 21:24

Ennis Ray Lynch, Jr. wrote:
I am one of those freaks that insist on SP

There is nothing wrong with that Big Grin | :-D

Get Mouse Message [modified]

İsmail Durmaz7-Jul-06 14:43

İsmail Durmaz

7-Jul-06 14:43

can i access mouse buffer to get mouse clicks with c#?
-or-
i want to learn mouse click on anywhere how can i do?

<br />
GetMessage(out msg, 0, WM_LBUTTONDOWN, WM_LBUTTONDOWN);<br />

but it runs only on the main window, it doesn't run on another applications.
i want to get all mouse messages.

-- modified at 20:44 Friday 7th July, 2006

Re: Get Mouse Message

Stefan Troschuetz7-Jul-06 22:03

Stefan Troschuetz

7-Jul-06 22:03

Search for global hooks. There are some articles here on CP that cover this topic.

"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook

www.troschuetz.de

Read data from datagrid

ujupanmester7-Jul-06 13:37

ujupanmester

7-Jul-06 13:37

Hy,

I have a problemns. I want to read data from datagrid, but i have few problemns, that i can't.

Let me explain:

Datagrid looks : <asp:datagrid id="dgcam" style="Z-INDEX: 104; LEFT: 856px; POSITION: absolute; TOP: 288px" runat="server"
="" cellpadding="0" gridlines="None" showheader="False">

Function how fill this grid is:

private void cam()
{
string conn = ConfigurationSettings.AppSettings["conn"];
SqlConnection objConnection = new SqlConnection(conn);

DataSet ds = new DataSet();

string user = "select utilizator from furnizori where id_client =" + lbluser.Text;
string listcamion = "select count(id_camion) from add_camion join furnizori on (add_camion.id_user = furnizori.id_client)where id_user=" + lbluser.Text;
SqlDataAdapter da = new SqlDataAdapter(listcamion,conn);
da.Fill(ds, "add_camion");
da.Fill(ds, "furnizori");

dgcam.DataSource = ds;
dgcam.DataMember = "add_camion";
dgcam.DataBind();

try
{
objConnection.Open();
}
finally
{
if(objConnection.State == ConnectionState.Open)
{
objConnection.Close();
}
}

In Page Load i have this code, where i had problemns:

if(dgcam.Items != null)
{
listcamionuser();
}
else
{
lblmesaj.Text = "Nu aveti adaugat nici un camion in baza de date";
}

Here i have problemns because i try to read data from grid. In grid count function works very good. In my page load i try to read grid who i fill this function cam(). This i don't knows how to put the cod(function is if(dgcam.Itemns != null) )

Pls help me.

Thanks for all

code Form within a code Form

Glen Harvy7-Jul-06 12:55

Glen Harvy

7-Jul-06 12:55

What I am wondering is if I can display a form within another forms field.

I have created a form that displays, updates, etc a database however I want that form to appear and be selectable from within another form.

I have created a clickable event that will show the form "outside" of my main form but what I want is for it to appear within an area of the main form.

I've searched everywhere but obviously my terminology is not yet good enough to match the experienced contributors to this fabulous vault Cool | :cool:

If there is a tutorial that specifically covers what I want to do I would appreciate a pointer to it.

TIA

Glen Harvy

Re: code Form within a code Form

Not Active7-Jul-06 13:31

Not Active

7-Jul-06 13:31

What you are discribing is called a Multiple Document Interface, or MDI, application. http://www.codeproject.com/csharp/suiteapp.asp[^]

Re: code Form within a code Form

Robert Rohde8-Jul-06 12:27

Robert Rohde

8-Jul-06 12:27

Glen Harvy wrote:
I've searched everywhere but obviously my terminology is not yet good enough

May be. I still don't know exactly what you want.
If you want to use your Form like it was a simple Control then just set its TopLevel property to false and add it to your other form via otherForm.Controls.Add(infoForm). Don't forget to set Location and Size properly.

Re: code Form within a code Form

Glen Harvy8-Jul-06 16:30

Glen Harvy

8-Jul-06 16:30

Thanks for the response.

I'll play around with your suggestion as it seems to be what I do/did want.

Glen Harvy

How to catch a security exception within Remoting.Config(...)

2bee 7-Jul-06 11:17

2bee

7-Jul-06 11:17

Hello,

well, i have been checking this over and over again, but i am still unable to catch this exception:

System.Security.Principal.IdentityNotMappedException.

This exception is thrown when i use an incorrect authorizedGroup attribute
within my application config. Surely it's right that i get an exception when i specify a group that
doesn't exist but at least i should be able to catch it, shouldnt i?

try
{

  RemotingConfiguration.Configure(".\\MyApp.exe.config", false);

}
catch (Exception)
{}
 
 
app.config
 
<channels>
  <channel ref="ipc" portName="MyAppPort" authorizedGroup="IIS_WPG">
    <serverProviders>
      <<formatter ref="binary" typeFilterLevel="Full" />
    </serverProviders>
  </channel>
</channels>

However i assume that i can't catch this excpetion because RemotingConfiguration is running
in another (application?)context. Furthermore my application is doing fine. The only thing that bothers me is that
cannot catch this exception when a nonexistent group is specified.

If someone has an idea how to catch this exception, then please let me know.
I would really really appreciate it.

best regards Tobias Big Grin | :-D

Look at the stack trace in the exception?

Ennis Ray Lynch, Jr.7-Jul-06 11:24

Ennis Ray Lynch, Jr.

7-Jul-06 11:24

That could reveal where the buck stops so to speak.

A man said to the universe:
"Sir I exist!"
"However," replied the Universe, "The fact has not created in me A sense of obligation."

-- Stephen Crane

Re: Look at the stack trace in the exception? [modified]

2bee 7-Jul-06 11:36

2bee

7-Jul-06 11:36

hi,

Hmm, i did this a thousand times but it doesn't point specifically to my application! Obviously RemotingConfiguration.Configure is running in a different thread but how to catch the exception in it?

e voila:

Unbehandelte Ausnahme: System.Security.Principal.IdentityNotMappedException: Man
che oder alle Identitätsverweise konnten nicht übersetzt werden.
bei System.Security.Principal.NTAccount.Translate(IdentityReferenceCollection
sourceAccounts, Type targetType, Boolean forceSuccess)
bei System.Security.Principal.NTAccount.Translate(Type targetType)
bei System.Runtime.Remoting.Channels.Ipc.IpcServerChannel.Listen()
bei System.Threading.ThreadHelper.ThreadStart_Context(Object state)
bei System.Threading.ExecutionContext.Run(ExecutionContext executionContext,
ContextCallback callback, Object state)
bei System.Threading.ThreadHelper.ThreadStart()

Further, this exception says that the system was unable to resolve the specified account. However i am fully aware of that and did intenionally use a wrong group. I just want to know
how to catch this security exception that is raised by the CLR.

regards Tobias

The app config file you posted isn't valid

Ennis Ray Lynch, Jr.7-Jul-06 11:58

Ennis Ray Lynch, Jr.

7-Jul-06 11:58

I don't know if that is it or not
<channels>
<channel ref="ipc" portname="MyAppPort" authorizedgroup="IIS_WPG">
<serverproviders>
<<formatter ref="binary" typefilterlevel="Full">

A man said to the universe:
"Sir I exist!"
"However," replied the Universe, "The fact has not created in me A sense of obligation."

-- Stephen Crane

Re: The app config file you posted isn't valid

2bee 7-Jul-06 13:04

2bee

7-Jul-06 13:04

Ennis Ray Lynch, Jr. wrote:
I don't know if that is it or not

<<formatter ref="binary" typefilterlevel="Full">

Nope, that is quite alright. As i said, there is nothing wrong neihter with the program nor with its configuration. I just need to know how i could catch a security exception that is raised during the remoting configuration. I mean my entire application works perfect, unless i specify a group that doesn't exist. It is quite logic that the remoting configuration fails when i specify a nonexistent group but why is it impossible to catch this security exception?

Anyway, thanks for your efforts.

Tobias

How to change the toolbar background color?

Rogenator7-Jul-06 9:17

Rogenator

7-Jul-06 9:17

Greetings:
Just as the title says, i want to know how to change the backcolor of a toolbar, i`m guessing it`s done by overriding the onPaint method, but some code would be useful Big Grin | :-D

, especially for the measurement of the elements

Passing variable

Chris McGlothen7-Jul-06 8:23

Chris McGlothen

7-Jul-06 8:23

I have a portal site that incorporates multiple web parts. One of the web parts is intended to pass a query string to a search application located in another area of the intranet. My problem is thus...The search application is written in standard asp and the portal site is asp.net 2.0/C#, how can I link the two up and pass the string.

Any help, suggestions, or possibly a push in the direction of a reference would be greatly appreciated.

Thanks in advance,

Cheers
Lil Turtle

Re: Passing variable

Ennis Ray Lynch, Jr.7-Jul-06 8:52

Ennis Ray Lynch, Jr.

7-Jul-06 8:52

You can pass the variable around between the two with the query string(term? I don't write asp.net)
ie: http://someWebAddress/someSite.asp?searchString=some%20really%20long%20search%20string;
or
ie: http://someWebAddress/anotherSite.aspx?searchResult=some%20really%20long%20result%20string;

A man said to the universe:
"Sir I exist!"
"However," replied the Universe, "The fact has not created in me A sense of obligation."

-- Stephen Crane

Re: Passing variable

Chris McGlothen7-Jul-06 11:16

Chris McGlothen

7-Jul-06 11:16

Thanks for the tip, I'd forgotten about passing data this way, I'm still rather new to this Smile | :)

, and I was kind of stuck in a brain-dead Friday funk. Cool | :cool:

I implemented the change and it is working well now, thanks.

Cheers,
Lil Turtle

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