Need to contact code project member. - ASP.NET Discussion Boards

ganeshMohan11-Feb-10 20:21

11-Feb-10 20:21

Hi,

I have a dataset,which is a combination of two tables and has more than
5000 records.

I want to insert all rows from dataset into db

using for loop

for (int i=1;ds.tables[0].rows.count;i++)
{
insert into tbl1
insert into tbl2
}

but it takes a long time

how to decrease the time to insert?

thanks in advance

Known is a drop , Unknown is an Ocean

Re: Bulk insert from dataset into db?

thatraja11-Feb-10 20:27

thatraja

11-Feb-10 20:27

you can solve that by using SELECT Query with UNION ALL.

INSERT INTO tblDummy (column1, column2)
SELECT 'Value1' ,1
UNION ALL
SELECT 'Value2' ,2
UNION ALL
SELECT 'Value3' ,3
UNION ALL
SELECT 'Value4' ,4
UNION ALL
SELECT 'Value5' ,5

thatraja

Re: Bulk insert from dataset into db?

ganeshMohan11-Feb-10 20:36

ganeshMohan

11-Feb-10 20:36

thanks for the reply.

but i know how to insert,i asked insert query takes more time.

how to decrease the time? is it possible to insert with out looping?

dataadapter.update() or dataset.acceptchanges() helpts to insert or update to databse but my scenario my dataset has data from two database tables
[person,address]

is any other way to insert?

Known is a drop , Unknown is an Ocean

Re: Bulk insert from dataset into db?

thatraja11-Feb-10 20:50

thatraja

11-Feb-10 20:50

your code will be like below.

string strQuery1="insert into tbl1(column) ";
string strQuery2="insert into tbl2(column2) ";

for (int i=1;ds.tables[0].rows.count;i++)
{
	strQuery1 = strQuery1 + " SELECT " +  ds.tables[0].Rows[0]["column1"].ToString() + " UNION ALL ";
	strQuery2 = strQuery2 + " SELECT " +  ds.tables[0].Rows[0]["column2"].ToString() + " UNION ALL ";
}

Now you get two queries in that two variables strQuery1, strQuery2, so you can execute with connection or command object.
actually you are executing multiple insert query in loop so it takes long time, but in this way you will get single query so it takes less time.
Then change the code depends on your no of columns which you want to store in db. also use stringbuilder instead of concatenating strings.
thatraja

Re: Bulk insert from dataset into db?

Abhishek Sur11-Feb-10 20:46

Abhishek Sur

11-Feb-10 20:46

You can create bulk insert using OpenXML as DataSet is actually an XML. Send XML to your stored proc which will insert them to the database.

See an excellent article regarding this :
Bulk Insert from DataSet to Database[^]

Use DataSet().GetXML() to get XML and pass it to the stored procedure

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
InfoBox Visual Studio 2010 Extension
Windows7 API Code Pack
Simplify Code Using NDepend

Re: Bulk insert from dataset into db?

T M Gray12-Feb-10 4:11

T M Gray

12-Feb-10 4:11

Have you looked at the SqlBulkCopy object?

Re: Bulk insert from dataset into db?

beginner in C#.net12-Apr-11 4:11

beginner in C#.net

12-Apr-11 4:11

better u can use bulkcopy

Need to contact code project member.

Hema Bairavan11-Feb-10 20:12

Hema Bairavan

11-Feb-10 20:12

hi peoples,

one of our member has the same problem of mine in 2004,

i need to contact him what he did for that problem as the problem and requirement is so unique..

the problem is

I have few crystal reports in a project. I need to combine all the reports in one pdf. I can print each report in one pdf file but need to combine all of them in one. Any help would be highly appreciated

The member name is AliHaider,

his link of code project is

http://www.codeproject.com/Members/Visionsoft

can you please tell me how to contact him or if you know the answer please revert me

Re: Need to contact code project member.

i gr811-Feb-10 21:51

i gr8

11-Feb-10 21:51

There are products available in market to combine multiple PDF files. U can use that.

1. print all u r reports as individual PDF file
2. using external products combine all this pdf to one pdf file

u need a lot of R&D work here( i think this would be an very interesting task to work on)

OR ELSE
Try something like this

1. Print all ur report to RTF file
2. Copy the content of each RTF file to stream and create a PDF file out of that.

Re: Need to contact code project member.

Hema Bairavan12-Feb-10 0:20

Hema Bairavan

12-Feb-10 0:20

hi guys i came with solution regarding...

get the PdfSharp.dll from website and then include in yours
the do the following..
it will work like gun...

using PdfSharp.Pdf;
using PdfSharp.Pdf.IO;

Stream[] ChildStream = new Stream[ReportDoc.Length];
Stream OutStream = new MemoryStream();
PdfDocument[] PdfChildDoc = new PdfDocument[ReportDoc.Length];
PdfDocument OutPutPage = new PdfDocument();

for (int i = 0; i < ReportDoc.Length; i++)
{
ChildStream[i] = (Stream)ReportDoc[i].ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
PdfChildDoc[i] = PdfReader.Open(ChildStream[i], PdfDocumentOpenMode.Import);
}

for (int i = 0; i < PdfChildDoc.Length; i++)
{
int count = PdfChildDoc[i].PageCount;
for (int idx = 0; idx < count; idx++)
{
// Get the page from the external document...
PdfPage page = PdfChildDoc[i].Pages[idx];
// ...and add it to the output document.
OutPutPage.AddPage(page);
}
}

OutPutPage.Save(OutStream, false);
//byte[] b = new byte[OutStream.Length];
//OutStream.Read(b, 0, b.Length);

Response.Buffer = true;
Response.ContentType = "application/pdf";
Response.BinaryWrite(((MemoryStream)OutStream).ToArray());

run time error

prateekfgiet11-Feb-10 18:16

prateekfgiet

11-Feb-10 18:16

i have made a web application which run smoothly at local system but when i uploaded on web server and trying to login it gives runtime error

error is:

Runtime Error
Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.

Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customerrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customerrors> tag should then have its "mode" attribute set to "Off".

<configuration>
<system.web>
<customerrors mode="Off">

Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customerrors> configuration tag to point to a custom error page URL.

<configuration>
<system.web>
<customerrors mode="RemoteOnly" defaultredirect="mycustompage.htm">

Thanks in advance

Re: run time error

i gr811-Feb-10 20:01

i gr8

11-Feb-10 20:01

Then do as for as its Info, you can able to login. let me know if error comes after that

Out of Placed things in server [solved]

Mehdi Ghiasi11-Feb-10 9:27

Mehdi Ghiasi

11-Feb-10 9:27

Hi!

I have been programming a web application with ASP.NET (.Net version 2) . when I run it on localhost, all things are correct. but when I upload files on my web server, many things are out of placed.
for example:
1. footer of my page: in localhost, it's on center of the page. in server, it's on right of the page.
2. Textbox sizes: in localhost, they are regular size. but in server, they are bigger and out of their regular place.

How can I do to correct this problem?

Regards.

Mahdi Ghiasi

modified on Friday, February 12, 2010 2:04 AM

Re: Out of Placed things in server

Abhishek Sur11-Feb-10 11:43

Abhishek Sur

11-Feb-10 11:43

I guess you dont have proper css files published properly. Or the browser doesnt download them correctly.

Check the View-Source and see if the deployment and development sources are different.

There is no way that browser behaves differently when same code is executed. The problem must be in the html generated.
You can also look for other external files which are downloaded with the page is working correctly or not.

To simplify your task, Use Fiddeler[^]

Rose | [Rose]

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
InfoBox Visual Studio 2010 Extension
Windows7 API Code Pack
Simplify Code Using NDepend

Re: Out of Placed things in server

Anurag Gandhi11-Feb-10 17:55

Anurag Gandhi

11-Feb-10 17:55

Good One.

Anurag Gandhi.
http://www.gandhisoft.com
Life is a computer program and every one is the programmer of his own life.

EntityDatasource

Sider8911-Feb-10 8:45

Sider89

11-Feb-10 8:45

How I can download for example: from country it's cities, when I'll click co country page must redirect me corresponding cities...

C# Developer

Re: EntityDatasource

Not Active11-Feb-10 9:20

Not Active

11-Feb-10 9:20

Perhaps you'd like to take a few moments to compose your question better and edit it so it is understandable what you are asking for and what you would like.

I know the language. I've read a book. - _Madmatt

Re: EntityDatasource

Sider8911-Feb-10 9:48

Sider89

11-Feb-10 9:48

well I'm using Entity Framework(I'm newbie in this)
I have Entities Country cities with onetomany realtionships

in domain are generated both of this classes, with it's properties...
but in cities There is only City.ID and for CountryID there is reference to Class country: public EntityReference<Country> CountryReference{//...}
and in Country Class:public EntityCollection<Cities> City{//...}

<asp:EntityDataSource ID="src" runat="server" ContextTypeName="Namespace.Domain" EntitySetName="Cities"
EntityTypeFilter="City" EnableInsert="true" EnableUpdate="true"EnableDelete="true">
<WhereParameters>
<asp:QueryStringParameter Name="here must be CountryID,but in class there is not such property" type="int32" DefaultValue="0" QueryStringField="CountryID">
</WhereParameters>
</asp:EntityDataSource>

sorry for my bad English Frown | :(

C# Developer

how to display image from database

netJP12L11-Feb-10 7:18

netJP12L

11-Feb-10 7:18

Hi gurus,

I have been looking around how to display stored images(varbinary(max)) from sql server2005 to Gridview. But I was unable to find a decent answer on google.
Do anyone of you have ever come across to this problem, if so, would you help me or perhaps suggest me to a resource.

Thanks

Re: how to display image from database

Not Active11-Feb-10 8:16

Not Active

11-Feb-10 8:16

Maybe this will help, C# Photo Album Viewer[^]

I know the language. I've read a book. - _Madmatt

Re: how to display image from database

netJP12L11-Feb-10 10:46

netJP12L

11-Feb-10 10:46

Thanks for replying. I am looking a solution for Asp.net. However, this is mentioned for client side applications.

I would like to know also which is a better way:
1. Display stored image as a blob format on gridview is faster or
2. Re-create blob image on the disk first and then point loction.

Thanks

Re: how to display image from database

T M Gray11-Feb-10 10:46

T M Gray

11-Feb-10 10:46

If you aren't going to write them out to the filesystem temporarily, you would probably have to do a base 64 encoded version.

http://en.wikipedia.org/wiki/Data_URI_scheme[^]

Color parameter in query string ?

paper6711-Feb-10 6:01

paper67

11-Feb-10 6:01

I'm calling and aspx page with a color param. I need this color to be passed on the querystring, so I call the aspx as:

somepage.aspx?color=#FFFFFF&...
The color parameter in the querystring is set by ColorTranslator.ToHtml(Color)

I think here the problem is the # symbol. Is there a problem passing # as a parameter? How can i get back my Color object from this querystring ?

I tried :

if (!string.IsNullOrEmpty(Context.Request.QueryString["color"]))
Color = ColorTranslator.FromHtml(Context.Request.QueryString["color"]);

but for some reason the above if statement evaluates to false. How can I fix this ?

TIA

Re: Color parameter in query string ?

Steve Wellens11-Feb-10 7:36

Steve Wellens

11-Feb-10 7:36

This seems to work:

 protected void Page_Load(object sender, EventArgs e)
 {
     String Color;
     if (Request.QueryString["color"] != null)
     {
         Color = Request.QueryString["color"];
     }
 }

 protected void Button1_Click1(object sender, EventArgs e)
 {
     String URL = "Default.aspx?color=" + Server.UrlEncode("#FFFFFF");
     Response.Redirect(URL);
}

Steve Wellens

Re: Color parameter in query string ?

Abhishek Sur11-Feb-10 11:46

Abhishek Sur

11-Feb-10 11:46

You mean

paper67 wrote:
if (!string.IsNullOrEmpty(Context.Request.QueryString["color"]))

Evaluates to false ?

Did you put the QueryString correctly.
Use HttpUtility.UrlEncode before sending the color code. And after fetching use HttpUtility.UrlDecode to get the color code back properly.

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
InfoBox Visual Studio 2010 Extension
Windows7 API Code Pack
Simplify Code Using NDepend

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.