I'm using C# and SQL Server. I have one gridview which contain 3 columns "ID, COMPLETED (either yes or no), BY (adminID that completed)" and adminID can be null.
If user selected "yes" in COMPLETED column then how can I make sure that adminID in BY column is NOT empty or adminID entered is EXIST in database.
I am using seperate buttons to control whether edit and delete row linkbuttons are enabled or not on the GV. When I click a buton to enable the edit linkbuttons on the GV and then click a linkbutton for a row that puts it in edit mode. Then if the Delete button is clicked I have code that disables the edit linkbutton and enables the Delete linkbuttons. But, if there is a row in edit mode and the delete button is clicked, the edit linkbuttons disappear and the delete buttons appear (as expected) but the row that was in edit mode does not have a delete linkbutton in it and the row is still in edit mode with no update/cancel buttons. When the delete button is clicked, if there is a row in edit mode, I need to cancel any edit modes in any row.
View 3 RepliesI need to know how to check last updated rows in Gridview.
View 2 RepliesI need to check for duplicate records before inserting them into the SQL database.Thus I have the following codes:
For count = 0 To GridView1.Rows.Count
If (GridView1.Rows(count).DataItem("Student Name").Equals(dtDataTable.Rows(count).Item("Student ID"))) Then
lblMsg.Text = "Records Existed"
End If
but there are error message. "Object variable or With block variable not set."
i have code to update multiple rows in a gridview. What I want is that if the row value is = 1 in the database then the row is checked otherwise it's not. I've put some pseudo code in below to illustrate what I want to achieve.
[code].....
I having problem on the checking duplication entry on grid view. The situation is like this:
When i click Submit Button, The function will make a checking into mysql. If the data already exist then the submition of data will not being process. The error that i got here is, Both already exist and not exist data not being process. this is my checking coding
[Code]....
I have a textbox, when ab OrderNo is entered in the textbox 3 GridViews are generated.
GridView1 has general data about the order
GridView2 has data about the items on the order
GridView3 has data about reserved/back order items on the order. GridView3 only has data if the order has items reserved or on back order.
Is it a way to check if the GridView3 has data or not?
I have tried
If GridView3 isnot Nothing then
'gets some data from GridView3
End If
But does not work. The code still goes inside the code block and returns an error when finding no data...
i take data from Sqlserver database , and my prblem is that i want to get old and new values from gridview and base on that i want to change there background colors .. i try gridview rowupdating , editing ,updated Events but when i debug no break point hit and there was no value in ViewSate that i declare ,
View 2 RepliesIs there a cleaner way to check for a null value comming from the database?
Right now i am doing this
[Code]....
There has to be a better what than doing this on every row which could possibly be null
I have a checkboxlist (cblTeamMates) with a sqldatasource (sqlTeamMates) that has 3 columns (ID, FullName and Status ). The datavaluefield and datatextfield for cblTeamMates is "FullName" and the 2 status values possible are "Available" and "Absent". How do I go about, in the page load event, checking all the names (FullName) whose Status is "Available"?
View 3 Repliesi am using a gridview in my web page,i used to bind the database records to the gridview..my columns are name,empid,company name,pl leave,sl leave,total leave taken here total leave taken is not a database fields,in the page i want to fill the records once loaded pl leave and sl leave is added and display in the total leave taken column..it working properly when all pl ans sl columns fill with numbers,if some pl and sl leave having blank values.it showing an error like input sting was not in correct format..this is my code
<Columns>
<asp:BoundField DataField="slno" HeaderText="SerialNo"
SortExpression="slno" />
<asp:BoundField DataField="ecode" HeaderText="Employee Code"
SortExpression="empcode" />
<asp:BoundField DataField="ename" HeaderText="Employee Name"
[code]....
I'm lost. I have a sub gridview in a gridview. In subGridbiview I have a button. How do I can clicking the button and get values outside the gridview? The subgridview not present the events ...
------------------------Gridview 1------------------------------------------
| cell(0) | cell(1) | Cell(2)| Cell(3 - ITEM TEMPLATE) | -
| | | | # # # SubGridview1 ######### -
! x1 | Y1 | Z1 | # Cell(0) ! Button #-
! | | | ######################-
------------------------------------------------------------------------------
| | | | # # # SubGridview1 ######### -
! x2 | Y2 | Z2 | # Cell(0) ! Button #-
! | | | ######################-
------------------------------------------------------------------------------
how do I click on the child gridview and get the values of the parent gridview? no events in the child gridview no number indexrow on the parent gridview I'm lost.
I have one filed that is encrypted using Rajindal algorithm and stored in MSSQL db.When I retrieve that column in gridview it's displayed in encrypted. I have the code that decrypts it but the problem is:How can I all loop throw this column values in the gridview and decrypt them all and display it in the gridview decrypted.See my code below:
[Code]....
how to get the values text box values to gridview..
if i enter any text in text box those values should display in gridview.
after entering of 2 or 3 records, i will click on save then all the values of grid should insert in to DAta Base.
i dont want to get the values form Database to Gridview.
how to retrive the values form Database to Gridview.
i just want to display the values which are there in Textbox...
I would like to ask a question on the visual basic codes to loop the gridview to retrieve the values and based on the values, it will be provided as parameters to update to the database table using stored procedure.
Firstly, I have a gridview named grvProduct. The page (ui) will be loaded with data from the database with the use of stored procedures. And only certain values can be edited through the use of template in gridview. So based on those edited values, I'm supposed to pass these values as parameters to the stored procedure which will then update a database table.
Let say, I have 3 records retrieved from the database and displayed in the gridview. And I would like to edit a values in the 3 records, how do I do batch update and pass those parameters to the stored procedure? I went to debug and step through the visual basic codes and realised there were too many arguments specified because I actually loop the gridview.
Below is my visual basic codes:
[Code]....
Below is my Stored Procedure code:
[Code]....
I believe it is the error in the looping of the gridview which results that I could not batch update the data/values.
protected void rptNavigation_ItemDataBound(object sender, System.Web.UI.WebControls.RepeaterItemEventArgs e){
if (!((e.Item.ItemType == ListItemType.AlternatingItem) || (e.Item.ItemType == ListItemType.Item)))
{return;
}string Name = string.Empty;
if (IsDBNull(e.Item.DataItem["FullName"])) {
Name = String.Empty;}
else {Name = (string)(e.Item.DataItem["FullName"]);}
Literal ltlLiteral = (Literal)(e.Item.FindControl("ltlLiteral"));
ltlLiteral.Text = Name.ToString();
I get error for IsDbNull - Error 1 The name 'IsDBNull' does not exist in the current context. What's the best way to check for null values returned from db? also I get errors on both lines where (e.Item.FindControl(ltlLiteral")); is present ERror: Cannot apply indexing with [] to an expression of type 'object'
in my gridview i have a list of names that are bound.
in my aspx i have a list of names that i can select from.
i want to see if each selected name is already in the grid.
something like
if (li.Value == row.FindControl("Name").ToString())
I would like to know the fastest/easiest way to check if a CheckBoxList control has any checked items or not, I'm talking about an entire checkbox list as a whole, not a single checkbox.
View 1 RepliesHow to write an if condition, to check to see. only one can have value not both at the same time.
txtResubmitNoDays.Text or cpuResubmitDate.PostedDate.ToString
I want to know which fields were edited in a form in the Edit Action. I have a Log field in a table named "someTable" which I wish to add the change to, along with the Username of the current user. This is a simple implementation:
[Code]....
Can someone tell me where I am going wrong, because the getChangedAttributes function always returns an empty list (assuming because "backupTable" and "form" contain the same values? But shouldn't they be different?
I have a problem that can't find a way to do it, I have a gridview with this columns:
ID | AreaName | CostCenter
with the "Enable Editing" option check and what I want to do is to get the values of areaname and costcenter and assign them to a label control so I can use the values for something else, for example:
ID AreaName CostCenter
1 Multiconector 1025
2 One Conector 2065
3 Plug & Play 1445
4 Splitter 1598
5 FNI 4298
and if I hit the edit button of the row with ID 4, assign the values to the labels lblAreaName = Splitter and lblCostCenter = 1598
Before I edit them, and so on with the rows I want to edit.
how to check if a particular data in the database already, for example, i want to check if a username already exist in database, then the user cant choose that username.
View 6 RepliesI want to get the values from a cell in a gridview so can I do that without selecting a row. Its something like this I have a drop downmenu and based on the value selected in the dropdown menu I have to change the presentation of gridview without going to the database.
View 3 RepliesHere is the code with the issue:
[Code]....
The value of txtName, for example, contains the value prior to editing and clicking update. Here is the grid code:
[Code]....
Snap shot of asp code
<Columns>
<asp:BoundField DataField="DeptarmentID" HeaderText="DeptarmentID" ReadOnly="true" />
<asp:BoundField DataField="DepartmentCode" HeaderText="DepartmentCode" />
<asp:BoundField DataField="DepartmentName" HeaderText="DepartmentName" />
<asp:BoundField DataField="Active" HeaderText="Active" />
</Columns>
snap shot of page behind
protected void GridViewDept_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
GridViewRow row = GridViewDept.Rows[GridViewDept.EditIndex];
string code = ((TextBox)(row.Cells[2].Controls[0])).Text;
string name = ((TextBox)(row.Cells[3].Controls[0])).Text;
bool active =((TextBox)(row.Cells[4].Controls[0])).Text=="True"?true:false;
//bool active = ((CheckBox)(row.Cells[4].Controls[0])).Checked;
int id = System.Convert.ToInt32(row.Cells[1].Controls[0]);
}
I get error on the last line stating out of index error, how do get the value which is not set editable in the gridview