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:
@{
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'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.
I was playing with some files the other day and one of them was a word document. That then got me thinking whether it was possible to open thos files in my browser. Saves Opening/Saving everytime i click on a document.
There are bunch of files stored in a DataBase as varbinary/image data. I am writing a program to extract these file data and send them to the browser so file can be opened or saved. My method is,
[code]....
BUT this method creates a file in the Server and then transmit to the browser. Means 100s of files will be created in the server when I open 100s of files with this process, naturally I want to avoid that.
Is it possible to do this without creating a copy of the file in the server ?
I usually use WebMatrix to manage my database (sdf file). I wonder if it can be possible to manage this database with SQL Management Studio 2008? When I try to open it with SQL Management Studio 2008 I get the error:
Incompatible database version. What's wrong?
BUT When I create a new sdf database with SQL Management Studio 2008, I have no problem for open it again with SQL Management Studio 2008 but if I try to open it with WebMatrix it doesn't work...(server not found?)
When i try to open a csv file from my asp.net 3.5 app by clicking on the link provided, a file download dialog box appears.When i click on the open button from there , i get this eror
C:Documents and settingsUserNameLocal SettingsTemporary Internet FilesContent.IE5X9TXTM06myfilename.csv could not be found .Check the spelling of the file name and verify that the file locationis correct?
Wjy am i getting this error? I am trying to open a file and it complains about file not found in the Temporary Internet Folder.I tried deleting the temp intrnet files.Dint work.I have IE 7 on xp professional sp3. Also i am streaming the file from the application. This happens only to some files and the rest of the files , i can open .
Here is what I need to to. I have a gridview which I have a column that has a link to a pdf file on our file server. When I click the link I need to go into a database and update a column that they clicked the link then I need to open the file. by usinga HyperLinkField I am able to put in the link that I want to go to and when the page is running I can click on the link and it goes to the page and everything works fine except for being able to update the database part.
[Code]....
I tried using a ButtonField where in the code behind in the GridView1_RowCommand I pull out the file path and put it into a response write statement the problem I'm having with it is that when it opens the file it removes all the ""s so I get the error file cannot be found.
I am trying to open a file share link from the window.open ... but its adding the http://localhost/vdir/ before the path can any one say what is the problem?
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 ?
When the user clicks on "OPEN" button, It should open up that(.txt) file which is on the file server in ReadWrite Mode (like in notepad) without any Access Issues.
Or simply has to be openend as temporary READONLY .Txt File. So that the user can close after viewing it.
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...
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");
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:
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'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?
I 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?
About: I want to define format string of the webgridcolumn by myself.Example:There is a ID column in a webgrid ,i want the cell of this column filled the data like "<a href="/Default/@ID">@ID</a>"
Microsoft.WebPages.Helpers.WebGrid mygrid = new Microsoft.WebPages.Helpers.WebGrid(tarobjs,canPage:Convert.ToBoolean(data.Groups["enablepager"].Value), rowsPerPage: Convert.ToInt32(data.Groups["pagesize"].Value));