DataSource Controls :: SQL Datasource / To Show A Message That There Is No Data Selected?
Mar 2, 2010
ASP.net SQL datasource C# code behind
I want the webpage to show a message that there is no data selected,
Instead of showing blank details view
here is a picture of blank details view:
[URL=http://img28.imageshack.us/i/errorks.jpg/][IMG]http://img28.imageshack.us/img28/4328/errorks.jpg[/IMG][/URL]
What C# code do i need to use so that, whenever I enter that page, only an error message will show up
instead of the details view ..etc.
View 3 Replies
Similar Messages:
Apr 24, 2010
i am trying to display a pop up message box on inserting the data into the database. The code i am using is as follows..
[Code]....
The problem is even on inserting the data and the data getting inserted into the database, the pop up mwindow does not get displayed. On debugging, it shows the value of i as 0.
View 12 Replies
Apr 15, 2010
i hve a data column containing data in this format...
1234-ab-1234
123-xy-123
12-ab-12
123-xy-123
1234-a-1234
12-s-1234
1234-xy-1234
how can i extract data between hyphens (ab, xy, a, s).. i need to extract distinct data only...
View 4 Replies
Aug 26, 2010
I need to show a tab two times in my web page ,,, each time this tab will be showed it will have different data will be called from a database while the page loaded >>>> when I use my code I can show the tab one time only
I will insert my code here look at it and tell me where the error
[Code]....
code behind is as follow:
[Code]....
View 2 Replies
Dec 12, 2010
I have a dataview on a page. I am binding a list of Items, and each item has a Person object. So I get this exception "field not found in selected datasource" when I try to bind to any property on the person object.
[Code]....
It appears that the dataview is having problems with the person object because it will display all the properties for the Item correctly.
why I get a not found on the boundfield and not on the eval?
View 2 Replies
Jun 3, 2010
I want to retrieve data from various column,which may some have blank value, so my problem is i want to retrieve only filled column(not any blank column) from multiple column.. I am doing this (given below) but it didn't return anything...
Column Name Value
Restaurant Restaurant
Spa Spa
Parking
Bar_Pub
Fitness_Center_Gym Fitness_Center_Gym
OleDbCommand cmd1 = new OleDbCommand("select nID Restaurant+''+Spa+''+Parking+''+Bar_Pub+''+Fitness_Center_Gym AS Facility from add_property where ncity='" + DropDownList1.SelectedItem.Text + "'", con);
DropDownList2.DataValueField = "nID";
DropDownList2.DataTextField = "Facility";
DropDownList2.DataBind();
con.Close();
--------------------------------------
View 9 Replies
Mar 4, 2010
I have a gridview with insert new row controls in the footer binded to sql datasource. I want to show the footer when the datasource is empty. Although the empty data template is there but any other solution you fellows can tell me ?
View 7 Replies
Feb 25, 2011
I am familiar with populating a gridview with data. I am able to bind the Data pulled from the database into the gridview
gridview.DataSource = myDataTable;
gridview.Databound.
If I write the following code, teh gridview will no longer show the data
gridview.DataSource = null;
gridview.Databound.
My question is , I want to make the same thing with a user control that contain a gridview. when I use the user control in an aspx page, I am able to populate it with data, but when I try to make this code, the Datasource does not show, instead, I see .DV. So I tried this code but then , I do not see DataSource property instead I see DV (DataView), when I put .DV = null, I get an error message that the object is not in existed. any idea how to clear the user control gridview from its data.
View 2 Replies
Nov 10, 2010
I have 50000 record in two tables which need to show in grid? and the records in the table use to insert , update and delete frequently. I need to load fast all the records. which method i should bind to get as quick as early as possible. Which z best method to bind whether using SQL datasource, creating views, using datatable, creating stored procedure etc?
View 8 Replies
Jun 23, 2010
Can someone please tell me what normally causes this error message (stack trace at bottom of this post)? I can't even tell what line or what page is producing the error.
Following are the relevant (I think) 2 code procedures...the Update command below seems to "work", because later I see that the image is updated---but I can't immediately see that: I get the above error message.
'FormView.ItemUpdating Event
Protected Sub AdvertisementForm_ItemUpdating(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.FormViewUpdateEventArgs) Handles AdvertisementForm.ItemUpdating
' Get the connection string from Web.config.
Using conn As New SqlConnection(ConfigurationManager.ConnectionStrings("MyDatabaseConnectionString").ToString())
' Create a command object.
Dim cmd As New SqlCommand()
' Assign the connection to the command.
cmd.Connection = conn
' Set the command text
' SQL statement or the name of the stored procedure.
cmd.CommandText = "UPDATE Advertisements SET UserName = @UserName, Age = @Age, Avatar = ISNULL(@Avatar, Avatar) WHERE UserId = @UserId"
' Set the command type
' CommandType.Text for ordinary SQL statements;
cmd.CommandType = CommandType.Text
' Get the person ID, first name and last name from the
' EditItemTemplate of the FormView control.
Dim strUserId As String = DirectCast(AdvertisementForm.Row.FindControl("UserIdTextBox"), TextBox).Text
Dim strUserName As String = DirectCast(AdvertisementForm.Row.FindControl("UserNameTextBox"), TextBox).Text
Dim strAge As String = DirectCast(AdvertisementForm.Row.FindControl("AgeTextBox"), TextBox).Text
' Append the parameters to the SqlCommand and set values.
cmd.Parameters.Add("@UserId", SqlDbType.UniqueIdentifier).Value = Guid.Parse(strUserId)
cmd.Parameters.Add("@UserName", SqlDbType.NChar).Value = strUserName
cmd.Parameters.Add("@Age", SqlDbType.NChar).Value = strAge
' Find the FileUpload control in the EditItemTemplate of
' the FormView control.
Dim uploadAvatar As FileUpload = DirectCast(AdvertisementForm.FindControl("uploadAvatar"), FileUpload)
If uploadAvatar.HasFile Then
' Append the Picture parameter to the SqlCommand.
' If a picture is specified, set the parameter with
' the value of bytes in the specified picture file.
cmd.Parameters.Add("@Avatar", SqlDbType.VarBinary).Value = uploadAvatar.FileBytes
Else
' Append the Picture parameter to the SqlCommand.
' If no picture is specified, set the parameter's
' value to NULL.
cmd.Parameters.Add("@Avatar", SqlDbType.VarBinary).Value = DBNull.Value
End If
' Open the connection.
conn.Open()
' Execute the command.
cmd.ExecuteNonQuery()
End Using
' Switch FormView control to the ReadOnly display mode.
AdvertisementForm.ChangeMode(FormViewMode.ReadOnly)
' Rebind the FormView control to show data after updating.
BindFormView()
End Sub
Private Sub BindFormView()
' Get the connection string from Web.config.
Using conn As New SqlConnection(ConfigurationManager.ConnectionStrings("MyDatabaseConnectionString").ToString())
' Create a DataSet object.
Dim dsPerson As New DataSet().
' Create a SELECT query.
Dim strSelectCmd As String = "SELECT UserId, Avatar FROM Advertisements"
' Create a SqlDataAdapter object
Dim da As New SqlDataAdapter(strSelectCmd, conn)
' Open the connection
conn.Open()
' Fill the DataTable named "Advertisements" in DataSet with the rows
' returned by the query.
da.Fill(dsAdvertisements, "Advertisements")
Dim dsAdvertisements As DataSet = New DataSet()
' Bind the FormView control.
AdvertisementForm.DataBind()
End Using
End Sub
Server Error in '/www.mywebsite.com' Application.
Incorrect syntax near ','.
[Code]....
Stack Trace: [Code]....
View 4 Replies
Mar 26, 2011
i have a dropdownlist that bind with sqldatasource1. everytime i load this page, dropdownlist will display directly the content of data.
However, what i want is display empty message like --Please select your currency-- by default.
View 3 Replies
Feb 25, 2010
i have two sqldatasource controls. one i use to display data in textbox's ,filter'd by a select parameter in page behind code. Once checked, i want to copy this data to the other datasource ,by selecting checkbox.Then display this data in detailsview control.
At present the two datasource controls declared , render data to the page simultaneously during pageload. I want to first check data in textbox's from first source, before second datasource is rendered to screen. note, both are filtered by a page variable. i wish to leave the textbox datasource control in situ, as other controls and code depend on it.The other detailsview datasource is my problem?
View 1 Replies
Sep 29, 2010
Scenario:
I am creating a custom gridview control which has a custom CheckBoxTemplateField column (deriving from TemplateField class). This template field column has custom Checkboxheadertemplate (implementing ITemplate) and CheckboxItemTemplate (also implementing ITemplate). In InstantiateIn method of both templates (header as well as Item template), I am adding a checkbox control which has Autopostback = true.
My requirement is:
I want to mark all the values in the binding column of datasource if checkbox in headertemplate is checked. I dont want to mark only rows visible on grid. I WANT TO MARK ALL ROWS IN DATASOURCE. I want to do this in _CheckedChanged event of checkbox in header template.
Problem I am facing: When I check/uncheck the checkbox in header, it postbacks. so in OnCheckedChanged event, gridview's datasource is null. Secondly, in any event of gridview, I could access only those rows of datasource for which corresponding rows are visible in gridview through Gridviewrow.DataItem property. But I want to set it for all rows in datasource.
View 5 Replies
Aug 9, 2010
This is the first time I have been working on databases and I am trying to insert data using an object datasource but no data is being inserted and no exception is thrown. I'm not sure where I am going to wrong. I am putting user data into session variables and inserting the session variables into the dataacess class layer and have a try and exception but nothing being thrown. Any help would be really appreciated because I don't know even where to start looking with this or how I can get the error to be thrown. Please see some of my code below to give an idea of what I am doing
Object Access Class
public void InsertCarPolicyHolder(PolicyHolderClass ph, CarInsuranceOptions options)
{
[code]...
View 2 Replies
Jul 12, 2010
I want to read the customers first name from the customer table below. Then right pad it with
blanks so that it will always have a length of 50 characters. This is not working for me and I need
help. Can someone help me? Here I create a temp table, populate it with the padded data. However
the padding does not work?
CREATE TABLE #Rab (YaName char(60))
select v.CustNum INTO Rab from (
select LEFT( FirstName + SPACE(50),50) As CustNum from Customer
) AS v
Customer table :
John Smith 22
Jimmy Gotro 33
Mimi Fox 31
View 6 Replies
Nov 15, 2010
The problem is that i have a search page. Access Database holding the information. I have a Access Datasource on the page with a Datalist to show the data. I need to find a way on setting it up to says "Sorry no results found" when the is no results. i am unsure on how to do this though.
Below is my datasource and datalist
[Code]....
View 6 Replies
Jun 11, 2010
This is my table structure :
ItemNo SubIteMNo Process
001 001 A
001 001/Z B
02 002 C
003 003 D
004 004 E
View 1 Replies
May 18, 2010
I have a DataSet that I bind to a GridView control. I want to only show certain columns from the DataSet. Should I do that with my SQL query (that I use to populate my DataSet) or somehow with a DataView?
View 7 Replies
Mar 25, 2011
I have a datagrid which is fetching data from my ASSETS table. The MaintenanceID field is linked to the MaintenanceID in the MAINTENANCE table. This also contains the MaintenanceValue (Yes or No). I have followed a tutorial so that in edit mode the dropdownlist in the gridview selects between Yes or No. This then passes through the value of MaintenanceID (but displays the MaintenanceValue).
I now want it so when i click update..instead of showing meaningless MaintenanceID (1 or 2) it shows the value (No or Yes). When I change it, it seems to mess up the drop down list and all kinds of things. I'll attach my current code - I think its a simple fix but as soon as I sort it - relationships and stuff go tits up! Datasource1 is populating the gird. Datasource2 is populating the dropdownlist template in the edit template.
[Code]....
View 3 Replies
Dec 6, 2010
The title pretty much says it all.
I'm trying to pass the selected value of a dropdown list to a stored procedure that will return a set of results based on the value passed.
View 3 Replies
Dec 24, 2010
I have dropdownlist which items are generated using SQLDataSource. And there is a "Delete Button" next to it. When user selects item from dropdownlist and presses that button I want the item to be removed from DB. Here is the question "How can I achieve this using sqldatasource Delete Command?" I do can remove Item From Code Behind. But i believe it's more efficient to use sqldatasource delete command.
View 2 Replies
Mar 10, 2010
I want to Update Column of a Table where ColumnName will be DropDown.SelectedValue. Example: A set of RECORDS will be displayed from a Customer Table where CUstNo ='1234' and City= 'Chicago' and Grade ='B' Once displayed I want to Update the grade to 'A' of all those customers from the above criteria. In My case I have like 100 Columns, so in where Clause Column Names will be selected from a DropDown. In My Query, Update Customer SET ColumnName= 'some value' where ColumnName ='ActualValue' So how can I pass the ColumnName which is Dropdown Selected Value. I believe I can't give as Update Customer SET DropDown.SelectedValue = 'some value' where DropDown.SelectedValue ='ActualValue' how can I resolve this ?...
View 9 Replies
Dec 19, 2010
I have to implement this common scenario but I'm getting in trouble (I'm new in asp)
I have to open a modalDialog, then I want an animation to indicate a "loading message" and when the data are ready
I want show them ina grid view. How can show the data when they are ready and interrupt the loading message?
View 2 Replies
Feb 2, 2010
how to get my perclock field to show a decimal? For some reason I keep getting '0'.
View 3 Replies
Jul 21, 2010
how can i show only the last INSERTED data entry made in SQLSERVER? And show that entry in a gridview but not all of the entries at once only the last one made.
View 1 Replies
