|
I know that Excel 2003 has a row limit of 65000 ish rows, is your report larger than that?
Getting error in report when export to excel[^]
Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch
|
|
|
|
|
Hi Simon,
Yes its having more than 80000 rows, is there anyway to export all the datas into excel sheet?
Ya we know only excel sheet have 65000 rows, but is there any possible way to split the records and export to excel worksheet1 and worksheet2? or anyother way is there to export all the datas into excel?
Thanks & Regards,
Member 3879881,
please don't forget to vote on the post
|
|
|
|
|
guys;
I have a problem with requesting resources from a virtual directory in IE8
I have in the page:
<img src="server/siteroot/virtualdirectory/resource.jpg" />
The first time i thought there was a problem with the resource, but i discovered that the image is shown in Chrome, FF, Opera, Safari, and also IE9 which makes no sense because every body knows that <img /> tag makes a get request of its source(src) then a response comes back from server to draw the image in the tag frame and it should make no deference being the resource in a virtual or physical folder.
I am sorry the problem was in the same resource. It had a mime type of image/png and the extension of .jpg which made the response so deferment than the request.
I am sorry again 
Help people,so poeple can help you.
modified 5-Mar-12 7:10am.
|
|
|
|
|
I have number of web instances in IIS server, where these websites uses connection strings to connect to the SQL Server data.
There is single web.config file for all the website where there resides connection string which used by these websites.
Few websites have its own web.config file where these uses connection string from this rather than using from common web.config.
My doubt it, when we take the properties tab and click on general. We can see Connection Strings over there with the values. We can create and edit those.
Is this related to the connection string in web.config? If we edit it ,,will this effect in web.config? How can we know which web.config this value is showing in IIS setting , whether in common web.config or web.config of individual web instance folders?
can we add a new connection string in IIS rather than adding in Web.config file?
|
|
|
|
|
Look Sir;
The IIS has a collection of handlers that handle the client requests. Every request assigns as application to handle a group of requests.
An example can be the *.aspx files which are handled by the framework to execute the associated assembly. This assembly reads the connection string from the web.config file in the same folder if it does not exists it reads the connection string from the file in the root directory.
this connection string is the same as that one you can see in the property tab.
Help people,so poeple can help you.
|
|
|
|
|
|
what are the modules in "enterprise content management system" can any one tell me?
|
|
|
|
|
|
Hi All,
I want develop a web applications using visual studio 2010 (asp.net), and at the first i want to set a standards and choose the best development tools (controls) from the performance and style criteria.
please help me to find the best controls such as telerik, infragistics, componentone, ...etc.
Thanks ALL.
|
|
|
|
|
My recommendation would be Devexpress, because of their quality of support.
But the decisive criteria should be what controls you actually need.
The different makers have different controls, that aren't entirely interchangeable.
|
|
|
|
|
I Need The Following Controls: (important controls)
1. Grids.
2. Combo-boxes.
3. Date-pickers.
4. Tabs.
and i want from these controls to support right to left languages.
|
|
|
|
|
I recommend Syncfusion controls. They have very good bunch of good controls.
|
|
|
|
|
Hi
I have a website where user needs ti upoad microsoft word document.
Is it better to save the doc in the database together with user profile or in physical folder?
|
|
|
|
|
|
Hello All,
I was testing a simple program to upload files to sever , but it failed with the following error message. "Access to the path '' is denied" I am using .Net Framework 3.5 in windows 7 machine. The code i have used is given below.
private void cmdSend_Click(object sender, System.EventArgs e)
{
if (filMyFile.PostedFile != null)
{
HttpPostedFile myFile = filMyFile.PostedFile;
int nFileLen = myFile.ContentLength;
if (nFileLen > 0)
{
byte[] myData = new byte[nFileLen];
myFile.InputStream.Read(myData, 0, nFileLen);
string strFilename = Path.GetFileName(myFile.FileName);
WriteToFile(@"D:\Temp", ref myData);
}
}
}
private void WriteToFile(string strPath, ref byte[] Buffer)
{
FileStream newFile = new FileStream(strPath, FileMode.Create);
newFile.Write(Buffer, 0, Buffer.Length);
newFile.Close();
}
Can someone help me?
Thanks in Advance...
Sebastian
|
|
|
|
|
Yu're being told that your application does not have the requisite permissions to the folder you are attempting to access.
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum
me, me, me
|
|
|
|
|
|
how to deploy a webproject in window7 having iis 7.5
|
|
|
|
|
|
I have more then 50 db call with different arguments (see below). So I am repeating my code every time I need to get datatable back from db. How can I have less code (just to pass argument and procedure name ?
Public Function Function1(ByVal arg As String) As DataTable
Dim strSQLProcedure As String = "mysp"
Dim db As Database
Try
db = New SqlDatabase(ConfigurationManager.ConnectionStrings("ConnectionStrings").ToString)
Using dbCommand As DbCommand = db.GetStoredProcCommand(strSQLProcedure)
db.AddInParameter(dbCommand, "@arg1D", DbType.String, arg
Using myDataSet As DataSet = db.ExecuteDataSet(dbCommand)
myDataSet.Tables(0).TableName = "tableName"
Return myDataSet.Tables("tableName").Copy
End Using
End Using
Catch ex As Exception
Throw
End Try
End Function
|
|
|
|
|
public void Execute(string procName, List<SqlParameter> paramerters)
{
using(SqlConnection conn = new SqlConnection(...))
using(SqlCommand cmd = new SqlCommand(procName, conn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddRange(paramerters.ToArray());
cmd.ExecuteNonQuery();
}
}
You could also use libraries such as Enterprise Library Data Access Application Block[^]
Also, note how the code snippet above was formatted. Next time you try it.
Failure is not an option; it's the default selection.
|
|
|
|
|
Here is what I come up with however I have isssue with adding AddRange. Could you tell me what I am doing incorrect? Where would I list my params DB type?
Public Function GetData(ByVal SQLProcedure As String, Optional ByVal SQLParams As List(Of Parameter) = Nothing) As DataTable
Dim db As Database
Try
db = New SqlDatabase(ConfigurationManager.ConnectionStrings("myConnection").ToString)
Using dbCommand As DbCommand = db.GetStoredProcCommand(SQLProcedure)
If Not SQLParams Is Nothing Then
db.AddInParameter(dbCommand.addRange, SQLParams.ToArray())
End If
Using myDataSet As DataSet = db.ExecuteDataSet(dbCommand)
DataSet.Tables(0).Copy
End Using
End Using
Catch ex As Exception
Throw (ex)
End Try
End Function
|
|
|
|
|
Please format your code snippets. This was pointed before and you were given an example. If you can't follow the guidelines here why should we answer your question?
Failure is not an option; it's the default selection.
|
|
|
|
|
Pretty much how I have done it.
I wasn't, now I am, then I won't be anymore.
|
|
|
|
|
the issue I have is when I try to use addRange. it won't recognized it.
And also how do I pass params types?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
