|
OK, but it doesn't relate to the presentation tier, so it's really a VB.NET or C# question. I'm only saying because asking in the right forum will get you more coverage and more answers.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
OK got it thanks bro
KaKaShi HaTaKe
|
|
|
|
|
hello frnds,
i have .Net framework 2.0 installed on my machine, I was developed one website which was run fine. But yesterday i upgrade the SP1 of .Net framework and my site gives scripting errors over there. i used Javascript, VBScript in website and take HTML buttons.
what should be the problem ???
any setting after installing SP1 ???
Thankx in Advance
koolprasad2003
Be a good listener...Because Opprtunity knoughts softly...N-Joy
|
|
|
|
|
koolprasad2003 wrote: But yesterday i upgrade the SP1 of .Net framework and my site gives scripting errors over there.
Really?? I too have websites which is developed in .NET 2.0 framework previously and I have upgraded my VS 2005 with SP1. They are working fine as before.
koolprasad2003 wrote: what should be the problem ???
What is the error, you are talking about? Could you please post somemore information about your errors?
Did you tried to convert you websites to web applications??
|
|
|
|
|
Hi All,
I have created a table called tblState in access with 2 columns: id and state and am populating a dropdownlist with state.
I am in need of code to delete a selected value of dropdownlist from database in asp.net2.0 using c#.
Can anybody help me please.
Thanks
Wajid
|
|
|
|
|
On postback, you can tell what your selected item is, what you need to be able to do, is turn that into an id you can use to delete the right record in the database. You do that when you populate the list, by using the unique ids as the data value for the list item ( the value that is not displayed )
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi Guy
do this way, put ur dropdwon list with Updatepanel,When you desired delete a item from the dropdownlist,first get the ID when u selectedValue, after send that ID to ur Database acces code and delete,after select all from the database and bind again to DropdownList,if you put in the updatepanel, doesn't take much more time for this operation.
Cheers
RRave
MCTS,MCPD
|
|
|
|
|
The OP never mentioned anything about needing asynchronous processing. Why are you suggesting using an UpdatePanel?
Ravenet wrote: put in the updatepanel, doesn't take much more time for this operation.
It takes just as much time as without an update panel. UpdatePanel just gives the user the perception of a faster operation because of the out-of-band processing and no page refresh.
only two letters away from being an asset
|
|
|
|
|
But, AJAX is the new magic bullet, didn't you get the memo ?
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Yes exactly.
Cheers
RRave
MCTS,MCPD
|
|
|
|
|
I was being sarcastic.....
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Guess he didn't get the memo
only two letters away from being an asset
|
|
|
|
|
Hi Guy
I think we want do fast work for that, becuase if when he select a item from the dropdownlist and process delete command, he wihs's delete from the database, so we must bind data again to dropdownlist, so i thought we reduce the time for the operation since, suggest AJAX update panel.
Just use ad tell me, how about applciation perfomance this operation
Cheers
RRave
MCTS,MCPD
|
|
|
|
|
The time it takes to perform the operation will not be reduced by using an UpdatePanel!!
only two letters away from being an asset
|
|
|
|
|
Hi Guy
i told not loading and getting and binding operation time man, i told page refresh and data show time. means, if u use update panel, postback time is very very less.
Cheers
RRave
MCTS,MCPD
|
|
|
|
|
Ravenet wrote: i told page refresh and data show time
No, you said
Ravenet wrote: if you put in the updatepanel, doesn't take much more time for this operation.
With only 2.5 years you obviously don't have "excellent experience in programming" or "excellent knowledge...with all other MS related languages and databases"
only two letters away from being an asset
|
|
|
|
|
Hi Man
i said about loading time . not data transfer time
Cheers
RRave
MCTS,MCPD
|
|
|
|
|
Hello Mr. Rave
I am not a very good programmer, just tryied following code but its not working.
when ever I am pressing delete button after selecting a value in dropdownlist, it just deleting the top most value.
--------------------------------------------------------------------------
C# CODE:
--------------------------------------------------------------------------
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
public partial class newDeleteValueDDList : System.Web.UI.Page
{
OleDbConnection cn;
OleDbCommand cmd;
DataSet ds;
OleDbDataAdapter da;
protected void Page_Load(object sender, EventArgs e)
{
getData();
}
protected void Button1_Click(object sender, EventArgs e)
{
connectDatabase();
string str = DropDownList1.SelectedValue;
string strDelete = "delete state from tblState where state='" + str + "'";
cmd = new OleDbCommand(strDelete, cn);
cmd.ExecuteNonQuery();
cn.Close();
getData();
}
private void connectDatabase()
{
string strConnectionString = Server.MapPath("~/App_Data/dummyDb.mdb");
cn = new OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=" + strConnectionString);
cn.Open();
}
private void getData()
{
connectDatabase();
string strSelectState = "select state from tblState order by state";
da = new OleDbDataAdapter(strSelectState, cn);
ds = new DataSet();
da.Fill(ds);
DropDownList1.DataSource = ds.Tables[0];
DropDownList1.DataTextField = "state";
DropDownList1.DataValueField = "state";
DropDownList1.DataBind();
cn.Close();
}
}
-------------------------------------------------------------------------
DESIGN SOURCE:
-------------------------------------------------------------------------
<body>
<form id="form1" runat="server">
<div>
<asp:DropDownList ID="DropDownList1" runat="server">
</asp:DropDownList>
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Delete" /></div>
</form>
</body>
--------------------------------------------------------------------------
ACCESS DATABASE:
--------------------------------------------------------------------------
ID STATE
-- -----
10 AAA
20 BBB
30 CCC
40 DDD
--------------------------------------------------------------------------
I am sending the relevent db and code which has been used in my code
If anybody can help I will be grateful to him.
Thanks
wajid
|
|
|
|
|
Are you certain that DropDownList1.SelectedValue is correct?
Since ID appears to be a unique key in the table structure use that for the value. This eliminates the need to pass strings around and do string comparisons. It also guards against deleting multiple rows with duplicate state values.
DropDownList1.DataValueField = "ID";
int id = Convert.ToInt32(DropDownList1.SelectedValue);
string strDelete = "delete state from tblState where ID=" + id + ";
only two letters away from being an asset
|
|
|
|
|
Hi Mark
Thanks for your help.
But still its giving same problem.
Thanks Again
Wajid
|
|
|
|
|
string strDelete = "delete state from tblState where ID=" + id + ";
only two letters away from being an asset
|
|
|
|
|
Hi Mark
Same old problem, Its not working.
But thanks for your suggestion.
Thanks
Wajid
|
|
|
|
|
i want to execute the text written in text box
e.g
i have a function
public void func(string s)
{
}
what i want to achieve is if i write
func("waheed")
in the textbox this function should be called on clicking a button
i cant use if/case etc
my requirement is this the textbox text will be passed to another function where this text will execute as code
Thanks
|
|
|
|
|
waheed awan wrote: i want to execute the text written in text box
e.g
i have a function
public void func(string s)
{
}
what i want to achieve is if i write
func("waheed")
in the textbox this function should be called on clicking a button
If you want this on javascript try the below on the onclick event of the button, (OnClientClick, if it is a Server Side button)
func(document.getElementById('MY_TEXTBOX').value)
If you want the above in ASP.NET, double click button, it will take you to the code behind, where you can try the below code in the Button Click event,
func(MY_TEXTBOX.Text);
Here MY_TEXTBOX is the ID of the textbox you mentioned
modified on Tuesday, February 12, 2008 9:52 PM
|
|
|
|
|
document.getElementById returns an object. How will this work in your example?
only two letters away from being an asset
|
|
|
|