|
Hi Friends,
I have made a SQL DB Wrapper for my project. It is working perfect on my machine dure to local settings.But I am using a shared server on wich it is giving the following error :
<br />
Source Error: <br />
<br />
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. <br />
<br />
Stack Trace: <br />
<br />
<br />
[SecurityException: Request for the permission of type 'System.Security.Permissions.EnvironmentPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.]<br />
System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet) +0<br />
System.Security.CodeAccessPermission.Demand() +59<br />
System.Environment.GetEnvironmentVariable(String variable) +66<br />
Something.DataProvider.SQLDBFactory..ctor(Provider strProvider) +108<br />
Something.DataProvider.SQLDBAccess.ExecuteDataset(IDbConnection cnn, CommandType enumCommandType, String strCommandTxt, IDataParameter[] objCommandParameters) +126<br />
Something.DataProvider.BaseDataProcess.SP_ExecuteDataSet(String text, IDataParameter[] param) +119<br />
<br />
.....<br />
....<br />
<br />
Please help me to resolve the problem.
Thanks in Advance.
Deepak Surana
|
|
|
|
|
Hello,
Have you check that the database login has the appropriate permissions?
|
|
|
|
|
Yes i have checked the DB login id and pass.
Its a .Net error as far as i know, wichi is coming beacuse of some security permissions of the dll's
Deepak Surana
|
|
|
|
|
Hi,
I am stuck now. I have a master page. and I have one dropdownlist in master page. When I click one item on master page it redirects to me some folder and opens the file in that folder.
I am using one javascript for opening the url. but if I include that java script it doesn't go to that
selectedIndexChanged property. because I need to know the infdex of selected item in the dropdownlist.
but if I remove the javascript it goes to selexctediIndexChanged property event. But I need jhavascript to call
I don't know where is the problem. Could you please help me to solve it.
Thanks.
Here is my code in master page
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataSet ds;
ds = AppName();
DropDownList2.Items.Add(new ListItem("--Select Application--"));
DropDownList2.AppendDataBoundItems = true;
DropDownList2.DataSource = ds;
DropDownList2.DataTextField = "AppName";
DropDownList2.DataValueField = "AppLocation";
DropDownList2.DataBind();
}
DropDownList2.Attributes.Add("onchange", "goToNewPage(this.value)");
}
here is my Java script
function goToNewPage(url)
{
window.location.href=url;
alert("hello");
}
Here is my selectedIndexchanged property
protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e)
{
int index = DropDownList2.SelectedIndex;
DataSet ds1;
ds1 = AppName();
Session["apprightid"] = Convert.ToInt32(ds1.Tables[0].Rows[index - 1][1]);
int count = Convert.ToInt32(ds1.Tables[0].Rows[index - 1][1]);
}
|
|
|
|
|
![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
I am looking for a code for web application in asp.net which contineously
( i.e say 1-5 sec ) updates the database table.I tried to use ajax timer control but cant get solution coz it refreshed the page at given interval but not raised a event my airthmetic ie:
int i;
private void timer_tick(........)
{
i=i+1
label1.Text=i.ToString();
////database update codes//////
}
What should i do to fire my events in every 5 seconds..............plz its urgent
Pokhrel Rohit
|
|
|
|
|
If you're using SQL Server 2000 you could use Job Scheduling to update the table every so often.
|
|
|
|
|
How can Job Scheduling Solve problem of timer can you give me any idea.
I haven't gone through job scheduling ..........
Thank you
pokhrel rohit
|
|
|
|
|
I have data in a table that I would like to display in a radioButtonList, inside a dataGrid. The fields are such: QuestionID, Question, Option_1, Option_2, Option_3, etc. All these options are different potential answers that the user can select by means of a radio button. I need the values from these Option fields to populate the radioButtonList List Collection. (These options are different for every row). Is there a way to do this?
Thanks in advance.
|
|
|
|
|
Can you help me understand, a bit more, I bulid lots of questionnaires that's all I do is bulid data collection forms, not understanding why you are loading your radio buttons in data grid?
Why don't you just put it all on the form, make the radio buttons post back, and on post back make visible what needs to be visible depending on the answer that was given with a switch?
|
|
|
|
|
Just so I can pull all the Question IDs, the Questions, and their optional answers from the database, in one simple select statement (if possible). If I used a form, you are saying populate a table with this information using a for-loop or something? I would still like to be able to use a RadioButtonlist that would automatically pull the choices from the database, instead of having to type them in, just in case there are changes to be made, so they don't have to be made in 2 spots.
-- modified at 15:11 Tuesday 1st May, 2007
|
|
|
|
|
You could still pull them all in, all the forms I do this On I can't post on here until I can spend some time deleting stuff out of them, got stuff I am not allowed to post because of were I work. I load everything into the page, and set it visible, on post back user answers the question for this on postback, sets the next correct option visible. Now what would suck is if they changed your varibles names..
|
|
|
|
|
I do not understand. How do you load everything onto the page after pulling from the DB? Are you also filling the RadioButtonList with info from the database? or are you typing this information in?
|
|
|
|
|
Just a second, I a am looking for an example
|
|
|
|
|
|
Hi, (I am a newbie to ASP.NET)...
I create an ASP.NET project in VS2005 and it gives an "object not found" or "cannot create object" error in the first line (no matter what the first line is!!)
I just create the webproject from its template and it gives this error!
Hint:
I am using Windows XP SP2 Home Edition (but I have installed IIS on it anyway), does this have anything related to my problem?
|
|
|
|
|
You usually get that error when you have an object that is null and you are treating it like it is not null.
I would suggest pressing F10 to step into your app. This should take you to the first line of the code. Keep pressing F10 until you find the object that is not set. Once you have found the object hopefully you will know what to do. If not respond back with what you find.
Hope that helps.
Ben
|
|
|
|
|
Hello. I have a ms access database (mdb) and I want to access it from asp.net, c#. I can access and display normal fields with OleDb. I need to display an image stored in the database. I have googled around a lot, but I can't seem to find something that just works. Please help me. Thank you in advance.
|
|
|
|
|
Is there anyway to create a directory listing, of the files in a folder? IE, on page show all contents of said folder all read only? In otherwords so it looks the user has FTP access, but through the web?
|
|
|
|
|
Any way to align text in an asp.net label vertically?
|
|
|
|
|
packerfan1904 wrote: Any way to align text in an asp.net label vertically?
Yes use Style Sheet for that
<br />
.bodyTextBoldCSm {font-size:70%; font-weight: bold; text-align : left;}<br />
Thanks and Regards
Sandeep
If you want something you never had,
do something you have never done!
|
|
|
|
|
Ok so I have a form
within the form I have two buttons Amend / submit
<asp:button id="btnAmend" onclick="btnAmend_Click" runat="server" width="192px" visible="False"
text="Amend">
<asp:button id="btnPost" onclick="btnPost_Click" runat="server" width="192px" text="Submit">
both have the caues validation attribute set to true but only the submit button actually causes validation when pressed. Is this because the submit button is called post?
any way to also get the amend button to cause validation also
Thanks
Colum
|
|
|
|
|
CausesValidation=true;
On your button propertys make sure that is set.
|
|
|
|
|
Also why have to buttons? Ammend and submit? Why arent you just calling the other function, if critera for submit is already met? I am assuming, your UPDATEING a record with your ammend button, versus your SUBMIT button, is being used for the first time the data is being submited?
|
|
|
|
|
yea I have the causesValidation=true on both buttons
yea that's correct I have two buttons amend and submit. submit for the first time I submit at this stage the amend button is not shown, then when amending I show the amend button and hide the submit button, is this logic flawed?
|
|
|
|
|
Yes, you do not need two buttons. You should check if the record is a new record within the same function of your submit button, if it is use your select statement, else use your UPDATE statement.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
