I am using Visual Web Developer (VWD)and I dragged in i.e created a Gridview. In the codebehind of the page, I will like to declare an sqldatasource and get data from a database using the sqldatasource and then bind the sqldatasource to the Gridview. PS: I know how to drag-in an sqldatasource and attach it to the gridview using VWD but this time, I want to do this declaratively in the codebehind.
I have a code that read all data from sqldatasource and store it in exel file. my problem is,when the program run when i click on button,the message pop up to open or save, so by click on open or save we can either save it in exel file or open and look in exel file.
i want withought poping any message,it store the file directly to the specific folder without infomring the user.
I have a dropdownlist that's being populated from a SQL datasource. I would also like to have a tooltip for each dropdownlist list item on mouse over. I found the example below which adds a title attribute for each list item using the listitem text as a tooltip but I want to make the title/tooltip value another field in the database. In other words,
i am facing a minor problem but can't find out its syntaxi have listview, and inside the template i have 2 labels, in design time i bind 1 label to one column thatis 'type' and depending upon this type i want to bind other labels to different columnsif type is question than 2 label will have to show data of question columnif type is job than 2 label will have to show data of job, so on........how to accomplish this,in databinding event handler i can check the value of typebut i want to know the syntax of binding 2 label in run time, with different fields using EVAL
I have a listbox controll and i want to bind it with an SqlDataSource.SqlDataSource must be declared in the code behind but i don't know where declare it(page init,page load...)and how to add sql parameter dynamically (parameters are the selected values of listbox, so they are multiple).
i designed a gridview to update, delete the records using sqldatasource, (there is no code in my aspx.cs file) but i dont know how to add the new row the gridview. so that if the table is empty then i cant add / update / delete the data.
how to Add new record on gridview using SQLDatasource without any code behind code?
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls;
my data in gridview4 disappears when i click add to cart it shows no data again i have to pass a query from gridview 3 and then gridview 4 appears and then again if i click on add to cart in gridview 4 it shows no data.
I am using Ajax ConfirmButtonExtender Control in GridView for Deleting the Record. I am also Exporting the GridData to Excel using Render Method. But when i click on the Export Button, i am getting below error Extender control 'confirmID' is not a registered extender control. Extender controls must be registered using RegisterExtenderControl() before calling RegisterScriptDescriptors(). Parameter name: extenderControl
in my asp.net+access web code in vb. There is three labels named (tata.text,tvs.text,msu.text) is there any option on clicking on the label named tata.text the data pertaining to tata be displayed in a gridview in another page or a popup display in same page.
I have a gridview and a SQLDataSource control. In my gridview I have 2 commandfields "Edit" and "Delete"
The "Edit" command field works as expected. Using the "Delete" command field I get the error below.
Server Error in '/DataControls' Application.
The DELETE statement conflicted with the REFERENCE constraint "FK__titleauth__au_id__0CBAE877". The conflict occurred in database "pubs", table "dbo.titleauthor", column 'au_id'. The statement has been terminated.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: The DELETE statement conflicted with the REFERENCE constraint "FK__titleauth__au_id__0CBAE877". The conflict occurred in database "pubs", table "dbo.titleauthor", column 'au_id'. The statement has been terminated.