Re: Compare 2 tables - ASP.NET Discussion Boards

Then it must be in the Ajax code. You need to use your debugger to find out what value is missing, presumably the name field.

Thanks Richard. Thanks for your effort.

Need to add the following tag in web.config file for .Net Framework 4.5

XML

<appSettings>
    <add key="ValidationSettings:UnobtrusiveValidationMode" value="None">
  </appSettings>

Have A Nice Day!
Murali.M

Blog

guys;
i have 2 request the first is post used to add cookies to response the other is a get request caused by Request.Redirect() call in the first one's server side.

my expectation is to find the added cookies in the second's request cookies, but what really happens is that the added cookies disappear.

please help me with this as i am stuck.

You should post the relevant code.

There are only 10 types of people in the world, those who understand binary and those who don't.

Sir;
Thank you for trying to help.
The reason for cookies disappearing was, that I was mistakenly assigning a domain for the response cookies in the post request other than the actual domain, so they wont appear in the redirect request.

Help people,so poeple can help you.

I need to compare 2 tables to find (List) the difference. How would I do this?

modified 18-Aug-14 13:46pm.

Sql tables? DataTables? Difference in columns? Difference in data? Need a lot more information.

There are only 10 types of people in the world, those who understand binary and those who don't.

try

C#

class Program
  {
    
    static void CompareList<T>(List<T> a, List<T> b, ref List<T> diff)
    {
      foreach(T item in a)
      {
        if(!b.Contains(item))
        {
          if(diff.Count == 0)
          {
            diff.Add(item);
          }
          else if(!diff.Contains(item))
          {
            diff.Add(item);
          }
        }
      }
    }

    /// <summary>
    /// Compare Two Lists of primitive types and return sorted list
    /// </summary>
    /// <typeparam name="T"></typeparam>
    /// <param name="a">The first list to compare</param>
    /// <param name="b">The second list to compare</param>
    /// <param name="diff">the ref param that returns the sorted list of items not in both lists</param>
    static void ListDifference<T>(List<T> a, List<T> b, ref List<T> diff)
    {
      CompareList(a,b,ref diff);
      CompareList(b,a,ref diff);
      diff.Sort();
    }

    static void Main(string[] args)
    {

      List<int> a = new List<int>{1,2,3,4,5,6,7};
      List<int> b = new List<int>{4,6,7,8,9,10};
      List<int> diff = new List<int>();

      List<string> c = new List<string>{"a", "b", "c", "d","e", "f", "t", "U"};
      List<string> d = new List<string>{"b","e","f","g","h"};
      //List<string> d = new List<string>();
      List<string> diff2 = new List<string>();

      ListDifference(a,b, ref diff);
      ListDifference(c, d, ref diff2);

      Console.WriteLine("-- Result of CompareLists for Int");
      foreach(int i in diff)
      {
        Console.WriteLine(i.ToString());
      }
      Console.WriteLine();
      Console.WriteLine("Results for CompareLists for strings");
      foreach(string s in diff2)
      {
        Console.WriteLine(s);
      }

      Console.Read();
    }
  }

I don't speak Idiot - please talk slowly and clearly

"I have sexdaily. I mean dyslexia. Fcuk!"

Driven to the arms of Heineken by the wife

Hi,

I want to download multiple pdf files in a single button click. I am using an open source dll, Ionic.Zip.Reduced.dll.
All code runs with out showing any errors or exceptions. By using Response.End(), I am getting a response in firefox's firebug window but when I use it in my application it throws an exception and not showing any download dialogue box. So, I had changed it to HttpContext.Current.ApplicationInstance.CompleteRequest();. Now the exception is gone, but I am not getting any response and dialogue window to download. When I debugged, I found something like this
:ClientDisconnectedToken = 'context.Response.ClientDisconnectedToken' threw an exception of type 'System.PlatformNotSupportedException'
:base {System.NotSupportedException} = {"This operation requires IIS version 7.5 or higher running in integrated pipeline mode."}

What is the real problem here, I could download files in zip by using the same code for a new project.

Please help me to sort this out. Here is my code:

System.Web.HttpContext context = System.Web.HttpContext.Current;
using (ZipFile zip = new ZipFile())
{
zip.AlternateEncodingUsage = ZipOption.AsNecessary;
zip.AddDirectoryByName("PDFs");

foreach (string item in FilePaths)
{
zip.AddFile(item.ToString(), "/PDFs/");
}
context.Response.Clear();
context.Response.BufferOutput = false;
//context.Response.Buffer = true;
context.Response.ClearHeaders();
context.Response.ClearContent();
string zipName = String.Format("Zip_{0}.zip", DateTime.Now.ToString("yyyy-MMM-dd-HHmmss"));
context.Response.ContentType = "Application/zip";
context.Response.AppendHeader("content-disposition", "attachment; filename=" + zipName);
zip.Save(Response.OutputStream);
//Response.Redirect("www.google.com", true);
context.Response.Flush();
context.Response.SuppressContent = true;
context.ApplicationInstance.CompleteRequest();

//Response.End();
}

Thanks in advance

Sarath Raj

Isn't this a programming related question?

Favourite line: Throw me to them wolves and close the gate up. I am afraid of what will happen to them wolves - Eminem
~! Firewall !~

Yes

When I commented the ajax settings from page source, the download dialogue box seems to be appear. But after downloading it, when I try to open/extract an error shows like the specified zip is invalid. Any solution?

I want to scrape a table from web page but the content of table doesn't exist in the source of page
the table created on the fly by java script
this is the source of page

HTML

 <HTML>
<HEAD>
<TITLE>Cisco Unified Communications Manager Express GUI</TITLE>
<SCRIPT Language="JavaScript"> 
  GUIVersion = "7.0.0.1 (Compatible with IOS 12.4(20)T)"
  var MWinC
  var newestDN = 0
  var retryTimes = 0
  var changeBit = false

  var FeedString = new Array()
  FeedString[0] = "Router config has been successfully changed."
  FeedString[1] = "Configuration has been successfully changed."
  FeedString[2] = "Configuration change failed."
  FeedString[3] = "Other telnet session active. Write delayed."
  var FailReason = new Array()
  // If error occurs, FailReason[0] always get printed out.
  FailReason[0] = "Please report the following error: "
  FailReason[1] = " Ambiguous Command."
  FailReason[2] = " No Matched Command."
  FailReason[3] = " No Matched Help Command."
  FailReason[4] = " No Matched Alias Command."
  FailReason[5] = " Config Locked Down Too Long."
  FailReason[6] = " Configuration Change is not allowed."
  FailReason[7] = " Wrong Tag Value."
  FailReason[8] = " System is writing config to memory. Your change is aborted!"
  FailReason[9] = " Parser return code failed."
  FailReason[10] = " Invalid ITS command option."

  var GenFeed = new Array()
  GenFeed[0] = "Add the new extension to a new phone?"


  function ksBanner() {
    MWinC = "<html><head><style>BODY{\n margin-left: 0pt; \n margin-top: 0pt;\n}"
          + "</style><title>Cisco Unified Communications Manager Express</title></head>"
          + "<body><IMG src='logohome.gif' alt='Cisco Logo'>" 
          + "</body></html>"
    return MWinC
  }

  function Greet1() {
    MWinC = "<html><head><title> View Window </title></head><style>BODY{BACKGROUND-COLOR: #cccccc} H2{PADDING-RIGHT: 0.25em; PADDING-LEFT: 0.25em; FONT-WEIGHT: bold; FONT-SIZE: 0.9em; PADDING-BOTTOM: 0.25em; MARGIN: 0.5em; COLOR: #666699; PADDING-TOP: 0.25em; FONT-FAMILY: Arial, Verdana, Lucida, sans-serif; BACKGROUND-COLOR: #cccccc }</style><body>\n"
          + "<H2>View Window</H2></body></html>\n"
    return MWinC
  }

  function Greet2() {
    MWinC = "<html><head><title> Change Window </title></head><body>\n"
          + "<h2>Change Window </h2></body></html>\n"
    return MWinC
  }

</SCRIPT>
</HEAD>
<FRAMESET rows="0,*" frameborder="0">
   <FRAME name="banner" src="ITSMain" scrolling="NO" frameborder="0" marginwidth="0" marginheight="0" noresize>
   <FRAME name="dispframe" src="javascript:parent.Greet1()">
</FRAMESET>
</HTML>

however i can get the content of the table from browser developer tools
any suggestions

modified 16-Aug-14 8:41am.

<pre><code>Imports System.Data
Imports System.Data.OleDb

Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim con As OleDbConnection
Dim cmd As OleDbCommand
con = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=C:\Users\db.mdb")
con.Open()
Dim insert As String = "insert into tbl1(names) values(@names)"

cmd = New OleDbCommand(insert, con)
cmd.Parameters.AddWithValue("@names", "Jacob")
cmd.ExecuteReader()

cmd.Dispose()
con.Dispose()
con.Close()

End Sub
End Class
</pre></code>

I'm trying to insert record into microsoft access database using the above code in asp.net. But the error specified above occurred and my connection string is ok. When i used same code in windows application, it works fine. Please help.

Don't you need spaces in your sql statement? ie
insert into tbl1(names) values(@names)
should be
insert into tbl1 (names) values (@names)

Thank you very much. It worked perfectly

If this is an MS Access database then the word names is a reserved keyword. You need to use square brackets around it to use in a query.

C#

"insert into tbl1([names]) values(@names)"

http://support2.microsoft.com/kb/321266[^]

Please up vote if it helped you Smile | :)

Thanks And Regards
Sibeesh

That depends where the data is being stored at.

The only thing to do is, to first check for any match in the data. Forexample, if it is a database related data then alteast first check for any row that has the same data as

SQL

"SELECT * FROM table_name WHERE column_name = value";

If there is a result, then don't save it. If there is no data for this query (no result) then save it.

There are other methods for saving data too, like JSON and XML files. Same algorithm works, you first check whether the data is present or not, and then do what's required, save it or not! General logic would be

C#

if(data == "present") {
   // data present
   Console.WriteLine("Data present! Thanks");
} else {
   // save the data to database or the location,
   Console.WriteLine("Data saved! Thanks");
}

Favourite line: Throw me to them wolves and close the gate up. I am afraid of what will happen to them wolves - Eminem
~! Firewall !~

Hi,

You can use bellow mentioned SQL Statement in your Stored Procedure / Query.

IF NOT EXISTS (SELECT <COLUMN NAME> FROM <TABLE NAME>)
BEGIN
"YOUR INSERT INTO SQL QUERY"
END
ELSE
BEGIN
"YOUR UPDATE SQL QUERY"
END

By this way you will handle duplicate insertion.
Hope this will help you.

Thanks,
Nishant Raval.

modified 28-Aug-14 5:48am.

You can check it in your c#, javascript, SQl codes. Where exactly you need that validation ?

Please up vote if it helped you Smile | :)

Thanks And Regards
Sibeesh

I have following problems disc. below

In the Iframe i call this page 'WorkingPanel.aspx'
on this working panel page i have many control .
i want to set all control enable false. when this page call from iframe.

not call from other link....

please give me suggestion for this topic.........

kp 777

You can put a JavaScript function in the WorkingPanel.aspx page that you can then call from the main page.

There are only 10 types of people in the world, those who understand binary and those who don't.

required field validator is not working in this code

HTML

<%@ Page Language="VB" AutoEventWireup="false" codefile="~/Test.aspx.vb" Inherits="Test" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=windows-1252" />
    <link rel="stylesheet" href="beml.css" />
    <title>Welcome to BEML Limited</title>
</head>

<body>
    <form id="form1" runat="server">
        <asp:ScriptManager ID="scriptmanger1" runat="server">

        </asp:ScriptManager>  
    <div>
        <table id="tblResume" runat="server" style="width: 325px;" cellpadding="0" cellspacing="0">
        <tr>
            <td style="background-image: url('images/title_bar.png'); padding-left: 10px; vertical-align: middle;
                height: 40px;" class="subhead" align="left">
                SUBMIT RESUME
            </td>
        </tr>
        <tr>
            <td style="border: 1px solid #F2F1F1; width: 325px;" align="center">
                <table style="width: 96%;">
                    <tr>
                        <td class="mandatory" style="text-align: right; padding-right: 10px;" colspan="2">
                            All fields are mandatory
                        </td>
                    </tr>
                    <tr>
                        <td align="left" class="content">
                            Name*:
                        </td>
                    </tr>
                    <tr>
                        <td align="left" class="content">
                            <asp:TextBox ID="txtName" Width="225px" runat="server" 
                                ValidationGroup="valEnquiry" CausesValidation="True" AutoPostBack ="True"></asp:TextBox>                            
                            
                            <asp:RequiredFieldValidator ID="RFName" runat="server" ControlToValidate="txtName" ErrorMessage="Please Enter Your Name" ValidationGroup="valEnquiry"></asp:RequiredFieldValidator>
                            
                        </td>
                    </tr>
                    <tr>
                        <td align="center" style="padding-right: 10px;">                                                            
                            <asp:Button ID="btnRSend"  CausesValidation="False" runat ="server" Text="Send" ValidationGroup="valEnquiry" />
                        </td>
                    </tr>
                </table>
            </td>
        </tr>
    </table>
    </div>
    </form>
</body>
</html>

I need help.
Thanks in advance

Have A Nice Day!
Murali.M

Blog

modified 27-Aug-14 16:14pm.

Your button, btnRSend has CausesValidation set to False which means when it is clicked the validators will not fire.

There are only 10 types of people in the world, those who understand binary and those who don't.