ASP.NET

Re: How to pass & retrieve gridview as session variable.

1-Jun-09 9:29

The code above actually saves the data in a session. If he doesn't want to do the saving in the first page better save data into a Session and retrieve in the second page. Less burden on the Database too.

Not Active1-Jun-09 9:36

Not Active

1-Jun-09 9:36

Ibrahim Bello wrote:
Less burden on the Database too.

And when the data being stored in session is large or the number of concurrent users is high?

only two letters away from being an asset

Re: How to pass & retrieve gridview as session variable.

Ibrahim Bello1-Jun-09 21:36

GridView Editing with VB.NET

1-Jun-09 21:36

No, surely not Smile | :)

If that is the case (and he hasn't said whether it is) saving to database will be better.

MacIntyre1-Jun-09 6:47

MacIntyre

1-Jun-09 6:47

(VS 2005)
I need to display a set of parts to be loaded on a truck for shipping.
After the parts are loaded on to the truck the actual number of parts is entered back into the system in a simple data entry fashion.
All of the columns should be ReadOnly=True except the Quantity Loaded field: QtyLoaded.
I want the field to be editable when the page is presented. No "Edit" links should be required since all rows in this column should be entered.

I created this asp code, with ReadOnly=False on the QtyLoaded field and it still will not let me edit this field. Is there something I am missing here?
-----------------------
<asp:gridview id="GridView1" autogeneratecolumns="False" runat="server">
<asp:boundfield datafield="QtyRequired" headertext="QtyRequired" readonly="True">
<asp:boundfield datafield="QtyUsed" headertext="Qty Used" ><="" asp:boundfield="">
<asp:boundfield datafield="QtyRemaining" headertext="Qty Remaining" ><="" asp:boundfield="">
<asp:boundfield datafield="QtyLoaded" headertext="Qty Loaded" readonly="False">
<asp:boundfield datafield="PartNumberDesc" headertext="Description">
<asp:BoundField DataField="PartNumber" HeaderText="Part Number">
-----------
Thanks

Chuck

ToddHileHoffer1-Jun-09 10:28

ToddHileHoffer

1-Jun-09 10:28

Yes. If you want a field to be editable, use a template column and and a textbox or something like that.

I didn't get any requirements for the signature

MacIntyre1-Jun-09 11:03

MacIntyre

1-Jun-09 11:03

Todd, thanks for answering...
Here is the same code except I have changed the BoundField QtyLoaded to a TemplateField.
Please tell me what I have done wrong. This field just appears as a blank non-editable field (Column).

<columns>
<asp:boundfield="" datafield="QtyRequired" headertext="QtyRequired" readonly="True">
<asp:boundfield datafield="QtyUsed" headertext="Qty Used">

<asp:templatefield headertext="Qty Loaded">
<edititemtemplate>
<asp:textbox runat="server" id="txtQtyLoaded" text="<%# DataBinder.Eval(Container, "Qtyloaded") %>">

<asp:boundfield datafield="PartNumberDesc" headertext="Description" ><="" asp:boundfield="">
<asp:boundfield datafield="PartNumber" headertext="Part Number">

Thanks again

Chuck...

ToddHileHoffer1-Jun-09 12:21

ToddHileHoffer

1-Jun-09 12:21

<asp:templatefield headertext="Qty Loaded">
<asp:itemtemplate>
<asp:textbox runat="server" id="txtQtyLoaded" text="<%# DataBinder.Eval(Container, "Qtyloaded") %>">
<asp:itemtemplate>

I didn't get any requirements for the signature

How to create forum in asp.net

MacIntyre1-Jun-09 12:57

MacIntyre

1-Jun-09 12:57

Todd,
When I used EditItemTemplate
the QtyLoaded field was recognized.
With your change here is the error that I am getting:
System.Web.HttpException was unhandled by user code
ErrorCode=-2147467259
Message="DataBinding: 'System.Web.UI.WebControls.GridViewRow' does not contain a property with the name 'QtyLoaded'."
Source="System.Web"
StackTrace:
at System.Web.UI.DataBinder.GetPropertyValue(Object container, String propName)
at System.Web.UI.DataBinder.Eval(Object container, String[] expressionParts)
at System.Web.UI.DataBinder.Eval(Object container, String expression)
at ASP.inventory_materialloadtruck_aspx.__DataBinding__control27(Object sender, EventArgs e) in C:\WorkOrders\Inventory\MaterialLoadTruck.aspx:line 66
at System.Web.UI.Control.OnDataBinding(EventArgs e)
at System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding)
at System.Web.UI.Control.DataBind()
at System.Web.UI.Control.DataBindChildren()

Please advise!

Chuck...

Saiyed Alam1-Jun-09 6:11

Saiyed Alam

1-Jun-09 6:11

Hello friends
I want to create a forum using asp.net just like one can make using joomla
or wordpress.
I have never made any. So I don't have much idea. But I need to do this asap.
If there is any code or example or any sort of thing that will help me making this please let me know.
Thanking in advance

Johnny

Re: How to create forum in asp.net

Christian Graus1-Jun-09 11:32

Christian Graus

1-Jun-09 11:32

You need to read the link in my sig. It explains what you need to know.

Christian Graus

Driven to the arms of OSX by Vista.

Please read this[^] if you don't like the answer I gave to your question.

sql query

jainiraj1-Jun-09 6:06

jainiraj

1-Jun-09 6:06

I have a table "custmsgrecieved" with columns as-
CustId,Message,DateofMsg,Subject,Status,FromBrokerId(may have NULL value),FromAdminId,MsgId(may have NULL value)

I have a gridview with diff columns.One of column is binded with "Name".This "Name" is defined below in sql quey.I have to pick up this table in my gridview.I have a query-

"select cust.*,brok.FirstName+' '+brok.LastName as Name,
from custmsgrecieved as cust,brokerdetails as brok
where cust.CustId='1001' and brok.BrokerId=cust.FromBrokerId"

here "brokerdetails" is another table which contains BrokerId,FirstName,LastName as columns.

Now problem is arising that when there is a NULL value in FromBrokerId in custmsgrecieved table then that row is not appearing in gridview.

and if following sql is used-
"select cust.*,brok.FirstName+' '+brok.LastName as Name,
from custmsgrecieved as cust,brokerdetails as brok
where cust.CustId='1001' or brok.BrokerId=cust.FromBrokerId"

then that row is appeared no. of times equal to no. of rows in brokerdetails.

I want that in gridview row correspondimg to FromBrokerId=NULL in custmsgrecieved appears as it is that is appear one time and also that column of gridview binded with "Name" has text "administrator".

plz help me...

Re: sql query

Not Active1-Jun-09 7:31

Not Active

1-Jun-09 7:31

I'm not sure if I follow what you're saying or asking, but I believe you want to use a JOIN statement in your SQL

SELECT ...
FROM Table1
JOIN Table2 on Table2.field = Table1.field

only two letters away from being an asset

Passing an ID to an external .js file

dwolver1-Jun-09 4:44

dwolver

1-Jun-09 4:44

Want to do clienside validation on a textbox control. This textbox can represent two data types depending on an associtate checkbox. So if checkbox is checked the validation should do (a) and if off do (b)

In the javascript funtion below I do a getElementForID("chkBox1")
However if I want this to be a global routine I don't know what the checkBox would be
and preferably I'd like to pass an Integer so I could do multiple validations on this control or others. The "Sender" parameter seems to be my textbox, So question is how do I setup the ClientValidationFuntion property of the validator to pass an integer?

My custom validator is setup like this

<asp:CustomValidator ID="lsdCustomVal" ControlToValidate="txtBox1" runat="server"
                     ClientValidationFunction= "validateLSDControl"></asp:CustomValidator>

in my external js file I have >>

function validateLSDControl( sender, args)
{
      var expr1 = "[0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9]";
      var expr2 = "[a-z]-[0-9][0-9][0-9]-[A-Z]/[0-9][0-9]";
      var x = document.getElementById(sender.controltovalidate);
      var chkbox = document.getElementById("chkBox1");
      var smsg = "";
      if (chkbox.checked) {
            var patt1 = new RegExp(expr, "g");
            smsg = "expr1 Invalid";
      }
      else {
            var patt1 = new RegExp(nts, "g");
            smsg = "expr2 Invalid";
      }

      var result = false;
      if (x != null) {
            var s = x.value;
            if (s.match(patt1))
            {
//                  alert("it worked");
                  result = true;
            }
            else
                  alert(smsg);

      }
      args.isValid = result;
}

Re: Passing an ID to an external .js file

RajeevKumarSharma1-Jun-09 23:19

RajeevKumarSharma

1-Jun-09 23:19

if you are using masterpage then you must below code to access asp control

like

document.getElementById('<%= chkBox1.ClientID%>');

or

change the form's default name according you and access the control by

FORMNAME.GETELEMENTBYID

plz check it.

Rajeev Kr. Sharma
Sr. Software Engineer
E-Meditek Solutions Ltd.
http://www.emeditek.co.in/

Gridview in ASP.Net with C# [modified]

mahichandu1-Jun-09 4:18

1-Jun-09 4:18

Below is my databse table..

I can populate this data into the UI Page..
My task is to automatically delete the columns which has '0'(zero) value...and i have to delete the first row of my table...
Hear i am not going to use any itemtemplate column..
I have to write some code in codebehind..

JurisdictionID JurisdictionDescription Year1 Year2 Year3 Year4 Year5 Year6 Year7 
                                        2005 2006   2009      0   0    0      0      
AL                       Alabama         0     0    6         0   0    0      0      
AK                       Alaska          2     0    0         0   0    0      0

Could Anyone suggest me ..How to proceed further in detail with some code... Confused | :confused:

modified on Monday, June 1, 2009 4:24 PM

Ibrahim Bello1-Jun-09 9:24

1-Jun-09 9:24

foreach (GridViewRow Row in grd.Rows)
{
for (int i = 0; i<7; i++)
{
if (Row[i].ToString().Equals("0"))
{
grd.Columns.Remove(Row[i]);
}
}
}

I have not tested this code. Let me know if it works or not so as to fix the errors. Regards

mahichandu1-Jun-09 9:40

1-Jun-09 9:40

hey..i am getting some errors..when am using that code..
in which method we have to write tht code..
i wrote in...

public void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)

i am getting errors like this..

1) 'System.Data.DataRow.DataRow(System.Data.DataRowBuilder)' is inaccessible due to its protection level
2) Cannot apply indexing with [] to an expression of 'System.Web.UI.WebControls.GridViewRow'

actually am poor in c# technologies..could you sen dme solution fot this.. Confused | :confused:

Ibrahim Bello1-Jun-09 22:04

1-Jun-09 22:04

Sorry, I was closing from work when I posted. This should work:

foreach (GridViewRow Row in GridView1.Rows)
{
for(int i=0; i < 7; i++)
{
if (Row.Cells[i].Text == "0")
{
GridView1.Columns.Remove(GridView1.Columns[i]);
}
}
}

I called up this function from a button which I created. You can place it within the GridView1_RowDeleting if you wish without problems.

As per deleting first row, I suggest deleting it from database first (using sql query) and re-binding your gridview.

mahichandu2-Jun-09 6:36

2-Jun-09 6:36

hey..thnx for ur reply..

i am writting the code in the row delete event only...
i am not getting any errors..when i execute this code...somehow am unable to delete the columns....

is there any pother way to do..?

Ibrahim Bello2-Jun-09 7:03

2-Jun-09 7:03

If what you want to do is to delete a column from the underlying database table I'm not sure I can help you on that.

If what you want h/ever is to simply hide the column from the GridView this should work otherwise you can replace GridView1.Columns.Remove(GridView1.Columns[i]); with GridView1.Column[i].Visible = false;

I've tested the previous code and it worked.

Why not post more code for us to see where you're getting it wrong?

mahichandu2-Jun-09 7:19

2-Jun-09 7:19

by using above syntax also..i can't see anychange in the table..i can see all the columns..the 0(zero) value cell columns are not hiding.. Frown | :(

actullt my task is to delete those columns..am unable to do that..
atleast i want to try with hiding those columns.. Cry | :((

below i copied my code of populating data into gridview and the rowdelete event..

protected void Page_Load(object sender, EventArgs e)
    {
        PopulateGrid();
       
    }

    public void PopulateGrid()
    {
        SqlConnection sqlConn = null;
        SqlDataAdapter da = null;

        try
        {
            string connString = null;
            SqlCommand cmd1;
            connString = System.Web.Configuration.WebConfigurationManager.AppSettings["SqlServerConnectionString"];
            //connString = "Data Source = SQD-CON4\QSRV1; Initial Catalog = NDI; Integrated Security = SSPI;";
            sqlConn = new SqlConnection(connString);
            sqlConn.Open();
            cmd1 = new SqlCommand("[MED].[usp_SelectAllSDNCounts]", sqlConn);
            cmd1.CommandType = CommandType.StoredProcedure;
            da = new SqlDataAdapter(cmd1);
            DataSet ds = new DataSet();
            da.Fill(ds);
            GridView1.DataSource = ds.Tables[0].DefaultView;
            GridView1.DataBind();
        }
        finally
        {
            sqlConn.Close();
            da.Dispose();
            da = null;
        }

    }

public void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
       
        
           foreach (GridViewRow Row in GridView1.Rows)
            {
                for(int i=0; i<11; i++)
                {
                    if (Row.Cells[i].Text == "0")
                    {
                     GridView1.Columns[i].Visible=false;
                    }
                }

            }
    }

Ibrahim Bello2-Jun-09 7:31

2-Jun-09 7:31

Change:

protected void Page_Load(object sender, EventArgs e)
{ PopulateGrid();
}

to:

protected void Page_Load(object sender, EventArgs e)
{
if(!Page.IsPostBack)
{
PopulateGrid();
}
}

Does this help? Smile | :)

mahichandu2-Jun-09 7:48

2-Jun-09 7:48

no..hmmm

it remains the same..i can see the table with all column ..

if u want to know my design page ..see below..

%@ Page Language="C#" AutoEventWireup="true" CodeFile="MedPending.aspx.cs" Inherits="Maintenance_MedPending" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server" >
    <div>
         </div>
        <asp:Panel ID="Panel1" runat="server" style="position:absolute; left: 184px; top: 82px;" Width="740px" CssClass="borderPanel" Height="177px">
        <table style="width:600px;" class="borderPanel">
        <tr>
        <td>
            <asp:GridView ID="GridView1" runat="server"  HeaderStyle-HorizontalAlign="Center" Width="592px" style="position:absolute; left: 68px; top: 26px;" CssClass="GridRowGrayBorder" >
                <RowStyle CssClass="GridRow" />
                <HeaderStyle CssClass="HeaderRow" HorizontalAlign="Center" />
                <EditRowStyle CssClass="GridRow" />
                
            </asp:GridView>
            </td> 
            </tr>
            </table>
        </asp:Panel>
    </form>
</body>
</html>

Ibrahim Bello2-Jun-09 8:09

2-Jun-09 8:09

1. Try putting a breakpoint in the code provided and see if the Row's Cell Text ever evaluates to "0". Does it ever enter the function i gave you?

2. Have you hooked the Row_Deleting method to the control calling it? If not add:

OnRowDeleting = "GridView1_RowDeleting" to this:

<gridview id="GridView1" runat="server" headerstyle-horizontalalign="Center" width="592px" style="position:absolute; left: 68px; top: 26px;" <b="">OnRowDeleting = "GridView1_RowDeleting" CssClass="GridRowGrayBorder">

Or alternatively in Page_Load add:

GridView1.RowDeleting+=new GridViewDeleteEventHandler(GridView1_RowDeleting);

Hope this helps

Ibrahim Bello3-Jun-09 22:08