i m developing web application in asp.net .Trying to deploy it.i m doing first time.I have uploaded my folder on plesk.But now hot to connect with database?How to connect physical server to database server on plesk 9.5?
View 3 Replies
I want to create ftp account in plesk using asp.net so that whenevrever user register in site can have an ftp account with his username and password. Please help me with what approach to follow (code example) and what api's does asp.net include for this...??
View 3 RepliesI was trying to upload the database of my ASP.NET website. On the local machine, if I copy the database from another machine, I have to attach it through SQL Server Management Studio and then use it in the connection string like
[Code]....
My database is approx. 10 MB in size for now. If I upload it via ftp to App_Data folder, how would I have to attach this database?In Plesk, I have the option to create the database and its user (as shown in the screenshots):1) Web Applications and services-Plesk2) Add New Databaseand add new database user3) Webadmin>ASP.ET Enterprise ManagerBut this is for the new database I created. My problem is to upload an existing one.There's also a section in Plesk for ASP.NET settings (as shown below)
This has the option to change the connection string etc.I also asked my hosting provider about the method to be followed for attaching the database that I would upload. This was the reply in quote." mdf ldf files perhaps will be working at your local computer but this way database of mssql will not work on web server as on web server you will be required to create and restore your database backup file using plesk control panel.
Sample connection string for asp.net
mssql `Standard Security`:
"Provider=SQLOLEDB;Data Source=Your_Server_Name;Initial Catalog=Your_Database_Name;UserId=Your_Username;Password=Your_Password;"
Server name to be used in coding: localhost Catalog/ database name , database user and database password you will be required to create your own using plesk control panelI would be really be appreciative for the steps I have to take to upload my existing database. How do I have attach it? What connection string I have to use?
i want to create application that register host and domain in pleskany guya have sample? or source code? or documentation
View 1 RepliesI've been using a standard web site in Visual Studio for my site, using the Plesk file manager interface to upload files either singly or in total as a .zip file.Recently I've changed the project to a VS web application.All the documentation that I see refers to using IIS to deploy a web app; if I wanted to just FTP all the source code, I may well have stayed with web site.I've not been able to find any Plesk specific deployment info.
View 1 RepliesI asked plesk the following question:I've been through the documentation and scoured various forums, but I can't find a defintive guide to uploading an mssql db (contained in a app_data folder) to the server and conecting it via the Plesk control panel. I've created a db and user via the panel but how do I get the actual db to the server and get it to work?"and they replied:"For database restoration please upload your database backup file ( i.e. .bak ) under your hosting space and update us the exact path where you place this file + your database login details ( i.e. database name , database user name and password ). So we restore this database for you. "
View 3 RepliesI am new for web hosting.My hosting provider use plesk panel for manage websites.I have created MS SQL database using plesk panel. but every time I am getting error when trying to connect ro database. I am using the following connection string.
<add name="ACN" connectionString="Data Source=209.59.179.205SQLEXPRESS;Initial Catalog=ACN;User ID=xxxxx;Password=xxxxxx" providerName="System.Data.SqlClient" />
U can check error detail by just clicking on Login button on [URL]
i have create a form..and i generate ID using dropdown list for user for registration before they save the page..the ID will appear when click "signUp" button.("ID" not saved yet into database)
i want the "ID" lock into databse when click "signUp" button..
I am trying to get value from the databse and assign it to the label using the below line:
lblQuestion.Text = ds.Tables[0].Rows[0]["Question"].ToString();
but it assigns as label.
if (ds.Tables[0].Rows.Count > 0)
{
lblQuestion.Text = ds.Tables[0].Rows[0]["Question"].ToString(); ;
}
I need to bind a menu with the databse, the problems is i need to define roles so that the menu will only contain links to pages that are allowed to the login user,user can only view pages allowed to him, what is the best choice for this purpose, and what control will give me best performance in this scanerio of dynamically generating menus???
View 2 RepliesI'm using Visual Web Developer 2010 Express with SQL server 2008 Express and I'm wondering if it is possible to query the database from within a VB subroutine located within pagename.aspx.vb, rather than just using the asp databound controls on the main page ?
I want to do something like this in the page load routine:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim username As String
username = GetUserName() 'calls function to get current username
Now connect to database and perform SQL command (SELECT FirstName FROM dbo.USERS WHERE UserName = username)
Assign the retuned data to a label: lblFirstName.Text
End Sub
Is it possible ?
here is my function
Public Shared Function GetData(ByVal strQuery As String) As DataTable
Dim dt As New DataTable
Dim cmd As New OracleCommand(strQuery, conn)
cmd.CommandType = CommandType.Text
Try
conn.Open()
da.SelectCommand = cmd
[Code]....
here im calling above GetData function
[Code]....
it is not accepting date i was try to use CDate(BDPLite2.SelectedDate) also but not working but when i use store procedure then this cdate method work but when i use inline code then no work....plz let me know where im doing mistake.
i want to take sql table .sql extesion in sql server 2008r2
View 1 RepliesI have an asp.net3.5 app. It has multiple client folders in the root folder. There are multiple web.config files. One is in root folder and one each in client folder. The web.config in client folder contains connection string for the database to be connected. I am using FORMS authentication. Each client has a specific page which are lying in root folder. This page redirects to the client specific folder and user logs in the application using the one more login page which is in client folder. And this page uses the connection string which in this client specific folder web.config.Now my problem is that I am not able to connect to the database using the client specific web.config on my live server. Live server is a Windows 2008 Datacenter and IIS7 machine. And my local system is XP IIS6 machine.Please help me to resolve this issue. Or how can I configure my application on IIS 7 &Win2008 DC system in WINDOWS authentication mode?
View 2 Repliesi want to get data from my database and dispaly it in my web page using json with webservicei'm going to post my code i create a webservice and add method which return string to get all data so my code like this
[Code]....
and in my page
[Code]....
I have two tables in my database
using "innerconnect" i have show table content in grid view as INV_NO INV_DT DN_NO DN_DT LR_NO LR_DT .
where LR_NO is null .
I want to update it from grid view.
here DN_NO and INV_NO are primary keys
[Code].....
when i have fill the null values through grid view and click on button1 it shows data saved but it not saves to my data base tables
I have inherited a very old SQL Server Database for a live site, but have been asked to add a new table for invoice recording to it. Fairly easy to do for any new record added from now on, however I run into some issues with selecting older records.I need to find a way to select from 3 tables, see if a record exists in the new table and if not insert a new record to it.My stored procedue so far is (The new table is [Invoicing]:
[Code]....
i m using Datalist control on that i have one section as a "Qty" which come from database .now how i can pass two values in <asp:parameter from database
look at my code
<asp:Parameter DefaultValue="<%#DataBinder.Eval(Container.DataItem, "ItemID")%>"Name="mItemNo" Type="String" />
if i write anywhere in datalist then it worlks , but not in this DefaultValue parameter , coz whenever that datalist item get bound one by one row then DefaultValue may get change and depend on that Default value my Quantity section also get changenx
I want to list all images in a horizintal way form the database where the id = number.ASP.NET, C#, SQL Server.
View 2 RepliesI have button, which fires an event, that deletes a record from the database. This is the source of the button:
<asp:Button ID="btnDelete" runat="server" Text="Delete" onclick="btnDelete_Click" />
But how can I make a confirm box appear before the deletion?
I am new to asp.net (I may use some incorrect termology while I explain my issue...) and need some help with DropDownList in Gridview. Currently I have a GridView set up with three Columns bound to a database: Column1 - some kinda of index, Column2 - string, Column3 - DropDownList(called Active). So far when I build the page, all the columns show up and the DropDownList appears and the values are bound correctly. I want to change a value in the DropDownList and automatically update that value in my database.
I have set AutoPostBack = true and I made a DataObject (called UpdateActive) to update the database (it takes 2 inputs, the Column1 index and Column3 DropDownList value).However, I don't know how to find the row that I am changing, is there a way to figure out what row it is (like finding the Column 1 index?). Also, I don't want to have to click a button to update the data.
[Code]....
I have been asked to develop an ASP.Net application which will directly connect (store and retrieve) to the ACT! databse already functional. I am new to ACT and looking for a starting point to integrate it with ASP.Net application. In particular I am looking for answers to the following questions:1. What database technology is used by ACT? Is SQL Server? In that case, I should be able to connect just like any SQL Server database?2. Is there any class library or API for .Net from ACT which will help achieve this?3.
View 1 RepliesI am creating the crystal report without database data, just i am read the data from text file and fill into dataset then genrate the crystal report but problem is here if i am export the crystal report into different format so he wants the database logon parameter.so in this case i have no database crendential because i am creating the report without database.
View 1 RepliesI am making a message module in asp.net with database of sql. i have made a gridview and enabled selecting. and a form view is synchorised with grid view on selecting. i am writing update sql but could not get a way to take data on Gridview or Formview to compare the record in sql database.
this is my page view
[Code]....
This my vb code
i am a beginner and i have done a tutorial to create a dynamic asp.net web app. I want to host it on my own laptop to the world wide web.
I have copied the content to my C:/inetpub.wwwroot and used IIS 7 to make an associated website. I can open the site in a browser by typing http:/localhost/mysite in the url field. Thing is I want to see it on the www. I have registered a domain name. I guess I have to map the domain name to the physical server on my machine. How do I do this? I am using a wifi router.
