Bind a GridView to a DataTable (in Viewstate) with full in-line CRUD

Hey all,

Havin quite a bit of trouble with this one.  I have a bunch of days that I worked in my database...mostly monday-friday and some saturdays.  What I want the gridview to do is add an empty line between each sunday and monday so that it seperates out my work weeks and makes it easier to read in the gridview.  I got some help here a few days ago on how to clone the db etc and I have all that working properly but I can't seem to wrap my head around how to do add these empty lines in the proper spots.  Here is my code so far:

private DataTable AddEmptyRow()
    {
        DataTable originalDataTable = GetItems();
        DataTable newDataTable = originalDataTable.Clone();
        DateTime testdate = Convert.ToDateTime("7/20/2010");

            for (int i = 0; i < originalDataTable.Rows.Count; i++)
            {
                DayOfWeek day = testdate.DayOfWeek;


                if (day == DayOfWeek.Sunday)
                {
                    DataRow newDataRow = newDataTable.NewRow();
                    newDataTable.Rows.Add(newDataRow);
                    newDataTable.ImportRow(originalDataTable.Rows[i]);

                }
                else
                {
                    newDataTable.ImportRow(originalDataTable.Rows[i]);
                }



             

Hi there,

Simple little problem. i have a gridview that shows products assigned to a customers job. They are displayed in exVAT prices. To make it easier i want to show the inc VAT prices. How can i add VAT to 1 column in this table?

The subject title should say it all, and I'm not sure what I've done to cause the problem.  Getting the GridView into editing doesn't pose a problem, but getting it back to read only does.

protected void ExceptionsGridView_RowEditing(object sender, GridViewEditEventArgs e)
    {
        string TXTCLIENT = ClientDropDownList.SelectedValue;
        string TXTPROV = DoctorDropDownList.SelectedValue;
        decimal TXTYEAR = Convert.ToDecimal(Calendar1.SelectedDate.Year.ToString());
        decimal TXTMMDD = Convert.ToDecimal(String.Concat(Calendar1.SelectedDate.Month.ToString().PadLeft(2, '0'), Calendar1.SelectedDate.Day.ToString().PadLeft(2, '0')));
        ExceptionsGridView.DataSource = schdExceptions(TXTCLIENT, TXTPROV, TXTYEAR, TXTMMDD);
        
        ExceptionsGridView.EditIndex = e.NewEditIndex;

        ExceptionsGridView.DataBind();
        ExceptionsGridView.EditIndex = -1;
       
    }

    protected void ExceptionsGridView_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        string TXTCLIENT = ClientDropDownList.SelectedValue;
        string TXTPROV = DoctorDropDownList.SelectedValue;
        decimal TXTYEAR = Convert.ToDecimal(Calendar1.SelectedDate.Year.ToString());
        decimal TXTMMDD = Convert.ToDecimal(String.Concat(Calendar1.SelectedDate.Month.ToSt

Hi Guys,

I have this entity model>> http://img840.imageshack.us/img840/306/schemaj.jpg and I would like to bind  a list  which consists of: employee's

• emloyee_firstname(employees table) + employee_lastname(employees table)
• employee's extension(employee_extension table)
• deparment name(departments table)

to my gridview. I already created my stored procedure

SELECT
    Concat(employees.employee_firstname," ",employees.employee_lastname) as name
    , extensions.extension_number
    , departments.department_description
FROM
    employee_extensions
    INNER JOIN employees 
        ON (employee_extensions.employee_id = employees.employee_id)
    INNER JOIN extensions 
        ON (employee_extensions.extension_id = extensions.extension_id)
    INNER JOIN departments 
        ON (employees.department_id = departments.department_id)
ORDER BY name

But my problem is, i don't know how to bind it since i don't have an entity that contains the employee's name, extension# and departments name. Do I need to create a custom class that consists of said columns? or is their a proper way to do this? I'

Hi,

I have a list box (that uses a SQlDataSource) that has a list of jobs. I have a grid view (that also uses a SQLDataSource) that has the items used in each job. I want to bind the list box value to the gridview on the client side, i.e. when the user clicks on a different job in the list view I want the grid to show the items for that job.

Also, at formload I want the gridview to show the details of the first job on the listview.

Please let me know how I can do this in the aspx page.

TIA

- Sankaran

I want to get the value of an xpath expression in rowdatabound event. But I get:
Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control.


<asp:GridView ID="gvSearchResults"  AutoGenerateColumns="False" DataSourceID="XMLDS" runat="server">
<Columns>
<asp:TemplateField>
<ItemTemplate>
    Rating:  <%# XPath("float[@name=""location_rating""]")%>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>

<asp:XmlDataSource EnableCaching="False" XPath="response/result/doc" ID="XMLDS" runat="server"></asp:XmlDataSource>


Protected Sub gvSearchResults_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles gvSearchResults.RowDataBound
    Dim value As String = XPath("float[@name=""location_rating""]")
End Sub

Hi all,

please i need to know if i could  bind dataGrid to dataTable Programmatically using wpf V.S 2010 (without using Xaml code)???

i google it before but i saw solution using (DataSet) and this not useful for me because its huge application.

Note : data source is MySql.

Thanks a lot .

Abed Salem

i have panel & i m trying to bind it with data table

as panel has no datasource property. can anyone solve it out.

DataTable dt=new DataTable ();

DataRow dr = dt.NewRow();
            dr["serviceid"] = ddlservices.SelectedValue.ToString();
            dt.Rows.Add(dr);
            foreach (DataRow row in dt.Rows)
            {
                PanelBody.Controls.Add(row);
                PanelBody.DataBind();
            }

thanks in advance

I have a ASP.NET gridview (embedded into a DIV) with several columns. For some columns line wraps are definied and for some not(with ItemStyle.Wrap = true/false). For all columns ItemStyle.Width is set to a specific value. Now I am wondering, that there is a line wrap in a column, where ItemStyle.Wrap = false. What could be the reason for that?

Hello,

My problem is with GridView and is as follows: I have a GridView that has DataTable as its data source. There is also one unbound column containing check boxes, indicating which rows to delete when a Delete button on the form is clicked. In Delete button click event handler I remove selected rows from DataTable, rebind data on GridView. This works as expected. The problem comes when I want to disable header row when GridView is empty (contains zero rows). To do this I call myGridView.HeaderRow.Enabled = false. Actually this call does nothing and as a result I have the header enabled. If I do not do data rebinding on GridView before disabling the header (or changing e.g. "check all" check box to checked state), it works, but rows are not deleted. What can be the problem with disabling the header in my case?