i have following code to bind gridview with sql datasource
Code:
[code]....
if it is 0 it checked it(checkbox) otherwise not ,all are enable too, i want that if it is checked it should become disable ,secondly i write some lines in code behind like row_databound event and put certain break point but it does not stop over that break point.
I want to access in code-behind a Textbox within the Template of a Formview.
[code]...
I am trying to start a new mobile web application project but cannot find the mobile page template originally available on VS 2005, nor can I get the mobile web controls to display in the toolbox even though I have then all selected in the tool-> select toolbox items why? and what can I do?
View 1 RepliesIm using enterprise Manager data access code block and have a table in sql server 2005 with a column type of 'bigint'
when querying against this table and adding in a parameter, there isnt a long datatype available, so is Int32 an equivalent ?
[Code].....
I am in VS2008 and in ReporViewer's Design page.
I have "Fruits" as column fields and Months as row fields and Sales as data field.
I have these columns:-
Apple, Orange, Pear.
However, I want it be displayed as
Orange, Pear, apple.
Any work around ?
Also I need a 4th column adding the Apple, Orange and Peer numbers total. How to do it in design view in VS2008 ?
I have a code to link to sql can anyone give me the same code for microsoft access....
try
{
int videoID = Convert.ToInt32(Request.QueryString["ID"]);
SqlConnection conn = new SqlConnection("server=WEBDESIGN-PC;database=Credentials;uid=sa;pwd=Azeem;");
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM videopath WHERE videoID=" + videoID, conn);
SqlDataReader dtr = cmd.ExecuteReader();
dtr.Read();
FlashVideo1.VideoURL = Convert.ToString(dtr["Filepath"]);
Label1.Text = Convert.ToString(dtr["Filename"]);
conn.Close();
}
catch (Exception ex)
{
Label1.Text = Convert.ToString(ex);
}
finally
{
}
As per my requirement, I am getting CompID, Company Name and URL from SQL database. I want to display just CompName and URL in gridvew. So, I need to hide the CompID in gridview. One way I can do BoundField field Visible to false but I need to retrive that compID id when user selected any of the row. if I set visible to false user wont see any compID in gridvew but I want access the selected compID also using SelectedRow.Cells[1].Text..
View 1 RepliesThis is a continuation of my other thread. Because of a slight shift of topic, I opened a new thread.I am generating my XML using a template. This thread is about getting the template to work, if you can help me - please don't suggest generating it another way. I would like to understand how this works and how to fix it. Alternative ways have already been discussed in the other thread.
Code:
<?xml version="1.0" encoding="utf-8"?>
<XML>
<Header>
<From>from</From>
<To>from</To>
</Header>
[code]...
I have set the Datasource of my gridview in code behind and created no columns (All columns in gridview are created automatically). Then I added a template column in gridview. Now I want to change the order of my Templated column in gridview at runtime. I want to show the templatedcolumn at column 20 but it is shown as first column. My Grdiview looks like this:
<asp:GridView ID="grdForecast" runat="server">
<Columns>
<asp:TemplateField></asp:TemplateField>
</Columns>
how can I set the template column at specified place(in my case it is column no. 20) and I've set Datasource and Databind the gridview in code behind at page load.
I have a datagrid and a template column which is bound. I don't understand how to set the sortExpression to make sorting on that column work.
View 2 RepliesI have a GridView that exports to .csv just fine with the code below. The problem is that I have a TemplateColumn with a TextBox which isn't wrote to the .CSV at all!
<asp:GridView ID="GridView1" runat="server" DataSourceID="as400"
AutoGenerateColumns="False" CellPadding="4" ForeColor="#333333"
GridLines="None">
<RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
<Columns>
<asp:BoundField DataField="IMSKU" HeaderText="SKU" />
<asp:BoundField DataField="IMDESC" HeaderText="Description" />........
I want to retrieve a single column from a table in a database(ms access) and then the value retrieved has to be converted to a string!!
View 4 Replies Can a query output made in MS ACCESS be accessed as a database in Visual Studio 2008?
I have a Parent and Child Table in MS Access with a one-to-many relationship. I created a query in Access that would produce a result table and I want the contents of this Query to be displayed in a Data Grid in Visual Studio 2008.
I have set the Datasource of my gridview in code behind and created no columns. Then I added a template column in gridview. Now I want to change the order of my Templated column in gridview at runtime. I want to show the templatedcolumn at column 20 but it is shown as first column. My Grdiview looks like this:
[Code]....
how can I set the template column at specified place(in my case it is column no. 20) and I've set Datasource and Databind the gridview in code behind at page load.
my c# web app containing a gridview template field with one column as dropdownlist,drop down list contains 3 items such as disposed,fitted to,battery room,when i click edit button corresponding row is selcted bt dropdown list contain its first value ie disposed instead of actual values in database, i used the following code for retrieving values from dropdown during updation
DropDownList tb3 = (DropDownList )GridView1.Rows[e.RowIndex].FindControl("drpstat")
;
my html code for my gridview is :-
[Code]....
I have the followingh scenario where I have a radgrid and inside it, I have a template column containing a check box:
[code]....
However, I only really want the user to be able to select one checkbox at a time.
Therefore, how to I go about ensuring that the any previous 'checks' are removed or stopping multiple checking altogether?
i want to sort my Gridview rows by a template column that is not bound to any database field. This template coulmn just has a label whose text i set in code depending on a value in a different column that is databound. So am stuck on how to set its sortExpression since its not linked to an column.
View 1 RepliesI have a gridview that I am dynamically creating and populating.
GridView myGrid = new GridView();
myGrid.Showfooter = true;
myGrid.Columns.Add(new BoundField() { HeaderText = "Serial #", DataField = "serial_number" });
...
...
...
myGrid.DataSource = myDS;
myGrid.DataBind();
My problem is that I'm having problems figuring out how to add a templatecolumn with a dropdownlist in it.
where I can find a 2 column css template with 100% content width?
View 2 RepliesI need to create a 'select/open file' template so it can easily be pulled into any page by any other Developer.
View 31 RepliesI have a checkbox template field in a grid view control. I want to execute some code when a checkbox is checked or unchecked - how do I do this? Which event is fired?
View 1 RepliesI have a question on adding a checkbox to my gridview that is binded to a SQLDatasource control. I have a field called SEL for the checkbox in my table. What I need to do is list the records and be able to check any of the existing checkboxes on any of the rows. When I added the checkbox in there, they are disabled and cannot change them. Is this where I need to use a type of template in the rows? Can they all be allowed to check without turning on the edit for each one individually at a time? I just want to check any needed.This is what I have there now:Code:
<cc1:C1CheckBoxField datafield="SEL" HeaderText="Select" SortExpression="SEL"></cc1:C1CheckBoxField>
I am trying to hide the first column of my gridview, a template/command column.
I want to export my gridview to Excel and the teplated contol shows up in the Excel file as a column.
This is what I tried in code :
Me.GridView1.Rows.Item(0).Visible =
False - This doesn't work !
Me.GridView1.AllowPaging =
False
Me.GridView1.AllowSorting =
False
Me.GridView1.EditIndex = -1
Me.DataBind()
Response.Clear()
Response.ContentType = "application/vnd.xls"
Response.AddHeader("content-disposition",
"attachment;filename=SearchedItems.xls")
Response.Charset = " "
Dim swriter As
New StringWriter()
Dim hwriter As
New HtmlTextWriter(swriter)
I need to change the image in my hyperlink template column (2) for each row, based on a column 3 text value.So if column 3 has a text of 0 the hyperlink image of template column 2 should be noedit16.png for that row else it should be edit16.png.Here is what I have:
<asp:TemplateField>
<ItemStyle Wrap="False" />
<ItemTemplate>
[code]...
I have a textbox added in an item template so I can enter data. But when I press enter in a textbox it caused the page to postback and I lose the data entered. I can tab through fine but why does Enter cause a postback? Can I disable this?
View 1 Replies