I have a little web app derived from one template (LinkDirectory). It works fine both on local and on live website.
But, when I download the database (which is filled with valud data, visible in the web app) from the website data (for maintenance purposes), it appear empty (no tables) in my local wite.
What did I miss ? is there a better way to get the database back home ?
I've found a Webmatrix help article that says MS Webmatrix "publishes the (SQL Server or MySQL) database by creating scripts that run in a database that has been created for you by your hosting provider." That is wonderful, except I can't get it to work when I'm trying to publish a MySQL database (backing wordpress) through FTP (my hosting provider does not support 'web deploy'). Again, no problem, since it is already documented that " FTP protocols cannot be used to publish MySQL database. " But this does not excuse Webmatrix from generating MySQL database install scripts for me. During the publishing step, no database install script is generated - at least that I can tell - and there is no manual option to create a database export / backup / install script.
In short, as Webmatrix goes, I'm dead in the water trying to get my database uploaded to my hosting provider. Does anyone know the trick to force Webmatrix to create the MySQL database install scripts on my local box? Once created, I can take-over the upload and install process.
based on the code below how can I tell if the recordset returned is empty and if the grid is emptyIf data is empty how can I tell data.Count(); and data.RecordCount(); generate errorsHow can I tell if the grid is empty, has no rows or if the rowcount = 0
var db = Database.Open("StarterSite");
var sqlQ = "SELECT * FROM table1 ORDER BY Name";
var data = db.Query(sqlQ);
var grid1 = new webgrid(data);
grid1.gethtml();
I want to show custom message when no data is present to display in WebGrid.
View 2 RepliesWhat is the proper way to check for null or empty strings on dynamic objects? This is the only solution I've found so far:
if (admin.PasswordHash.GetType() == typeof(DBNull) || admin.PasswordHash == string.Empty)
If the field is null, the object returned is DBNull.Value, but if the field is empty string, it's return as a System.String object. This makes it impossible to do regular "admin.PasswordHash == DBNull.Value" check, as that will fail whenever the field has been set to empty string. Is my example the right (and only) way to go?
I have a sql database that on some field will have a empty string/field. I am using a Datalist to display my results. How do I not make the labels that are empty not display? Currently if the field is empty it will leave a space there which my goal is if the field is empty do not leave a white space instead move the other colunms up.
View 2 RepliesIn the webMatrix examples, which I have working, it's very easy to access a database. Only three lines are necessary to get up and going:
@{
var db = Database.Open("LOS");
var selectQueryString = "SELECT * FROM wknTest";
}
and a little later,
@foreach(var row in db.Query(selectQueryString)){
There's no using's, no connection strings, all that happens behind the scenes. But now I have enough complicated c# code that I want to separate it into a separate C# file. How would I do the above, but in a C# file residing in the app_code folder in a webMatrix project?
In the webMatrix examples, which I have working, it's very easy to access a database. Only three lines are necessary to get up and going:
[Code]....
and a little later,
[Code]....
There's no using's, no connection strings, all that happens behind the scenes. But now I have enough complicated c# code that I want to separate it into a separate C# file. How would I do the above, but in a C# file residing in the app_code folder in a webMatrix project?
WebMatrix must be creating the Database object behind the scenes.
I'm wondering if it is possible to include Microsoft.Data.Entity.CTP.dll reference to WebMatrix site and if the Compact edition of the database would support it? I'd kinda love use something like
code-first development in my WebMatrix project. I think is even easier than writing SQL-s into the code...
As mentioned in this tutorial (http://www.asp.net/webmatrix/tutorials/5-working-with-data), I tried using my own connectionstring from web.config.
I got this error: "Format of the initialization string does not conform to specification starting at index 0."
The tutorial suggests to use: Database.OpenConnectionString("SmallBakeryConnectionString") method
Instead you should use Database.Open("ConnectionStringName").
Ref: http://cytanium.com/forums/yaf_postsm18_Connection-string-problem.aspx
The API Document is missing Database.Open method and also Database.OpenConnectionString info needs to be modified.
I started the Bakery site demo...everything runs fine on my local machine.When I publish the site to production server in w2k8r2+iis7.5 and with .net 4.0 (integrate) pool, my bakery apps not able to connect to the .sdf file.
Error I got is :
Connection string "bakery" was not found. 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. Exception Details: System.InvalidOperationException: Connection string "bakery" was not found.
Source Error:
Line 2: Layout = "_SiteLayout.cshtml";
Line 3:
Line 4: FacebookSocialPlugins.Initialize("[xxx]", "[xxx]","bakery");
Line 5:
Line 6: }
Stack Trace:
[InvalidOperationException: Connection string "bakery" was not found.]
WebMatrix.Data.Database.OpenNamedConnection(String name, IConfigurationManager configurationManager) +132
WebMatrix.Data.Database.Open(String name) +42
System.Web.WebPages.DatabaseConnectionInfo.Connect() +43
System.Web.WebPages.SimpleMembershipProvider.CreateTablesIfNeeded() +42
System.Web.WebPages.WebSecurity.InitializeMembershipProvider(SimpleMembershipProvider sMembership, DatabaseConnectionInfo connect, String userTableName, String userIdColumn, String userNameColumn, Boolean createTables) +70
System.Web.WebPages.WebSecurity.InitializeProviders(DatabaseConnectionInfo connect, String userTableName, String userIdColumn, String userNameColumn, Boolean autoCreateTables) +51
System.Web.WebPages.WebSecurity.InitializeDatabaseConnection(String connectionStringName, String userTableName, String userIdColumn, String userNameColumn, Boolean autoCreateTables) +52
FacebookSocialPlugins.InitializeMembershipProviderIfNeeded() +54
FacebookSocialPlugins.Initialize(String appId, String appSecret, String membershipDbName) +171
ASP._PageStart_cshtml.Execute() in d:xxxakery\_PageStart.cshtml:4
System.Web.WebPages.StartPage.ExecutePageHierarchy() +15
System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext, TextWriter writer, WebPageRenderingBase startPage) +33
System.Web.WebPages.WebPageHttpHandler.ProcessRequestInternal(HttpContext context) +207
I know we can use the HTML helpers, but how about the strongly typed one's?
Html.LabelFor()
I struggle with publishing 2 databases from WebMatrix using WebDeploy. On Publish settings screen I specify 2 different connection strings, but on Publish Compatibility screen Database names in both destination connection strings are equal. When I return to settings screen, original value is replaced there as well.
How destination server connection strings are evaluated? Here are connection strings from the root web.config file, which are set by hidden parameters in my parameters.xml:
<connectionStrings>
<add connectionString="Server=(local);Database=xxx;Uid=xxx;Pwd=xxx" name="xxx" providerName="System.Data.SqlClient" />
<add connectionString="Server=(local);Database=xxx2;Uid=xxx;Pwd=xxx" name="xxx" providerName="System.Data.SqlClient" />
</connectionStrings>
If I create two websites using the starter site template logging into one shows me logged into the other.
Here are the steps:
Create starter website called website1 Create starter website called website2 Run both websites in the same browser, firefox Register an account in website1 Log out of website1 Log back into website1 Refresh website2 and it shows my login name from website1 Has anyone else encountered this?
I downloaded WebMatrix thinking I could create a local Intranet page and simply host it from my server. Can I do this with WebMatrix? If so how?
View 1 RepliesI'm often experiencing that keyboard shortcuts stops working in WebMatrix. This is very annoying as CTRL-S, CTRL-C, CTRL-V, etc. stops working, all of which are heavily used when programming. It's obviously hard to explain how to reproduce this, but I waswondering if someone knows a quick-fix?
View 12 RepliesI have searched endlessly for an answer but found nothing useful! I'm writing a simple blog application using Web Matrix and its going pretty well, but I have run in to a problem. I am storing the content of each blog post in a ntext field in a table with the intention of entering HTML in to the database and then have my application pull it out and insert it in to a few different view pages. The problem is that all of the '<' and '>' characters are getting converted in to '<' and '>' when my application pulls the HTML from the database and displays it. I understand that this is for security (preventing code injection?), but only trusted users will ever be able to write posts using my application. Here is a screen shot of what gets displayed by my application:
Is there a way to disable this behaviour or work around it somehow?
I try to create a wordpress site from the gallery and I get an error that says that it cannot find database. I dont have mySQL installed. I thought that WebMatrix would download and install it. Does WebMatrix Beta 3 expect MySQL to be installed? And if so, which version?
View 1 Repliesso I've set up the table as described.. (seems to be some directions missing with regards to, is identity? and is Primary Key? and what those values are and should be set to for name, description, and price durring table setup) So, ive tried to set the table up as directed and then go on to click DATA which allows me to fill in the table. I can fill in the table all the way accross but when i reach the end of the first row it says:
INVALID DATA your change could not be committed to the database. after you click OK you can fix the invalid entry or press to cancel your changes.
There I was, happily coding webpages, when suddenly it wouldn't run them anymore. Now when I click run I get an error message that looks like this: Server Error in '/' Application.This type of page is not served. Description:The type of page you have requested is not served because it has been explicitly forbidden. The extension '.cshtml' may be incorrect. Please review the URL below and make sure that it is spelled correctly.
Requested URL: /quiz/intro.cshtml
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1
My hosting company states they support .net and razor. However after uploading my website made with webmatrix and razor *.cshtml pages. When i visit my website all i get is 404.17 error messages. As an testcase i decided to add an standard .aspx page. Visiting that page gives the same 404.17 error message :-(
.
According to my webhoster my web.config is wrong. However that one is generated by webmatrix. Besides my *.cshtml *.aspx a lot of files and directories are added to the bin folder. What can i check and what should my hosting provider check. When using the check compatibility the asp.net version is shown as unknown? My hosting provider claims my site is running asp.net 4.0 in integrated mode and that should be enough.
It's unfortunate that Microsoft WebMatrix (beta) doesn't recognize that files has been modified. I suggest you implement a feature similar to Visual Studio, allowing the user to decide what to do if the file has been modified outside WebMatrix. Especially when you have a button to launch the project in Visual Studio, it should have better support for "dual-development", cause at it is now, code can be overwritten by mistake easily.
View 3 RepliesI got the first beta of WebMatrix, downloaded Drupal, and got a site more or less going. I then tried to move it to two different hosts - first the IIS server running on my own domain controller, then to my hosting service. I dumped the DB with mysqldump, and imported it to the databases running on each server. Then I ftp'd the code and configuration files to both servers, and made appropriate configuration changes (primarily the mysql connect string).On both servers I have the same problem: The site comes up in its home page and looks great, but as soon as I log in as the site admin, I get a 404 (not found) error. Since it looks like virtually everything in Drupal is driven from the database, I really haven't the faintest idea where to start debugging this.
View 3 RepliesI have created "DotNetNuke SQL Database Application" from the WebMatrix Gallery. Now I want to deploy it on the remote server using Web Deploy method. Without selecting SQL database, application is deployed successfully but when I select SQL database it gives following error: Publish : Error - Make sure the database connection string for the server is correct and that you have appropriate permission to access the database. (Web Deploy provider is dbFullSql).
View 2 RepliesThat subject may not do this questions justice.
I am trying to limit what I write on all my .cshtml pages. For example, on everypage I am @using myDLL and "connecting" to sql server.
I write that out like
@using System.myDLL;
@{
myDLL dll = new myDLL();
dll.ConnectionString = "blablabla";
}
How can I remove the need to do that to every single page? I think I can create a web.config and do some funky stuff... can someone show examples?