|
|
Hi guys
My problem is this . I need to generate a large number of records from SQL server 2000 to and excel spreadsheet. However the durations of time id too long. For about 900 records there's about 40 min.
Any idea or guide to boast up the speed?
i am generating to excel .xls
Basically i have a main details table link to many sub details Table
Then first i select all the main info id and use the for loop to loop through all the sub details table whether the id is match. then insert into the excel spreadsheet. The method i use is Create the XLS file then connect to it and do insert statement to input data. This method work but when inserting 900 records it took about 30 mins or more....
Any suggetion or solution please guide.... Need help man
Thanks a million guys need it urgently
KaKaShi HaTaKe
|
|
|
|
|
Why are you asking this in the ASP.NET forum ?
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 )
|
|
|
|
|
Becasue i am using ASP.net to generate the reports. Is a Web applications
KaKaShi HaTaKe
|
|
|
|
|
OK, but it doesn't relate to the presentation tier, so it's really a VB.NET or C# question. I'm only saying because asking in the right forum will get you more coverage and more answers.
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 )
|
|
|
|
|
OK got it thanks bro
KaKaShi HaTaKe
|
|
|
|
|
hello frnds,
i have .Net framework 2.0 installed on my machine, I was developed one website which was run fine. But yesterday i upgrade the SP1 of .Net framework and my site gives scripting errors over there. i used Javascript, VBScript in website and take HTML buttons.
what should be the problem ???
any setting after installing SP1 ???
Thankx in Advance
koolprasad2003 
Be a good listener...Because Opprtunity knoughts softly...N-Joy
|
|
|
|
|
koolprasad2003 wrote: But yesterday i upgrade the SP1 of .Net framework and my site gives scripting errors over there.
Really?? I too have websites which is developed in .NET 2.0 framework previously and I have upgraded my VS 2005 with SP1. They are working fine as before.
koolprasad2003 wrote: what should be the problem ???
What is the error, you are talking about? Could you please post somemore information about your errors?
Did you tried to convert you websites to web applications??
|
|
|
|
|
Hi All,
I have created a table called tblState in access with 2 columns: id and state and am populating a dropdownlist with state.
I am in need of code to delete a selected value of dropdownlist from database in asp.net2.0 using c#.
Can anybody help me please.
Thanks
Wajid
|
|
|
|
|
On postback, you can tell what your selected item is, what you need to be able to do, is turn that into an id you can use to delete the right record in the database. You do that when you populate the list, by using the unique ids as the data value for the list item ( the value that is not displayed )
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 )
|
|
|
|
|
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
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
