|
<NewDataSet>
<Jobs>
<WID>0</WID>
<AccountReference>08LO5</AccountReference>
<OEReference>.BBS087</OEReference>
<InvoiceNumber>5</InvoiceNumber>
</Jobs>
<Jobs>
<WID>1</WID>
<AccountReference>08LO3</AccountReference>
<OEReference>.BBS0833</OEReference>
<InvoiceNumber>6</InvoiceNumber>
</Jobs>
</NewDataSet>
how could i parse the above xml by javascript which will work in all the browser. please help me with sample code.
thanks in advancetbhattacharjee
|
|
|
|
|
hi sir,
please help me sir.i want to block integer for textbox1 and character for textbox2.actually what java script i am using works fine for explorer 6,7 and mozilla but not in ie8.and i have enable all the script from tools-internet option-custom.but nothing works.please support.
thanks
|
|
|
|
|
Is it possible to show what code you placed for Integer checking?
I think you might put a debugger in your code and inspect what the object has when you keypress.
Check if event.keyCode is giving proper value or not. 
|
|
|
|
|
hi sir,
yes why not i can see you my java script.it is below.and i am using this on input textbox keypress event.but one more issue is that it's working fine if i am use it in mozilla or ie 6,7 but not in ie8 only.
function number(e)
{
var key;
var keychar;
if (window.event){
key = window.event.keyCode;
}else if (e){
key = e.which;
}
else
return true;
if((key == 8) || (key == 0))
return true;
keychar = String.fromCharCode(key);
keychar = keychar.toLowerCase();
if((key > 47) && (key < 58)){
return true;
}else
return false;
}
|
|
|
|
|
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 advanceKnown is a drop , Unknown is an Ocean
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
Have you looked at the SqlBulkCopy object?
|
|
|
|
|
better u can use bulkcopy
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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());
|
|
|
|
|
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
|
|
|
|
|
Then do as for as its Info, you can able to login. let me know if error comes after that
|
|
|
|
|
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
|
|
|
|
|
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]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
Good One.
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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 
C# Developer
|
|
|
|
|
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
|
|
|
|
|
|
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
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
