1. I know about collections but I dont remember the precess. I know you drag a sqldatasource control on the form(Select everything in the database ie. selct *) and then delete it. But how do I use it i code.
Example. I need to select services where country=canada from the Agencies table.
2. I know how to manually pull data from an access database using the code below. I want to know how to pull data from a sql database just like the one below.
3. explain the difference between Collections and manually pulling it like the one bellow?
I have a database (SQLExpress) to populate my web page with some products.
Some times, I want to perform an if else function to the result (which seems to be very difficult in asp.net for some reason - compared to asp.classic).
Is there a better way to do this? Or is this the correct way?
Second question is:
ds.Tables["B2B"].Rows.Count;
also works. correct my terminology but the ds parameters(?) Tables, Rows and Count all belong to ds. How does any one know this? How would I know what else I can use with ds? I have viewed the microsoft website to try to work out what I can and can't apply and have gotten no where! Is there a site which says if you use XX, then you can use the following parameters.
I am working on a web app that will heavily rely on configuration. The configuration is also will be written by another process or human. I am looking to get response on best practices in .net 3.5 on how to implement this case. I had used the configuration section of an early version of the Enterprise Library Applications Block. I really liked working with it but from what I hear it is discontinued in current versions. Hence the question... Need to be able to serialize collections, pick up file write event to reload new instance of config into memory.
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#.
My asp.net app has is using a web.config for common configuration. I also have a section that maps some data objects to connection strings, and that section is going to be couple thousand of lines. I want to move that section to another config file "dataMappings.config", so I don't bulk up web.config - is there a standard mechanism of accessing that config file?
I a custom config file which I am having problems reading from a class project, is there a simple way to do this? the path does not seem to be getting picked up in code, where as this works in a web project
I have a website written in C# that was running fine on one server. We moved it to another server and have a couple issues. I am mainly a VB.NET coder but can do a few things in C#. This is not a project - it is a website and can open it in VS2008 no problem. This is an admin site for the whole website where the user can add customer comments, etc. When logging in, it works fine. I can go to one of the admin pages after logging in and works. If I go to two other different pages, I get this error:
Object reference not set to an instance of an object.
[Code]....
It turns out this is in the main.master page and it is used by the other pages that load fine. The ApplicationTitle variable is set right in the web.config file and like I said, it shows on the other pages.
My question is why would this code work fine for some pages and not two others? All of these admin pages are under a folder called Admin and the web.config file is in the root folder of the website. Its almost like these two pages cannot see the web.config file in the root folder? Why would that be if thats the case?
Btw, when I have this loaded in VS2008 and try to do a Build, it says:
It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS.
I would assume the folders on the server are set right since all but two .aspx pages run fine. Just something I thought I would mention. This does not really seem to be a coding issue but something not set right especially since it ran on the other server just fine.
One of my NUnit tests has to read in some values from config files. In my main application this process works perfectly well, however when I run the unit test, the code that reads in the values from the config files doesnt read anything in. Ive tried putting app.config in my unit test project (I even tried web.config) but nothing seems to work. Are there any special steps involved when reading from config files in an nunit test ?
I have some inherited code which stores SMTP server, username, password in the system.net/mailSettings/smtp section of the Web.config.
It used to read them like so:
Configuration c = WebConfigurationManager.OpenWebConfiguration(HttpContext.Current.Request.ApplicationPath); MailSettingsSectionGroup settings = (MailSettingsSectionGroup)c.GetSectionGroup("system.net/mailSettings"); return settings.Smtp.Network.Host;
But this was failing when I had to deploy to a medium trust environment. So following the answer from this question, I rewrote it to use GetSection() like so:
I have a textbox that serves as a status panel (box) on the masterpage. I use the same code on two different content pages. On one content page, the write occurs. On another content page, the write does not occur. I even moved the code that was working into position on the erring page and it still doesn't write.
I'm seeing a really strange error that I'm having a difficult timetracking down. I think its related to my configuration of Rhino ESB, though I'm not sure if RSB is actually causing it, so I figured I'd ask and see ifanyone else has come across this in any other usages of MSMQ.I'm using RSB as a client in a web app (ASP.NET, the client runs in the background). The client talks to a windows service via the MSMQ binding for RSB. Restarting the service never appears to have an effect on MSMQ, neither does restarting IIS by hand. However, whenever I actually restart the computer itself, MSMQ always refuses to start back up, claiming that a "queue is in an inconsistent state". Attempting to start MSMQ manually results in the same error, effectively rendering the MSMQ install completely useless. The only way to solve it is to actually remove then reinstall MSMQ.
The only information I've found via the almighty Google are references to a problem in MSMQ 2.0 (this problem is occurring in MSMQ 4.0). I've verified that Dispose is being called on on the bus at shutdown, in both the service and the web site.
I have a code potion that runs a particular SQL and Fill the data in to a DataTable:
[Code]....
This code is working perfectly for a Query in my local machine without any error. But when I am trying to run this code in my friends machine (which is in the same network) I am getting the error 'ORA-00932: inconsistent datatypes'.I have tried to run the SQL in the database also (with the same user), but got no errors there. Could somebody please help me to get out of this problem?Here is the SQL I am running, the query is basically returning all the jobs that are being scheduled under Oracle 10g scheduler and the count of errors they have from the previous day:
Ran into a bit of problem when using PageMethods when calling a webmethod in the code-behind. My markup page has a radgrid which gets populated via the objectdatasource.Pagemethods works and returns data as expected when the objectdatasource binds the radgrid with some data but not when the objectdatasource returns nothing, i.e. radgrid is empty. PageMethods call has got nothing to do with the objectdatasource, I'm simply using its output to build a list of checkboxes dynamically on the client side using Javascript. And this is how my code snippets looks like:Markup page:
<script type="text/javascript"> function CallGetARInvoices(src,dest) {
I've got stuck for this for a long time. I always got empty value for the posted data. Here is my code:
Protected Function sqlparameter_insert_newscat() As SqlParameter() Dim sqlparam(4) As SqlParameter Dim ddlstatus As Boolean If rbActive.Items(0).Selected = True Then ddlstatus = True Else ddlstatus = False End If sqlparam(0) = New SqlParameter("@username", SqlDbType.VarChar, 30, ParameterDirection.Input, False, 0, 0, "", DataRowVersion.Current, Session("user.id")) sqlparam(1) = New SqlParameter("@news_category", SqlDbType.VarChar, 255, ParameterDirection.Input, False, 0, 0, "", DataRowVersion.Current, news_category.Text) 'Response.Write(HttpContext.Current.Request.Form(name)) sqlparam(2) = New SqlParameter("@news_category_desc", SqlDbType.Text, 1000000, ParameterDirection.Input, False, 0, 0, "", DataRowVersion.Current, HttpUtility.HtmlEncode(news_category_desc.InnerText)) sqlparam(3) = New SqlParameter("@news_category_status", SqlDbType.Bit, 1, ParameterDirection.Input, False, 0, 0, "", DataRowVersion.Current, ddlstatus) sqlparam(4) = New SqlParameter("@news_category_parent", SqlDbType.BigInt, 100, ParameterDirection.Input, False, 0, 0, "", DataRowVersion.Current, ddlRoot.SelectedValue) Return sqlparam End Function
the news_category.text always the empty string even the dropdownlist selected value return empty string. Is this an error of bug in Visual Studio 2010? I 've got stuck for this for long time and i have been nearer to deadline. I just made change "ValidateRequest = False" to aspx file to permit html tag to be posted.
I have a form that contains times and dates. Each of these controls has a required field validator so that the user must put in the date and time. This apprears to work fine in testing. The data is stored in sql tables which are then worked with in the office using an Access Database. The webforms are simply used for gathering the data. In analyzing the data, they are finding that there are instances when no time has been stored. I don't know how the insert information could be saved if the control was blank. To make matters worse, the staff swear that they are entering the times.
I have a simple form with a list of linkbuttons, each fires the same onclick event which sets an indicator image. I have a dummy button with style="display:none" which I have set as the TargetControlID of the modal.
onClick event from the imagebutton, the modal is shown via modal.Show(). The cancel button inside the modalpopup fires an event which turns off the indicator image and hides the modal via modal.Hide().
The events fire perfectly, it's very simple! Although after doing some testing I noticed the modalpopup is not presented after the 6-10th cycle of clicking the open event, then clicking cancel. The grey background appears but it is behind the main panel and the modal is either presented behind this or is just simply not displaying.
I spent hours researching various methods, implemented the CancelControlID to see if it was somehow tied to my call of modal.Hide() that fails.This occurs with an updatepanel only. The behaviour is much cleaner this way, so I would hope to be able to implement this. I have basically eliminated everything but these two events!
Create a control 'ClassName' in file ClassName.cs. Path is c:ProjectWebuserControlsControlTypeClassName.cs
[code]...
The really bizarre thing is that the error is inconsistent.Sometimes the project builds, sometimes some files break the build, sometimes others do, sometimes all of them do.
I know this is probably a pretty easy thing to do and it is if I can upload the file and store it onto the hard drive of the server. What I need to do is read the text file into memory and then parse through it one line at a time. Anyone have any code that demonstrates that?
I have this ListView that has a Drop Down List.Everything works fine (I think/hope) except that the drop down list are not showing its result correctly.This is the code.
Front-End [Code]....
The code behind consist of the page_load and the ItemDataBound [Code]....
I'm having a problem with my Linq to XML query. I'm getting the result data I want, but it's nested so deep that there must be a better way.Here is my XML:
[Code]....
I'm trying to get a list (simple string[]) of all Item IDs where Category Names contains "Other".Here is my Linq:
[Code]....
[Code]....
Here is a snapshot of my result from Visual Studio:The results I want are there ("item100", "item400", "item500"), but buried so deeply in the results var.
So I'm coding up a simple blogging/content application in MVC2. In my EF domain model I have an abstract entity named "Resource" which serves as a base class for any content that can be published. I have entities named "Picture", "BlogEntry" and "Event" which all inherit from "Resource".
My problem is, it seems it doesn't make collections for Pictures, BlogEntries and Events. I only have a collection of Resources. How can I get collections of the inherited classes? Is it something I'll have to create myself? If so, how?
