I'm using sql dependent caching in my ASP.NET application, and to achieve this I have the following entry in the web.config:
<connectionStrings>
<add name="DatabaseName" connectionString="Data Source=.Dev;Initial Catalog=DatabaseName;Integrated Security=True" />
[code]...
I was wondering if it is possible to assign 2 variables to DataView.RowFilter. if it is, how do I code it.
I have tried this:
[Code]....
but i got this error
Missing operand before 'and' operator error
I am looking to cache a dataset and then filter the results as they will be used repeatedly. However, I don't know how to assign values in the filtered dataset to variables in C#. I have looked on the internet for the past few hours but all I can get in binding the dataset to a control.
View 4 RepliesI am using MS SQL Server 2005 & here is my problem: I need to assign values to the multiple variables in a single select. But each value is depend on the certain value of the other column of the table.
declare @i1 Int, @i2 Int, @i3 Int;
select
case Table.column1
when 'red' then @i1 = Table.column2
when 'green' then @i2 = Table.column2
when 'blue' then @i3 = Table.column2
end
from
dbo.Table
how to achieve this in a single select?
I have a website that sales associates access to view account information with clients. S.A's can only view information for accounts that they are tied to. Some clients have more than one account, S.A's can be tied to more than one account, but not all accounts of one client need to be tied to one S.A.
On the account info pages, I have account numbers (dynamically displayed labels) displayed of other accounts that the account client is associated with, which the S.A's can see. I'm modding this so that if the S.A has viewing permissions of any of the other accounts on that list of accounts, that instead of a label being displayed, a button directing them to that account page will display instead. In order for this to work, I have to attach a security function to the button, otherwise the page will blow out on the S.A's.
So I'm running a piece that is displaying a button instead of a label, which is working fine. My problem is when I try to attach the security event to the dynamically displayed buttons. It seems that the page just posts back and doesn't execute my code at all.
On my Page_Load, I'm running this after the buttons and labels are displayed:
For x = 0 to tblAccountList.Rows.Count - 1
'use a try to target the button, use catch to handle if it's instead a label, only one cell per row.
Try
Dim accountLink as Button = tblAccountList.Rows(x).Controls(0)
Addhandler accountLink.Click, AddressOf Me.PermissionViewCheck
Catch ex as InvalidCastException
Continue For
End Try
Next
I don't have any code checking for postbacks or anything like that, but the "PermissionViewCheck" event never fires and just reposts the page.
My UI layer calls my business layer which populates a DTO. I need to display properties from the DTO on my ASPX page. Should I create public variables on the code behind page for each of the DTO properties and reference like <%=PublicPropertyName%> OR is it ok to set the DTO instance to public and reference the properties directly like <%=dtoInstance.propertyName%>
Additionally, would it be better if I just created Literal and Label controls for every item on the ASPX page and just populate them from the code behind only?
I am looking to retrieve data from a database and assign those values to class objects which in turn will be turned into session variables. I am using an object datasource to retrieve the data from the database but I cannot find anywhere that shows how to assign these values to variables. The data is returned in a dataset. There is the added problem that there will be mulitple items returned which will have to be assigned to different arraylists of objects based on the a primary key in the database.
View 4 RepliesIs there a way write code in web.config file using preprocessed function. Say I created environment variables like %Temp%, %WINDIR%. order to read these I can use the configurationManager class. But I dont want to use it. I woudl like to use a preprocessed function similar to timeStampPattern="{timestamp(local)}". Here timestamp(local) retrieves the value directly. So in a similar way can i read the environment variables %temp% and %windir% using preprocessed function if any exists?
View 2 RepliesI am making some application in asp.net 1.1 in that I am displaying data in datagrid from database. In data grid first column is of check box and radio button and in the last column we have text box now thing is that when i click on check box crosponding textbox we fill some figure and at the end we press calculate button to get total. After getting total we have to press continue button to go next step
But suppose if some body remove that check the we should press calculate button or chnage some figure in the text box then we should press calculate button again to recalculate. for that i kept autopost back on check box oncheckedchanged event and text box ontextchanged event and hide continue button so user will click calcutae button abd then continue button will re-apper
Problem it that it taking too much refresh and taking long time. So was lloking for some ajax method to use in my application.
I would like to have a variable defined in my web.config that I can use in multiple places within my web.config file (and other config files). It's probably easier to explain by example
web.config
<?xml version="1.0"?>
<configuration>
<appSettings>
<add key="AuthServiceEndPoint" value="any_old_name_i_like"/>
</appSettings>
<system.web>
[code]...
I would like to put a value in web.config file in my project and read it programatically from .aspx page.Under which section of web.config file should I save the value. This is not a connectionstring. It is path of a file. And I how can programmatically read the value in the code?I am using C#.
View 3 RepliesI did a couple google searches about this and am not finding anything, so I thought I'd ask here. I'm working on our internal CMS and I noticed that we're getting live data back when doing debugging because of our web services instead of the dev data that I wanted. It doesn't do this on our dev CMS website, but we're trying to do all our development on localhost. Is there any way to set up an environment variable in our web config for the URL so that the CMS points to the dev database instead of live database that is referenced in the wsdl files?
View 3 Repliesi am looking for a easy & elegant way to change my appsettings in web.config based on the different environment and i have (dev/qa/test/stage/prod) and i am manually changing the appsettings and its very tedious and time consuming and i have about dozens of settings.... what is the best approach for this kinda situation? i know one solution using Environment variables but wants to hear the best practice?
View 8 RepliesI want to do something like the following in an asp.net web form but get a Invalid Token error message:
<ul>
<%foreach (var item in Items) {%>
<li>
<asp:TextBox ID="<%= item.Id %>" runat="server" />
</li>
<%} %>
</ul>
What alternative methods are there to achieve the desired result?
I am developing an application using ASP.Net MVC 2. I have different modules and every module have different styles. My design goal is to use single master page and assign CSS at runtime based on the module selected by the user.
View 4 RepliesIs it possible to assign a Master Page dynamically?
View 2 Repliesafter the user login , i need to assign this use name as a global varliable, and then i want to select from a table in the sql server that have select first_name,last_name from dependincies where user id = global_value and then to add the first name and last name , to a list will should have different values according to the global varible values. how i can do this for my mvc project.
View 3 Repliesforeach (DataGridViewRow item in dataGridView1.Rows)
{
if (Convert.ToBoolean( item.Cells[0].Value) == true)
{
foreach (DataGridViewColumn col in dataGridView1.Columns)
{
**class oclass=new class();
oclass.property = item.Cells[col.Name].Value.ToString();
Collection.add(oclass);**
}
}
}
In the above syntax,i want to fill class property dynamically.I also add my class in collection.Is it possible in C#,fill class property dynamically?My grid contain more than one column.My grid's column name are same as class property name.I want to do the bellow thing:
foreach (DataGridViewColumn col in dataGridView1.Columns)
{
**class oclass=new class();
oclass.col.Name= item.Cells[col.Name].Value.ToString();
Collection.add(oclass);**
}
I'm working on an ASP.Net page containing a GridView, which is populated with customer orders returned by a stored procedure. What I'd like to do is dynamically change the backcolor of the GridView rows to indicate priority.
The stored procedure returns an integer indicating the records priority, I think I just need to translate the integer to a color, then make the GridView row display it.
The "making the GridView row display it" part is the one that's giving me a hard time.
What's the best way to do this?
i was working on an application where i was having large string and need to be divided in chuck of string, and should be kept in a div, just the purpose was giving pagination to the large string, so i wrote code to split the whole string into multiple chunks and added the chunk of string in a div created at runtime, and also disabled all the other div's except the first, and also given page numbers in the footer for changing pages, but now my issue is i am using anchor tags using HTMLAnchor from code behind, now whenever user clicks on any page that div should be set to display and other all should get hide, i am not getting how should i do this from code behind, i have done everything from code behind, from creating div to hiding div...
View 2 RepliesHow to assign style sheet to a dynamically seleted master page. like my master page will be selected dynamically as per used type and at that time I want to add a style sheet to it.
View 1 RepliesI'm trying to dynamically assign the visibility of the TabPanels in my page. The code below sort of works, but not correctly (refer to image).
It is able to hide the actual tab, but the header still appears (though unclickable). I need for the header and the tab to be hidden.
I tried to use "tb = (AjaxControlToolkit.TabPanel)this.page.findControl("TabPanel1").Visible = true"
And get this error Object reference not set to an instance of an object.
I can be pointed to the right direction.
[Code]....
I would like to dynamically load a user control and assign one of its public properties OnLoad...
I'm doing the following from a parent user control to dynamically load the child user control...
UserControl uc = (UserControl)Page.LoadControl("~/Controls/MyUserControl.ascx");
What else do I need to do to pass a value so its public property is set OnLoad?
How do I assign database to AccessDataSource control dynamically.
If I load aspx page by mypage.aspx?DB=100 then I want to use 100.mdb as data base
If I load aspx page by mypage.aspx?DB=200 then I want to use 200.mdb as data base
Both databases are identical except for the fact that data is different.
Here's default code - Need to replace Bold Code with equivalent of DataFile = response.querystring("DB") + ".mdb"
<asp:AccessDataSource ID="AccessDataSource1" runat="server"
DataFile="c: rims2k�00001000.mdb"
SelectCommand="SELECT * FROM [EquipmentUsage]"></asp:AccessDataSource>
in my asp.net+vb+access web i am having a page in which i am counting and displying the numbers in text boxes/labels. it works fine.
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim connectString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:webWing.mdb"
Dim con As OleDbConnection = New OleDbConnection(connectString)
[Code].....
i want to amend the value with the value of the text boxes that i had tried manually it works fine.
