I have a grid having 60000 records (implemented paging) . I want to update these records , user can view these records in a single page alsowhile updating these records I am making 60000 times database calls in a for each loop like
for each( datagridrows rows in gridviews.rows)
{
// getting the datakeys ...
// calling a sp to update specific records....
}
This approch works fine but creates performance issue .
i got a problem to update my database which i bounded to datagrid. The problem is, i want to update my database only by clicking one update button at the bottom.. when the user click it, all the fields will be updated to database.
View 3 RepliesI want to create password in single database for example when i attach My database abc.mdf or open that database then it ask me password. as like access database password..
View 3 RepliesI found lots of sites telling me how to put a database into single user mode, but how can I determine what mode a database is currently in?
View 2 RepliesI Getting A Problem In DataGrid's ItemDataBound Event. I Am Calling A JavaScript Function In DataGrid's ItemDataBound Which Retrun The CellIndex And RowIndex Number On Which UserClick After That I Am Re-Binding The DataGrid With jQuery Function After That ItemDataBound Event Not Working. I Want To Call The Same Function Again. Is Their Any Method To Call A Server-Side Function On ItemDataBound Event Except Client-Side Function..
View 4 RepliesI've tried:
[Code]....
I've also tried:
[Code]....
I tried to make an Update Panel to not load the whole page every time I need to load data from the Database server so I add Update Panel and add this java script code in every content page in my web site.
Code:
<script language="javascript" type="text/javascript">
<!--
with( Sys.WebForms.PageRequestManager.getInstance() )
[code]...
It works good but after end of the request I got a popup message say "NaN" every time I don't know from where it comes and of course it looks very bad for the client if got this popup.
I have read plenty of tutorials on taking a datagrid to a text file, but I haven't seen anything about taking a single cell from a datagrid, formatting it, and writing it to a text file. Is this possible, am I going about it wrong?
View 3 RepliesContext: In an ASP.NET application, I need the behavior of the ItemTemplate / EditItemTemplate that the DataList control provides. However, I only need one item in my control, which makes the DataList seems like overkill.
Question: Is there a control in ASP.NET made to store a single item that has the template content behavior of the DataList and DataGrid? Should I use a DataList for only one item?
I have datagrid that binds it's data from database.I have to select,update,insert,Delete data grid using stored procedure.I created a dataset and using dataset storedprocedures for this issue.select stored procedure is works fine,but I have problem in Update,Insert,Delete Storedprocedure.
I created them(storedprocedures) through wizard,But I don' know how to call them.I write the below code in "DataGrid2_UpdateCommand" event but it doesn't work
here is my code:
[Code]....
I am new here so I will try and give you as much detail as I can:
(C# + SQL)
I am developing a web site that has holiday prices which are taken from a different database and loaded into two SQL databases.I have two girdviews to display each of the prices data.What my issues is that I need to load an SqlDataSource on database 1,when 'Family' is selected from a dropdown list and run an SqlDataSource on database 2 when 'Themed' is selected and then run both when 'Don't Mind' is selected.
I have a BING MAP in web app. which is of JavaScript or Jquery. And also I have a DataGrid in same page. Data Grid is populated with Address ROWS. A check box is also there as ItemTemplate for DataGrid.
Now after dataGrid binded with data source, and when user clicks on check box, that particular address should show on BING MAP.
My question is,
How to invoke a JavaScript function when user checks checkbox in data grid. Which data Grid events suits my scenario? Also can I do this on client side without going to server side and call JS function?
I'm trying to make a call to a JSON ASP.NET web service with .NET.
It is ok when I send " { county : 'whatever' } ", but I get a 500 Internal Server error if I try for example " { county : 'It's ok' } ".
[Code]....
I've found some posts with examples but I cannot make it work:
" { county : "whatever" } " and " { "county" : "whatever" } " also works.
But either of " { county : "It's ok" } ", " { county : "It's ok" } " or any other combination that contains a single quote in the variable work.
How can I send a single quote inside a JSON call?
I have the following code which toggles the visibility of one of a pair of DropDownLists based on the selected radio button. This code works but my problem is that I have several sets of controls just like this on a single form. How can I use a single JavaScript Toggle() function, irrespective of the ID of the RadioButtonList that triggered it?
function Toggle()
{
var list = document.getElementById("produceDDL");
var inputs = list.getElementsByTagName("input");
var selected;
for (var i = 0; i < inputs.length; i++)
{
if (inputs[i].checked)
{
selected = inputs[i];
break;
}
}
if (selected.value == 'Vegetables')
{
div1.style.display = 'none';
div2.style.display = 'block';
}
else
{
div1.style.display = 'block';
div2.style.display = 'none';
}
}
<asp:radiobuttonlist ID="produceDDL" OnClick="javascript:Toggle();"
RepeatDirection="Horizontal" runat="server">
<asp:ListItem Selected="True">Fruit</asp:ListItem>
<asp:ListItem>Vegetables</asp:ListItem>
</asp:radiobuttonlist>
<div id="div1">
<asp:DropDownList ID="fruitDDL" Width="120" runat="server">
<asp:ListItem>Select</asp:ListItem>
<asp:ListItem>Apples</asp:ListItem>
<asp:ListItem>Oranges</asp:ListItem>
</asp:DropDownList>
</div>
<div id="div2" style="display:none;">
<asp:DropDownList ID="vegDDL" Width="120" runat="server">
<asp:ListItem>Select</asp:ListItem>
<asp:ListItem>Onions</asp:ListItem>
<asp:ListItem>Potatoes</asp:ListItem>
</asp:DropDownList>
</div>
On a single page, I'd like to fill 2 hyperlink controls as well as a datalist control with table data using one call to the database. The page looks like this:
[Code]....
In the code-behind, I've tried several ways to accomplish filling the labels and the datalist with a single call but I can't make it happen without using either reader.read() or if (reader.read()) on the line before I make the call to fill the labels and the datalist. This fills the hyperlink controls correctly but advances the recordset forward by one, which results in the datalist missing it's first record.
I've tried using while (reader.read()), but I get an "invalid attempt to read when no data is present" error. I've also tried using if (reader.hasrows) but I get the same error as above.Here's an example of one of the 2 ways I can get the labels and the datalist filled with data, but again this advances the recordset forward and I end up missing the row of data:
[Code]....
I have an existing asp.net web application I am redesigning to use a service architecture. I have the beginnings of an WCF service which I am able to call and perform functions with no problems. As far as updating data, it all makes sense. For example, I have a button that says Submit Order, it sends the data to the service, which does the processing.
Here's my concern: If I have an ASP.NET page that shows me a list of orders (View Orders page), and at the top I have a bunch of drop down lists for order types, and other search criteria which is populated by querying different tables from the database (lookup tables, etc). I am hoping to eventually completely decouple the web application from the DB, and use data contracts to pass information between the BLL, the SOA, and the web app. With that said, how can I reduce the # of WCF calls needed to load my "View Orders" page? I would need to make 1 call get the list of orders, and 1 call for each drop down list, etc because those are populated by individual functions in my BLL.
Is it good architecture to create a web service method that returns back a specialized data contract that consists of everything you would need to display a View Orders page, in 1 shot? Something like this pseudocode:
public class ViewOrderPageDTO
{
public OrderDTO[] Orders { get; set; }[code].....
Or is it better practice in the page_load event to make 5 or 6 or even 15 individual calls to the SOA to get the data needed to load the page? Therefore, bypassing the need for specialized wcf methods or DTO's that conglomerate other DTO?
I use the following with datagrid to call itemcommand or update command etc, and i do this:
If e.CommandName = "doAdd" Then
End If What is the equivalent check in gridview?
loop table depending on arraylist and load datagrid?
View 1 RepliesI got 15 tabs and 15 user controls assigned to each tab.All are loading at once which id delaying the process.
I want to load one user control on selection of a tab in tab container.
I wnat to call the JS function on the form load.
Code:
ClientScript.RegisterStartupScript(this.GetType(),
"pt", "alert('I was called from Content page!');", true);
ABove code is displaying the alert message, While the Below will not call the JS FUNCTION.WHy so ??
[/code]
ClientScript.RegisterStartupScript(this.GetType(),
"pt", "alert1();", true);
[/code]
Code:
function alert1()
{
alert ('a');
}
I'm a bit new to .net so i was wondering if a thing like this is possible. I'm having one basic aspx script that needs to load some "plugins". Every plugin has its own settings and it should perform different logics. What i'd do in php is create a class for each plugin, load that class, pass the settings file to it and call some method on that class that would give me some output. But is it even possible in vb.net? I'd need to have multiple files with multiple classes, load those files, depending on the plugin name and call some method on them to parse that plugin's settings.
View 2 RepliesI am loading my with web controls and loading them based on the URL parameters.I need to load a gridview if the user is in :&cat=8My web control has a method which I need to call. One of its parameters is a session which is created only when the category is 8.Technically I need a way of calling methods within my web control from my page. Placing it on page_load results in an error.
View 1 RepliesOn the page load i wanna call a custom validator which validates my page and display corresponding error messages.
How can i do this?
I am using javascript in the custom validator.
I am trying to export data to a csv file in my web application.
I have the following class to enable this but i want to know how to call the class on Page_Load?
public class CSVExporter
{
public static void WriteToCSV(List<Category> categoryList)
{
string attachment = "attachment; filename=PersonList.csv";
[Code]....
I have a confusion regarding ajax call.when an ajax call is done why is it so that a page load event is fired when its not a ful page request.
My understanding is that a page load event should not be called on an asynchronous postback.
Can any1 explain me why this is happening?
here is the code:
aspx page:
[Code]....
aspx.cs page:
[Code]....