i am using vb 2010 and sql server 2008 r2 how to Create sql query with monthname and Year? Like "May 2012"
i have a form with Two ComboBoxes
ComboBox1 = 2012
ComboBox2 = "May"
How To Make Query from Invoice Table
have field in Invoice Table "InvoiceDate"
I am working in a project where i have to add employees in a company. I have a form with text fields(for example name,surname,age,...). What i want is to insert this txt values into a database. My project is connected with an sql database. How can i add the values into a data table on button click("submit")?
View 9 Repliesanyone knows the query of selecting from monthname and year(September 2011) from mysql database DATE format(yyyy-MM-dd)
View 1 Repliesrow in datagridview not come all when query from database (sql server 2008)?
View 4 RepliesWith a Windows form that I would like to be a DDE server. I know that DDE is not natively supported in VS 2010/11 so I'm using the NDde.dll to add DDE functionality to this program.
Objective: Create a windows form to act as a Pop-up notification that has a textbox field. This textbox field must be selectable in order for users to copy a text string to the clipboard and paste into another program that does not support DDE.
Overview: A phone system has an on-screen agent program that triggers a pop-up form, the DDE Server, when an incomming call is presented. When the agent accepts the call the agent program, acting as a DDE Client, registers a DDE session, Application=phnserver and Topic=callerid. Then communicates an "OnExecute" command to the DDE Server followed by a number string. This string should be presented on the pop-up form in a text box. Once the call is completed the agent application will issue a command to close the pop-up form.
Below is my current code.
CODE:
I have a working game server browser project in VB.NET 2008 and I'm trying to fix the CS 1.6 and CS-Source query protocols. Where can I go to learn how to query a game server? The code worked in 2004 and now I want to update it [Code]
View 2 RepliesINSERT INTO [ET_SolutionText]
([SolnTextKey]
,[SolnTextValue]
,[SolnTextTitle])
[code]....
In Above Query, SolnTextValue is XML field. How i can format XML data in Values using insert query in SQL server 2008?
create an EDI 837 /X12 file from a SQL query. I will be creating a temp table then inserting data to the file.The X12 file has essentially 3 parts: The Header, The Detail, and The Footer
The Header looks like this
ISA*00* *00* *ZZ*HIS199 *ZZ*300002373 *060920*2314*U*00401*000000089*0*P*:~
GS*HC*HIS199*300002373*20060920*2314*43*X*004010X098A1~
ST*837*000000001~
BHT*0019*00*90*20060920*2314*CH~
[code]....
What method choices do I have to choose from to assemble this to a file?
i wan't to create a tcp client and server
Client contains 1 textbox
Server contains
dim pcdetails as string
pcdetails = "Operating System Name : " + My.Computer.Info.OSFullName.ToString + " ; " + "Platform : " + My.Computer.Info.OSPlatform + vbNewLine + "Operating System : " + Environment.OSVersion.ToString + " v." + Environment.OSVersion.Version.ToString + vbNewLine + "Computer Name : " + Environment.MachineName.ToString + vbNewLine + "User Name : " + Environment.UserName.ToString + vbNewLine + "System
[code]....
I'm doing a project in VB.NET, in which the application will interact with SQL Server 2008 database. I know how to develop that application. But after created executable version of that application(.exe) i will install it in another machine. How will that application interact with database at that machine??
View 6 RepliesI'm using ReportExecutionService to create file on a different server on the network. The application does the required job if I run it locally, but fails to create file when I publish it. The error I get is- Access to the path '\servernameapth..xyz' is denied. The folder has full access to Domain users. Here is my code to create a report file on a different server via an ASP.net app.
[Code]...
I've just downloaded SQL server express and have created a database in there. Now back in my VB.NET application from Visual Studio how do i find/connect to it?
View 16 RepliesHowever I have hit a massive brick wall with my program. My program that I'm trying (can't emphasis this word the importance of that word) to create a Client/Server chatroom using TCPClient in Visual Basic. So far I can get my client to speak to my server. However, i'm trying to get the returned data to display in a listbox which never happened, i then tried a label, which again never happened then a text box which I'm sure you can figure out how that went! I'm not great at networking programmers nor am I not bad I'm terrible but duty calls when it comes to projects.
The code I currently have was mostly taken from the net but when I have the program fully work and I understand how the software works I intend to heavily modify for it to suit the needs of what I need to achieve. where I can get my client to display the data from the server that I have already sent to the server (which displays successfully within the server).
[Code].....
I'm looking for a control that allows images to be placed onto it and moved about. Moreover, I need to draw lines between the images. It will sort of be like the query designer in SQL Man Studio. It will be used as a virtual desktop where a variety of objects (and their icon representations) can be freely placed and moved. I'm having a blank and cant remember where I saw this before.
View 2 RepliesI am going to create a gaming platform primarily with flash,flex and was also looking to create a windows client that could communicate with my server using these protocols. Could someone point me in the right direction on any possible .net libraries available that could handle the communications between client and server?
View 2 RepliesAm having a hard time co be connected to sql server 2008 enterprise edition.i am using oledb in this fashion
db.connectionstring="Provider=SQLOLEDB.1;User id=helen;password=123;Initial Catalog=mydb; Data Source=server"
but it gives this error: Login failed for user 'Helen'/ Is SQLclient a must to be connected to sql server?
I'm new to this forum and have only been working with VB for the past 6 months.I am working on an ADO project, creating a home based movie directory that tracks movies, family and views(movies)I am having a problem with my "Update" from VB2010 to SQL.I am using a date time picker to view the SQL data in the dataset. In that I am not having any issues (txtYear.DataBindings.Add("Text", ds, "Movie.MovieYear")however whenever I try to update and "Send the data" back to SQL Server.[code]I keep getting an error System.Data.sqlClient.SqlException "Invalid column name 'March'.I do realize that this is a formatting issue, i'm just not sure how to format it to the proper date.
View 8 RepliesI am trying connect to a SQL Server database i have created using Visual Basic.Both reside on my local machine (PAUL-PC).Here is what i have done so far but i am missing something (or more worryingly i have got it completely wrong).[code]So i have an MDI form and i want to make a connection to SQL Server when that form loads.I do not want to use a DSN if possible so am trying to use Oledb. Not sure also of the DataAdaptor declaration as in previous versions i used many years ago it was recordset.I would like to use a trusted connection to connect.
View 5 RepliesI just got into VB 2010 with SQL 2008 Server Report. I was able to create a report as my wish and it's vieable via direct url (URL). But I want to pass login Information and Selection parameters to the report. But I don't want to pass them thru URL, So I want to load them from the application (winform) and launch the report in iexplorer.
View 1 RepliesI'm looking to use the DHCP Server Management API to query scopes and reservations on a DHCP server.
View 8 RepliesI am trying to connect to SQL SERVER 2008 from vb.net but failed with Error 40. If I try to connecton to serversqlexpress, error 26 is raised.
View 1 RepliesI am facing now a very frustrated simple project, I successfully imported .csv to datagridview using VB .NET 2010 but I have no idea how to import it to SQL SERVER 2008 specific data table.
View 7 RepliesI am trying to create a simple chat server over vb that can relay messages back and forth using an echo server. Could someone point me in the correct direction to begin?
View 3 RepliesI migrated some applications from Visual Studio 2005 to Visual Studio 2010. I develope using VB.NET in VISUAL STUDIO 2010 on a Windows 7 PC (32 bit). The applications writed in VB.NET - VS2005 run correctly in PC having XP, VISTA, WINDOWS 7 and Windows Server 2008. After the migration, the exe of these applications work correctly in PC having XP, Vista, Windows 7 but work stop immediatly on Windows Server 2008. The error returned is 'System.InvalidOperationException'. Seems that the application stop when attempt to evaluate the first global variable that meets. If i change the framework from 2.0 to 3.5, things don't change.
[Code]...
I have linked VB to my sql server and all my tables and data load correctly in VB.I drag and dropped my table in "detail" view and then debugged the program, little did I know, when I tried to add a new instance of data into my table I literally have to enter the primary key. I am trying to figure out how to set the "STU_ID" (PrimaryKey) to auto-increment off of the last row of data on my table.
View 3 RepliesFirst off, my apologies for being a complete Newb! I have a SQL Express database that I use quite successfully to track my investments in several accounts. I built it myself, it's quite functional, and Im happy with it. The problem is that there are multiple account tables and updating them can be tedious in SQL Server, if multiple purchases and sales in multiple accounts have occurred in a month. Tedium can lead to errors¦
[Code]...
I'm trying to store and retrieve PDF files using SQL server 2008 and Visual Basic 2010.The Issue:i need to lookup a PDF file and store it to the DB using filestream and display it in Adobe Acrobat COM Control on VB Form?
View 2 Repliesi want to add TimeOfDay (Time) in Table Record which datatype is use for add Time.i am created a field "JoinedTime" DataType "time(7)"[code] "Specified cast is not valid.Couldn't store <1/1/0001 3:35:42 PM> in JoinedTime Column. Expected type is TimeSpan"want store like "3:40:14 pm" How Can I do?
View 8 RepliesHere is the code snippet
objCommand.CommandText = "UPDATE tblCustomers SET weight= @weight, height= @height WHERE id=@id "
What i want to do is the following:
I have a form and i want,by clicking the appropriate button, to update the height and weight values which have the specified primary key 'id'.
The primary key 'id' is of type IDENTITY.The problem is that the above code does not work. It says Must declare the scalar variable "@id".
I have recently developed a back end database in SQL server 2008 R2 and attached it to a application in VB express 2010.Everything works fine and when i publish the application, it works fine on my machine, but once i try to setup up the application on another machine i get the error message: A network related or instance specific error occurred while establishing a connection to SQL Server. Server was not found or not accessible please verify the instance name is correct or allow remote connections.I have read numerous forums on this saying about changing the connection string and instance name.but with being novice i dont understand what needs to be changed etc.The sql server allows remote connections, but i am unsure what else needs changing to allow the application to work with the database on another machine.
View 5 Replies