User Profile

Collapse

Profile Sidebar

Collapse
BD5
BD5
Last Activity: Sep 24 '07, 01:01 PM
Joined: Sep 7 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • BD5
    replied to Add 'OR' with AddWhere?
    in .NET
    Yeah, but I didn't find a subcategory in this forum..

    maybe someone else knows how to deal with this?
    See more | Go to post

      Leave a comment:

    • BD5
      replied to Add 'OR' with AddWhere?
      in .NET
      Subsonic..

      If you mean that...
      See more | Go to post

        Leave a comment:

      • BD5
        replied to Add 'OR' with AddWhere?
        in .NET
        I found this about it:

        http://www.codeproject.com/cs/databa...eryBuilder.asp


        If you look at complex queries, they use this:

        Code:
        query.AddWhere("CustomerID", Comparison.Equals, 
                                   "VINET", 1);
query.AddWhere("OrderDate", Comparison.LessThan, 
                     new DateTime(2005,1,1), 1);
        ...
        See more | Go to post

          Leave a comment:

        • BD5
          replied to Add 'OR' with AddWhere?
          in .NET
          Hi,

          I hope you mean this :):

          Code:
          protected void SearchButton_Click(object sender, EventArgs e)
	{
Query query = CalendarItem.CreateQuery();

query.AddWhere(CalendarItem.Columns.Description, Comparison.Like, "%" + SearchTextBox.Text + "%");
query.AddWhere(CalendarItem.Columns.IsPublished, true);

LoadAndBindQuery(query);

	}
          See more | Go to post

            Leave a comment:

          • BD5
            replied to Add 'OR' with AddWhere?
            in .NET
            Hi, thanks for your reply!

            It is for a web application. About the object types, I am not sure what you mean (I am kind of a newb to ASP, but I am trying :)). If you mean string etc, well Description is of the type ntext, and the other colums the search should be going through are colums, all nvarchar(255) types..

            I hope this is what you meant with object type?...
            See more | Go to post

              Leave a comment:

            • BD5
              replied to Add 'OR' with AddWhere?
              in .NET
              Anybody please? :)

              ///
              See more | Go to post

                Leave a comment:

              • BD5
                started a topic Add 'OR' with AddWhere?
                in .NET

                Add 'OR' with AddWhere?

                Hi all, I wanted to make a search function where you can type a word in one field, now I use this:
                Code:
                query.AddWhere(CalendarItem.Columns.Description, Comparison.Like, "%" + SearchTextBox.Text + "%");
query.AddWhere(CalendarItem.Columns.Location, Comparison.Like, "%" + SearchTextBox.Text + "%");
                But then the word has to be in Description AND in Location, but I was wondering,...
                See more | Go to post
                • BD5
                  replied to Opening existing project
                  in SQL Server
                  I currently use this connectionstrin g:
                  The database file was Project.mdf

                  <connectionStri ngs>
                  <add name="ProjectCo nnectionString" connectionStrin g="Data Source=.;Initia l Catalog=Project ;Integrated Security=True;"/>
                  </connectionStrin gs>

                  <SubSonicServic e defaultProvider ="SqlDataProvid er" fixPluralClassN ames="true">
                  <providers>...
                  See more | Go to post

                    Leave a comment:

                  • BD5
                    replied to Opening existing project
                    in SQL Server
                    Thank you!

                    I could attach it!

                    But when I want to open a page, I still get this error:


                    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

                    Exception Details: System.Data.Sql Client.SqlExcep tion: An error has occurred while establishing a...
                    See more | Go to post

                      Leave a comment:

                    • BD5
                      replied to Opening existing project
                      in SQL Server
                      Can anyone help me please? :) I am really stucking here..
                      See more | Go to post

                        Leave a comment:

                      • BD5
                        replied to Opening existing project
                        in SQL Server
                        Thanks for the help!

                        I did not get a .ldf file with it... is it necessary?? By the way, that manager program you are talking about.. is it this program:
                        http://users.pandora.be/vipers/screenn.jpg


                        Because I right clicked those items, but I can't find attach.....
                        See more | Go to post

                          Leave a comment:

                        • BD5
                          started a topic Opening existing project
                          in SQL Server

                          Opening existing project

                          HEllo all,

                          I got a project sent to me, and I want to open it, it is delivered with a .mdf file. I downloaded VS 2008 and SQL server 2005, and i opened the project with VS2008.
                          But when i want to open a page that required data the page says:

                          An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings...
                          See more | Go to post
                          No activity results to display
                          Show More
                          Working...