How can you query an SQL server data base using a variable passed via an HTML stringHere's my code that connects to the database, and the select statement.
Function GetPins2(ByVal MyTable As String) As Data.DataSe
Dim sqlConn As New SqlConnection( _
"Server=mysever;Database=mydatabase;Uid=myid;Pwd=mypassword;")
[code].....
In my project frontend was vb.net and backend was sqlserver..
How to make an exe file ?
Client/Server Application in vb.net 2010 i have created but it was just basic one. I need to show send data from client to sever and sever to client and and more functionality. (like showing price ot item or anything
View 2 Repliesconnetvity vb.net with sql sever 2005
View 4 RepliesI created a program to upload any file on my ftp server. Is there any way i can modify this code to create a new directory (for example a directory named "images") and then upload the file to that directory?
Public Class ftpuploader1
Private Sub UploadButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles UploadButton.Click
[Code]....
Basicaly i want to know how i could create a new directory on the ftp server from this program itself and den upload the file to the directory that i created
My company got a new server, with a new sever share name, etc. I also moved my project from 'My Documents' to the C: Drive. I went through all my code and replaced the old path info to the new path. Tried to publish and received errors stating my temporary key was no longer valid. I googled that error and tried a solution. I created a test certificate and the app published as expected.
View 2 RepliesI have a simple TCP Client/Server application that ties two pcs on a lan together. This has worked great for many job sites but the most recent has an IT manager that will not allow me to set a static ip address on the server pc.Basically, I was wondering if there was a nifty way to have the client find the server.
View 25 RepliesI am looking to access a folder on my web server to retreive a picture and to replace a picture in that folder. I am using VB.Net 2005.
View 3 RepliesHow to "download a file from sever to client".
View 3 Repliesi need a screen short for vb.net sql sever connection
View 1 RepliesI have developed a vb.net application using sql server 2005 express database. How can i install this application on any web sever and use it from a browser?
N.B.: I have never worked on a website or web application before.
code to upload the my.settings document for my windows forms application on my sever.
View 2 Repliesi have to upload resume on submit button click..how to add that file in database..and retrivw when selected by recuriters..
View 4 RepliesI am coding this app on my home pc, but when complete it will be run on individual pc(s) (each pc has it oun HD) on a local network. I have a world of questions but right now how do I set the path to my database? is there a way to set a default if its not found.Database(s) that the app use's are stored in a folder on the server. i.e.: P:MyServerNameDeptFolderData for example.OLEDB or TableAdapters which would be the better choice.I understand that MS Access DB is rather resticting.
View 3 Replies[URL]. i'm in need in a little assistance here i have a textbox that can upload test.csv(file example) into the text box.and then i have another button call "submit" to insert test.csv into the table in sqlserver. when i click submit i want to insert test.csv in sqlserver table name SMS_contact (which contains names, contacts) Im stuck at the submit button where i dont know how to insert test.csv into the database I have no idea how I should do this because I just started learning Vb.net yesterday.
View 1 RepliesProgrammatically reading Emails from Exchange Sever 2003
View 4 RepliesAfter compiling the project it works fine on windows 7 32bit and 64 bit but will not work on server 2003 or xp clients have not checked vista yet, i have verified that .net 4 is installed and i can tell you that i do not get an error message when installing apart from the icon that i have given the project does not appear and is a blank icon on the desktop. When i try to run the program it will try to start i see the service in the task manager and after a while it will error out and crash. I can see the memory usage go from 20,000K to 70.000k.
View 7 RepliesWhen i do the query
Dim SQL As String = "SELECT FirstName, Surname FROM List
it loads what i want in a combobox
However whenever i go
[code].....
I am using in built sql server 2005 which comes with visual studio 2008 in my project.This is my connection string.SQLConnection oConnection = new SQLConnection("Data Source=.SQLExpress Initial Catalog=Fas");
When I try to open the connection like oConnection.open() I am getting error like "Login failed for this user. User is not associated with trusted connection."By some googling I get the idea that I am using Windows authentication mode. So how can I change it to mix mode authentication? I dont have separate sqlserver installed on my system. It is same that comes with visual studio 2008
Question: How to pass the current user on the web page from the IIS server to the Reporting Services Server.I have seen this topic throughout the forums. However, the answers are always hard code the user in web.config - use a login window and pass those fields to the IReportServercredentials or create one user for everyone.
When the person who asks the question comes back and says that doesn't work there is not answer.Does anyone know how to do this? I have VS 2008 ( and 2010 ) I am sending the info to SSRS 2005 server.As anyone using SSRS knows that if the reports have parameters and udf behind the report to inspect who the user is, then you have to pass that user to the report.
[Code]...
I have been programming steady with vb.net for a year now and was all happy about using the List view and email etc from web sites. I even used a reportviewer to pdf to email attach, cool. Now I feel quite lost and realize I have not been using properties, etc. That is my background.
This is my first client server application using vs2008(vb) + sqlserver 2008. how can i hide my database schema,tables from application users through management studio..?
View 5 Repliesim decide to develop Vb .net Application With Sql server Express 2008 ,but microsoft says they limit 4 GB Sze for per DB! So im developing my app for Single user Desktop pc , so what i do when the DB reached to the Maximum size? when the db size reached to maximum size , is it Good thing to create new DB and allow my vb.net application to work with both DB s ?
View 4 RepliesI am having a bit of a problem with a query and I have google around and I still haven't find out a solution.I have an update query, but when it is executed I get a Syntax error in UPDATE statement.
[Code]...
I have a problem with not getting my head around this at all.The problem is i need to:Add a customer to list view (I can do)Add multiple products to that specific customer on a daily basis from another database (which i cant do)Then somehow use listview to generate a list of these customers only showing outstanding amount from previous weeks and current weekly amount. then be able to "Roll forward" a week populating listview again with customers and outstanding amounts.I need to have the ability to input payments from the customers as well
View 7 RepliesI'm working in a database on vb.net with sqlite wich hosts a gallery and I want expand the search proprieties.[code]...
I want to filter the results also for image ext (table = images.ext) or one or more parameter...for example:
If the user search "cars ext:jpg width>500" the the database returns all images wich has the tag "cars", has the extension jpg and are bigger than 500 px width
i'm trying to make a query to a sql database, so when the user enters the id, the columns related to that id will be displayed. but, im getting an error: "Object reference not set to an instance of an object"
the code:
Code:
Try
TextBox1.Text = InputBox("Enter the Id.", "fsdf.")
query = "select * from Students where Id = '" & TextBox1.Text & "'"
[Code]......
How do I make a parameterized query in the database with VB.NET? remember to mark the replies Welcome to the All-In-One Code Framework! If you have any feedback,
View 1 RepliesI have a report that I want to filter using a From Date Text Box (which is a string) and a To Date Text Box (which is a string) so the user will insert a start date and and end date to filter the report, how would I do that? This is what I have:
Try
Me.FuelTableAdapter.FillByDate(Me.ShuttleRunsDataSet.Fuel, FromTextBox.Text &
ToTextBox.Text)
[code]....
i have a project which is room scheduling. i'm having a problem on how to make my query to be able to select the available rooms for the givin time start and time end.
View 14 RepliesHow to make query from mutiple datagrid so that the data from datagrid will create chart?
View 10 Replies