When the page loads, the GridView (located in an update panel) should be loaded with my first SQL SELECT statement. On the button click, the same GridView will be loaded with new data.
What am i doing wrong? On startup, the GridView doesn't appear.
Public cmd As New SqlCommand()
Public percentp As New SqlCommand()
Public da As New SqlDataAdapter(cmd)[code].....
Is declaring a constructor private or declaring a class sealed is same thing?
View 1 Replieshow to query the system date in selectcommand in gridview without using the codebehind. using c# .net
my code:
<asp:SqlDataSource ID="SqlDataSource1" runat="server" SelectCommand="SELECT * FROM tablename where date_today = <SYSTEMDATE>" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName
%>"
I've got a gridview which works fine. I use dropdownlists which are filled with distinct values of the columns. So when I select an item in a drompdownlist the gridview refreshes based on the selected value. When I have a column which uses string values, I can start the filter with a default % value to use in my select paramaters. But when I have a date column, I can't use that. I use a datasource for the gridview and I prefer to leave codebehind out if this is not needed. Now I use >= in my gridview select to show all rows. but I want to use only = to make the filter work correct when I select a date in the ddl and use the selectedvalue in the gridview selectCommand
<asp:DropDownList ID="ddlUpdateDatum" DataSourceID="dsPopulateUpdateDatum"
AutoPostBack="true" DataValueField="UPDATEDATE" runat="server"
CssClass="selectinput" AppendDataBoundItems="true">
<asp:ListItem Text="All" Value="01/01/1900"></asp:ListItem>
</asp:DropDownList>
<asp:SqlDataSource ID="dsPopulateUpdateDatum" runat="server"
ConnectionString="<%$ ConnectionStrings:GAMSYSTEMSqlServer %>"
SelectCommand="SELECT DISTINCT(UPDATEDATE) FROM [messages] ORDER BY UPDATEDATE ASC ">
</asp:SqlDataSource>
And I use this in the gridview datasource:
<asp:SqlDataSource
runat="server"
ID="dsGridview"
ConnectionString="<%$ ConnectionStrings:DBSqlServer %>"
SelectCommand = "SELECT * FROM [messages] WHERE AND UpdateDatum >= @UpdateDatePar ORDER BY UpdateDatumDESC"
>
<SelectParameters>
<asp:ControlParameter Name="UpdateDatePar" ControlID="ddlUpdateDate" PropertyName="SelectedValue" Type="string" />
</SelectParameters>
This grid looks great in the browser, but when printing, the date is duplicated - one w/ the correct format and one w/ the full datetime format (including hh:mm:ss). I've tried converting the datetime in the Select query, but keep running into error messages.
Here's the query:
[Code]....
And here's the grid, using an Obout control:
[Code]....
With asp 2.0 and vwd 2005, I have a page with a radiobuttonlist, textbox and gridview with edit/delete. Using the radiobuttonlist, the user selects a search type and then enters the criteria in the text box. the click event of a submit button checks the rbl.selectedindex and chooses a sqldatasource.selectcommand with the where clause getting its criteria from the textbox. The gridview loads the data, but the edit/delete are not working. Code and relevant markup is below
[Code]....
[Code]....
[Code]....
Why is it that I cannot declare List in my web service using asp.net just like what I got on a certain site.
Code:
List<string> responses = new List<string>();
I just noticed that I can save a lot of spacing by not using "as" when declaring variables, in some cases (not sure if this is something new in VS2010). For example:
Dim Name as string = "Bob"
works the same as:
Dim Name = "Bob"
I prefer the latter as some of my type declarations can be very long due to the library I am working with, and omitting the types simplifies the lines and makes them more readable. I am wondering a few things:
1. Do the two methods function at all differently?
2. Is this a bad practice, or generally excepted?
3. Is there a name for this?
I just want to know the declaration of variables in a separate class file or declaring in the same aspx.cs file. the best practice of declaring the variables.
View 3 Repliespublic Jquery Extra(this HtmlHelper htmlhelper,
string message,
IDictionary<string, object> htmlAttributes)
if i declare the this Htmlhelper htmlhelper when i declare my method, but i don't want to pass that parameter in when i call the method?
I have a really simple web interface which has been created in visual studio 2010 and is connected to an SQL server running MS SQL Server 2008. I essentially want the user to be able to enter values into the two text boxes provided and when the button is clicked, these values are inserted into the relevant table in the database.
When I run the code, I get an error back saying that the 'scalar variable for @clientName is not defined.' I have altered the insert statement to fixed values rather than entering from the text boxes and this works fine (ie, replace @clientName and @serverName in the insert statement with 'xx' and 'yy' respectively). How I can define these scalar variables. I'm not to sure what i'm missing. Code below.
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default2.aspx.vb" Inherits="Default2" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
[Code] .....
The code that the button executes is below
Partial Class Default2
Inherits System.Web.UI.Page
Protected Sub Button1_Click(sender As Object, e As System.EventArgs) Handles Button1.Click
SqlDataSource1.Insert()
End Sub
End Class
I want to declare a Dictionary<string, object> variable but don't know where/how to. The values in the dictionary will be objects from the Page (ListBoxes, DropDownLists, etc) so I can't exactly create a class somewhere else. Is there any way I can make this variable accessible from each method in the codebehind?
View 5 RepliesI have a DDL with 2 options: "Trainer" & "Observer." I'd like to use the selection from that DDL to reference a field in the SqlDataSource SelectCommand.
There are 2 fields in the table that may be referenced in the SelectCommand:
"Trainer_Oracle_ID" & "Observer_Oracle_ID." I'm trying to do something like:
WHERE @Oracle_ID_Type = <%=DropDownList_Oracle_ID_Type.Text%>_Oracle_ID
i.e. User selects "Trainer" and the SelectCommand references the field called:
"Trainer_Oracle_ID."
I am trying to pass a variable "PIN2" that I am retrieving like below to a SelectCommand statement in a asp SqlDataSource tag
<%
Dim PIN As String = Request.ServerVariables("LOGON_USER")
Dim PIN2 As String = Right(PIN, 6)
%>
How do you declare a dictionary called MyDic in the master page?
I want MyDic to hold lists of objects MyObj with a date as the key so that I can write something like this: "get the list for date 1/28/2011 from MyDic" or "put this list of MyObj from 1/28/2011 in MyDic".
I'd like to declare the dictionary in the master page so that I can access it in every page.
I got a simple SQL Connection which works fine under VS 2005, once I convert to VS 2008, is failed to work. I even re-build entire apps from scratch under VS 2008, yet it still failed.
Here's the code.
[Code]....
The code failed at this line:
objCon = New SqlConnection()
Error message being:
The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception.
I want to create a control just like a Panel.
I want my control to accept some controls as childs without typing the template name, just like the Panel, as shown here:
<asp:Panel runat="server">
My content
<div>Content</div>
</asp:Panel>
I have controls with content inside without telling what is the ITemplate.
I basically want to convert this
<my:MyControl runat="server">
<ContentTemplate>
My content
<div>Content</div>
[Code]....
The above works with <Content></Content> tags inside the control, but without it doesn't work. And the attribute isn't doing anything at all (I guess). What's missing?
I have this procedure
[Code]....
I don't know what variable should be put in where clause for tblVisitor.visitorID because there's a variable that was already passed by an output identity parameter by a different stored procedure. What will I put in the where clause for visitor id?
I have a Interface for CRUD operations.and some classes implemented it.I want to design a user control that have two buttons:insert and delete,to reuse this control over my forms.this class must have a instance of my interface to do insert and delete tasks (if I'm right).this is my interface:
[Code]...
my problem is,i can't declare a property of type ISchoolSystemRepository in user control,because i must pass T for interface.
What is the use of declaring the static class. I know that we cant create the object for the static class but i want to know that is the use of creating the class as static.
View 1 RepliesHow to get sqldatasource1.selectCommand value
[Code]....
i want to set that if nothing return i will display a msg to users.
I have a database with two columns: Retailers or Traders. A row can have only one of them with values while the other must be 'Null'. Both are nvarchars kinds. What I am trying to do is to show data if a radio button is selected for either Retailer or Trader. So I constructed a SelectCommand statement which is getting column names of either 'Retailers' or 'Traders' as a parameter but the SelectCommand statement still returns all records. What can I do?
<asp:SqlDataSource ID="dsSearchResults" runat="server" ConnectionString="<%$ ConnectionStrings:AdoFabricsConnection %>"
SelectCommand="SELECT Name,Address1,City,State,Zip, Telephone, Email_Address, TO_THE_Trade, Retailer,
[code]...
I have a legacy solution where all the DataSources are defined in the markup for all .aspx-pages. The problem I have with this is that the DataSource get instantiated several times since it is used in page, control... What I want is to have NInject to handle the instantiation of the DataSource so this doesn't happen. I have got that part to sort of work, but when the DataSource is defined in the code-behind instead of in the markup the Page property is not set on the DataSource, does anyone know why? A simple solution to this is to set the the Page property in a base class or something, but I do think that the property should be there and want to know why.
View 2 RepliesI am loading .aspx and .ascx files as StreamReader.
I want each file to register it's javascript and stylesheet dependencies in some declaration like a <%@ ClientDependency path="~/Scripts/jquery-1.4.1.min.js" %>.
Is there an existing convention for doing such a thing? I don't need an implementation, but I don't want to create a new syntax if there is already a way to do it.
Also, what are the guidelines for custom <%@ blocks in ASP.NET?
i have a dropdown list with values
America
Asia
Europe
I need to the display the ddl as Select Type and when i click the dropdownlist to see the values in it, it should display the three values, but i should not use Select Type as a list item and it should not be displayed in the list. It should only be used as a default text in ddl.
