.Net Silverlight Project And MySQL?
Mar 20, 2012
I have found the MySQL .NET Connector - am I correct that this is not compatible with Silverlight and I do not need it?I understand I must use a Web Service for this. Can I use WCF or WCF RIA, or am I best using a more traditional web service method like REST or SOAP?
What's the best web service method for many quick queries (such as updating a search as the user types in the keywords)Do I have to use technology like LINQ, Entity SQL, ADO.NET Framework, or a stored procedure? Is one of these the best way to do it or should I just skip them all and create a simple web service?What's the best source to learn how to do specifically Silverlight VB.NET and MySQL and learn to do it the best way as explained above. Everything I've found (books and websites) seems to be in C#, not a Silverlight product, or just uses built in SQL Server support. For our web app, we need to be able to give the buyer not just access to our client side application via a browser but also the server side so they can OPTIONALLY host the entire product themselves. We're hoping to have one installer for them on their server (so they wouldn't have to set up php or mysql to host the product for example). If I use a VB.NET website and web service, will that deploy as just an exe or dll so the user won't have to install anything special?
View 1 Replies
ADVERTISEMENT
Feb 28, 2010
I have a central page loading child controls into a container in a Silverlight Project.Problem is events like button click events are fired twice after processing the child forms.Suspect it might have something to do with a double initializecomponent??
Private Sub btVolgende_Click(ByVal sender As Object, ByVal e As System.Windows.RoutedEventArgs) Handles btVolgende.Click
Select Case Stadium
[code].....
View 2 Replies
Aug 11, 2011
Silverlight project with tabcontrol hosting canvas objects. I want to wrap my entire tabcontrol with a scrollviewer so that on a short display you can scroll vertically to see the whole area on my canvas.When I run my project my scrollviewer vertical bar is always showing even when there's more room vertically than needed for a scrollbar.
All I am trying to accomplish here is a min resolution of 1280x768 to be scrollable and anything bigger than that have the scrollbars hide. My laptop is only 768 tall, but my canvases were developed with 1280x1024 in mind. So I would like a way to set this up so that everyone can scroll or just see the canvas all at once depending on their resolution.
Anyone have any ideas why it is always visible? I've tried setting canvas width and height. I tried setting stretch on alignments on the outer grid. Saw both those tips while searching other issues similar to mine.
Some code:
<Grid x:Name="LayoutRoot" MinHeight="768" MaxHeight="1024" MinWidth="1024" MaxWidth="1280" Background="#FF6A6868" HorizontalAlignment="Stretch" VerticalAlignment="Stretch">
<Grid.ColumnDefinitions>
<ColumnDefinition Width="0.775*"/>
[code]....
....lots of child canvas items in my "Main Floor" canvas. Child canvas objects contain lots of path objects. None which are taller or wider than the main floor canvas width/height.
<sdk:TabItem Margin="0" Header="Mezzanine">
<Canvas x:Name="Upstairs" HorizontalAlignment="Left" Height="1000" UseLayoutRounding="False" VerticalAlignment="Top" Width="1280">
..another tab. Same deal with child canvas objects.
View 1 Replies
Apr 17, 2010
I have created a banner for a sl3 app . What I need now is a timer(timespan?) event to trigger the banner to load new info every 5 seconds. I can't find info on timespan on how to trigger this event.
View 10 Replies
Mar 19, 2009
I have a LOB app written in VB.NET with a WinForms front-end and SQL back-end. After many months weighing up how to get onto the Web, I decided last month to use Silverlight 2. Now, Silverlight 3 Beta is out, but there is no end-user runtime.
Does anyone know when the runtime will be available for deployment of SL 3 apps onto client sites?
My dev timeline is about 3 months: should I persist with SL 2 and then u/g to SL3, or jump straight in to SL3?
View 5 Replies
Feb 17, 2010
I developed a project in VB.NET..In this project I want to use data from MySQL that is resides in my WEB Server.I can communicate with the MySQL server of my localhost but can not communicate with the WEB Server.In my CPanel I added Host from the Remote Database Access..But I can't communicate with WEB MySQL Server.
View 2 Replies
May 28, 2010
I have some questions about mysql database; I have set up columns and rows on mysql database and I would like to make mysql connection for a test before I would release the project in the near future, but my doubts is that how would I be able to keep mysql admin username and password details secure in the project without anyone could find out??Secondly, I don't want anyone to crack my project to get the details, which it will put me and other clients at risks.
View 22 Replies
Apr 11, 2011
I have determined thanks to the last q & a that there is something wrong with my "save to db" code as well as my "retrieve to picture" code. Even If I manually save the pic in the db it stil wont retreive. This is code i patched together from 3 or 4 examples around the net.
Dim filename As String = txtName.Text + ".jpg"
Dim FileSize As UInt32
Dim ImageStream As System.IO.MemoryStream[code]......
View 2 Replies
Sep 22, 2009
MySQL databases exists for saving values as strings (text only). Is there any way that i could store files with the same speed as a mysql command ? I know that it depends on the file size but lets say that the file is "Avatar.jpg" 50KB... I ve tried FTP but this is not what im looking for. e.g. You want your users been able to upload a file like the [Add This Attachment] button does in dreamincode.net and you dont have any background on PHP/HTML/Javascript/ASP.NET just VB.NET and the basics of MySQL plus you dont want to use it for a website. How do you accomplish this? Something silly that ive tried was opening an image as text then update the mysql server with that text but it didnt work backwards after i wrote the text on the file and oppened it ...it said that the image was corrupted.
View 7 Replies
Jun 21, 2012
What i have going on, is i have a MySQL connector as a resource on my application, and im basically trying to connect to my MySQL server, to either a) register a new account, or b) check that the account exists and they are premium, and login, Now what i have run into problems with is: My MySQL Database Name has a _ in it which VB is not allowing for some strange reason.
The code i am using is below
Imports MySql.Data.MySqlClient
Public Class Form1
Function UpdateRecord(ByVal query As String) As Integer
[CODE]...
How i can allow the _ into the application, because the only databases that don't have a _ in the user or dbname are a) Paid ones which i DO NOT have the money for or self hosted ones, i cannot leave my computer on 24/7
View 3 Replies
May 3, 2010
I am trying to make a login system mysql try to connect to a mysql database.
Here is my code:
Imports MySql.Data.MySqlClient
Public Class LoginForm1
Dim MySqlConnection As MySqlConnection
Private Sub OK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK.Click
MySqlConnection = New MySqlConnection()
[code]....
View 6 Replies
Dec 20, 2010
Public Class ExtendedDateTimePicker Inherits DateTimePicker
View 5 Replies
Aug 27, 2011
i Built A MySQL Login System Using MySQL Connector But If Other People Want To Use The Program Thay Get An Error, I Think This Is Due To Thay Do Not Have The Connector So What Should I Do, Btw Dont Say 'Tell Them To Connector'!
View 5 Replies
May 5, 2010
For reasons that are beyond my control, I have three Projects. Projects A and B reference project C. Project A references project B so that it can open a large form in project B. I now need to open that large form from project C, but VB won't allow me to add a reference from C to B because that would create a circular dependency. I found a way around it, though. I created a Timer in A, and when I opened C from A, I passed in that timer. When the user performs a certain action, I enable the Timer from A, and this causes C to open B for me.
View 2 Replies
May 6, 2009
I have a project that I have created, it something like a contact database.It is complete with its own sql server database, and controls and forms.I kinda of understand that I can include this project into another project.This is the tricky part,Can I include my contact project into another project and add more items to the database and forms in a new project?What I'm after is like using classes.My contact database would be like the base class, and the new project would be adding more features to that project.
View 10 Replies
Nov 16, 2009
Im building an app to manage PSP contents, and it should connect to my MySQL server on my domain to refresh game info and ratings and so on, but I cant make it connect with MySQL Connector 6.1.
[Code]...
View 2 Replies
Jan 30, 2011
I can have mysql database. but i have not mysql. how to connect this database vb.net 2005. but i have mysql-connector-net . I want to mysql-connector-net use to connect this database. database path(C:Documents and SettingsAdminMy DocumentsVB.NETStock delnaSTC.sql)
View 3 Replies
Mar 21, 2011
I have a query from within my vb.net code which searchs for a record by date. The date being entered via the code is in format dd/mm/yyyy, i need to search in the database using yyyy/mm/dd? Ideally i thought there may just be a function within MySQL which will convert this. If not in vb.net to convert the string 01/01/2011 to 2011/01/01?
View 1 Replies
Feb 26, 2012
What i am trying to do is get my system to look into the database and recognize if the user is a admin or a user, based on that they have certain rights below is my code
Imports MySql.Data.MySqlClient
Imports System.Data.SqlClient
Public Class Form3
[code]....
View 5 Replies
Nov 15, 2010
i was developing Voice Chat Application in visual Basic .NET 2008 i try a lot methods to make installer for it :
1- i add Project Setup Project for my Project for Visual Studio 2008 Deploy & setup Type Projects and make it with output option and detect dependices
2- i try make it with Setup Factory 8.2.1
3- i try with MSI Factory 2.0
4 i try with Setup Factory 6.0
and after making installer copying it to my test virtual Machine or my friend lap and install it i get this error when try to run my application :
[Code]...
View 3 Replies
Jul 13, 2011
I am trying to implement multibinding in Silverlight using VB.Net. I have found a very good reference for an implementation in C# here. I spent some time trying to use various converters to migrate it into VB.Net but I still didn't get it working properly. So..
I'm looking for some references that exemplify how MultiBinding can be done in VB.Net. Also an example using Silverlight 5 beta would be fine (I read in a post right here on Stack Overflow that it supports multibinding).
View 1 Replies
Apr 4, 2009
is it possible to write xml in silverlight with vb
View 5 Replies
Jul 1, 2010
if this has been asked before (I couldn't find the answer anywhere), but I have a WCF Service Application that I have created, and am trying to access via my Silverlight 4 app. I have added the service reference to the SilverLight App and am just trying to call one of the default pre existing methods on the service (GetData). When calling the method i get an error of:
[Code]...
View 3 Replies
Feb 12, 2011
How can i use SilverLight Video Player on Visual basic 2010
View 1 Replies
Feb 8, 2010
I am designing a web application in Visual Studio 2010 Beta 2, using Silverlight 3, with Visual Basic as the underlying programming language. What is the Visual Basic code that I would put in a Button1_Click event to tell the program to navigate to another UserControl XAML file?
View 4 Replies
Mar 21, 2012
I'm testing and trying to understand how to create a DLL and call a function from it in my Silverlight project. I'm getting an exception: Unable to find an entry point named 'WriteTextFile' in DLL 'C: empTestDLL.dll'.[code]...
View 1 Replies
Jun 4, 2010
I'm connecting to my mysql server using ODBC in vb.net, the database is shared throughout the company because it is used in an accounting program (simply accounting), each user has their own account user/pass to login to the database. I have developped a program that uses the accounting database and combines it with other information, my problem is that at least once a day I get this error when I run my program: "(10061) ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on"and the error persists for at least 4 hours, for some reason it starts to work again later on in the day.
View 1 Replies
Sep 20, 2011
error " Unable to cast object of type 'MySql.Data.MySqlClient.MySqlException' to type 'MySql.Data.MySqlClient.MySqlDataReader'. " ?
THIS IS THE CODE Ssql = "SELECT ItemID, Prodname, qty, Desc, Cost * FROM items ORDER BY ItemID ASC"
[Code]...
View 4 Replies
May 6, 2011
I call upon your combined intellects. I have a web application with a silverlight app that calls a ria service. The ria service is defined inside the web application and everything else is just dandy.
The issue is this.It is my understanding that in order for the silverlight application to talk and know what the ria service is, you need to add a service reference for that service. The service reference defines the ria service and sets up the connection binding. One of the files it adds is the ServiceReference.ClientConfig which has the connection binding in it. During the course of this application's development, this is the way it was set up. And it worked perfectly fine locally and on the dev server.
Unfortunately there were issues when deploying to the clients in-house server. At this point I was onto other projects while my co-worker continued with the deployment. He soon became frustrated with the goofy errors that were occurring and recruited some help. This dev came in and, albeit got it working, but in order to do so he removed the service reference from the silverlight project but left the ServiceReference.ClientConfig which pointed to the location of the service in the web application(but that's it, no definition or explanation as to what the service does and I'm not sure how the silverlight app is supposed to know how to work with it..). This works perfect on my co-workers workstation and he has deployed this version to the clients server fine.
When I open the project it doesn't run at all. And the reason why is that it doesn't know what the service is that i'm using in code. Specifically, it doesn't know where this is (names changed for clarification):
Imports SilverlightApp.ServiceReference.WebApp.Service
I have cleaned the solution, completely deleted and got the latest from source control, built the web app first and made sure the asp.net dev server was running so that the address in the ServiceReference.ClientConfig resolved correctly. But, alas, it still doesn't know what Imports SilverlightApp.ServiceReference.WebApp.Service is.
So, to get it working on my workstation, I added the ServiceReference back but kept the current connection bindings so that it matched the endpoint in the web app web config. and changed the import statement to Imports SilverlightApp.ServiceReference and everything works fine.
View 1 Replies
Jan 27, 2011
I currently have a silverlight application which has silverlight class library. The silverlight class library has a WCF service reference which works as expected for small data. However we have come across a problem which is caused by the default value of maxItemsInObjectGraph. We have tested it with an increased value (called from vb app set in behaviour) and it works however we are unsure how to set the value of maxItemsInObjectGraph when it is in a silverlight class library (as it is only defined in the clientconfig file and no services are added to the client). I have seen posts about adding it to the web.config but this only seems to apply when the service is called directly by the app not by a class library?
View 1 Replies