Is it possible to send the selected value of a web part to a SqlDataSource that fills a DetailsView?
I have a few web parts on a SharePoint page that link together, but I need to call a VB procedure when a certain link is clicked. I was hoping to achieve this through a DetailsView.
While working with LINQ to ENTITIES I see that there is only a way to use stored procedure that is returning one entity only, or a view that is a join of two entities.
But what if I need in ASPX page to get two tables that there is NO connection between them, no join can be done between them at all.
I have one Stored Procedure that return the two tables, but entities don't support this right now.
I can split them to two Stored Procedure and call each of them separately.
I've got an image URL in a gridView which retrieves the name of a file, but I need to add some text to the start and end of the value returned. This is the code so far:
[Code]....
The image URL renders as 'filename.png', but I need to add 'about-us/images/' before it.
I am using Visual Studio 2008 and asp.net technology with C# language. Whenever I try to choose any datasource for databound control like "gridView" of "ObjectDataSource". The connection can be tested as OK but when I click on OK the it gives following error and database could not be added: "Object Reference not set set to an instance of an object." it was working perfectly fine in Visual Studio 2005, so kindly help if there is some settings that are to be adjusted for 2008 version.
View 9 RepliesI have a problem with connecting a DropDownList to a DataSource.
The scenario: When I add am item to the database (I do this using a GridView/ObjectDataSource / SPROC) I want to update a DropDownList that lists this items as well.This DropDownList is linked with another ObjectDataSource. Now, I listen to the RowCommand event of the GridView and in a certain case I refresh the DataSource of the DrpoDownList and do a DataBind to the DropDownList afterwards.
The strange thing is, that when I take a look at the DropDownList's Items-Collection during the Page's OnPreRender event handling, the items collection contains the new entry but the new entry is not rendered, i.e. when I take a look at the rendered HTML the <option></option> entry for the new value is missing.
After another postback to the page the entry appears in the DropDownList?
How to Divide image in two parts like I have an image which width x Height = 16 x 32.
And I want to split image in two images 16x 16 and 16x 16.
How can i do it?
If I have a huge Order-table and I want to display records from it using paging, what is the best way to select the records from the database?
If I first do like this:
[Code]....
..and then select the records I want based on RowNum it seems like I select ALL records in the first query anyway. I guess I want to do something like SELECT TOP @PageSize FROM Orders...
i have a project running good (database and application both are in same server). some days before we've decided to place databse (sql server 2000) in different server.we created new server with windows server 2003 and Sql server 2000; nothing else is installed in it.And then i register new server's sql in old server's sql server. it connected successfully. even i can fire a query to new server from old server.
Both new and old server having windows server 2003 and Sql server 2000.
Now the problem :I CAN NOT ACCESS NEW SERVER'S DATABASE FROM MY APPLICATION.
I have changed my web.config as under :
OLD :<connectionStrings>
<add name="ConnectStr" connectionString="Data Source=OLDSERVER;Initial Catalog=DataExtractor;Persist Security Info=True;User ID=123;Password=123;pooling=true;Max Pool Size=50" providerName="System.Data.SqlClient"/> [code]....
I need the syntax for a connection string in web.cong to connect to a SQL Server 2005 database that is on a VPN. I have an account on the DB that I can use....just don't know how to construct the connection string properly.
View 4 RepliesI am working with webpart. I have developed webpart but has some issues in managing its personalization/personal settings.
For example when user A gets logged in and personalize any webpart. Then uer B gets logged so it should have default webpart setting or own personal setting webpart.
I am referring following site:
[URL]
kindly tell how to use these methods or others which are present in sqlprovider
1) SavePersonalizationBlob
2) LoadPersonalizationBlobs
Is there any tutorials or example to help me or any1 can have idea or example etc to
This is my first time working with web parts. Was wondering if anyone can show me how to create a new webpart project in VS2008. I don't see any options for creating a "web part template" when I go to create a new project.
View 2 RepliesI am having trouble with ASP.NET and trying to use web parts. I am receiving and error. I am using VS 2008, with ASP.NET 2.0. I create a new project and add the webpart manager and then the webpartzone. I build and run the project and receive the error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
SQLExpress database file auto-creation error:
The connection string specifies a local Sql Server Express instance using a database location within the applications App_Data directory. The provider attempted to automatically create the application services database because the provider determined that the database does not exist. The following configuration requirements are necessary to successfully check for existence of the application services database and automatically create the application services database:
If the applications App_Data directory does not already exist, the web server account must have read and write access to the applications directory. This is necessary because the web server account will automatically create the App_Data directory if it does not already exist. If the applications App_Data directory already exists, the web server account only requires read and write access to the applications App_Data directory. This is necessary because the web server account will attempt to verify that the Sql Server Express database already exists within the applications App_Data directory. Revoking read access on the App_Data directory from the web server account will prevent the provider from correctly determining if the Sql Server Express database already exists. This will cause an error when the provider attempts to create a duplicate of an already existing database. Write access is required because the web server accounts credentials are used when creating the new database. Sql Server Express must be installed on the machine. The process identity for the web server account must have a local user profile. See the readme document for details on how to create a local user profile for both machine and domain accounts.........................
Is there a way to connect the database PROGRAMMATICALLY without using SYSTEM.DATA.SQLCLIENT?
View 9 RepliesCould not establish a connection to the database. If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider. I have set up a db locally which mimics the production DB, THe production db and website has no has no issues.
THis used to work till i had hard disk failure and had to reinstall all software and do the db from scratch. Used the table scripts and ran the aspnet_regsql. I am using sql server express 2008 asp.net 3.5 I am using custom provider for Roles and custom membership provider for Memberships. Pretty sure the problem is in the db permissions, though I have set up Users in the Security of the DB.
[Code]....
When ever I try to connect to server through Microsoft sql server management studio express then an error is generated saying that
Cannot connect to .//SQLEXPRESS
Additional Information
A network related or instance specfic error occured while connecting to SQL server. The server not found or not accessible verify that instance name is correct and that SQL server is configured to allow remote connections.(Provider: Named Pipes Provider, error 40-could not open connection to SQL server )(Microsoft SQL server, Error:53)
I have form and i'm using web parts for asp.net.I want the first web part the stretch the entire width and on the second row I have 2 small web parts to on the second row
<big web part>
<second><third>
But, I can't get the 2nd and third web parts to be on the same line. [Code]....
I am using web parts in my web page( ASP.NET 2.0 and C#).
The contents of these web parts vary in size. For example, one web part has calendar control, another web part has the File Upload control.
I have added the web parts under "td" tag. So the web parts are of different sizes now, I want to make the webparts to be of same height and width, regardless of the content available.
How to set the height and width to be same for all web parts regardless of the content available in the webparts.
Also, when I web page is running, I am able to "WebPartZone1" which is the Id in the page. How to hide that name from appearing.
I am studying for the 70-562 examination and I came to the web part section.
I was trying to do the exercises presented in the Microsoft's book for this examination, but there is a part where I have to gather all the Display
[Code]....
I would like to know if it's possible not to use ASPNETDB.MDF file for the web parts.I don't want to store any data in ASPNETDB.MDF, I would like to remove that file, I tried delete it, but every time I compile my project, ASPNETDB.MDF creates it self automatically.
View 2 RepliesI'm starting a web project where I would like to have the minimize/collapse functionality of the Web Parts. In a future version I would like to let the user move the modules around and add and remove modules to/from the page, but not right now. The users don't have to be authenticated to use the portal and if they are, I can't use the built in authorize functions. My questions are: should I use Web Parts, or should I just use Web User Controls? Is there other libraries, similar to Web Parts, that are better suited for my use?
View 2 RepliesWhich table does contain information about web parts?
For example: if I minimize web part zone and I again connect to my web application (even after server restart) this web part zone still will be minimized.
In which table this information is stored?
I know this topic has been visited before, but most of the posts I saw were 3+ years old [1]. I just tested adding a WebPartManager and a WebPartZone to an ASP.NET 4.0 site and was dismayed to see it still dumped out a table.Is the preferred way to get a tableless web part layout to use a ControlAdapter? Is there a more modern UI composition framework for ASP.NET that other have good success with, or has everyone just moved to MVC? I am building an application where the (non-technical)by dragging & dropping widgets around.
View 1 Repliesconnecting my database to the online server. My server is seekdotnet. But I had been receiving this error code Cannot open database "database.bak" requested by the login. The login failed. Login failed for user '219_nypmecom'.
View 1 RepliesI was working on a asp.net project earlier but due to some OS problem I had to re-install the OS..so before re-installing the OS I detached my sql database and then attached it back after installation..but I am having a login problem now..the previous servername was XYZ-DB840C74SQLEXPRESS..so this user i.e. XYZ-DB840C74ASPNET is added to the database's permissions..now my new server name is XYZ-8D50FD73SQLEXPRESS..but I am unable to add this user through the permissions wizard..I am getting the following error: Cannot open database "finance" requested by the login. The login failed. Login failed for user 'XYZ-8D50FD73ASPNET'.
View 7 RepliesIn my windows application, i am listing the System DSN's configured on the remote machine in a combobox. Once i select the DSN and click on Connect button, i should be able to connect to the remote database. I am trying to open the connection to the database using ODBC but am getting the below error.
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.
Below is the code sample
string conn = "Provider=MSDASQL;Remote Server=http://BLR1WKD010; Remote Provider=MSDASQL;DSN=" + clsODBC.pDBName + ";UID=" + txtUsername.Text + ";PWD=" + txtPassword.Text;
OdbcConnection odbcConn = new OdbcConnection(conn);
odbcConn.Open();