|
i said that coz i wanted to let ppl know that i am not a dba and don't know how to carry out such tasks... if anyone know how to get excel data in c# and transfer it to sql server database
haseeb
|
|
|
|
|
I know. It's just that, well, you're a moron. This is not the SQL forum. I pointed this out to you and your response to me left me wondering if you even read my reply.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
thanks , ur reply really helped...
You know there are quite a few types of morons in this world. First there are morons like me who have very less idea and experience and post a msg on a site with 6073937 members, so that someone with a bit of idea could help.
2nd type of morons are those, who don't know the answer , still they reply... C'mon, this is world wide web, and there are 6073937 members... putting it more simply, if we subtract 2 (me moron and u moron) , still there are 6073835 members... and yeah, mostly there are programmers solving such problems, only big companies keep dba's... I am not saying that u are a moron , but wanna tell u that this type also exist
Plz don't bother to reply again...
Thanx for ur help..
haseeb
|
|
|
|
|
How many times do you have to ask the same question? Stop Cross Posting NOW!
Yusuf
Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]
|
|
|
|
|
i tried dts as was mentioned in ur link, but i was able to transform data from an excel file to only one database table,where as i want to transform it into multiple tables. Maybe dts can do it but i can't find any help on it...
anyways, thanx for ur help and yeah, are u the only guy responsible for answering queries of the whole world? why don't u leave my query and give others a chance to provide help...
anyways... thanx alot...
Please , consider not answering back if u are gonna write something like "STOP cross-posting"... coz i think i know that u are smart
bye, thanx
haseeb
|
|
|
|
|
Look, There is no obligation on our end to help you. We do it because we like helping people, but we don't do your work for you.
If you want to receive assistance, first and foremost, you need to get your act together and watch your behavior. We have seen many who went down the hill very quickly. And you will find that very quickly if you don't change your attitude.
Yusuf
Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]
|
|
|
|
|
just stop cross posting, OK ?
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
<wc:RequiredFieldValidator id="rfvFirstName" runat="server" ControlToValidate="txtFirstName" ErrorMessage="First name is required." meta:resourcekey="rfvFirstNameResource1">*</wc:RequiredFieldValidator>
The asterix in the validator control should show up at page load, but shows up only when there is a postback.Reason why the asterix should show at page load is I want the user to know which fields are mandatory. Any suggestions?
|
|
|
|
|
Write some JS to validate the form on page load by calling the methods that the framework generates.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
at page load : rfvFirstName.isvalid = false
try this it may work
|
|
|
|
|
I'm posting this question in the ASP.NET forum because my application is an ASP.NET application.
Background:
I'm trying to develop a generic ASP page that contains the Crystal Report viewer and I will be passing the following parameters to it.
1) Report name (Ex: myReport.rpt)
2) XML filename (Ex: myXML-nnnnn.XML)
I have another system that I am integrating with which produces the XML file with a unique name, so even though my report doesn't change, the name of the datafile does.
I have the report working with a sample XML file, but I can't seem to figure out how to programatically set the datasource to the correct XML file at run time.
Thank you in advance.
David
|
|
|
|
|
Hi,
I don't know where to post this question. I am just doing it here atleast to get some idea.
I have an asp.net web application running in my intranet server. Say, there are different pages for different departments.
Now, the problem is : We have 10 different pages need to be displayed in 10 different monitors which are connected to my server.
How to achieve this ? Can you please throw some light on it?
|
|
|
|
|
interesting problem, but sorry asp.net won't help you to solve it.
May be open 10 different browser windows and in each window open a page and drag the window to different monitors 
Yusuf
Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]
|
|
|
|
|
just the monitor not the system?
|
|
|
|
|
Yes, it it just a monitor. Not system
|
|
|
|
|
You don't have any issue. If someone wants to do this, as someone said, you open 10 browsers and point to 10 pages. I am confused as to how you could not know this if you know anything about what ASP.NET is and does.
Christian Graus
Driven to the arms of OSX by Vista.
"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )
|
|
|
|
|
I develop ASP.NET web apps and deploy them to a public web server.
What I want to know is how do they have sites that instead of beginning www. begins with something else, ie http://motors.ebay.co.uk.
Can I replace the 'www' with something else with my sites??? and how do you do it???
Many thanks
|
|
|
|
|
mnemonic69 wrote: I develop ASP.NET web apps and deploy them to a public web server.
Keep that in mind
mnemonic69 wrote: What I want to know is how do they have sites that instead of beginning www. begins with something else, ie http://motors.ebay.co.uk.
it is called subdomain
mnemonic69 wrote: Can I replace the 'www' with something else with my sites???
Yes you can
mnemonic69 wrote: and how do you do it???
If you are in public web server, you need to know if your host will allow you to it. As for the technical detail, Google [^] is your friend (notice the quesry is specific to IIS)
Yusuf
Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]
|
|
|
|
|
Hi all,
i am developing an application where after log in, when i type any Url in address bar, i literally move to that page w/o any problem.I wanted to restrict URL tampering. i am using ajax update panel,by then Request.URLReferrrer returns null value always. without ajax update panel, it is Working fine.Finally i must use update panel to get value from request.URLReferrer property.
Thanks For reading,
Sundeep G
|
|
|
|
|
pleas im in proplem i need to veiw the photo from database to the graid veiw or datalist and when i press on it it give me the other information that is related to it
are ther any one help me how we do it
pleas
salah alnagar<
|
|
|
|
|
|
|
use template field and in template field use image control
|
|
|
|
|
Hello Friends,
Urgent help required...
I am developing a Web Application using ASP.Net 2.0 and C#, my data base is ORACLE 9i. Previously everything was going right, but now as the data increases and the retrieving is become headache for me. Previously i was showing this data in the third party grid i.e. FARPOINT Spread. It happens with the spread too. so i write a program to convert the Generic List into excel sheet. This works fine on local (XP Professional 2 GB RAM and all) but once i deployed this application on the server (Win server 2003 12 GB RAM with 3GB Virtual Memory set and 500 GB HDD) it gives me error that 'System.OutOfMemoryException'.
I checked that data is coming till UI layer from Business layer but still why it is throwing error. Couldn't make it out. And i need solution for this ASAP.
Currently trying to write this fetched data in Excel sheet by using following code block.
Thanks in advance.
Code to write excel sheet -
private void FpLoadEditData(ArrayList userName, ArrayList siteId, string from, string to)
{
oXL = new Application();
oXL.Visible = false;
//Get a new workbook.
oWB = (_Workbook)(oXL.Workbooks.Add(System.Reflection.Missing.Value));
oSheet = (_Worksheet)oWB.ActiveSheet;
//System.Data.DataTable dtGridData = ds.Tables[0];
int iRow = 2;
// Setting Column name for Sheet
int colCount = QiSpread.ActiveSheetView.Columns.Count;
int colHeaderIndex = 1;
for (int j = 0; j < colCount; j++)
{
oSheet.Cells[1, j + 1] = ConfigurationSettings.AppSettings["colHead" + colHeaderIndex];
colHeaderIndex++;
}
for (int rowNo = 0; rowNo < vzmLst.Count; rowNo++)
{
//if (rowNo < 150)
//{
for (int colNo = 0; colNo < QiSpread.ActiveSheetView.ColumnCount; colNo++)
{
PopulateSheet(oSheet, iRow, colNo, vzmLst[rowNo]);
}
iRow++;
//}
//else
// rowNo = vzmLst.Count;
}
if (vzmLst.Count > 6000)
Session.Timeout = 15;
oRng = oSheet.get_Range("A1", "IV1");
oRng.EntireColumn.AutoFit();
oXL.Visible = false;
oXL.UserControl = false;
string strFile = string.Empty;
if (Request.Params.Get("__EVENTARGUMENT") != null &&
Request.Params.Get("__EVENTARGUMENT").ToString().ToUpper().Equals("EDITDATA"))
{
strFile = "VzMEditData_" + loginName + from + "TO" + to + "_" + DateTime.Now.Second.ToString() + ".xls";
//strFile = "VzMEditData" + from, to DateTime.Now.Ticks.ToString() + ".xls";
}
else if (Request.Params.Get("__EVENTARGUMENT") != null &&
Request.Params.Get("__EVENTARGUMENT").ToString().ToUpper().Equals("VIEWDATA"))
{
strFile = "VzMViewData_" + loginName + from + "TO" + to + "_" + DateTime.Now.Second.ToString() + ".xls";
}
//string strFile = "report" + DateTime.Now.Ticks.ToString() + ".xls";//+
oWB.SaveAs(strCurrentDir + strFile, XlFileFormat.xlWorkbookNormal, null, null, false, false, XlSaveAsAccessMode.xlShared, false, false, null, null, null);
// Need all following code to clean up and remove all references!!!
oWB.Close(null, null, null);
oXL.Workbooks.Close();
oXL.Quit();
Marshal.ReleaseComObject(oRng);
Marshal.ReleaseComObject(oXL);
Marshal.ReleaseComObject(oSheet);
Marshal.ReleaseComObject(oWB);
Session.Add("fileUrl", strFile);
}
To display the generated excel -
private void GetExcel()
{
if (Session["fileUrl"] != null && Session["fileUrl"].ToString() != string.Empty)
{
Response.ContentType = "application/vnd.ms-excel";
Response.AppendHeader("Content-Disposition", "attachment; filename=" + Session["fileUrl"].ToString());
Response.TransmitFile(Server.MapPath(".") + "\\EditViewDataFiles\\" + Session["fileUrl"].ToString());
HttpContext.Current.ApplicationInstance.CompleteRequest();
Response.Flush();
Response.Close();
}
}
Regards,
Abhijeet
|
|
|
|
|
As far as I can see this has loaded in all the data into the memory before processing it. Perhaps you need to load the data in in small chunks, process each chunck then move on to the next chunk.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
