|
Kalim_mughal wrote: I am showing around 100,000 record That's ridiculous, how do you expect your user to find the information they want in that many records? It takes a long time because your are getting lots of records.
Use the best guess
|
|
|
|
|
Do you know answer?
|
|
|
|
|
Yes, do not try and read 100,000 records at a time. It is obvious that it will take 100,000 times some finite period, which is likely to be some minutes at the very least.
Use the best guess
|
|
|
|
|
The answer is to apply paging. The browser will take a long time to render that much data. On top of it, the browser will likely not perform well anyway if the user were to try and scroll and find data. Is there are reason you do not want to do paging?
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
Paging is only solution?
Do we can use Ajax? If yes how??
|
|
|
|
|
Yes, you could use ajax to load more records as the user scrolls. But at some point, you will still run into a slow performing browser because there is too much data. It is simply a limitation of the browser. You could also cut down on how much formatting you are applying or how many columns of data, that could help.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
Kalim_mughal wrote: I am showing around 100,000 record
No chance to load that quickly, even computers are not capable of doing magic work.
Kalim_mughal wrote: I don't want to apply paging in data control
You will have to.[^]
But only when you want a fast loading. Decide yourself what you want.
|
|
|
|
|
I have created a web application for inserting and updating a set of record using C#.net.
the coding is as follows.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
public partial class insert : System.Web.UI.Page
{
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\PRAVINR\Documents\Visual Studio 2010\WebSites\strikers\App_Data\royal.mdf;Integrated Security=True;User Instance=True");
protected void Page_Load(object sender, EventArgs e)
{
DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
con.Open();
SqlCommand cmd = new SqlCommand("insert rusty values(@CustID,@Name,@Address,@City,@Pin,@State,@Country,@ContactNO)", con);
cmd.Parameters.AddWithValue("@CustID", TextBox1.Text);
cmd.Parameters.AddWithValue("@Name", TextBox2.Text);
cmd.Parameters.AddWithValue("@Address", TextBox3.Text);
cmd.Parameters.AddWithValue("@City", TextBox4.Text);
cmd.Parameters.AddWithValue("@Pin", TextBox5.Text);
cmd.Parameters.AddWithValue("@State", TextBox6.Text);
cmd.Parameters.AddWithValue("@Country", TextBox7.Text);
cmd.Parameters.AddWithValue("@ContactNO", TextBox8.Text);
cmd.ExecuteNonQuery();
Label1.Text = "Inserted Completed..";
}
catch (Exception ex)
{
Label1.Text = ex.ToString();
}
finally
{
con.Close();
}
}
protected void Button2_Click(object sender, EventArgs e)
{
TextBox1.Text = "";
TextBox2.Text = "";
TextBox3.Text = "";
TextBox4.Text = "";
TextBox5.Text = "";
TextBox6.Text = "";
TextBox7.Text = "";
TextBox8.Text = "";
}
}
i need to change the coding to parallel processing so that the process of inserting is done parallel.
Can anyone help me solving this ?
|
|
|
|
|
Can u plz describe ur problem? Not understood....
What is Parallel processing?
|
|
|
|
|
What u want to do actually?
|
|
|
|
|
As far as I can see there is only one insert command in the above, so how can that be made parallel (or more likely multi-threaded)?
Use the best guess
|
|
|
|
|
supposing if there are 2 updates taking place simultaneously the updates takes some time.so to avoid the time delay i need to do it using parallel programming or threading.
My main aim is to reduce the CPU work usage.
|
|
|
|
|
vasanth2vasu wrote: My main aim is to reduce the CPU work usage. You do realise that multi-threading actually increases it? And how can you tell when there are two updates in progress since the initiator is the user pressing a button? Your question and your code sample do not make clear exactly what you are trying to achieve, but if all you want to do is to multi-thread some processes, then you should look at the Thread class[^].
Use the best guess
|
|
|
|
|
Can yu give an example in web application where we use parallel processing for inserting and updating SQL database by C#.net simultaneously.
|
|
|
|
|
Sorry I have not got one, but all you need to do is look at that link I gave you and code yourself some threads. You can also find lots of samples via Google, or in the CodeProject articles section..
Use the best guess
|
|
|
|
|
Quote: string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlConnection conn = new SqlConnection(connStr);
string strddl;
SqlCommand cmdddl;
Quote: try
{
conn.Open();
strddl = "INSERT INTO Users (Username,Name,UserID,Password,UserRoles,SecurityAns) VALUES(@user,@name,@id,@pass,@roles,@Sec)";
cmdddl = new SqlCommand(strddl, conn);
cmdddl.Parameters.AddWithValue("@user", TextBox1.Text);
cmdddl.Parameters.AddWithValue("@name", TextBox2.Text);
cmdddl.Parameters.AddWithValue("@id", CID);
cmdddl.Parameters.AddWithValue("@pass", Password.Text);
cmdddl.Parameters.AddWithValue("@roles", Role);
cmdddl.Parameters.AddWithValue("@Sec", TextBox6.Text);
cmdddl.ExecuteNonQuery();
conn.Close();
}
catch (Exception ex)
{
Response.Redirect("~/ErrorPage.aspx");
}
Dun't know this code may help on u or not, for the parallel processing is mean wht? i just a newbie
|
|
|
|
|
i am working with discussion forum , i need the complete source code of forum module in asp/net 3.5 and VS2008
|
|
|
|
|
|
|
Can anyone tell me how to pass a data to another,
Eg the textbox1 in page1.aspx data(such as hello) when i click on button save, the save button will redirect to page2.aspx and at the textbox2 at page2.aspx will show the data(such as hello) i'm key in previous page page1.aspx.
can anyone help me plszzzzzz, did u all understand what i mean T_T , what function/technology i nid to use?
|
|
|
|
|
|
thank you , that is what i found ^_^
i dun't know what is this function ~
|
|
|
|
|
JammoD87 after cross page at second page, i press the back button the data at first page nid to remain, how to do this ?
|
|
|
|
|
In which case you will need to use either "Session" or "Cookies" to store the value from the text box and check the value on page load.
Thanks
|
|
|
|
|
JammoD thank ^^ can ady~ thx to teach me cross page
page1.aspx
<asp:Button ID="Save" runat="server" class="styled-button-10"
PostBackUrl="~/test2.aspx" Text="Save" />
page2.aspx
<script runat="server">
void Page_Load(object sender, System.EventArgs e)
{
Label1.Text = ((TextBox)PreviousPage.FindControl("txtID")).Text;
Response.Write("" + Label1.Text );
}
</script>
modified 17-Apr-13 13:30pm.
|
|
|
|