.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Creating an database search application in VS C#

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
Hello everyone, I wish to create a C# application that will have a form and a text box where I can enter a text, and then ask the application to search if this text exists in a database. If it exists, I want all the information associated with this text to be displayed in a datagrid view or list box. I am able to create a database in SQL Server and I can connect to my database from VS 2005 C#. If this is possible, how do I go about it? Many thanks in advance.

View Complete Post

More Related Resource Links

problem rename sharepoint 2010 search service application admin database

Hi all, i have a problem that hopefully someone has an answer to.  i am not too familiar with sharepoint so please excuse my ignorance. we have sharepoint 2010 on a windows 2008r2 server.  everything seems to work fine.  but as you know, the default database names are horrendous.  i have managed to rename all of them, except for the "search service application" admin database. the default is: Search_Service_Application_DB_<guid> the other 2 databases (crawl and property) were renamed without a problem. we are following the article from technet on how to rename the search service admin db (http://technet.microsoft.com/en-nz/library/ff851878%28en-us%29.aspx).  it says to enter the following command: $searchapp | Set-SPEnterpriseSearchServiceApplication -DatabaseName "new database name" -DatabaseServer "dbserver" however, i get an error about identity being null.  no big deal, i add the -Identity switch and the name of my search service application.  but the real problem comes the error it throws:   Set-SPEnterpriseSearchServiceApplication : The requested database move was aborted as the associated search application is not paused. At line:1 char:54 + $searchapp | Set-SPEnterpriseSearchServiceApplication <<<<  -Identity "Search Service Application" -DatabaseName "ShareP

Search server 2010 setup - error creating search service application

I am running in a very similar siutation as this post:

I am configuring a new Search Server 2010 production environment.

I used the search setup account to run the setup and run the SharePoint Products Configuration Wizard.

During the first run of the SharePoint configuration wizard (where the farm account and service applications are setup), the process failed because the search service application could not be created.  

Errors were encountered during the configuration of the Search Service Application.
System.Data.SqlClient.SqlException: User does not have permissiont to perform this action.

I was under the assumption that the setup account had securityadmin and dbcreator SQL Server roles.  However, this was not the case and I had them added.  My original thought was the setup failed because of this.  After those roles were added, I tried to recreate the search service application and I still get a failure.

I am pretty sure I have followed the prerequisites as prescribed by Microsoft in terms of account setup (

Creating and configuring a Web Application with pre-created content database


I recently looked at the very interesting Technet article named "Deploy by using DBA-created databases (SharePoint 2010)"; I've noticed something strange in the following section:

To create and configure the portal site Web application

  1. [DBA] Create the portal site Web application content database using the LATIN1_General_CI_AS_KS_WS collation sequence and set the database owner (dbo) to be the Setup user account.

  2. [DBA] Using SQL ServerManagement Studio, add the service application service account to the Users group and then to the db_owner role for the portal site Web application content database.

  3. [Setup] From the SharePoint 2010 Management Shell, use the New-SPWebApplication and Get-SPWebApplication cmdlets to configure the portal site Web application content database. Use the following example as a guide.

    New-SPWebApplication -Name "Contoso Internet Site" -Port 80 -HostHeader "http://sharepoint.contoso.com" -URL "https://www.contoso.com" -ApplicationPool "ContosoAppPool&q

    Issue with creating a new Search Service Application


    I am new to SharePoint, so please bare with me.


    1)      Installed SQL Server 2008 on a virtual machine

    2)      Installed SharePoint Server 2010 on another virtual machine and configured it in a Farm environment. Installed and configured FAST search successfully on this same machine.

    3)      One of the initial steps for post installation of FAST Search states that we have to create a new Search Service Application.

    a)      Tried to create a New Search Service application using the following steps: 

    i)                    From the Microsoft SharePoint Server Central Administration home page, select Application M

    Using SharePoint Search feature in ASP.Net Application

    Integrating ASP.Net application in to MOSS 2007 to utilize SharePoint Enterprise Search Feature can be done by using Business Data Search.

    Creating a Smartphone Application and Using Data from SQL Mobile

    In this exercise, you will use Visual Studio 2005 to create a Smartphone application. You will associate commands with a mobile device's soft keys, and you will add the ability to scroll through the list of available products (a list of images). You will create a data source for an existing SQL Mobile database, and then test the application in the Windows Mobile 5.0 emulator.

    In the following procedure, you will create a new Windows Mobile 5.0 project in Visual Studio.

    Need Help in creating chat application using jquery.


    Hello Friends

                 I have to develope Jquery chat application Like Gmail  in My Web application. For this i spend My lots of hours in Googling. AT THE time of searching I got one script. which is very helpful.  But in the script author has used all the members who has logged will be appeared in the chat box. instead of this i have to put only the members who's are in the friendlist. i have to show only these members.

    Following is the project from where i get script.

    As well as in the code author has passed dynamic userid to session but i have to pass actuall userid from database.


    from Here I download the code. but the code is in the 3.5 framework. i m using 2.0 framwork. so most of the code I have changed but not getting how to make changes for list.

    Please help me to solve the Problem.

    Thanks In Advance


    search in mysql database, mvc



    I have set up a mysql connection in visual studio 2010 and now i have a connection and dont really know where to go next.

    I want to be able to search the data and get the result in a view.

    using asp.net mvc

    Upsize Your Database: Convert Your Microsoft Access Application to Take Advantage of SQL Server 7.0


    What if you need to convert an existing Microsoft Access 97 database application into a true client-server application that is based on a SQL Server back end? If you know a little about Visual Basic and SQL Server, it's easy to make your app take advantage of the power and scalability provided by SQL Server 7.0. Using some concrete code examples, this article takes you step by step through converting the native Jet queries in your Access application into stored procedures and pass-through queries that SQL Server can use. You'll also learn how to pass on parameters when your client-server app calls these SQL Server stored procedures and queries.

    Michael McManus

    MSDN Magazine June 2000

    An example of packaging web application containing database upgrade SQL file

    A few months ago, we have a blog talking about extending the web publishing pipeline to package database project deployed SQL file.  In this blog, I'll show step by step example of packaging web application with SQL Server database upgrade SQL file using Visual Studio 2010.  This way, we can generate a web package with incremental SQL script to certain database version.  The scenario may help distributions of a web upgrade package which needs to be installed on many different locations, each with their own SQL server database.   1. Create a Web Application Project 2. Add a new "SQL Server 2008 Database Project" to the solution 3. Prepare a development database, such as my test1 database as the following: 4. Right click our...(read more)

    Error in / Application after adding employee search in webpart


    Hello everyone,

    I am working on sharepoint 2007 and I was editing the webpart of the software and after adding the predefined employee search table, the server has crashed while trying to access the server remotely with the following error message:

    Error in / Application

    However, while trying to login locally I have no problem and can easily login.

    What will be the course of action in fixing this error.

    Also the site is complaining of an invalid certificate even after adding an exception.

    Any help would be greatly appreciated.

    Thank You,

    Chris Stanko

    Create user is creating aspxxxx.mdf database in my app_data folder


    I had already setup roles for my pages and requirements call for ability to manage and create users.

    So i was looking at code that allows you to do so using membership, even though i got the page to work, it was creating a database in my app_data folder.. i already have SQLExpress setup with the asp schema, but cant figure out how to get my application to use that instead of creating the db in the folder?

    What am i missing or doing wrong?

    I have the following setup in my web.config file..

    		<authentication mode="Windows"/>
    			<deny users="?"/>
            <add name="SqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"

    Video: Creating Custom Ranking Models in SharePoint 2010 Search

    In SharePoint search you can tune the weighting that search uses for the results and create custom ranking models to return the results the user is expecting. (Length: 2:28)

    One or more types failed to load - While creating a web application as well as running psconfig wiza



    I got this error while i was trying to create a web application - 'One or more types failed to load'. So i tried to run psconfig and got the same error.

    My Spec

    Windows Server 2008 R2 x64

    SharePoint Server 2007 x64 with MOSS SP1, MOSS SP2, WSS SP1 and WSS SP2

    Microsoft Office Professional 2010 x64

    Microsoft SQL Server 2005


    And, here is the complete error -


    Log Name:      Application
    Source:        SharePoint Products and Technologies Configuration Wizard
    Date:          8/27/2010 3:30:28 PM
    Event ID:      104
    Task Category: None
    Level:         Error
    Keywords:      Classic
    User:          N/A
    Computer:      ZBDEV22.zenbridge.com
    Failed to register SharePoint services.
    An exception of type Microsoft.SharePoint.Upgrade.SPUpgradeException was thrown.  Additional exception information: One or more types failed to load. Please refer to the upgrade log for more details.
    Microsoft.SharePoint.Upgrade.SPUpgradeException: One or more types failed to load. Pleas

    Problem with Movie Database Application

    Hi Im following MVC tutorials on ASP.net website..I have a problem at Movies database application found in http://www.asp.net/mvc/tutorials/create-a-movie-database-application-in-15-minutes-with-asp-net-mvc-cs  Listing 3 - Views\Home\Index.aspx----------------------------------------------------------------------------------------------I dont understand where "Model" refer to in this code <% foreach (var item in Model) { %>  Also im confusing with accessing the database fields using var item Please explaine me what is happening in this code.<% foreach (var item in Model) { %> <tr> <td> <%= Html.ActionLink("Edit", "Edit", new { id=item.Id }) %> | <%= Html.ActionLink("Details", "Details", new { id=item.Id })%> Movie Database Application

    Change SSP and Search database names

    While creating SSP, besides the Admin site and MySite content databases, two more databases get created. They are usually named MySSP_DB and MySSP_Search_DB. If later we have a need to change these database names, what is the procedure? Thanks

    Creating a .msi installer package for WPF application

    Hi Frends, I need to create a .msi installer or a setup of my WPF application. ineed to submit tht to my client. i can ask my client to install .net framework 4.0 as a pre requisite but then except that the installer should take care of rest of the things...how can i build such kind of installer or setup. kindly help me as soon as possible pleae coz my project is about to release in a day or so. regards KuldeepRegards Kuldeep Gupta
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend