Web Forms Data Controls

Hide LinkButtons in Formview based on Role

2013-05-22T18:24:23.113-04:00

Need to be able to either hide the New, Update, Insert, Delete linkbuttons or hide the EditItem and InsertItem templates from users not in Admin Role. Can anyone assist

edit, delete, update only chat text witch is from user

2013-05-22T18:24:09.593-04:00

Dear reader,

I have made a chat with a data list in this datalist there is a label named lblUser.

Now i have made my script so far that in every chat Text a edit/update and delete button is so the user can edit there text if something is written wrong. The problem is they can also edit the text from other users. Is there some way how i can resolve this problem. I used cookies for recognize the user. Is post snippets of my scrit how i do something.

Most urgent question is How can i make the buttons edit/update/delete vissible "false" on the other users there post, so they can only edit there own post, or can i make my edit part in ItemCommand so that the edit button only on own post is working

Recognize the Loggedin User:

protected void Page_Load(object sender, EventArgs e)
    {
HttpCookie User = Request.Cookies["alwayson"];


        // Read the cookie information and display it.
        if (User != null)
            
        {
            lblUser.Text = User["Name"];
}
}

For editing the posted post:


protected void foradatalist_ItemCommand(object source, DataListCommandEventArgs e)
    {
        Label lblUser = (Label)foradatalist.Items[e.Item.ItemIndex].FindControl("lblUser");

        if (e.CommandName == "edit")
           
        {

            Label label1 = (Label)foradatalist.Items[e.Item.ItemIndex].FindControl("lblverhaal");
            tbpost.Text = label1.Text;
        }
        else
        {
        }

How to identify the ID of DDL inside ASP.NET Repeater!

2013-05-22T19:21:26.243-04:00

Helo all,

I try to update the value for DDL in each row of repeater. My detailed front end ASPX of the repeater as following:

--------------------------------------------------------------------------------------

<asp:Repeater ID="repeaterDept" runat="server">

<asp:DropDownList ID="ddlAge" runat="server">

<asp:ListItem>20</asp:ListItem>

<asp:ListItem>40</asp:ListItem>

<asp:ListItem>60</asp:ListItem>

</asp:DropDownList>

</td>
</tr>
</table>
</ItemTemplate>
</asp:Repeater>

When I populate the data from above repeater, the sample data look like as following:

John Sale ddl component

Kelly IT ddl component

...

How do I can set ddl value for first record such ddlAge?.SelectValue = 20 from dropdowlist items and ddl value for second record such ddlAge?.SelectValue = 40

I looked in source code view from brownser, I see the system generated the automatic ID= repeaterDept_ddlAge_0 for first record, ID= repeaterDept_ddlAge_1 for second record. Any ideas how to identify the dropdownlist control for each row? Thanks in advance.

girdview populated on buttonclick and on page navigation it disappears

2013-05-22T19:04:36.927-04:00

gridview populated with pages. If I try to select diff pages in the gridview it disappears but appears on buttonclick. I see its opening and closing sql connection on each page. Anyway I can avoid this. Heres is my code.

<td>Enter Name: </td>

<asp:Button ID="Button1" runat="server" Text="click search to find ID"onclick="Button1_Click" /> </td>

</tr><tr><td>ID:</td>

</asp:GridView>

Cs:

protected void Gridview1_SelectedIndexChanged(object sender, EventArgs e)

{

txtID.Text = GridView1.SelectedRow.Cells[1].Text;

}

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)

{

GridView1.PageIndex = e.NewPageIndex;

GridView1.SelectedIndex = -1;

GridView1.DataBind();

}

protected void Button1_Click(object sender, EventArgs e)

{

SqlConnection myConn = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ToString());

myConn.Open();

string strSQL = "";

SqlDataAdapter da = new SqlDataAdapter(strSQL, myConn);

DataSet ds = new DataSet();

da.Fill(ds, "");

GridView1.DataSource = ds;

GridView1.DataBind();

myConn.Close();

}

Sum values left to right in Gridview

2013-05-22T19:15:43.38-04:00

I have a gridview that now needs a new column for total, so the hours from the drop down list in each column will sum in the last column. I have a sum in the footer that sums these values from top down, but now how do I get the same function to return a sum for each row.

Here is the javascript I used for the footer sum and that works fine:

function hrcount() {

for (var c = 1; c < 11; c++) {

var total = 0

var val = 0

for (var i = 0; i < 10; i++) {

var name = "MainContent_gvts_hours" + c + "_" + i;

val = +document.getElementById(name).value;

total += val;}

var namea = "lblhrs" + c;

document.getElementById(namea).innerHTML = total;

<asp:TemplateField HeaderText="Insert Job" HeaderStyle-VerticalAlign="Middle" ItemStyle-HorizontalAlign="Center" >

<FooterTemplate>

<label id="lblhrs1">

</FooterTemplate>

<HeaderTemplate>

<div><asp:Button ID="btnjob1" runat="server" Text="Add Job" CommandArgument="1"

CommandName="addjob" /></div>

<div style="layout-flow: vertical-ideographic">

<asp:Label ID="lbljob1" runat="server" Text="" Font-Size="Medium"></asp:Label> </div>

</HeaderTemplate>

<ItemTemplate>

<asp:DropDownList ID="hours1" runat="server" style="text-align: center">

</asp:DropDownList>

</ItemTemplate>

<HeaderStyle VerticalAlign="Middle" />

<ItemStyle HorizontalAlign="Center" />

</asp:TemplateField>

need help...checkbox list - passing selected values to sql comma separated function

2013-05-22T18:54:03.067-04:00

I have a checkbox list and a many to many table. i am trying to use the checkbox list to filter a sql query and the funtion works. the query works, but when i try to hook up the html checkbox list to the query..it falls apart.

ex...
(dashes were for formatting purposes only)
person -------person/sport---------sport
_________________________________________
a ------------a | baseball------baseball
b ------------a | football------football
c ------------a | baseball------basketball
--------------b | baseball
--------------b | football
--------------c | baseball
--------------c | football
--------------c | basketball

i've been trying to use the sqldatasource wizard to plug everything together. i set the checkbox list as the control parameter, but for some reason, the query doesn't work properly when i try to debug the page.

when i test the query, if i pick any combo with baseball and basketball, or football and basketball...i get all 3 persons like i am supposed to.

when i debug and run the page, if i try any combo with basketball (ie baseball, baketball) person b does NOT show up and i don't understand why.

how do i send the checkbox selected values to the split function? is it possible to do this with the asp sqldatasource wizard? if not...how do i accomplish this?

here's the select parameter:

<asp:ControlParameter ControlID="DropDownCheckBoxes1"
                        ConvertEmptyStringToNull="False" DefaultValue="0" Name="Ids"
                        PropertyName="SelectedValue" Size="8000" Type="String" />

here's the function:

ALTER FUNCTION SplitDelimiterString1 (@StringWithDelimiter VARCHAR(8000), @Delimiter VARCHAR(8))

RETURNS @ItemTable TABLE (Item VARCHAR(8000))

AS
BEGIN
    DECLARE @StartingPosition INT;
    DECLARE @ItemInString VARCHAR(8000);

    SELECT @StartingPosition = 1;
    --Return if string is null or empty
    IF LEN(@StringWithDelimiter) = 0 OR @StringWithDelimiter IS NULL RETURN; 
    
    WHILE @StartingPosition > 0
    BEGIN
        --Get starting index of delimiter .. If string
        --doesn't contain any delimiter than it will returl 0 
        SET @StartingPosition = CHARINDEX(@Delimiter,@StringWithDelimiter); 
        
        --Get item from string        
        IF @StartingPosition > 0                
            SET @ItemInString = SUBSTRING(@StringWithDelimiter,0,@StartingPosition)
        ELSE
            SET @ItemInString = @StringWithDelimiter;
        --If item isn't empty than add to return table    
        IF( LEN(@ItemInString) > 0)
            INSERT INTO @ItemTable(Item) VALUES (@ItemInString);            
        
        --Remove inserted item from string
        SET @StringWithDelimiter = SUBSTRING(@StringWithDelimiter,@StartingPosition + 
                     LEN(@Delimiter),LEN(@StringWithDelimiter) - @StartingPosition)
        
        --Break loop if string is empty
        IF LEN(@StringWithDelimiter) = 0 BREAK;
    END
     
    RETURN
END

here's the query:

SELECT DISTINCT 
                         person.personID, sports.sportsID, person.personName, sports.sport,
 
FROM            sports INNER JOIN
                person INNER JOIN
                personSport ON personSport.personID = person.personID 
                       INNER JOIN
                personSport ON personSport.sportID = sports.sportsID
 
WHERE        (person.personName LIKE '%' + @personName + '%') 
              AND 
             (sports.sportID IN
                    (SELECT   ID FROM dbo.fnSplitter(@IDs) AS fnSplitter_1) OR @IDs = 0)
/*the @IDs = 0 is for the initial value...eveerything pops up on pageload*/

export table to CSV problem.

2013-05-21T14:59:16.84-04:00

My gridview table has a field called comment with a lot of words in some case with a comma(',") separated. When I want to export the gridview table to a CSV file. it caused the field separator ",". So I replace "," in this field to a ";" before export. However, for some reason, the exported file for this field only contains part of field;s content and rest of was converted into the next line. some cells in this field are okay.

my code in C# is a nested loop as:

for (int i = 0; i < GridView1.Rows.Count; i++)
{
//first column 0 starts at command column 0
for (int k = 1; k < GridView1.Columns.Count; k++)
{
//replace "," in the comment field otherwise
//it will be confused with separator ','
if (k == 14) //this comment field
{
string str = GridView1.Rows[i].Cells[k].Text;
str = str.Replace(",", ";");
if (str != null)
sb.Append(str + ',');
else
sb.Append("" + ',');

//Label2.Text = str.ToString();
}
//convert checkbox fields with value 1(checked) or 0 (unchecked)
else if (k == 17 || k == 20)
sb.Append(Convert.ToInt32(((CheckBox)GridView1.Rows[i].
Cells[k].Controls[0]).Checked).ToString() + ',');
else
//append each cell in each column to StringBuilder
sb.Append(GridView1.Rows[i].Cells[k].Text + ',');
}
//append new line
sb.Append("\r\n");
}

output example:

13253, 09/21/2007,383,27,5L,,0.007,11.257,2.753,0.006,0.098,2.854,613,SO4 very low ~1/5 rest
SRP low ~1/2 rest

you can see "SRP low ~1/2 rest" goes to the next line.

the orginal comment in this cell is: "SO4 very low, ~1/5 rest SRP low, ~1/2 rest no3_NO2 very low, ~1/4 rest"

there are some others cells in this fields like this. but some are exported correctly.

Any help will be appreciated.

GridView1 ... error on row deleting

2013-05-22T17:24:15.37-04:00

protected void GridView1_RowDeleted(object sender, GridViewDeletedEventArgs e)
{
    string a = GridView1.DataKeys[e.RowIndex].Value.ToString();

    string query = "delete from orderdetails where id='" + a + "'";

    SqlConnection con = new SqlConnection(@"Data Source=...");

    try
        {
            con.Open();

            SqlCommand cmd = new SqlCommand(query, con);
            cmd.ExecuteNonQuery();

            con.Close();
        }

    catch (Exception ex) { }
}

-------------------------------------------------------------------------------------------- & the arror is

Error 3 'System.Web.UI.WebControls.GridViewDeletedEventArgs' does not contain a definition for 'RowIndex' and no extension method 'RowIndex' accepting a first argument of type 'System.Web.UI.WebControls.GridViewDeletedEventArgs' could be found (are you missing a using directive or an assembly reference?) E:\OnlineShopping\cancellation.aspx.cs 102 41 E:\OnlineShopping\

Display query string value in a label

2013-05-22T14:35:19.12-04:00

in my asp.net web i used the following code

<asp:LinkButton ID="LinkButton1" runat="server"
PostBackUrl="unitlink.aspx?coy=tata">Tata</asp:LinkButton>

the data is correctly displaying in gridview.

there is a label (label1.text) in the same page i want to display the coy in that label alongwith the gridview

Setting a value in a grid view column

2013-05-22T15:34:41.4-04:00

I have a gridview that displays a list of bugs, from a list of projects. The bug table has the user, bug description, etc. What it does not have is the project where the bug was found. Another Database has the list of projects, but there is no key to join the two. To get the bugs from each project i get the project name (which is the same as the database name) and use it to pull the bug lists from each database.

protected void Button1_Click(object sender, EventArgs e)
    {
        //DataTable dt = new DataTable();
        int i = 0;
        foreach (GridViewRow rowItem in gvProjects.Rows)
        {

            CheckBox chk = (CheckBox)(rowItem.Cells[0].FindControl("CheckBox1"));
            bool cval = chk.Checked;
            if (cval == true)
            {
                string val = gvProjects.Rows[i].Cells[2].Text;
                string project = gvProjects.Rows[i].Cells[2].Text;


                dt = getbgs(val, project);
                

               
                GridView2.DataSource = dt;
                GridView2.DataBind();

            }
            i++;
        }
    }

    private DataTable getbgs(string val, string project)
    {
        string username = DropDownList1.SelectedValue;

        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["qcsiteadminConn"].ConnectionString);

        SqlCommand cmd = new SqlCommand();
        cmd.Connection = conn;
     
        cmd.CommandType = CommandType.Text;
        cmd.CommandText = "select  BG_SUMMARY, BG_USER_06, BG_RESPONSIBLE FROM " + val + ".td.BUG WHERE BG_RESPONSIBLE  = '" + username + "' AND BG_USER_06 <> 'Closed' AND BG_USER_06 <> 'Fixed' ";

        conn.Open();

        dt.Load(cmd.ExecuteReader());
        conn.Close();

        return dt;
    }

Gridview2 shows the correct fields. The project name is retireved in a variable before each project retrieved fromthe database, but I cnat see a way to add that variable to the datatable. Ihave a template field with a Label but I dont see how to add the value to it.

How to do rowspan in Header of Gridview??

2013-05-20T07:16:28.787-04:00

Hi all,

I am trying to make header in Gridview such that two headers have rowspan=2 ,i have done Yearly Target to have coloumn span=2 but how to make Sno and Component to have rowspan=2

This is my gridview:-

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource3" OnRowCreated="Gridview1_RowCreated" >
<Columns>
<asp:BoundField DataField="Componentname"
SortExpression="Componentname" />
<asp:BoundField DataField="Unit" SortExpression="Unit" />

<asp:BoundField DataField="Phytarget" HeaderText="Phytarget" ReadOnly="True"
SortExpression="Phytarget" />
<asp:BoundField DataField="Fintarget" HeaderText="Fintarget" ReadOnly="True"
SortExpression="Fintarget" />
</Columns>
</asp:GridView>

VB.net:--(griviewrowcreated event)

Protected Sub Gridview1_RowCreated(ByVal sender As Object, ByVal e As GridViewRowEventArgs)
If e.Row.RowType = DataControlRowType.Header Then
Dim HeaderGrid As GridView = DirectCast(sender, GridView)
Dim HeaderGridRow As New GridViewRow(0, 0, DataControlRowType.Header, DataControlRowState.Insert)
Dim HeaderCell As New TableCell()
HeaderCell.Text = "<h4>Components</h4>"

HeaderCell.ColumnSpan = 1

HeaderGridRow.Cells.Add(HeaderCell)

HeaderCell = New TableCell()
HeaderCell.Text = "Unit"
HeaderCell.ColumnSpan = 1

HeaderGridRow.Cells.Add(HeaderCell)

HeaderCell = New TableCell()
HeaderCell.Text = "Yearly target"
HeaderCell.ColumnSpan = 2
HeaderGridRow.Cells.Add(HeaderCell)

GridView1.Controls(0).Controls.AddAt(0, HeaderGridRow)

End If
End Sub

How to check for null value from textbox in gridview??

2013-05-22T15:51:01.797-04:00

Hi,

I need to check integer type value from textbox in itemtemplate , i am not geting VB code to check textbox value whether it is null or has some integer value in button click event,so how it can be done.???

How to do required field validation for textbox in Gridview??

2013-05-22T15:24:05.323-04:00

Hi all,

I have textbox in itemtemplate of gridview, i have button click event which saves all values from textbox in itemtemplate,so how can i do required field validation for textbox.

Thanks

how can delete a uplodedfile from a directory and session by clicking gridview delete buttion

2013-05-22T14:25:16.687-04:00

i have a post aspx page. where i post multiple file and after clicking upload buttion i take the data into session which i named session["Filelist"]. now i want to delete one of my selected file by clicking delete buttion. how i delete it from code behind..and it should deleted from folder and also from session...

<div>
                                                        
                                                      <asp:HiddenField ID="HiddenField1" runat="server" />
                                                        <asp:Label ID="Label1" runat="server" ForeColor="red"></asp:Label><br />
                                                        Choose Your File :<asp:FileUpload ID="FileUpload1" runat="server" />
                                                        <asp:Button ID="Button1" runat="server" Text="Upload" OnClick="Button1_Click" /><br />
                                                        <asp:GridView ID="GridView1" ShowHeader="False" ForeColor="#99CD99"
                                                            runat="server" AutoGenerateColumns="False" CellPadding="10"
                                                            onselectedindexchanged="GridView1_SelectedIndexChanged">
                                                            <Columns>
                                                                <asp:TemplateField>
                                                                    <ItemTemplate>
                                                                        <asp:Label ID="Label1" runat="server" Text='<%# Eval("text1") %>'></asp:Label>
                                                                    </ItemTemplate>
                                                                    <HeaderStyle HorizontalAlign="Left" />
                                                                </asp:TemplateField>
                                                                <asp:TemplateField >
                                                                    <ItemTemplate>
                                                                        <asp:LinkButton ID="lbtnDelete" runat="server" OnClick="GridView1_SelectedIndexChanged" >Delete</asp:LinkButton>
                                                                    </ItemTemplate>
                                                                    <HeaderStyle HorizontalAlign="Left" />
                                                                </asp:TemplateField>
                                                            </Columns>
                                                            
                                                        </asp:GridView>

                                                    </div>

    
//this is my code behind for upload file...

protected void Button1_Click(object sender, EventArgs e)
    {
        string str = Server.MapPath("~/Files") + "\\" + (Request.QueryString["id"]);
        List<temp> objList = new List<temp>();
        temp obj = new temp();

        if (!Directory.Exists(str))
        {
            Directory.CreateDirectory(str);
        }
        if (!File.Exists(str + "\\" + FileUpload1.FileName))
        {


            FileUpload1.SaveAs(str + "\\" + FileUpload1.FileName);

            if (Session["FileList"] == null)
            {
                obj.text1 = FileUpload1.FileName;
                objList.Add(obj);
                Session["FileList"] = objList;
            }
            else
            {
                objList = (List<temp>)Session["FileList"];

                obj.text1 = FileUpload1.FileName;
                objList.Add(obj);
                Session["FileList"] = objList;
            }

            GridView1.DataSource = objList;

            GridView1.DataBind();
        }
        else
        {
            lblfile.Text = "File already exits*";

        }
      
    }


pls help me how to do it.............pls pls pls.............

How Do I Find the Current GridVIew Row?

2013-05-22T15:18:38.253-04:00

I have a Gridview that has some DropDownLists in the EditItem Templates like the one below:

<asp:TemplateField HeaderText='Unit' SortExpression="unit" ItemStyle-HorizontalAlign="Center">
	<EditItemTemplate>
		<asp:DropDownList runat="server" ID="ddlUnit" AppendDataBoundItems="true" DataSourceID="SDS3" DataValueField="id" DataTextField="unit" SelectedValue='<%# Bind("unit") %>' OnPreRender="Unit_PreRender" >
			<asp:ListItem Value="" Text="Select a Unit..." />
		</asp:DropDownList>
	</EditItemTemplate>
	<ItemTemplate>
		<asp:Label ID="lblUnit" runat="server" Text='<%# Bind("unit") %>' />
	</ItemTemplate>
</asp:TemplateField>
<asp:BoundField HeaderText="Unit Assigned" DataField="unitassigndate" SortExpression="unitassigndate" ReadOnly="true" />

I need to be able to determine the current GridView Row from within the PreRender handler for the DropDownList but have not been able to do so. The goal is to take an item from one of the cells and add it to the Item List for the DropDownList.

Thanks!

Cannot Populate Gridview to dropdown selection event ..

2013-05-19T19:01:41.773-04:00

Hi all ,

I am using two dropdownlist to populate gridview , but still not working , Please Help me out to solve this.I would be very Thankful,

please give code of VB.net if required,

Code of .aspx file:--

<table align="center" cellspacing="16">
<tr>
<td>Select Year :</td><td>
<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True"
DataSourceID="SqlDataSource1" DataTextField="Yearname" DataValueField="Year_id" EnableViewState="true">
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:Connect %>"
SelectCommand="SELECT [Year_id], [Yearname] FROM [Year]">
</asp:SqlDataSource></td>
</tr>

<tr>
<td>Select Month :</td>
<td> <asp:DropDownList ID="DropDownList2" runat="server"
DataSourceID="SqlDataSource2" DataTextField="Districtname"
DataValueField="District_id" AutoPostBack="True" EnableViewState="true">
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:Connect %>"
SelectCommand="SELECT [District_id], [Districtname] FROM [District]">
</asp:SqlDataSource></td>

</tr>
<tr><td colspan="2">
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource3" >
<Columns>
<asp:BoundField DataField="Componentname" HeaderText="Componentname"
SortExpression="Componentname" />
<asp:BoundField DataField="Unit" HeaderText="Unit" SortExpression="Unit" />
<asp:BoundField DataField="Targetid" HeaderText="Targetid"
InsertVisible="False" ReadOnly="True" SortExpression="Targetid" />

<asp:BoundField DataField="Phytarget" HeaderText="Phytarget" ReadOnly="True"
SortExpression="Phytarget" />
<asp:BoundField DataField="Fintarget" HeaderText="Fintarget" ReadOnly="True"
SortExpression="Fintarget" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource3" runat="server"
ConnectionString="<%$ ConnectionStrings:Connect %>" SelectCommand="Hotarget"
SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList1" DefaultValue="5" Name="Yearid"
PropertyName="SelectedValue" Type="Int32" />
<asp:ControlParameter ControlID="DropDownList2" DefaultValue="5"
Name="Districtid" PropertyName="SelectedValue" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource></td></tr>
</table>

sorting the gridview to ascending and then to descending

2013-05-20T11:34:57.297-04:00

Ref     Ref Name    A B C D E F
540 Admin       0 1 2 2 2 3
454     Expenses    3 2 2 2 1 1
101     HR     1 2 2 2 2 2
107 Resources   3 1 2 1 1 1

when I clik on the 'Ref', it is sorting the Ref in the ascending order as follows

101     HR     1 2 2 2 2 2
107 Resources   3 1 2 1 1 1
454     Expenses    3 2 2 2 1 1
540 Admin       0 1 2 2 2 3

and the code for that is follows

protected void gvrecords_Sorting(object sender, GridViewSortEventArgs e)
    {
        GridView gv = sender as GridView;
        DataSet ds = new DataSet();
List<ReturnStatusRow> dataSourceList = gv.DataSource as List<ReturnStatusRow>;
        if (dataSourceList.Count>0)
        {
     Comparer<ReturnStatusRow> defComp = Comparer<ReturnStatusRow>.Default;
            defComp.Compare(dataSourceList[0], dataSourceList[1]);
            dataSourceList.Sort();

            gridview1.Datasource = dataSourceList;
     gridview1.DataBind();
}
}

public int CompareTo(ReturnStatusRow other)
    {

        if (this.Ref.CompareTo(other.Ref) != 0)
        {
            return this.Ref.CompareTo(other.Ref);
        }

        else
        {
            return 0;
        }

}
now for the second time click, it should sort in descending order. for the third- ascending,
fourth-descending and should continue in that pattern of ascending and descending for every click.

how should i write the code for that?

Add dynamic row below my gridview

2013-05-21T10:58:33.033-04:00

Hey there I after I populate my gridview , I wanna add a "add" button on the footer So I can add new data when it's running . What would be the easiest way to do this ?

Post Back Issue.

2013-05-19T22:23:56.697-04:00

I am not sure I am doing this correctly. I have few controls hidden and they appear depending on the value selected from a drop down control. Think my postback isn't correctly setup because I try to add an item on postback which doesn't appear unless I select one value then it appears. As I am hosting this without web hosting company I've had to add this to my page: EnableEventValidation="false".

<asp:UpdatePanel ID="updatepanelGender" runat="server" UpdateMode="Conditional">
<ContentTemplate>
<p>
<label for="gender" style="font-weight: bold">
Gender</label>
<asp:DropDownList ID="ddlGender" runat="server" AutoPostBack="true" OnSelectedIndexChanged="ddlGender_SelectedIndexChanged">
<asp:ListItem>Male</asp:ListItem>
<asp:ListItem>Female</asp:ListItem>
</asp:DropDownList>
</p>
</ContentTemplate>
<Triggers>
<asp:AsyncPostBackTrigger ControlID="ddlGender" EventName="SelectedIndexChanged" />
</Triggers>
</asp:UpdatePanel>

        protected void Page_Load(object sender, EventArgs e)
        {
            if (IsPostBack)
            {
                gender = ddlGender.SelectedValue;
            }
        }

        protected void ddlGender_SelectedIndexChanged(object sender, EventArgs e)
        {
            ddlGender.Items.Insert(0, new ListItem("Please select your Gender", ""));
            if (ddlGender.SelectedValue == "Male")
            {
                pnl.Visible = true;
                pnlHB.Visible = false;//female question
                pnlPB.Visible = false;//female question
                pnlBD.Visible = true;//male question
                pnlPH.Visible = true;//male question
            }

            if (ddlGender.SelectedValue == "Female")
            {
                pnl.Visible = true;
                pnlBD.Visible = false;//male question
                pnlPB.Visible = true;//female question
                pnlHB.Visible = true;//female question
                pnlPH.Visible = false;//male question
            }

            if (ddlGender.SelectedIndex == 0)
            {
                pnl.Visible = false;
                pnlBD.Visible = true;
                pnlHB.Visible = true;
                pnlPB.Visible = true;
                pnlPH.Visible = true;
            }
        }

Validating BoundField on Insert

2013-05-22T11:05:31.02-04:00

When using ObjectDataSource is there a built in way to prevent Insert if one of the BoundFields is empty?

Thanks.