I created a Function called GetWordsLike("word") it look in database to get some words that they are like "word". i also have a TextBox in my page to get "word" from User.
i use ObjectDataSource to databind a gridView and this ObjectDataSource use the GetWordsLike("word") Function to get the data frome database.
now i need to give this "word" to ObjectDataSource programatic.
How do I set the selectparameter of Objectdatasource in usercontrol from dropdownlist in parent page?I tried the following but when I select a new value in the dropdownlist it does not change the data from the initial page load
Protected Sub ODSLocations_Selecting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.ObjectDataSourceSelectingEventArgs) Handles ODSLocations.Selecting
Dim ntid As DropDownList = CType(Me.Parent.FindControl("DDLEmployees"), DropDownList)
e.InputParameters("ntid") = ntid.SelectedValue
End Sub
Ultimate goal is to provide protection against programming mistakes. I want to make sure that every page in a portion of my web application has a role specified like below. Ideally I would like to programatically check all requests coming in ( think IHttpModule ) and make sure that the page being requested has a role specified.
I can't seem to find how to get programatic access to the allowed roles.
[code]....
I have a series of classes that loosely fit the following pattern:
public class CustomerInfo {
public int Id {get; set;}
public string Name {get; set;}
public class CustomerTable {
public bool Insert(CustomerInfo info) { /*...*/ }
[code]...
I've an ObjectDataSource & its datasource from typed dataset which is bind to 3 textboxes.
One of that textbox text concatenate with other two textboxes values.
Some thing like this,
textbox1.text=textbox2.text & textbox3.text
How can I customize my insert query for this?
I could not see the insert query in my objectdatasource.
I have a interesting problem and being relatively new to .NET I thought to try the forum for some guidance. I need to present information from a database, typical, but I need to create stand alone views of the data based on the "category" for the reported information. I don't know how many or how few categories I might need to generate but each needs to be displayed in its own datagrid or gridview. I did a prototype report where I could dynamically generate a variable number of columns in a generic datagrid already placed on the page based on the database but the user "changed their minds", also typical, and want a different view (actually views). Does anyone have any thoughts on creating anywhere from 1 to a dozen (or more) datagrids in the code behind and then pushing them out to the aspx page for the user? Can you dynamically generate datagrids and gridviews on the fly? Or would you need to?
View 3 Repliesi have a detailsview in insert mode and that is bound to objectdatasource. now the class that is attached to objectdatasource is :
[Code]....
here ResturantId value has to be in session or from Dropdownlist and rest of the value from Detailview. So how to assign that value?
I am trying to insert some records using objectdatasource but getting no result.
I am sure I have to write some code in insertbutton but what I am not getting to it.
Here is my code used:
[Code]....
How to use ObjectDataSource Update query from code behind.using edit and cancel button in GV asp.net.
View 1 RepliesI am using an objectDataSource for the first time. My objectDatasource looks like this:
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" TypeName="CustomerData"
DataObjectTypeName="Customer" DeleteMethod="DeleteCustomer" InsertMethod="InsertCustomer"
SelectMethod="GetCustomersByObject" UpdateMethod="UpdateCustomer" OldValuesParameterFormatString="original_
[code]...
I am really sorry for this, but this is such a bizarre situation I don't know where to turn. I have a stored procedure that takes four parameters (two dates, a positionID, a userID). The SQLDataSource is very generic:
[Code]....
and I set the parameters via this code:
[Code]....
When this executes, no matter what the value of PositionID, it acts as if the PositionID is zero. Now, if I remove PositionID variable and add the number:
[Code]....
All is well. Also, when I look at the parameter in the immediate window, it appears to be correct:
[Code]....
I'm working with Linq and I'm using with ObjectDataSource that have SelectParameters tag for inserting default parameters to object.
How can I set <DefaultValue> for an array parameter ?? (i.e : object that have 2 parameters - string and array of int , I can set <DefaultValue> for the string but I don't know how to do it for array)
I am trying to get my Nested ListView to work. I have my parent List View supplying the correct information, but I can't seem to set the SelectParameter Value for my Nested ListView. I am using SQLDataSources for both. I read your comment about adding a Hidden Field. Where Should that field be located. Right now I have it inside my Parent ItemTemplate but nothing is happening. Currently I have both DataSource outside my Parent ListView. I tried moved the nested ds inside with the list view but I still was not able to grab the hidden field values either. Here's what I have:
<asp:ListView
ID="lv"
runat="server"
DataSourceID="sdsParent"
DataKeyNames="CaseNo">
<LayoutTemplate>
<div
class="grid">
<h2>Bankruptcies
by RetailerID <asp:ImageButton
ID="btnSort"
runat="server"
ImageUrl="images/sort_asc.gif"
ImageAlign="AbsMiddle"
CommandName="Sort"/></h2>
<table
id="tblBankruptcy"
cellpadding="0"
cellspacing="0">
<tr
class="head">
<th
class="first"></th>
<th>Retailer
ID</th>
<th>Retailer
Name</th>
<th>Chapter
Number</th>
<th>District</th>
<%
--<th>Date</th>--%></tr>
<tr
id="itemPlaceholder"
runat="server"
/>
</table>
<table
id="pager"
cellpadding="0"
cellspacing="0">
<tr
class="pager">
<asp:DataPager
ID="pager"
runat="server"
PageSize="8">
<Fields>
<asp:TemplatePagerField
OnPagerCommand="PagerCommand">
<PagerTemplate>
<td
class="commands">
<asp:ImageButton
ID="btnFirst"
runat="server"
CommandName="First"
ImageUrl="images/first.gif"
AlternateText="First Page"
ToolTip="First Page"
/>
<asp:ImageButton
ID="btnPrevious"
runat="server"
CommandName="Previous"
ImageUrl="images/prev.gif"
AlternateText="Previous Page"
ToolTip="Previous Page"
/>
<asp:ImageButton
ID="btnNext"
runat="server"
CommandName="Next"
ImageUrl="images/next.gif"
AlternateText="Next Page"
ToolTip="Next Page"
/>
<asp:ImageButton
ID="btnLast"
runat="server"
CommandName="Last"
ImageUrl="images/last.gif"
AlternateText="Last Page"
ToolTip="Last Page"
/>
</td>
<td
class="info">
Page
<b>
<%
# Container.TotalRowCount > 0 ?
Math.Ceiling(((double)(Container.StartRowIndex + Container.MaximumRows)
/ Container.MaximumRows)) : 0 %></b>
of
<b>
<%
#
Math.Ceiling((double)Container.TotalRowCount / Container.MaximumRows)%></b>
(<%
# Container.TotalRowCount %> items)
</td>
</PagerTemplate>
</asp:TemplatePagerField>
</Fields>
</asp:DataPager>
</tr>
</table>
</div>
</LayoutTemplate>
<ItemTemplate>
<%
<%
-- <table id="orders" cellpadding="0" cellspacing="0">--%><tr
id="itemPlaceholder"
runat="server"
/>
-- </table>--%><tr
id="row"
runat="server"
class="group">
<th
class="first">
<img
src="images/plus.png"
alt='Group:
<%# Eval("CaseNo")%>'
onclick="toggleGroup(this, '<%# Eval("RetailerId") %>');"
/>
</th>
<th
colspan="1">
<%
# Eval("RetailerId")%>
</th>
<th>
<%
# Eval("RetailerName")%></th>
<th>
<%
# Eval("BankruptcyTypeID")%>Chaper 11</th>
<th>
<%
# Eval("DistrictID")%>District</th>
</tr>
</ItemTemplate>
<SelectedItemTemplate>
<asp:ListView
ID="lvItems"
runat="server"
DataSourceID="sdsChild">
<LayoutTemplate>
<tr
runat="server"
id="itemPlaceholder"
/>
</LayoutTemplate>
<ItemTemplate>
<tr
class="item">
<th></th>
<th>Action</th>
<th>Comments</th>
<th>Attorney
Information</th>
<th>Date</th>
</tr>
<tr
id="row"
runat="server"
class="item">
<td
class="first"></td>
<td><%#
Eval("ActionID")%></td>
<td><%#
Eval("CaseNo")%></td>
<td><%#
Eval("Comments")%></td>
<td><%#
Eval("AssigneId") %></td>
<td><%#
Eval("Date",
"{0:MM/dd/yyyy}")%></td>
<td><%#
Eval("CaseNo") %></td>
</tr>
</ItemTemplate>
</asp:ListView>
</SelectedItemTemplate>
</asp:ListView>
<asp:SqlDataSource
ID="sdsParent"
runat="server"
ConnectionString="<%$ ConnectionStrings:Legal %>"
SelectCommand="SELECT * FROM [tblBankruptcy ]">
</asp:SqlDataSource>
<asp:SqlDataSource
ID="sdsChild"
runat="server"
ConnectionString="<%$ ConnectionStrings:Legal %>"
SelectCommand="select * from tblbankruptcyaction where CaseNo = @CaseNo">
<SelectParameters>
<asp:ControlParameter
ControlID="hf1"
Name="CaseNo"/>
</SelectParameters>
</asp:SqlDataSource>
If I ran my sproc from query analyzer, I get the correct results(data is filtered by datetime), i.e:
exec Uds.Dashboard_GetJobs '9/20/2010 11:01:23 PM'
However, if I ran it from the Asp.Net page, (ALL records are showed). Looking at the SQL Profiler I see the following call:
exec sp_executesql N'exec Uds.Dashboard_GetJobs',N'@date nvarchar(21)',@date=N'9/20/2010 11:01:23 PM'
Running both statements above in the query analyzer it WILL return me different results. Why? Someone mentioned that it looks like I don't have correct data type specified for SQLParameter in .Net application. I was asked to create something like:
cmd.Parameters.Add("@Date",SqlDbType.DateTime).Value =
Well, my code in the asp.net is in this form:
<asp:SqlDataSource ID="sourceRealtimeLogging" runat="server"
ConnectionString="<%$ ConnectionStrings:UctConnectionString %>"
SelectCommand="exec Uds.Dashboard_GetJobs">
<SelectParameters>
<asp:ControlParameter ControlID="UpdatedTimeUTC" Name="date" PropertyName="Text" />
</SelectParameters>
</asp:SqlDataSource>
So I guess I am passing a string to SQL, not a datetime type. How do I fix this? Not even sure if this is the cause of my issue but worth a try.
I'm using a ListView (e.g topListView) with paged rows (using a DataPager). One of the topListView's features is when a user clicks on one of its rows, its SelectedValue property is used to populate a SelectParameter in another SQLDataSource control that populates another ListView (e.g. bottomListView). It's working fine. Even when the webpage first loads, the SelectedValue of first row of the topListView is successfully being used to generate content in the bottomListView.
However, when one of the DataPager's buttons is clicked, the SelectedValue seems to be ignored, and the bottomListView isn't refreshing. And yet, when you click a DataPager button again, it works. basically it's taking TWO clicks of the pager for the SelectedIndex to be read. I've tried assigning the SelectedIndex to 0 in the PagePropertiesChanged and PagePropertiesChanging handlers but no luck (even with calls to bottomListView.DataBind(); and/or SQLDataSource1.DataBind(); after index assignment).
assigning the index seems unecessary though, since top row content is being rendered correctly in a SelectedItemTemplate after clicking any DataPager button. to me that means the SelectedIndex is being set to 0 when the page is being re-rendered.
[Code]....
I am trying to pass in as an insert parameter for SQLds2 the scope_identity of the insert of SQLds1.
Exception Details: System.InvalidOperationException: Error executing 'InsertCommand' in SqlDataSource 'SqlDataSource1'. Ensure the command accepts the following parameters: @Name1, @NewId
[Code]....
Getting the message that ObjectDataSource ... count not find a non-generic method ... that has parameters ... The parameter list is fine until I get to the very end and it list the two data fields that are in my DetailsView. Using the ASP Tutorial #17 (Examining the Events Associated with Inserting, Updating, and Deleting) and the Exploring the Data Modification - specifically the one showing the INSERT of the Product Name and UnitPrice. ASPX page is pretty simple and attempting something similar, two fields to insert a new record - update the other fields later.
Full Error Message follows along with ASPX and the AsignaturasBLL.cs. Interesting thing is that when I swap the two fields in the DetailView, then the last two fields in the error message are swapped. In the error message I bolded these two fields.
[Code]....
i need to insert multiple rows at a time into database table(sqlserver) from datatable or gridview. Actually iam looping through the rows of gridview and inserting each row. Is there any method to insert entire table of rows at a time into database table. Both datatable columns and database table coulmns are similar.
View 2 RepliesI use GridView & FormView to update a record. but when I click the "save" button, throw an except : FormView must be in the insert mode to insert a record. The record has been updated success, and I didn't change the mode of the FormView, how this error comes?
View 3 RepliesI do have a details view, which insert data to a database table using SQL Datasource. Now i need the data to be inserted in to 2 tables instead of one.
View 1 RepliesIn my detailsview, I have an emptydatatemplate set up to allow users to enter new records. The code works. However, once the record is inserted, the detailsview defaults to a standard insert screen. I know this will cause confusion for the users. I would prefer the detailsview to either show in edit mode or a read-only mode. I have used detailsview.changemode and detailsview.currentmode in the custom sub created for the add new button of the emptydatatemplate- neither of which do what I was hoping. It would be even better if when there was no data, it defaulted to the insert screen (which seems like that should be an easy, no-brainer way for .net to function) but it doesn't. Or, I don't know how to accomplish it.
I don't want to force the user to click cancel after inserting an item through the emptydatatemplate just to be able to use the detailsview for other records.
I have grid view in ASP.Net 3.5. I need to add multiple blank rows in a gridview and then have to save them in database. How can I do that in most simplest way?
View 7 RepliesI am using Visual studio 2010 express and I have a details view databinded to an sql database table. When I use the Insert option on the view it causes an error due to it trying to insert a null into the primary key field. If the Insert function does not create a new primary key entry how is it created?
View 9 RepliesHow do I insert a snippet to change a hyper link ' insert' to a button image?
Here is the front page code:
[Code]....
I have a Winform that has fields need to be filled by a user. All the fields doesn't belong to one table, the data will go to Customer table and CustomerPhone table, so i decided to do multiple inserts. I will insert appropriate data to CustomerPhone first then Insert the rest data to Customer table.
View 3 Replies