I need to run a command (such as turn text red) if todays date is 30 days or more from the date in the gridview. How would I accomplish this? I can't really think of a way as I'm not good coding with dates.
View 8 Repliesi'm trying to issue a select command in my app soi could execute the command and retrive the data into a string variable.the problem is that this command is overloaded with DataSourceSelectArgument and i can't figure out what it is.i'm using sql server express and when issue a n insert command for example sq.Insert(); i have no problems.this the command that's holding me:
SqlDataSource sq = new SqlDataSource();
sq.ConnectionString = ConfigurationManager.ConnectionStrings["CustomerDatabaseConnectionString1"].ToString();
sq.SelectCommandType = SqlDataSourceCommandType.Text;
sq.SelectCommand = "SELECT * FROM CustomerTable where customerID = 1";
string result = sq.Select(some overload that's stopping me);
I have a Gridview and I allow fullscreen editing. I have some RequiredFieldValidators in my Gridview and this works fine. But if the user clicks on a dropdownlist in the Gridview and chooses "Rejected", I want to turn off validation. But I am not sure how to do this. Here is my code in the SelectedIndexChanged event for the ddl:
Protected Sub ddlPOACKCodes_SelectedIndexChanged(ByVal
sender As
Object,
ByVal e
As System.EventArgs)
[Code].....
But I get an error on this line: rfv = gvPODetail.SelectedRow.FindControl("rfv11"). the error is:
Object reference not set to an instance of an object.
I have a Gridview with some cells in numbers while in some cell they could be null without numbers. I need to modify it such that the numbers in the Gridview are in these formats:-
(a) If it is 12345.333 becomes 12,345
(b) If it is blank, I wish the cells to display 0
This is the code I am using to achieve (a), but when it comes to blank, it returns error (I believe my code below failed to provide blank cases but I dunno how. So what should be the code to do (b) above ?
For i As
Integer = 1
To N
e.Row.Cells(i).Text = String.Format("{0:#,##0}", Convert.ToDouble(e.Row.Cells(i).Text))Next
how would i do my Gridview delete command like a update command?
im using a datasource... and my delete command is like my update command... so i can change the status into "INACTIVE"...
DeleteCommand="UPDATE ACCOUNT_MAINTENANCE SET am_status = 'INACTIVE' WHERE (accmain_no = @accmain_no)"
UpdateCommand="UPDATE [ACCOUNT_MAINTENANCE] SET [account_type] = UPPER(@account_type), [min_deposit] = @min_deposit, [min_capital] = @min_capital WHERE [accmain_no] = @accmain_no"
when i press my delete command at gridview... the status changed into "INACTIVE" but when i refresh or press f5... it automatically update the status into "INACTIVE" also...
I am updating a gridview. Problem is that when I hide certain fields that I do not want the user to update, they lose their values ie. the data is wiped out in the field unless I show them on the grid and make them writeable. Is there a property I need to set for the field to retain the value when the grid is updated or is this in the sql statement?
View 7 Replies I just installed Visual studio 2010 ultimate RC on my windows 7 server. It doe snot show line number. So I went to Tool->Option->Editor, however, there is no where I cna find line number choice.
I used to have Visual Studio 2010 professional beta, it has the same problem, no line number to show up. However, it has a check box: line number. Even if I check the box, still no line number to show up.
I want to issue an INSERT command for an SQL Server table using DataAdapter without first issuing a SELECT command. Could anybody send me lines of code to handle this? Also how do i manage INSERT into selective table columns (I have 10 columns but i only want to update 2 of them)?
View 2 RepliesI've got 3 groups of controls each of which I want enabled/disabled depending on which radio button the user has clicked.
The code *works*, but daaaaaayuum the postback time from a radiobutton click is long.
I suspect my approach is the noobish way, and that there's a slicker way to achieve this control-groups-enabled effect.
how i can perform Update Row in Gridview using Template Feild's
[Code]....
[Code]....
what will be next step as i know how to write update statement in databasejust want to know how i can catch the template feilds value and update on click of edit
[Code]....
I started a C# web project in Visual Web Developer. I dropped a grid view in with designer and connected to my remote SQL database with the designer dialog based wizard. All is well there. I have in my program also a textbox where a user enters a zip code and clicks a button 'search'. When the user clicks search I want to run the SQL command "select * from flat_list where zipcode='userszipcode'". In other words the userszipcode is dynamic and different every time. It is my understanding I should use a SQLDataSource object but I do not know how.
View 1 RepliesUsing vb.net 2003,asp.net 1.1
I have a usercontrol on a page with 2 dynamic datagrids
on it with dynamic custom buttons, I get a questionID from
the buttons and that is ok.
What I need to know is which one of the grids gave me the questionID
so I can transfer to an approriate page.
For Instance:
If gridone was the sender/commandsource Then
Server.Transfer(pg1.aspx)
Else
Server.Transfer(pg2.aspx)
End If
Hope thats enough info,
i have a radiobutton list and i want the select statement of a SqlDataSource to change according to which radiobutton is selected. My code is as follows
[Code]....
It is giving me the following error when i put jon in the Text Box provided for searching Incorrect syntax near 'kae'. Incorrect syntax near 'Jon'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and
where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near 'jon''.Source Error:
[Code]....
Line 29: query = query + "WHERE ([Ufname] LIKE '%'" + txtSrch.Text + "'%')";
Line 30: SqlDataSource1.SelectCommand = query;
Line 31: SqlDataSource1.Select(DataSourceSelectArguments.Empty);
Line 32: }
Line 33:
how can we read all rows data in rowcommand event of gridview?
View 2 RepliesI'm having a problem with the results of a Gridview. The SQL statement I use works in SQL Management Studio, but in my .NET app, it only display a few of the results. The part of the SQL that seems to be effecting it is in the where statement I use like:
[Code]....
@Consultant comes from the value of a selected dropdown.
i have created one context menu when ever i Righ click on image that contex menu will come.my problem is how to track that image id when ever i Right click on that image.if i dont give the context menu the Item command is firing ,if give context menu it is not working.here is my code:
[Code]....
C#code:
[Code]....
I have started practicing a little on asp.net c# and I have a very simple problem which i cannot figure out. I have th following datalist code and below the code I have attached a screenshot of how does it look like.
task.aspx code:
[Code]....
task.aspx.cs
[Code]....
[Code]....
I am using this command to get the value of a particular cell in the GridView: Question: Do you know why I do not get a value in strValue ?
There is definitely value in the grid.
protected void grid_RowCommand(object sender, GridViewCommandEventArgs e)
{
//proceed only if the Details button is clicked...
if (e.CommandName.ToLower() == "details")
{
//Get the row index selected...
int index = Convert.ToInt32(e.CommandArgument);
GridViewRow row = grid.Rows[index];
string strValue = grid.Rows[index].Cells[1].Text;
}
is it possible to get row index in row command evend?
View 2 Repliesinside row command event of gridview i want to call a function which will open db conectn and run a stored proc to fetch value.but this gives error.
View 3 RepliesUsers can reply to a comment made in the parent repeater by clicking a link that opens a popup that inserts a row in the replies table. This is then displayed in the repeater as soon as the lists refresh. What I need to do is have a Delete comment link that only the user that inserted the reply can utilize. How do you get the command or onclick from a ImageBUtton that is in the child segment?
[Code]....
The Enabled='<%# isEnabled() %>' disables the button foe users that are not logged in...that seems to work OK
Command name and argument didn't work in datalist ! am I doing something wrong ??
[Code]....
Here is my datalist buttons;
<td><asp:Button ID="buttonytl" CommandName="Purchase" CommandArgument='<%# DataBinder.Eval(Container.DataItem, "YtlArgument")%>' style="font-size: x-small;" runat="server" Text="Book Transfer" /></td>[Code]....
I am trying to use an Update Command within my GridView. I need to find the "FindControl" for the Edit Command textboxes.
Ie. When the user clicks the Edit button, the row is populated with dropdown boxes, textboxes, etc for editting. Then when the user clicks on Update (button) and the GridView1_RowCommand function is activated with 'if (e.CommandName == "Update")' statement with my FindControl. etc. and my sql UPDATE command statements are used. How do I convert my FooterRow info to my Edit FINDCONTROL info?
This is what I have:
[Code]....
i am using edit,update,cancel command in gridview, i need to update value in bound field how to retreive that value.
View 7 RepliesI have a simple table, ID,Fruit,StockSo, the rows are its primary key (ID), Fruit type (Orange, Apple etc) and Stock (1 is it is in stock, 0 if it is out of stock).I have a grid view on a page which lists the rows.What I would like is a button that executes a SQL command based on the row.(The command is just an update to change the Stock field from 1 to 0).The query i tried was UPDATE [Table] SET [Stock] = 0 WHERE id = @id
View 6 Replies