I have a view created that I want to use as my datasource, however to enable to generate insert/update commands it specifies I must have all primary keys selected. Is there a way to set a column as a PK, or unique, within an already created view? And how?
View 2 Replies
I have a dynamically created grid view in the load even of my web page. I am setting its data source at run time like
gv.datasource = someObject.getItems();
gv.dataBind();
Now I wanted to hide, that is to make some of the columns visible false.
First how can I do that, Second should I write the code in the same page_load event or I should write the code some where else, cause when I add this line of code
gv.colums[0].visible=false;
an exception is produces "Argument out of range"
It happened to add an extra Gridveiw Header in row_databound event , It did worked fine on !Postback but disappered on Page.Postback . Quick google search guided me to move the event to Row_Created event and every thing is okay .
Can any expert post some pointers , differnces between grid row_created vs row_databount with some sample table data created dynamically behaviour of both the events in !Postback and page.Postback .
I want to view '*' in Database in password column
View 1 RepliesI have gridview and want to show datalist in grid view view column on click of linkbutton show.
[Code]....
i have a grid view with some coulmns like Name,Phone no etc with Edit,Delete column in grid view. I click a row in grid view to Edit,it goes another page where i can edit all fields .Once i update i redirect the page to gridview. I want the grid view to remain in that particular page say 4 of the grid view
View 5 RepliesI have a grid view with a few columns, for example a column in the grid view contains description of a product. The description might be very long, so i want to display only first 100 characters of the description and then provide a . when we click on the. then the whole description should be displayed.
View 3 RepliesNeed row editing on page_load for all the cells and need to validate each cell entry. Means cell1 one entery isvalid it fills thrid cell and insert or update to a table in the database. How do i handle on tab clicking to update in databse.
View 1 RepliesI have a stored procedure in my database that sorts a dataset by distance from the specific address input by the user. The distance is created among each individual users query and the sorting of distance occurs within my stored procedure, the distance is not returned in the output. Is there a way I can create a temporary column that returns the distance so that I can give the user an option to sort by distance?
View 9 RepliesI am creating dynamic view using two tables.one is emp_Tbl and 2nd table emp_salary which is created dynamically .creating view it gives error 'Create View or Function failed because no column name was specified for column 2.
my code is: create view [dbo].[Emp_Salary_pay] as select dbo.Emp_Tbl.Emp_Status, (select column_name + ', ' from information_schema.columns where table_name = 'Emp_salary' ) FROM dbo.Emp_Tbl INNER JOIN dbo.Emp_Salary ON dbo.Emp_Tbl.Emp_Id = dbo.Emp_Salary.Pay_Emp_Id
i have a grid view myGridView. I populate this gridview in the page load event as:
myClass newObj = new myClass();
myGridView.datasource = newObj.getItems();
myGridView.databind();
Now I wanted to hide some of the columns of the grid view. How I can do that?
GridView, TemplateFields. Is there a way to have a column only appear in DataBound View, but not in Edit View? Leaving EditTemplate blank only blanks out the row, not the entire column.
View 1 Repliesspeed Performane i create a web site but it very slow run i use tree view and grid view but i do it run very fast
View 1 Repliesi have gridview , it contains record of productsname field of product table and hyper link, hyperlink named as Detail.
when i click Detail link ,it will show record of that row in another page,means it shows complete fields of table in another page,,
i want to know only that,how detail link will perform,to view only that row record,
i'm tring to search my table according to id number or the case number then view it in a gridviewbut it work for the first time then after it stop for error
Dim conn As New SqlConnection
conn.ConnectionString = "Data Source=.SQLEXPRESS;AttachDbFilename=C:Program FilesMicrosoft SQL ServerMSSQL10.SQLEXPRESSMSSQLDATATask.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
[code]...
i have created a simple view, and display it into gridview.. i have successfully created view but it is not shown in grid view , it return nothing...
protected void Button3_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(@"Data Source=.SQLEXPRESS;AttachDbFilename=E:
arenHDI-AJAX-TK-Calendar-CSApp_DataDatabase.mdf;Integrated Security=True;User Instance=True");
con.Open();
SqlCommand cmd = new SqlCommand("select * from nview", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
con.Close();
}
I want to hide a grid view column if that column is empty. How do I do this? I dont have much exp. with grids.
View 23 Replieshow to get text value from each row in a specific column in a list view
View 6 RepliesI got this code which bind a datatable to a grid view. After the binding, i wanted to add additional column to the right of the grid, how can I do that? My codes below failed to do it.
[Code]....
The Header value of "ID1" is shown, but the cells only shows a '-' instead of 'New Column' sign.
i have a DatagridView which contains 5 columns. The Fifth Column can contain a number or a NULL value .
I need to edit the DataGrid it in such a way that the fifth column is hidden everytime.
And on a specific condition that if fifth column is not null , then display the value which is present in fifth column ,in a small subscript below the the corresponding element in first column .
I have a GridView that isn't databound until the user clicks a button...
[Code]....
The GridView has one bound column: the employee name. It also has a template field that has an empty asp:Table.
[Code]....
I populate the tblInfo in the RowDataBound event.
[Code]....
The CreateInfoTable(...) method manually creates the rows and columns for the employee. This works, and I can see my dynamically created table; however, after the user submits the form back to the server for PostBack, the rendered page after submission is missing my manually populated table. How can I save my table across PostBacks?
How can i create a hyperlink to Grid view column, when i click this column it should open Word documentnt.Each Column row values does have seperate information.
View 3 RepliesI have a grid view with a nested text box in it.I would like to turn view state off but the fact of the matter is when data is posted,the text boxes inside the gridview aren't available (there are no rows in the gridview on postback). Control's information is not stored in the View State (for things like selected value and .text etc.):Control state,introduced in ASP.NET version 2.0, is similar to view state but functionally independent of view state.However,control state cannot be disabled. Control state is designed for storing a control's essential data (such as a pager control's page number) that must be available on postback to enable the control to function even when view state has been disabled. Source: http://msdn.microsoft.com/en-us/library/1whwt1k7.aspx
View 2 RepliesDisplay grid view with column names when row count is zero. I dont want to insert new row when row count is zero. How can I achieve this
View 2 RepliesI have a grid view with manual sorting. In some cells, the data are numeric and datetime. But due to some constrains, the data type on tables are varchar. The problem here is when I sorting those numeric data, it is treated as varchar.Eg: 1, 12, 13, 2, 23, 3, ...But I wanted the order to be: 1, 2, 3, 12, 13, 23, ...I have tried these method, but it doesnt works.
[Code]...
