9,022 Topics
please help!!!me.. I'm a beginner vb.net programmer I have a difficult that is how can I save image file from vb.net to sql server
Hi is it possible to fill a list box from two SQL tables firstname lastname thanks M
Hi Guys, How do i obtain the nearest shipdate prior to Returndate. here is my sample script. thanks. kindly check my script. the result should be 2011-02-23 [CODE] Table1 ESN--DateReturn 123--2011-03-08 TABLE2 ESN---ShipDate 123---2010-09-28 123---2011-02-23 Select a.DateReturn max(b.shipdate) from Table1 as a left outer join table2 as b on a.esn=b.esn …
Hello, May be the there is a very simple solution for my problem, but I am stuck on this for 2 days already. May be I had been looking at the wrong places...I would really appreciate any kinds of helps....feeling really frustrated right now. You see, for my project at …
hi, i have a question in data tables. i am coding in C#. my scenario is employees have many benefits in a company such as life, health, dental, 401k and such... i have a tabel in MSSQL database to represent the employee data and a emp benefit table to hold …
hi ...i have a problem connecting MSSQL 2005 express and php.. i've tried configuring the php.ini by removing the ; in extension=php_mssql.dll but not working i also place the php_mssql.dll on ext folder but not working again; and also i tried downloading an old ntwdblib.dll and placing it in system32 …
Continuing on from my adding data to the db I am using the following to try and update the db [CODE] End If 'Refresh_Form() conn.Close() 'update property table Dim connUpString As String = My.Settings.strConn Dim connUp As New SqlConnection(connUpString) Dim cmdUp As New SqlCommand Try connUp.Open() cmdUp.Connection = connUp cmdUp.CommandText …
hi ... can someone help me on connecting MSsql 2000 to vb6 ...i've been searching google but they always point me to this site .. [url]http://www.connectionstrings.com/[/url] i dunno how to set up this strings in vb since im new to vb... :( please help
Anyone know what is the root cause unable to open the connection in php? [CODE]CDbConnection failed to open the DB connection.[/CODE] I m having trouble connecting to mssql server connection..in yiiframework
Hello, May be the there is a very simple solution for my problem, but I am stuck on this for 2 days already. May be I had been looking at the wrong places...I would really appreciate any kinds of helps....feeling really frustrated right now. You see, for my project at …
[CODE]newUserCommand.CommandText = "INSERT INTO users(username, password, security) VALUES('" & newUserNameBox.Text & "';'" & newPassWordBox.Text & "';" & newUserSecurityBox.Text & ";'"[/CODE] I cannot find where the syntax error is but vstudio tells me the error is in a unclosed quotation after ;
Hi I am trying to submit a date value from a DateTimePicker1 using short date format 05/02/2011 I get an error on submission .NetSqlClient Data Provider:conversion failed when converting date and/or time from charecter to string this is my insert [CODE]cmd1 = conn.CreateCommand cmd1.CommandText = "INSERT INTO tenant(firstName, lastName, Email, …
Hello Everyone, I know this is going to be easy to all of you, this is my first time performing an if else statement in SQL, after performing this query: Collapse | Copy Code IIf(IsNull(EventSummary.[Event Information - Event Status]),"ACTIVE",EventSummary.[Event Information - Event Status]) AS [Event Status], I get this error …
I am using SQL Server 2008. I have data from SQL like this. [CODE] ID ID2 PartNo -- ---- ---- 75 23921 DENT 75 26145 PLGD 75 26145 PRRP 75 26145 SIST 75 57290 PRMD 75 57290 abc 75 57290 def 75 57290 ghi 75 57290 jkl [/CODE] I need …
I am using SQL Server 2005. I have a data from SQL like this. ID ID2 PartNo 75 23921 DENT 75 26145 PLGD 75 26145 PRRP 75 26145 SIST 75 57290 PRMD 75 57290 abc 75 57290 def 75 57290 ghi 75 57290 jkl I need an output like this. …
Hi I have [B]Windows 7 Home Premium SP-1, 64-bit[/B] version on my PC. I want to install SQL Server either 2oo5 or 2008. but i am unable to install this. Error: [I]OS Incompatibility[/I] Pls Reply: Thank U
hi guys i have problem with my code here is my code [CODE] Public Sub increment() Dim dr As SqlDataReader If con.State = ConnectionState.Closed Then con.ConnectionString = (strconnection) con.Open() End If Dim str As String = "Select CUSTOMERID from tbl_Customer" cmd = New SqlCommand(str, objconnection) dr = cmd.ExecuteReader While (dr.Read()) …
Hello,This is my code.I have in big problem anyone have a solution. I want view crystal Report by using studentid. [CODE] { CrystalReport1 objRpt; objRpt = new CrystalReport1(); string con = ("Data source =DATA;Initial Catalog = Schooldata;Integrated security = True"); SqlConnection objCon = new SqlConnection(con); // Here I am writing …
I have a csv file that needs to be imported into sql server using vb.net. I got it working with the following code with one exception: [code] Private Function ImportLeadFile(ByVal projectfile As String, ByVal sLeadFile As String, ByVal DATABASE As String) As Boolean Dim objConn As nsSqlClient.SqlConnection Dim ds As …
SELECT * INTO NewTable FROM existingdb.dbo.existingtable; I am executing this query but it is showing me the error as undeclared variable:Quanti (as quanti is my NewTable)
I am having difficulty with a SQL query in my project. I have 3 tables. T1: - Date - ID - Location_ID T2: - Location - Location_ID T3: - ID - Result From this I need the T1.Date and T3.Result based on Location in T2. So my I need a …
I have a Windows Form where 225 buttons are added at the run time, also I have the database which have two columns (first column is the SeatNumber with the datatype nchar(4) and the other column is IsBooked with the datatype bit). The SeatNumber contains data like this, A1,A2,A3,A4................O13,O14,O15, The …
I have a gridview with 3 columns Name,Surname,Change(ButtonField column) which is populated from an SqlDataReader with the following code [CODE] SqlCommand sqlCommand = new SqlCommand("select * from Empl where userId ='" + userid + "'", sqlConnection); sqlConnection.Open(); SqlDataReader reader = sqlCommand.ExecuteReader(); GridView1.DataSource = reader; GridView1.DataBind(); [/CODE] In my database there …
hi i have to search based on opening and closing times of shops. e.g. opening time of one is from 9 am to 11 pm another can be 5 am to nextday 2 am. e.g of sample data below [CODE] ShopID open time close time shop1 10am 11pm shop2 6am …
Hello all, I have a DataGridView that is being populated via SQL with one table and is being filtered by Stock Code. I need to sort the view of one Stock Code by Nutrient names, but the sequence number is in anther SQL table. it would be easy if i …
Hi, I have a sql view below: [CODE] SELECT b.Stk AS secode, b.TktE AS Ticket, CAST(a.Last / 10 AS integer(10, 3)) AS Last, CASE WHEN CONVERT(integer, a.Last) <> 0 THEN (CONVERT(integer, a.Last) - CONVERT(integer, a.Ref)) / 10 ELSE (CONVERT(integer, a.Ref) - CONVERT(integer, a.Prev)) / 10 END AS Change, CAST(a.High / …
Guys, Please take a look my script. my object here is to get the most recent date from table 2. what if the recent date from table 2 is less than the date from table 1? [CODE] Table1 Type-Date1 -------- 1-2011-07-16 2-2011-07-16 3-2011-07-10 4-2011-07-10 Table2 Type-Date2 -------- 1-2011-07-06 2-2011-07-07 3-2011-07-01 …
Hi, can anybody suggest me how to take backup and restore of sqlexpress. I have used sqlexpress in my project i have little bit idea about taking backup and restore of sql server using SMO but unaware about sqlexpress. Can anybody help me please.... Thanks in Advance
Can someone please tell me what i am doing wrong with this code. I have created a dataset and want to push that data into crystal reports. [CODE] Dim rpt As New CrystalReport1() 'The report you created. Dim myConnection As SqlConnection Dim MyCommand As New SqlCommand() Dim myDA As New …
Good day every one please I need help in coding this small easy program it just three text boxes and one button to save them this is my code [ICODE] Imports System.Data Imports System.Data.SqlClient Public Class Form1 Dim cmd As SqlCommand Dim con As SqlConnection Private Sub Button1_Click(ByVal sender As …
Hi We have two identical web servers in a farm and I need them to be able to share Session variables as I do not know which machine the user will be using at any given time i.e. if a user where to log in to a site on server1 …
Hello, In CFQUERY operations, can someone advise as to the following: 1. What data types REQUIRE single quotes for UPDATE and INSERT statements? * We are using MS SQL 2008 R2 with CF9 2. Is it best practice to use CFQUERYPARAM for EVERY statement now days? I searched everywhere but …
Good Day Everyone.. i have two tables..how to read from one table1 to table2.. example.. Table1 with thousand over records various types of recurrance and due pattern. where ID = History_ID Table 1 ID Reccurance Duepattern 1 Monthly 10 2 Yearly 25 3 Monthly 15 4 Weekly 5 yearly 14 …
Good Day Everyone.. since i have two tables..how to read from one table1 to table2.. example..Table1 with thousand over records various types of recurrance and due pattern [CODE]table1 ID Reccurance Duepattern 1 Monthly 10 2 Yearly 25 3 Monthly 15 4 Weekly [/CODE] output must b like this in table2 …
Hi, My problem is that I'm recovering data (which depend on what the user selected on a first page) from a SQL database for several language checked (also on that 1st page). I would like to create files for each one of the language selected. For now, I tried to …
Keep getting this error. Using ASP datagrid [CODE] Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Dim connectionString As String = WebConfigurationManager.ConnectionStrings("connectionstring").ConnectionString Dim selectSQL As String = "SELECT * FROM checkInOut" Dim con As New SqlConnection(connectionString) Dim cmd As New SqlCommand(selectSQL, con) Dim adapter As New …
Connecting and using SQL in VB.NET
Hi guys, Need you inputs on my query. I have an excel file which we have to upload weekly. They want me to make an application using SSRS (MS SQL) . To read the excel file from a certain folder And then make some data entry to inputs like date …
How can I connect two tables from MS SQL Server 2005 using vb.net 2008? what's the code?
i have one array [{"id":23,"name":"Video Clips"},{"id":15,"name":"Deleted Scenes"},{"id":9,"name":"Music Albums"},{"id":7,"name":"Trailers"},{"id":18,"name":"Short Films"},{"id":21,"name":"Movie Clips"},{"id":1,"name":"Movies "},{"id":4,"name":"Plays"},{"id":22,"name":"Scenes"},{"id":2,"name":"TV Show"},{"id":5,"name":"Kids"},{"id":16,"name":"Interviews"},{"id":11,"name":"Film Songs"},{"id":14,"name":"Making of Movie"}] after the split this array i get value== value== value=="id" value==23 value=="name" value=="Video Clips" value== value== value=="id" value==15 value=="name" value=="Deleted Scenes" value== value== value=="id" value==9 value=="name" value=="Music Albums" value== value== value=="id" value==7 value=="name" value=="Trailers" value== …
can you please help me to create a adding form and it will save to sql database .. pleas
Hi i have used multiple layer in my web application. my db of sql server 2008 is in other machine and stored procedure has defined there. I want to retrive data from 1 table from db and bind with gridview as well as if i select 1 row that row …
Hello, i have tried many solution for solving this problem. I want to passing field in database to list view with stored procedure. Any Body please help me example Table A [LIST] [*]name [/LIST] [LIST] [*]Sex [/LIST] and stored procedure just (select * from [A]) how i can pass the …
Hey All I would like to know how to retrieve a image from sql server database. im storing the path in the database..
i had created login form in vb.net there are two fields username & password.i want to check username & password enter in the login form,from the first.mdf(database file). if it is correct then message is displayed i had written code for this but i got error in the code.what modification …
Please let someone help me out here, i want to insert record to the database using VS2010, when i input data to textboxes and hit button, the program will run and tell me data inserted succesffuly. But when i check my dbs table i won't see any thing. here is …
Hey everyone, kinda new to all this...really need some help: Ok so I want to creat a log in and registration form in VB connecting to a sql database. Databse Name: Users Table Name: UserDetails Table Fields: ID, Username, Password The ID field was specifed as primary and self incrementing …
I'm working on a C# windows program with Visual Studio 2008. Usually, I work from school, directly on my usb drive. But when I copy the folder on my hard drive at home, and I run it from my hard drive at home, an sql exception is unhandled whenever I …
Hi all, I am getting an error in my application that reads: Incorrect syntax near the keyword 'set' It only occurs in a database at a particular venue and only when the offending query/queries are run locally. I have restored the database on my PC and the queries run without …
<input type="button" name="b2" value="Delete" onClick="<? $delQuery = 'DELETE FROM artist_schedule WHERE artist_schedule_id=.$artistID'; $result=mssql_query($delQuery,$con); ?>"/> ------------------------------------------------------------ when i echo $artistID i get the value. how do i delete using a javascript button onClick ?? if using function also then how do i implement the function ?
The End.