6,934 Topics
 | |
| | i have a windows forms with 7 texboxes, i would like to save the input into a sqwl databse , but i am having a bit of problem, this is my code: Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim con As New SqlConnection("server = … |
| | I've written an SQL select statement. I've checked te statement in SQL Server Management Studio Express and it works greate. When I go take the code to my asp page and insert it, I get a generic IIS 500 error. When I take out my variable I'm tyring to use, …  |
| | using vb.net and sql query i need to join multiple tables to view in one datagridview control .In each table i need to take only one field and want to dislpay all in the datagridview control...can anyone provide me the apat code for this  |
 | Imports System.Data.Sql Imports System.Data.SqlClient Public Class Form1 Dim connetionString As String Dim connection As SqlConnection Dim adapter As New SqlDataAdapter Dim sql As String Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim connetionString As String Dim cnn As SqlConnection connetionString = "Data Source=obeng\obeng;Initial Catalog=mangementsystem;integrated security=true" …  |
| | I have 10 field that I want to calculate the total. some of the fields take null value. I tried the codes below but the result was empty. select id, (c1+c2+c3+c4+c5+c6+c7+c8+c9+c10) as total from items order by id; the result show was null. In dreamweaver the result was blank. please …  |
| | hello i have a table "employers" Employerid int InsuranceNumber varchar(10) Ministry nvarchar(100) Adress nvarchar(250) PostalCode varchar(50) Phone varchar(14) Mobile varchar(14) Email nvarchar(60) UserName nvarchar(50) Password nvarchar(50) ContactPerson nvarchar(250) EntryDate datetime LastUpdateDate datetime IsDeleted bit Active bit and i have created how to insert data using insert stored proc Create procedure … |
 | Is the MySQL database and the SQL query language part of the Microsoft Windows 7 operating system If yes, is there something I need to do to activate them? If not, where would I get them?  |
 | i am using a store procedure to access field in asp.net View, i am putting db columns in HTML table, it's workign except for one field, 'NetSalary'. It can't be accessed, it says that model doesn't contain it. i tried many ways but couldn't get to work. ALTER PROCEDURE [dbo].[GetMonthlyReport] … |
 | i declared a variable string to store my query video_id value in it `Inline Code Example Here` string videoid; private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { loaddata(); string myconnection = "connection string"; MySqlConnection myConn = new MySqlConnection(myconnection); MySqlCommand SelectCommand = new MySqlCommand("select * from livestream.video where title ='" + channeltitle.Text … |
 | I am am experience Mainframe programmer, but new to SQL-Server & learning vb.net so I realise that this is probably very basic ... I have a DataTable called MailTypes which contains 2 Columns, the ID & the Name. I have a DataTable called Leagues which contains a lot of Columns, … |
| | I was wondering, how do I make it so users can login. I have an SQL database, I have a VPS, I have a VPS. I just need help setting it up and adding an account.. This is the login form: Public Class Form1 Private Sub FlatToggle1_CheckedChanged(sender As Object) End … |
| | I've been trying to delete row in my database and all I get is this error ORA-04084: cannot change NEW values for this trigger type ORA-06512: at "myDB.STUDENT_ID_TRIGGER", line 4 ORA-04088: error during execution of trigger 'myDB.STUDENT_ID_TRIGGER' DELETE FROM STUDENT WHERE STUDENT_ADDRESS = 'NY Street'  |
 | Hi all, I have two tables in a database. Both have columns named "Company Name". I want to compare between these columns for any similarities in their names. For Example : Table1.CompanyName = 2i Ltd /// Table2.CompanyName = 2i Limitied. Thanks Gilbert |
 | I'm stuck on this problem any one know the answer. **Write a query that displays the grade of all employees based on the value of the column JOB, as per the table shown below. Order the result according to the grade! ** JOB GRADE PRESIDENT A MANAGER B ANALYST C … |
| | i installed PHP version5.4.3 SQL server 2008 IIS7 SQLSRV version3.0 Drupal 7 SQLSTATE[42S02]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'watchdog'. This error occurs right after the following during Drupal 7.26 installation (shown in the error report). It hangs at the start of Install Profile: Installation tasksChoose profile(done)Choose language(done)Verify …  |
| | hi my name is vishal for past 10 days i have been going nuts on how to combine selected datas from 3 or more tables into single sql select query in vb6. i have 4 tables named table1 name: Inward column Name DataType mfr_ref_number text no_of_bundle integer supplier_id integer DC_date …  |
| | please help for query... i want sum (kns+kng) by name - [example](http://sqlfiddle.com/#!2/b5a7e6) the result should be: name|sum ----------- john - 36 bart - 16 steve - 53 jim - 10 tnx |
| | I have an old access 2.0 database, i converted it in access 2007 but the old code doesn't work.. i heard that it is about DAO and ADO anyone can help me to convert this DAO code to ADO coding.. thank you so much in advance.. Private Sub cmdSave_Click() Dim … |
| | hello everyone, im pretty new in this language (vb.net) so i have difficulties understanding its function, right now i am able to populate my database to datagridview, i've been looking for some related answers. but found no luck. so i decided to post it in here. so i have this … |
 | Hye dude, Really need help. My problem is I want to insert data from treeview checkboxes into database. Currently im using an array, but when i insert the value it become double. for example, when i click two checkbox. the id insert in database will be two. Can someone help … |
| | where to get sql dump file for countries,cities and states |
| | See i have two table named Studentmaster-rollno,name,permanentaddress1,permanentzipcode studentacademocdetails-rollno,dptname,status,programid I want to select roll no of a student with permanent address like "chennai" and permannet zipcode=60004 and from second table i have to select dptname,status where status will be like('c','f,,'t','k') I tried a query as follows SELECT t1.rollno,t1.firstname,t1.permanentaddress1,t1.Permanentaddress2 ,t1.Permanentzip, t2.departmentcode, t2.status,t2.programid … |
 | This is sample code for a ASP.Net Login page (using Visual Basic.Net code behind) with OleDB connection to an Access Database using ADO.Net. The datebase used is the Access Northwind Database. With the connection string being placed in the [i]web.config[/i] file. [b]1. [u][i]Web Config[/i][/u] File code:[/b] [code] <?xml version="1.0" encoding="utf-8" … |
 | Hi.. i want to get all columns from tbl_class where course_id of tbl_course is equal to course_id of tbl_class more over course_id of tbl_course should be thw one who has semester = 5 brife structure of tables are: tbl_class >class_id >course_id >class_room tbl_course >course_id >semester i have design this kind … |
| | I'm trying to calculate and list the websites in order of biggest overall reduction in response time from one time period to the next. I don't strictly need to use a single query to do this, I can potentially run multiple queries. | 1 | 1 | 93.26 | 2014-01-28 … |
 | I am creating a pageant scoring system. I managed to display the field names from different tables : [Click Here](http://oi58.tinypic.com/5c0jz5.jpg) The first column "Participants" is from Participant table and the succeeding columns is looped from the Criteria table. This is the code: Private Sub CreateDataEntry(ByVal CatID As Integer) Me.CriteriaTableAdapter.FillByCategory(Me.PSSdbDataSet.Criteria, CatID) … |
| | Hi guys, I have worked with PHP and MySQL before and recently I wanted to try and learn ASP.net MVC since some of my friends are using it in the work place. But the most confusing thing about this is, why does all the tutorials out there not mention how … |
| | I am trying to get 20 images displayed on a jframe in jlabels using a gridlayout. I have added a while loop but still i am only am to see 1 image, please can you help me to display more than image in jlabels on a jframe? setSize(600, 600); setDefaultCloseOperation(HIDE_ON_CLOSE); …  |
| | hi my name is vishal for past 5 days i have been nuts of how to combine data from multiple tables into single table using sql select query (join query) Given below i have tried solution but i get error message data not found. But in table i have datas … |
| | I have 2 tables in sql , one is called stock and the other stock warning the stock table has columns ' Pid, pdescr,current stock, stock warning' this shows up in datagridview 2nd table(stock warning) has columns 'pdescr, current stock' showing in datagridview in the stock table when the 'current … |
| | Hello, i want ask somthing about mysql in multi pages i hope someone help me and sorry about my English this code works good but there problem if i used it with this tybe sql = "SELECT * FROM emaillogs ORDER BY id DESC" cursor.execute(sql) results = cursor.fetchall() if page … |
 | this query was working fine but when added OverTime part then it started throwing error: Msg 8117, Level 16, State 1, Line 52 Operand data type varchar is invalid for sum operator. with times as ( SELECT t1.EmplID , t3.EmplName , min(t1.RecTime) AS InTime , max(t2.RecTime) AS [TimeOut] , t4.ShiftId …  |
| | This query shows emplName,emplID, totalworking time, InTime, OutTime, DateVisited, Overtime for an employee based on his InTime and Outime, that's OK. Now i am trying to modify it to show only emplID, EmplName, Total Working hours(Per month), total overtime (per month). e.g. Empid EmplName TotalWorkingHours TotalOvertime Month 00001 John 77:00 … |
| | i have written this query to show total working time and overtime of an employee on particular date (if he has came) otherwise it doesn't show record for a person if his INTIME and TIMEOUT are empty but i don't want this now, i want if for a particular date … |
 | I created a three layer application with BO (Business Objects), BLL (Business Logic Layer) and DAL (Data Access Layer). I had to do some unit testing using nUnit tool. I've done that like following and works perfectly: SQL Tables: USE [Projekti_TI_1] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO … |
| | hi all ... i want fill data graid view with data taken from text boxs in medecian info group box when i press add button the problem is it add only one row ... i want make that data grid view represet bill so i want add mor than one …  |
 | Hi there, i need hel whit this one : i'm learning how to develop MVC but evry time that i wand to create a data base whit visual studio express 2013 i get the classic connection to DefaultConnection : Data Source=(LocalDb)\v11.0;AttachDbFilename=C:\FRANCESCO\Project\OdeToFood\OdeToFood\OdeToFood\App_Data\OdeToFoodDb.mdf;Initial Catalog=OdeToFoodDb;Integrated Security=True Ho can i set as a connection … |
 | cmd = new SqlCommand ("select beggining_school, end_school FROM Student,student_weekend,Weekend WHERE Student.ID=student_weekend.studentID AND student_weekend.WeekendID=Weekend.ID ", con); I just want to say that i don't have any problem concerning my code functionality. I would just like the design to be like the above example.That is, I dont'want my whole sql expression to …  |
| | As some of you might know I'm working on a movie database to help track my movie collection. For a while I was having trouble getting the output I wanted for that, but I finally figured out some sql code to help with that problem. I'm going to be working … |
| | How can i connect vb.net to sql server |
| | Hi i have a problem in binding DateTimePicker value from one form named SearchDoctor to existing form named Doctor. Here is the code of my Doctor form and it works: using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; using System.Data.Sql; …  |
| | I am new to VB, and have attempted to load all the free versions of the SQL available. Dispite many go's I still can not make any work. I go through the motions of including a database into my programs but I keep geting a long delay then "Unable to …  |
| | Greetings, i'm having a problem on inserting all my items from listview to my database using stored procedure. heres my code. Dim lvItem As ListViewItem For Each lvItem In ListView1.Items With dbComm .AddParameter("@details", lvItem.Text, SqlDbType.VarChar) .ExecuteStoredProcedure("insertRecord") If .Success = False Then MsgBox("Record failed to save.") Else MsgBox("Record Saved.") End If …  |
| | I have text file (attached image) i need to loop and get the values (with ellipse shape )into sql table the text file record usually started with (----) |
| | (SQL , PL/SQL) enough for searching jobs in ORACLE ? i have 2.6 years exp with oracle sql, plsql . can i get better JOB ? |
 | I have a file that a friend/hacker was able to create called `'AND SELECT * FROM 'users''` The FTP command `DELE 'AND SELECT * FROM 'users''` says this: Command: DELE 'AND SELECT * FROM 'users'' Response: 553 Prohibited file name: 'AND SELECT * FROM 'users'' That means it can't delete … |
| | Hi Please any help me on the below issue i am having a interger as below the formate is CYYDDD 114024 i want to change the above line as 24-01-2014 |
| | Hi can any one pls help on the below thing I am having a value as 91819.0 But I required the above data should be converted as time as below 9:18:19 Likewise it should be viceversa |
| | Hi Experts, I have to Pad some numbers that have decimal points and I have done it successfully as follows: SELECT case when len(myValue)=1 then RIGHT('000' + CAST(CAST(myValue AS float) AS VARCHAR(5)), 2) when len(myValue)=2 then RIGHT('000' + CAST(CAST(myValue AS float) AS VARCHAR(4)), 2) when len(myValue)=3 then RIGHT('000' + CAST(CAST(myValue … |
| | i am bit confused by the nature and working of query , I tried to access database which contains each name more than once having same EMPid so when i accessed it in my DROP DOWN LIST then same repetition was in there too so i tried to remove repetition … |
The End.