|
Place a bookmark at the end of the page and add the bookmark to the URL.
---
b { font-weight: normal; }
|
|
|
|
|
Private Sub DataGrid1_DeleteCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.DeleteCommand
Dim d As String
d = DataGrid1.DataKeys(e.Item.ItemIndex)
cmd = New SqlCommand("DELETE FROM functional WHERE comp=@comp", con)
cmd.Parameters.Add("@comp", d)
con.Open()
cmd.ExecuteNonQuery()
con.Close()
deletedata()
and
Sub deletedata()
Dim ds As DataSet
Dim strSQL As String = "select FROM functional "
da = New SqlDataAdapter(strSQL, con)
ds = New DataSet
con.Open()
da.Fill(ds, "functional")
con.Close()
DataGrid1.DataSource = ds
DataGrid1.DataMember = "functional"
DataGrid1.DataKeyField = "comp"
DataGrid1.DataBind()
End Sub
what wrong with it
-- modified at 11:40 Thursday 17th August, 2006
omi
|
|
|
|
|
omi98 wrote: what wrong with it
Nah, you need to tell us in details what wrong with it so that we may help you figure out the cause.
|
|
|
|
|
after click on delete link in datagrid it shows following error
Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index
omi
|
|
|
|
|
+ Can you try to debug your application to see which line (or which code) is causing the error?
+ Can you also post the error stack?
|
|
|
|
|
i forword source error and stack trace
boldline indicate error line
Line 127: Private Sub DataGrid1_DeleteCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.DeleteCommand
Line 128: Dim d As String
Line 129: d = DataGrid1.DataKeys(e.Item.ItemIndex)
Line 130: cmd = New SqlCommand("DELETE FROM functional WHERE comp=@comp", con)
Line 131: cmd.Parameters.Add("@comp", d)
******************************************************
Stack Trace
ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index]
System.Collections.ArrayList.get_Item(Int32 index) +91
System.Web.UI.WebControls.DataKeyCollection.get_Item(Int32 index)
WebApplication2.WebForm12.DataGrid1_DeleteCommand(Object source, DataGridCommandEventArgs e) in c:\inetpub\wwwroot\WebApplication2\js\WebForm12.aspx.vb:129
System.Web.UI.WebControls.DataGrid.OnDeleteCommand(DataGridCommandEventArgs e)
System.Web.UI.WebControls.DataGrid.OnBubbleEvent(Object source, EventArgs e)
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
System.Web.UI.WebControls.DataGridItem.OnBubbleEvent(Object source, EventArgs e)
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args)
System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e)
System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
System.Web.UI.Page.ProcessRequestMain()
omi
|
|
|
|
|
Hi.
My problem is simple, but detailed.
Instead of creating list items for the drop down list (Mr,Mrs,Miss), I would like to instead get the information from a table in SQL server DB which holds thats information.
The table has 2 fields.. UserTitleID and Description.
There is another User table, holds the foreign key "inUserTitleID". I need to be able to store new users in the User table, selecting the entries from a drop down list with entries which the UserTitle table can hold(variable number-not fixed like list items).
I request for a hint(or a push in the right direction) on how to tackle this issue..
PS. Sorry if this sounded more like a rant =(
Thanks.
-- modified at 11:38 Thursday 17th August, 2006
|
|
|
|
|
One way is to read the items into a DataSet and use that as DataSource for the DropDownList. Set the DataTextField and DataValueField properties to the names of the fiels in the DataSet. Assign the DataSet to the DataSource property and call the DataBind method to populate the list.
Another way is to get the items using a DataReader and iterate the reader to populate the list. Read the values from the DataReader and use them to create a ListItem object for each item and add it to the list.
---
b { font-weight: normal; }
|
|
|
|
|
Thanks for the suggestions.
I'll get cracking on then 
|
|
|
|
|
|
Thanks for the link!
|
|
|
|
|
Hi there,
I am currently looking into how we can integrate PHPBB into an ASP .NET website, by integration, I do not simply mean placing the forum into and IFrame and forgetting about it...
One of the main challenges is to implement a 'Single Sign On' mechanism, has anyone here done something like this? any suggestions?
My ideas are along the lines of, accessing the PHPBB (mysql) database using Connector.NET and 'planting' an auth cookie for PHPBB when the user logs in, are there any known issues with this approach?
Any general advice would be welcome.
Thanks,
Paul
|
|
|
|
|
Hi,
I am using the logging block to capture events in my web application. I need to configure the database listner to point to my database (sql server) instead of the one provided by default.
How can that be done? Can anyone point me to any articles on this?
Thanks
Minu
|
|
|
|
|
Hi Nish,
Could u pls explain in details regarding
'Client-side validation of radio button column in a DataGrid By gn_srini'
I tried it on my application, but it is not working.
As per ur article, user should be able to select only one option button, but it is selecting all the options in the datagrid. can u help me in this regard. I might be wrong in some where.
-- modified at 10:15 Thursday 17th August, 2006
Balasaheb
Software Developer
Platform: Asp.net,vb.net
Database: SQL Server 2000
|
|
|
|
|
If you want to ask a question about an article, then you should use the forum right below the article, and the author is also notified by your post.
|
|
|
|
|
Hi,
in my asp.net appln i have displayed the data in a crystal report.but i canot able to print that document using network printer.i want to print that one without going for export option.so could u plz help me.
|
|
|
|
|
Can row in datagrid be scrollable-- if length of the row is exceed the lenght of datagrid can we make it scrollable.
thank u
uma
|
|
|
|
|
You need to create a DataGridTextBoxColumn and set the Multiline and WordWrap properties of the hosted DataGridTextBox. You can then add scrollbars if you wish.
Steve
-- modified at 8:09 Thursday 17th August, 2006
|
|
|
|
|
I kept the datagridview in a panel and made the scrollproperty of the
panel to Auto and it works. Try it
Thanks
Kal
|
|
|
|
|
i have the follow xml file :
<ListBoxes>
<row>
<Number>None</Number>
<Description>None</Description>
<Counter>999</Counter>
<Factor>0</Factor>
<Harmful>N</Harmful>
</row>
<row>
<Number>R1</Number>
<Description>R1 Explosive when dry</Description>
<Counter>1</Counter>
<Factor>1</Factor>
<Harmful>N</Harmful>
</row>
<row>
<Number>R10</Number>
<Description>R10 Flammable</Description>
<Counter>10</Counter>
<Factor>1</Factor>
<Harmful>N</Harmful>
</row>
<ListBoxes>
I have been trying to bind this to a listbox but have been unsuccessful, can anyone help. I have read that i may need an xslt file to transform it, is this true and could someone point me in a good direction on how to use xslt files
Thanks
-- modified at 6:22 Thursday 17th August, 2006
|
|
|
|
|
May be you can try giving DisplaySource property as "ListBoxes.row" OR "row" and DisplayMember as "Description" and ValueMember = "Number"
Hope this works for you.
- ashish
|
|
|
|
|
How to take reference of connection string or connection
which is written in the web.config in a c# code.
urgent
Regards
|
|
|
|
|
If it is inside the appsettings in config file then you can access it like this:
ConfigurationSettings.AppSettings.Get("the variable name");
Best Regards,
Apurva Kaushal
|
|
|
|
|
Hi there...
I have a user control (UC) which is dynamically added to a page. In this UC I have a DropDownList (DDL) (normally added - not dynamically). The problem is that the item which is set selected in the beginning in the DDL wont fire the OnSelectedIndexChanged event. In the beginning the item is selected – then I choose another item and it fires the OnSelectedIndexChanged event. When I then select the first selected item again the event isn't fired.
I don’t set the selected item in the beginning so it is the first item – but I have tried to set it as an item somewhere in the middle and then that item wont fire the event. So it has something to do with the first selected item.
Here’s my code...
The page which dynamically adds the user control:
m_plhTableForm.Controls.Clear();
UserControl ucTableForm = null;<br />
<br />
switch( strTableID )<br />
{<br />
...<br />
case CConstants.DB2ID_BUNKANUMER:<br />
ucTableForm = (UserCtrls_Tableforms_Bunkanumer_UC) this.LoadControl( "~/UserCtrls/Tableforms/Bunkanumer_UC.ascx" );<br />
break;<br />
...<br />
default:<br />
ucTableForm = null;<br />
break;<br />
}<br />
<br />
if( ucTableForm != null )<br />
{<br />
ucTableForm.ID = "WebUserCtrl1"; <br />
m_plhTableForm.Controls.Add( ucTableForm );<br />
}
The User Ctrl – aspx file (took out the brackets for rendering):
<br />
asp:DropDownList ID="m_cboBUNK" runat="server" CssClass="controlText" AutoPostBack="true" OnSelectedIndexChanged="onCboBUNKSelectedIndexChanged" /asp:DropDownList<br />
The User Ctrl – codebehind file:
Nothing big done here – data fetched and databinded to the DDL
|
|
|
|
|
spoa wrote: then I choose another item and it fires the OnSelectedIndexChanged event. When I then select the first selected item again the event isn't fired.
After the SelectedIndexChanged event gets fired, do you set any new selected index for the dropdownlist? Do you see the new item selected in the dropdownlist after the postback? Basically, the event is raised when the control detects the new selected item value in comparision with the current one which is persisted in the ViewState. You also make sure that the values (not text) of all the items are different.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
