delete row in dataset - ASP.NET Discussion Boards

Hi,

Below code solves your problem.

<script language='javascript'>

function newtest()
		{
                //check box checked
		if(document.getElementById("CheckBox1").checked == true)
		  document.getElementById("DropDownList1").disabled = true;
                else  //check box uncheck
                  document.getElementById("DropDownList1").disabled = false; 
		}

</script>

Add the below code inside checkbox tag..

OnClick="newtest()" 'removed' text has to be changed to 'onclick'

Hope this helps you... Smile | :)

Thanks for ur Suggestion

Sir/Madam,
I want to select system month and year in dropdown list:
In detail i have two dropdownlist1, dropdownlist2 and 1st for months and second for years. it will automatically take month and year according to the system date. i have eneted items in months in character and year in numeric Confused | :confused:

Balwan Singh

Please do not double-post!

--------------------------------------------------------
My portfolio & development blog
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!

I would like to bind the slides in powerpoint to my datagrid .what all I should do for this.

Manoj Kumar
Infonet technologies
Hyderabad

I am currently using visual studio 2005 and given the task to implement a user/role management wif asp.net and atlas reference to this url
http://livedemos.peterkellner.net/AJAXDemo/

anyone has any ida how i can start on this?

I downloaded MembershipEditorAtlas1.zip and used asp.net configuration to configure it.

But it keeps giving the error

The type specified in the TypeName property of ObjectDataSource 'ObjectDataSourceMembershipUser' could not be found.
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.

Anyone has any idea... i really urgently need to get this to work... thanz

silverP wrote:
The type specified in the TypeName property of ObjectDataSource 'ObjectDataSourceMembershipUser' could not be found.

There are a couple things which you might want to check:
+ Where is the type specified in the TypeName property defined? (In the App_Code folder or in a seperate assembly)
+ Check the assembly reference if any.
+ Check if the type name in the TypeName property is qualified or not?

Gave up on earlier post of using imageButtons and command arguements, but can't get the following to work either. When trying to delete a row, and using the SELECT rows, I get an error of the selected index out of range even though I'm asking it to select the record in the dataset based on a primary key field (the rows commented out). When using the FIND rows, it stops on the row.delete() line with an error of "Object reference not set to an instance of an object." Really frustrated and would appreciate some help.

<%@ Import Namespace="System.Data.SqlClient" %><br />
<%@ Import Namespace="System.Web.UI.WebControls" %><br />
<%@ Import Namespace="System.Data" %><br />
<%@Page Language="VB" debug="True"%><br />
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><br />
<script language="vb" runat="server"><br />
Public strConn As String = "user id=myUser;data source=serverName;persist security info=True;initial catalog=myDatabase;password=pwd;" <br />
Public cn As New SqlClient.SqlConnection(strConn)<br />
Public ds as New Dataset<br />
Public da as New SQLDataAdapter<br />
Public varID as integer, varUPD as integer, varPG as integer<br />
<br />
Sub Page_load(sender as Object, e as EventArgs)<br />
if request("upd")="" or request("upd")="0" then varUPD=0 else varUPD=int(request("upd"))<br />
if request("eventID")="" or request("eventID")="0" then varID=0 else varID=int(request("eventID"))<br />
if request("pageID")="" or request("pageID")="0" then varPG=0 else varPG=int(request("pageID"))<br />
eventID.text=varID<br />
<br />
da = New SqlDataAdapter("sp_eCoursePage", cn) <br />
da.SelectCommand.CommandType = CommandType.StoredProcedure <br />
Dim p_ID as New SqlParameter("@ID", varID) <br />
da.SelectCommand.Parameters.Add(p_ID) <br />
da.Fill(ds, "pages")<br />
Dim autogen As New SqlCommandBuilder(da)<br />
Dim dt As DataTable = ds.Tables("pages")<br />
<br />
select case varUPD<br />
  case 1  ' Delete a record.<br />
    dt.PrimaryKey = New DataColumn() {dt.Columns("pageID_pk")}  'used find<br />
    Dim row As DataRow = dt.Rows.Find(varPG)                             'used find<br />
    row.Delete()                                                                           'used find<br />
    'dim mySQL as string = "pageID_pk=" & varPG  'used select<br />
    'Dim row As DataRow = dt.Select(mySQL)(0)    'used select<br />
    'row.Delete()                                                  'usedselect<br />
    da.Update(ds, "pages")' Update the database.<br />
    lblMsg.text=mySQL<br />
  case 2<br />
    dim myURL="adminEcourseUpdate.aspx?pageID=" & varPG<br />
    response.redirect(myURL)<br />
end select<br />
<br />
If ds.Tables("pages").Rows.Count = 0 Then <br />
    dgCourseList.visible=False<br />
else<br />
    dgCourseList.DataSource = ds.tables("pages")<br />
    dgCourseList.dataBind()<br />
    dgCourseList.visible=True<br />
end if<br />
if Not Page.IsPostback then <br />
    pageAdd.visible=False<br />
else<br />
    pageAdd.visible=True<br />
end if<br />
cn.close<br />
'OnItemCommand="dgCourseListItemCommand" - for imageButtons that couldn't get to work<br />
end sub<br />
</script><br />
<br />
<asp:DataGrid id="dgCourseList" autogenerateColumns="False" runat="server" ><br />
<Columns><br />
<asp:BoundColumn DataField="pageID_pk" Visible="False"></asp:BoundColumn><br />
<asp:hyperlinkcolumn dataNavigateurlField="pageID_pk" dataNavigateUrlFormatString="adminECourse.aspx?upd=1&pageID={0}" text="Del"></asp:hyperlinkcolumn><br />
<asp:hyperlinkcolumn dataNavigateurlField="pageID_pk" dataNavigateUrlFormatString="adminECourse.aspx?upd=2&pageID={0}" text="Upd"></asp:hyperlinkcolumn><br />
</Columns><br />
blah, blah.....

I have two pages A and B.

ON page A, I have three drop down boxes ( month , year, and unit_abbr and they have cascading and Auto post backs) and click button to run a report. What I am trying to do is keeping selected drop down list values after the postbacks. The problem right now is when I come back to page A after I browse page B , the selected values in dropdown boxes are set back to the default ( in my case most recent month, year, unit_num). How can I keep the selected values inside of dropdown lists while I am browsing around different pages? If I select month = 1 year 2006 unit_abbr = D11 to run the report on page A, then go to the different page to browse around different report and when I come back to Page A, the selected parameters in those drop down lists should be set to month = 1 year 2006 unit_abbr = D11

Here is my code using session variable:

<asp:label id="Label4" runat="server" text="Select Year:" forecolor="Black" font-bold="True" font-names="Arial" font-size="8pt">

<asp:dropdownlist id="DropDownList2" runat="server" datasourceid="SqlDataSource3" datatextfield="year" datavaluefield="year" font-names="Tahoma" font-size="8pt" autopostback="True" onselectedindexchanged="DropDownList2_SelectedIndexChanged1">

<asp:label id="AccountStatus" runat="server" font-size="16pt" visible="False" width="87px">

<asp:label id="Label5" runat="server" text="Select Month:" forecolor="Black" font-bold="True" font-names="Arial" font-size="8pt">

<asp:dropdownlist id="DropDownList1" runat="server" datasourceid="SqlDataSource2" datatextfield="month" datavaluefield="month" font-names="Tahoma" font-size="8pt" onselectedindexchanged="DropDownList1_SelectedIndexChanged" autopostback="True">

<asp:label id="Label7" runat="server" text="Select Region:" forecolor="Black" font-bold="True" font-names="Arial" font-size="8pt">

<asp:dropdownlist id="DropDownList4" runat="server" autopostback="True" datasourceid="SqlDataSource6" datatextfield="region_name" datavaluefield="Region_num" font-names="Tahoma" font-size="8pt" onselectedindexchanged="DropDownList4_SelectedIndexChanged">

--Here is code behind

public

partial class Dashboard : System.Web.UI.Page
{

protected void Page_Load(object sender, EventArgs e)
{

if (!Page.IsPostBack && ((this.Session["MMselectedvalue"] != null) && (this.Session["YYselectedvalue"] != null)

if (!Page.IsPostBack && ((this.Session["MMselectedvalue"] != null) && (this.Session["YYselectedvalue"] != null) && (this.Session["Unitselectedvalue"]) != null) && (this.Session["Regionselectedvalue"] != null))
{

this.DropDownList1.SelectedIndex = Convert.ToInt32(this.Session["MMselectedvalue"]);

this.DropDownList2.SelectedIndex = Convert.ToInt32(this.Session["YYselectedvalue"]);

this.DropDownList3.SelectedIndex = Convert.ToInt32(this.Session["Unitselectedvalue"]);

this.DropDownList4.SelectedIndex = Convert.ToInt32(this.Session["Regionselectedvalue"]);
GridView4.DataBind();

}

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{

this.Session["MMselectedvalue"] = this.DropDownList1.SelectedIndex;
}

protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e)
{

this.Session["YYselectedvalue"] = this.DropDownList2.SelectedIndex;
}

protected void DropDownList3_SelectedIndexChanged(object sender, EventArgs e)
{

this.Session["Unitselectedvalue"] = this.DropDownList3.SelectedIndex;

protected void DropDownList4_SelectedIndexChanged(object sender, EventArgs e)
{

this.Session["Regionselectedvalue"] = this.DropDownList4.SelectedIndex;

But, the problem is the data controls of drop downboxe ( sql datasource) are overwriting the session varialbles, so it set back to the default value...

How can I keep the session variables after the data binding ( sql datasource for drop downboxes)? ,and How can I ditermine whether it's just a postback ( changing selected values on the same page) or the user is actually changing the page( navigate different pages and come back to the same page).?

In the selectedIndexChange event handler add the selected index to a session.
Then in page_load you check for a postback (you do nothing). If there is no postback you check the session if it contains those stored indexes and if it does you fill the drop downs with data and then select the one that is in the session.

--------------------------------------------------------
My portfolio & development blog
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!

You may also need to set the selected indexes from session after the ddls are databound.

How can I do that? Can you provide me some code examples?

Thanks, I think I almost figured it out.. except the dropdownlist3 is still set back to the default value ( doesn't remember previous selected value). Is it because the dropdownbox3 is populated by the drop down box4 ( cascading dropdown box)? How can I work around this?

--Here is the code for dropdownbox3
<asp:dropdownlist id="DropDownList3" runat="server" datasourceid="SqlDataSource4" datatextfield="unitname_abbr" datavaluefield="unit_abbr" width="352px" font-names="Tahoma" font-size="8pt" onselectedindexchanged="DropDownList3_SelectedIndexChanged" autopostback="True">

<asp:sqldatasource id="SqlDataSource4" runat="server" connectionstring="<%$ ConnectionStrings:Finance_AppsConnectionString %>" selectcommand=" select distinct(unit_name) as unit_name,unit_abbr , ( convert(varchar(5), unit_abbr) + ' - ' + convert(varchar(50), unit_name))as unitname_abbr from revenue_aggregate where region_num = @region_num group by unit_name, unit_abbr order by unit_abbr">
<selectparameters>
<asp:controlparameter controlid="DropDownList4" name="region_num" propertyname="SelectedValue">

--------------------------------------------------Updted code
if (!Page.IsPostBack)
{
try
{
this.DropDownList1.SelectedIndex = Convert.ToInt32(this.Session["MMselectedvalue"]);
this.DropDownList2.SelectedIndex = Convert.ToInt32(this.Session["YYselectedvalue"]);
this.DropDownList3.SelectedIndex = Convert.ToInt32(this.Session["Unitselectedvalue"]);
this.DropDownList4.SelectedIndex = Convert.ToInt32(this.Session["Regionselectedvalue"]);

}

catch
{
}

}

else
{
}

Hi.

I have DataGrid that has 11 columns. Some of the columns are white and some are gray. How can I change row color onmouseover and when put the original color back? I've tried to use in the
ItemDataBound the following
e.Item.Attributes.Add("onmouseover", "changeMouseOverandOut(this, false)")

and in the JavaScript

var lastColorUsed;
function changeMouseOverandOut(row, highlight){
if(!highlight) {
lastColorUsed = row.style.backgroundColor;
row.style.backgroundColor = '#FFFF66';
}
else
row.style.backgroundColor = lastColorUsed;
}

It does work but only for white background. My gray background color doesn't change. Setting background color from ItemDataBound gives the same result so that's why I used JavaScript function (it is nice to try new things).

Please hlep. Frown | :(

Hi AlexFromTo Smile | :)

Here is a codesample that shows how you can get the desired result for a cell, you can probably modify the code to change a row instead.

http://www.codeproject.com/aspnet/DataGridHelperTool.asp[^]

Kind regards - Jakob Cool | :cool:

*********************************************
Three kinds of people in the world:
- Those who can count..
- Those who can't!

10 kinds of people in the world:
- Those who understand binary
- Those who don't

Thank you very much.

am developing a local site
how can i get the ip address of any client once calls any page of the site?

Request.UserHostAddress()

-
बुरा जो देखण मै चला, बुरा न िमलया कोय,
जो मन खोजा आपणा तो मुझसे बुरा न कोय।

Translation

thanks for your time

btw great quotation!!!

-- modified at 5:03 Wednesday 3rd May, 2006

could i find server to upload my files that are aspx
for 2 days or 3 days i mean free? to test my project in internet ?
thank you very much

Hello,

I am creating a web site using ASP.Net using C#. I want customers to buy products from the website. What is the best and most secure way to use different payment methods. The website will need to be able to use credit cards, and another payment method, e.g. paypay. What is the best way to implement these into a ASP.Net website?

Thanks in advance,

Steve

Nice Information

http://www.programmersheaven.com/2/PayPalIntegration

http://www.devx.com/codemag/Article/29342/1763

"Aim to go where U have never been B4 and Strive to achieve it"
http://groups.yahoo.com/subscribe/dotnetforfreshers
http://himabinduvejella.blogspot.com

Hello,
we are using Master Pages in asp.net 2.0. Our Master page has three contentplaceholders. On the left most ContentPlaceHolder we have all the links for the navigation of the site. One of the links on it is "Admin" link. Now, if some one with "Admin" Role logs in and clicks on it then the "Admin" link should populate all the other links underneath the "Admin" link. I am looking for some thing like toggel link.

Can some one please help me how do I accomplish this toggle link type of task.
Thanks
-L

I have to export reports built in .net 2.0 into pdf, word and xls formats.
Please note that i already have codes for crystal reports but the fact is that these reports are not crystal ones...so i actually have to export the page data in the above mentioned formats..

Please reply soon.. the deadlines are very strict.. D'Oh! | :doh:

Thanks & best regards....