|
Hi there, i'm currently developing a venue booking system too.
Is it possible for you to send me your sample code?
because i'm having a major breakdown right now.
thanks.
|
|
|
|
|
Hello All,
I am having an issue. one of my method is returning huge datatable having hundered of thousands records and then writing the data in to a csv file. Because of huge in memory data the exception 'System.OutOfMemoryException' is thrown. Please tell me any workable solution of this problem. My application is using .net2.0/SqlServer2005. Please give a solutin and if possible code like to solve the issue throgh multithreading and then combining the data and writing the csv file. Pleae help.
Thanks,
Safvi
|
|
|
|
|
|
Thanks for your suggestion David,
It really impreoved the efficiency of my download module by using datareader inspite of datatable and now i was able to write more then 2 million records to a csv file. But still this exception is thron when the no of records exceeds like in my case 7 Millios. What else should i do.? Thanks again for your valuable suggestion that solved my 50% problem.
Safvi
|
|
|
|
|
Hi,
Which method is the best way to transfer realtime data from one sqlserver to another sqlserver.
Plz let me know..
Thanx...
krishna veer singh
|
|
|
|
|
krishnaveer wrote: Plz let me know..
This is ASP.Net forum.
Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
I know this is ASP.NET forum, I have posted this thing here just because i need fast response. In My Sql forum its very late.
If you are aware of this thing then let me know. Otherwise ignore this.
Thanx..
krishna veer singh
|
|
|
|
|
|
krishnaveer wrote: I have posted this thing here just because i need fast response.
The only fast responses you'll get are to tell you to post to the correct forum, otherwise your question will be ignored. How will that help you get a fast response?
only two letters away from being an asset
|
|
|
|
|
I think you should post it to General Database Forum...
Thanks
Md. Marufuzzaman
Don't forget to click [Vote] / [Good Answer] on the post(s) that helped you.
I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.
|
|
|
|
|
|
I have deployed my application in three systems I am able to run properly. But when I deploy same application in the other machine getting Javascript error "String was not recognized as a valid DateTime." Coming I am not able to understand why this error is coming,
But my code is working fine and Tested in three machines there also working same installer used in another machine getting error
Please help me
|
|
|
|
|
Can you provide the code line where you are getting the error? Then it will be helpful to find and fix the error.
Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.
|
|
|
|
|
Best guess, you've written horrible code to parse dates that assume a certain date format, probably DD/MM/YYYY. Then you deployed to your client, who uses MM/DD/YYYY. This will break your code. Keep dates as a date type whenever possible.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
hi m using a menu control and populating the items and child items dynamically.
The items of menu are in cat1 table and the childitems are in cat2 table.
but when i run my code it only shows one item and the childitem of that item.
why does it not show the other items.tell me wr m i wrong....
thnks...
my code is:
public partial class MasterPage : System.Web.UI.MasterPage
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["SilverOnline"].ConnectionString);
protected void Page_Load(object sender, EventArgs e)
{
populatemenu();
}
private void populatemenu()
{
SqlDataReader dr = null;
string str = "Select * From Cat1";
SqlCommand cmd = new SqlCommand(str, conn);
conn.Open();
dr = cmd.ExecuteReader();
while (dr.Read())
{
MenuItem mt = new MenuItem();
mt.Text = dr["CatName"].ToString();
mt.Value = dr["Cat1ID"].ToString();
mt.NavigateUrl = "Displaymenu.aspx?id=" + mt.Value;
string s = mt.Value;
conn.Close();
string str1 = "Select * From Cat2 where(Cat1ID='" + s + "')";
SqlCommand cmd1 = new SqlCommand(str1, conn);
conn.Open();
dr = cmd1.ExecuteReader();
while (dr.Read())
{
MenuItem mf = new MenuItem();
mf.Text = dr["Cat2Name"].ToString();
mf.Value = dr["Cat2ID"].ToString();
mf.NavigateUrl = "Displaysubmenu.aspx?id=" + mf.Value;
mt.ChildItems.Add(mf);
}
}
conn.Close();
Menu1.Items.Add(mt);
}
}
|
|
|
|
|
Did you debug your code ? what dr returns ?
|
|
|
|
|
I am new for web development.
On a button click event, I would like to raise a web request with a URL.
I would like to collect the new URL page in A frame of current page
As of now, I was able to raise a web request but it was navigating to a new page
I would like to display the new page as a frame in the current page
Please advive, Many thanks
|
|
|
|
|
Why did you posted same post when you could have modified the previous one.
|
|
|
|
|
Hi I am new to web development.
On a button click event, I will be firing a web request.
I would like see the resulting page in a fram of current page.
as of now I was able to ge the result page in a new page
Pls advice Many Thanks
|
|
|
|
|
ptr_Electron wrote: I would like see the resulting page in a fram of current page.
You mean you want to show it on IFrame ? Then why are your making WebRequest of the page ?
|
|
|
|
|
I need help developing MLM in asp.net
how to show Binary tree & save data in database
modified on Wednesday, October 14, 2009 1:37 AM
|
|
|
|
|
There is a wizard control in my form. In one of the step, I put a treeview inside an update panel.
Issue is, I disabled the next button while loading the treeview because for selection atleast one node in treeview. Upon selecting any node, the next button of Wizard control should be enabled. Since the wizard button may likely of outside the update panel, I am not able to enable the next button again. Any idea how to enable it again once any treenode is checked?
Following is my code:
<asp:WizardStep ID="BusinessUnitWizardsStep" runat="server" StepType="Step" Title="BusinessUnits">
<br />
<table class="FormTable">
<tr>
<div id ="BusinessUnitsPanel1" runat="server" style="width:100%;height:330px;overflow:auto;">
<asp:Label ID="emptyTextLabel" runat="server" CssClass="ErrorMessagesLabel" Text="No Records found" />
<asp:UpdatePanel ID="TreeViewUpdate" runat="server" ChildrenAsTriggers="true">
<ContentTemplate>
<asp:TreeView onclick="postbackOnCheck(event,'ctl00_PCMSMainContent_CreateDocumentWizard_TreeViewUpdate')" ID="AvailableBusinessUnitsTreeView"
runat="server" Height="100%" Width="50%" ShowLines="true" ShowCheckBoxes="All" ExpandDepth="1"
OnTreeNodePopulate="AvailableBusinessUnitsTreeView_TreeNodePopulate"
OnTreeNodeCheckChanged="AvailableBusinessUnitsTreeView_TreeNodeCheckChanged" EnableClientScript="false">
<ParentNodeStyle Font-Bold="False" />
<HoverNodeStyle Font-Underline="True" ForeColor="#6666AA" />
<SelectedNodeStyle BackColor="#B5B5B5" Font-Underline="False" HorizontalPadding="0px"
VerticalPadding="0px" />
<NodeStyle Font-Names="Tahoma" Font-Size="10pt" ForeColor="Black" HorizontalPadding="2px"
NodeSpacing="0px" VerticalPadding="2px" />
</asp:TreeView>
</ContentTemplate>
</asp:UpdatePanel>
</div>
cs file:
protected void CreateDocumentWizard_ActiveStepChanged(object sender, EventArgs e)
{
if (CreateDocumentWizard.ActiveStep == BusinessUnitWizardsStep)
{
EnableDisableNextButton(false);
}
}
private void EnableDisableNextButton(bool isEnable)
{
Button btnnext = (Button)CreateDocumentWizard.FindControl("StepNavigationTemplateContainerID").FindControl("StepNextButton");
if (btnnext != null)
{
btnnext.Enabled = isEnable ? true : false;
}
}
protected void AvailableBusinessUnitsTreeView_TreeNodeCheckChanged(object sender, TreeNodeEventArgs e)
{
if (e.node.Checked)
{
}
EnableDisableNextButton(true);
Can anybody please help me on this?
Thanks,
Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.
|
|
|
|
|
I have 200 records in a table. I want show the names in the table to dropdownlist but i don't want scroll for user. for this solution is any control have asp.net tell me and how will we do it?
|
|
|
|
|
I didn't understand you question, please clarify.
harshitha2006 wrote: I want show the names in the table to dropdownlist but i don't want scroll for user
So, you want to show all 200 names at once on webpage to user
|
|
|
|
|