|
It is simply a matter of forming the database query. Something like,
SELECT Title, Summary
WHERE Title CONTAINS('@keyword')
No comment
|
|
|
|
|
Hi,
I have an asp.net application which loads data from csv file. I need to check for duplicate rows in the csv file and should not process them and give error message for those duplicate rows.
I did in some approach but got the comments like performance is impacted. Is there any performance oriented process available to compare the string arrays
Any type of help is greatly appreciate.
Here is my code
private static bool CheckForDuplicateRow(FileInfo file
,string[] line
,int lineNumber
,ref bool lineAlreadyVerified)
{
CsvStream csvStream;
using (Stream fileStream = file.OpenRead())
{
using (StreamReader reader = new StreamReader(fileStream))
{
csvStream = new CsvStream(reader);
string[] rowItems;
try
{
csvStream.GetNextRow();
rowItems = csvStream.GetNextRow();
int rownumber = 1;
while (rowItems != null)
{
if ((rowItems.Length == line.Length) && (rownumber != lineNumber) && (rowItems.Length > 0))
{
bool b = AreRowItemsEqual(rowItems, line);
if (AreRowItemsEqual(rowItems, line) == true)
{
if (lineNumber < rownumber)
lineAlreadyVerified = true;
return true;
}
}
rowItems = csvStream.GetNextRow();
rownumber++;
}
}
catch (Exception e)
{
throw e;
}
}
}
return false;
}
private static bool AreRowItemsEqual(string[] rowItems, string[] line)
{
for (int i = 0; i < rowItems.Length; i++)
{
if (rowItems[i] != line[i])
{
return false;
}
}
return true;
}
Thanks & Regards,
Abdul Aleem Mohammad
St Louis MO - USA
modified 16-Dec-11 12:34pm.
|
|
|
|
|
indian143 wrote: I have an asp.net application which loads data from csv file. I need to check for duplicate rows in the csv file and should not process them and give error message for those duplicate rows.
Here's my approach:
ArrayList uniqueLines = new ArrayList();
ArrayList duplicateLines = new ArrayList();
String[] lines = File.ReadAllLines( "C:/file.csv" );
foreach ( String line in lines )
{
if ( !uniqueLines.Contains( line ) )
{
uniqueLines.Add( line );
}
else
{
duplicateLines.Add( line );
}
}
From the above, you have all the unique lines in the uniqueLines arraylist and you have duplicate lines in the duplicateLines arraylist.
To display errors, loop through the "duplicateLines" and tell the user about the error.
Happy Coding,
Morgs
|
|
|
|
|
Can I use List instead of ArrayList, because that class is not coming in my application, I dont know why?
Thanks & Regards,
Abdul Aleem Mohammad
St Louis MO - USA
|
|
|
|
|
Yes, you can use List<string> if you want. The ArrayList comes from the: using System.Collections;
|
|
|
|
|
Hi,
Is there any way to get the which rows are repeated, like for example row 1, 3, 5 are same and 2 and 4 are same.
Is there any way to get that from this list?
thanks,
Abdul.
Thanks & Regards,
Abdul Aleem Mohammad
St Louis MO - USA
|
|
|
|
|
Hi,
For when click datalist item show pupup on parent window i use this code :
any other???????
protected void dlPhotos_ItemCommand(object source, DataListCommandEventArgs e)
{
if (e.CommandName == "Select")
{
Response.Write("<script>");
Response.Write("window.open(Default3.aspx','_self','toolbar=0,location=0,menubar=0,resizable=0,width=400,height=320')");
Response.Write("</script>");
}
}
|
|
|
|
|
Jitendra Parida1987 wrote: ItemCommand(object source, DataListCommandEventArgs e)
this is server side code which will get executed the user clicks a button in your DataList. I am assuming that your expected behavior is not working.
since everything in your script appears to be static why not just write the script code into your .aspx page directly? add your control and on the click event call your javascript function. the only thing you need change is returning false so that it won't post back.
as if the facebook, twitter and message boards weren't enough - blogged
|
|
|
|
|
Hi,
My requirement is dynamically implement so that i try this code.
|
|
|
|
|
Jitendra Parida1987 wrote: My requirement is dynamically implement
dynamically implement??
there is nothing dynamic about that script that you posted so why not just put it in a static javascript function that gets called from each item in the DataList. the html code that gets displayed is dynamically generated on the server so maybe that is it??
sounds like a homework assignment when you mention it this.. haha
as if the facebook, twitter and message boards weren't enough - blogged
|
|
|
|
|
hi,
please tell me what is problem in my code???????
|
|
|
|
|
Hi,
I have tried to deploy my web application (VS2010 + C#) by adding the project output and building a msi setup. But, I want to do these steps through command prompt. Our command scripts will do all the stpes to deploy in server.
That command prompt scripts should do the following things
1. Getting latest version of my solution
2. Adding web deployment project and adding project outputs there
3. Building and deploying in a server..
How to do that?
Thanks in advance.
Balasubramanian K.
|
|
|
|
|
hi
Request.ServerVariables("REMOTE_HOST") does not work on IIS 7. but work on IIS 5.1 and 7.5.
what problem can be?
|
|
|
|
|
i am looking for vertical according menu for asp.net shopping cart project.
the menu items accessed from database, please advice me how can i do that.
Thank you
NInad
|
|
|
|
|
There are javascript menu codes available
Please find the below link if its helpful for your query.
http://www.dynamicdrive.com/
Regards
Naina
Naina
|
|
|
|
|
|
Hi,
follow this example for dynamic menu.
http://chandradev819.wordpress.com/2011/07/03/how-to-bind-asp-net-menu-control-with-database
|
|
|
|
|
Dear,
When we are hosting a web site on server which steps to follow the configuration a domain name to a static ip address.
|
|
|
|
|
Please repeat the question ?
But make smaller sentences ?
What do you really wish to know ?
Kribo
http://blog.kribo.be
|
|
|
|
|
hello,
My objective is that i am create a virtual directory for my website how to set domain just like: "www.codeproject.com" and static ip to global access my website.
|
|
|
|
|
Dear
Please be specific. I might be different based on your shared hosting or dedicated hosting. I have a shared hosting and it doesn't ask me for such kind of configuration.
thanks & regards
Nitish Arora
Web developer (Learner)
|
|
|
|
|
How to create keep me logged in code on asp.net?
|
|
|
|
|
What have you tried for yourself? Hint: you could use Session to maintain the logged in state of users.
"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
|
|
|
|
|
I create a login page here put a check box for keep me logged on.
but i have know knowledge for implement that one.
any one help on c#.
|
|
|
|
|