|
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
|
|
|
|
|
It should be
func(document.getElementById('MY_TEXTBOX').value);
Thanks Marks for pointing out.
|
|
|
|
|
|
THANKS
the arical you gave me reference is very helpful and it solved another problem that i was facing
but here my problem is
as i write
func("vaue"); in the cs file the function is called
what i want to achieve is when i write
func("vaue"); in the textbox then on clicking the button the textbox should be executed
|
|
|
|
|
waheed awan wrote: then on clicking the button the textbox should be executed
I don't understand what you are asking for here.
Do you want something like; func("Console.WriteLine("Hello, World");" ) which causes "Hello, World" to be written to a console window?
only two letters away from being an asset
|
|
|
|
|
i want to say
the textbox will be used to write code statements and clicking the button will execute the statement written in the textbox
Example;
if in the textbox i write
MessageBox.Show("Hello");
then clicking the button executes the statement in the textbox in this case display a messagebox
|
|
|
|
|
Then read my previous response about CodeDOM, and the warning that this is VERY dangerous thing, don't do it, think of another way.
only two letters away from being an asset
|
|
|
|