|
You might be able to change it to make it work, but it's not advisable. Here are some reasons:
- A web application is a multi threaded application, so you need to make a singleton that is unique for the thread, not for the application. You can't share the same connection between threads.
- Putting the connection in a singleton makes it more complicated to close the connection properly. You don't want to keep the connection open between requests.
Experience is the sum of all the mistakes you have done.
|
|
|
|
|
Guffa wrote: You might be able to change it to make it work, but it's not advisable
It depends how it is designed to work in the first place. If each method in the singleton creates its own connection and closes it by the end of the method then there aren't any problems. I typically store only the connection string so I can have as many connections running as I want.
|
|
|
|
|
Colin Angus Mackay wrote: If each method in the singleton creates its own connection and closes it by the end of the method then there aren't any problems.
In that case the singleton is pointless, and you can just make the methods static.
Experience is the sum of all the mistakes you have done.
|
|
|
|
|
Guffa wrote: In that case the singleton is pointless, and you can just make the methods static.
True.
|
|
|
|
|
jnaude wrote: This class works more than 100% in my win-forms applications.
That's an interesting performance metric. Got some figures to back it up?
|
|
|
|
|
Hi!
In a website we generate a drilldown report from a GridView component. With Javascript the onclick functionality is added and works fine.
We generate a DataTable depending on rownumber and columnnumber from the click.
As soon as we have the data in the DataTable we export the DataTable to Excel. Works fine.
If i Close Excel and want to click on a button in the webpage (Run Report-button) I get again the same Excel as I just Closed.
Somehow my webpage is out of sync.
How do I get in InSync again?
Method to send the DataTable to an aspx file for exporting to Excel:
private void DrillDown(DataTable drillDown)
{
try
{
Page.Session.Add("excelTable", drillDown);
Page.Session.Add("excelName", "DrillDownClaimsReport");
Page.Session.Add("returnPageAfterExport", "../Reports/ClaimReport.aspx");
Response.Redirect("../Export/DataTableToExcel.aspx");
}
catch (Exception err)
{
lblError.Text = err.Message;
}
}
Page DataTableToExcel.aspx.cs:
using System;
using System.IO;
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;
public partial class Export_DataTableToExcel : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
DataTable excelTable = new DataTable();
String excelName = String.Empty;
String returnPage = String.Empty;
excelTable = (DataTable)Page.Session["excelTable"];
excelName = (string)Page.Session["excelName"];
returnPage = (string)Page.Session["returnPageAfterExport"];
ExportDataTableToExcel(excelTable, excelName, returnPage);
}
private void ExportDataTableToExcel(DataTable table, String fileName, String returnPage)
{
Response.Clear();
Response.AddHeader("content-disposition", String.Format("attachment;filename={0}.xls", fileName));
Response.ContentType = "application/ms-excel";
Response.Charset = "iso-8859-1";
String Combineer = String.Empty;
String sep = String.Empty;
foreach (DataColumn dc in table.Columns)
{
Combineer += sep + dc.ColumnName.Replace("_", " ").Replace("occurrence date", "Date of Loss");
sep = "\t";
}
Combineer += "\n";
int i;
foreach (DataRow dr in table.Rows)
{
sep = String.Empty;
for (i = 0; i < table.Columns.Count; i++)
{
Combineer += sep + dr[i].ToString();
sep = "\t";
}
Combineer += "\n";
}
Response.Write(Combineer);
Response.End();
Page.Session.Remove("excelTable");
Page.Session.Remove("excelName");
Page.Session.Remove("returnPageAfterExport");
Response.Redirect(returnPage);
}
}
Help Needed!!!
|
|
|
|
|
im working in asp .net for 2 years and i wanna go to the next step.
so plz i wanna to know?
1-what DLLs should i install (i need link).
2-and simple example will be nice
regards
|
|
|
|
|
1 - None. AJAX is just a mishmash of things you had all along. If you want to use the ASP.NET AJAX library, that's a whole other thing. For that you need to install the library
2 - I'd recommend the book 'AJAX in Action' and if you want to use the ASP.NET library, the ASP.NET AJAX in Action is the best book going on that front.
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 )
|
|
|
|
|
Ahmad Adnan wrote: what DLLs should i install (i need link).
As Christian graus said[^], you have misunderstood that AJAX is created by Microsoft. It's not. They created a library that supports AJAX and make things easy. AJAX is just javascript. You need to look here[^] to start.
To use AJAX library created my MS, download it and install AJAX extensions. Use the AJAX toolkit.dll with your project.
Hope it helps
|
|
|
|
|
Hi all,
I'm working on a project that uses the eBay SDK and first I need to test a few things by making a Store in the Sandbox. I'm working on it for the first time and I know we can't make a store in the Production thru API but this article in their documentation tells something taht we can make a store in the sand box for testing purposes.
Managing eBay Stores
I've been looking around for quite a while now but I'vent been able to find some thing that tells me how I can create a store like that.
if any one of u has worked on such a project plz give me some guideline. that would be much help!
Thanks in advance
-- modified at 4:29 Thursday 8th November, 2007
Rocky
You can't climb up a ladder with your hands in your pockets.
|
|
|
|
|
Your post scrolls, can you make the link to some text and link to it?
|
|
|
|
|
ok here u go! now its ok
Rocky
You can't climb up a ladder with your hands in your pockets.
|
|
|
|
|
Hi frnds,
I hv a page which is in panel. If i directly click on Save Button, Validation in code behind takes place to check all values are entered or not.
If any value is not entered it displays the text in lable which is on the top of page but the focus is still on Save Button instead of moving to the top..
Plz help me out..
thnks in advance
|
|
|
|
|
Hi all,
How can i raise an synchronous post back by javacript function in asp.net ajax?
I don't want to do this by web services.
I want raise an synchronous post back by javacript function.
(Or) How can i raise an synchronous post back of UpdatePanel control by javascript function?
thanks
-- modified at 4:14 Thursday 8th November, 2007
|
|
|
|
|
It's very simple with pure Javascript (without using ASP.NET AJAX)
Pass "false" in the third parameter of open method of XmlHttpRequest object.
req.open("GET", url, false);
|
|
|
|
|
Hi Michael,
Thanks for your help, but how can i raise an synchronous post back by javascript with asp.net ajax (without web services).
|
|
|
|
|
i am developing an application where i have a gridview which dispalys search values when i click a search button. But intially when the page loads gridview should show only
the header and empty rows and columns and it should be populated with values only on clicking the search button. can u give me any solution please?
|
|
|
|
|
You can create a dummy DataTable and bind it to the GridView. It will show only the headers
|
|
|
|
|
Hi There,
I am posting a Sample hope it helps you,
if (sDataSet == null || sDataSet.Tables[0].Rows.Count == 0)
{
sDataSet.Tables[0].Rows.Add(sDataSet.Tables[0].NewRow());
GridView1.DataSource = sDataSet;
GridView1.DataBind();
int TotalColumns = GridView1.Rows[0].Cells.Count;
GridView1.Rows[0].Cells.Clear();
GridView1.Rows[0].Cells.Add(new TableCell());
GridView1.Rows[0].Cells[0].ColumnSpan = TotalColumns;
GridView1.Rows[0].Cells[0].Text = "No Record Found";
}
else
{
GridView1.DataSource = sDataSet ;
GridView1.DataBind();
}
Cheers
Menon
|
|
|
|
|
you can use EmptyDataTemplate
<EmptyDataTemplate>
<table width="100%" border="0" cellspacing="0">
<tr style="background-color: #5D7B9D; font-weight: bold; color: White; width: 100%;">
<td>
Name </td>
<td>
Surname</td>
<td>
City</td>
<td>
Phone</td>
<td>
</td>
</tr>
</table>
</EmptyDataTemplate>
|
|
|
|
|
how to perform click event on dynamically created bottons, in a page there are 100s of buttons which r created dynamiclly , i want to perform click event on them . what can i do for that. plz help
yogesh
|
|
|
|
|
Assign an EventHandler to their Click event.
Experience is the sum of all the mistakes you have done.
|
|
|
|
|
They need to be created before page load, and the exact same buttons need to be created on postback, in the same order, so that viewstate can be restored and the events can fire.
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 guys.
i can explain for my doubt with example.see.my table have multiple type of employee details like as Mangemment,Programmer,Designers,Accountants,Contra ctEmployees.Each type of department having many employee details.Now my drop down list having types of department names like that above types of department names..if i select any one type of department data wil be display in gridview format .gridview data column as employee Name,Address,Phone_No,email_address and each every row with checkboxes.gridview showing data according to select the dept.No problem.
first I select Mangemment type of employee grid view showing that type of employee details ,here i checked first two employee details then checkbox values put in one viewstate,then i go to Programmer type of employee it showing that type employee details here i want to checked two employee details using checkbox but what happened first two checkboxes are already checked. so view state having proper checked check box values but problem is
whenever i go to select for another type of employee details checkboxes are checked based upon order of previous checked index.
i checked checkbox values of dropdown list selected index changed event,values are coming from viewstate,so we want viewstate values add plus new checked checkbox values ,but if i click display button control that viewstate values are removing then new checked checkbox values are only diaplay .
see my code behind..
i can put tears smile near code where i used viewstate and i can qustioned smile near the code of viewstate values are removing( i mean previous page checked checkbox values).
Protected Sub gridview1_PageIndexChanging(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewPageEventArgs) Handles gridview1.PageIndexChanging
gridview1.PageIndex = e.NewPageIndex
getselected()
databind1("First_name", "asc")
setSelected()
End Sub
------------------
Public Sub getselected()
Dim arrayListContactGroup As New ArrayList
If ViewState("ArrayList") IsNot Nothing Then
arrayListContactGroup = CType(ViewState("ArrayList"), ArrayList)
ViewState.Remove("ArrayList")
End If
For Each row As GridViewRow In gridview1.Rows
Dim chkselectcontacts As CheckBox = CType(row.FindControl("chksel"), CheckBox)Dim arraylistlabel As Label = CType(row.FindControl("contid"), Label)
If chkselectcontacts.Checked Then
If Not arrayListContactGroup.Contains(arraylistlabel.Text) Then
arrayListContactGroup.Add(arraylistlabel.Text)
End If
Else
If arrayListContactGroup.Contains(arraylistlabel.Text) Then
arrayListContactGroup.Remove(arraylistlabel.Text)
End If
End If
Next
ViewState("ArrayList") = arrayListContactGroup
-------------------
Public Sub setSelected()
Dim arrayListContactGroup As New ArrayList
If ViewState("ArrayList") IsNot Nothing Then
arrayListContactGroup = CType(ViewState("ArrayList"), ArrayList)
End If
For Each row As GridViewRow In gridview1.Rows
Dim chkselectcontacts As CheckBox = CType(row.FindControl("chksel"), CheckBox)Dim arraylistlabel As Label = CType(row.FindControl("contid"), Label)
If arrayListContactGroup.Contains(arraylistlabel.Text) Then
chkselectcontacts.Checked = True
Else
chkselectcontacts.Checked = False
End If
Next
End Sub
--------------------------
Protected Sub Selcon_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles Selcon.SelectedIndexChanged
getselected()
databind1(ViewState("sort"), ViewState("ascdesc"))
setSelected()
End Sub
My problem is,arraylist values(checkbox values) stored in viewstate,viewstate get the values no problem,but whenever i go to dropdown list select index change at that time we want add viewstate values and current checked checkbox values,but its doing opposite side operation i mean removing the view state value.see i can underlined that line.
Thanigaimani.thirumalai
|
|
|
|
|
How many times you posted this messages. If you are not able to do the suggestions provided, what is the use of reposting it. It's shame on you
1 - Your post here[^] (2 replies)
2 - Here[^]
I really don't know how people like you will survive in the programming field.
|
|
|
|