6,934 Topics
 | |
| | Hai; I am having a problem, I want to insert data in ACCESS database via using SQL insert into I want to add data in specific fields.... and I am Suffering... Please help me , how I can update data I am using the statement like conn.Execute ("Insert into Class_Nursery … |
| | This code seems legit to me, i cannot figure out why it wont run! please help :) [code=sql]create table #test ( col1 varchar(6) not null, col2 numeric(5,2) not null, col3 varchar(5) not null, col4 numeric(4,0) not null ) MERGE into table1 a using #test b on a.col1 = b.col1 when … |
| | Hi all i need some help with my code. i have a page where i want to update a row 'key' in my table users with a new value that i have generated. dbc.php [code] <?php $dbname = 'phplogin'; $link = mysql_connect("localhost","root","") or die("Couldn't make connection."); $db = mysql_select_db($dbname, $link) …  |
| | [B]I was starting my MS SQL Server Express 2005 when this dialog box [I] "new database connection "[/I] Came . I am confused what server name is and what server name should i put in the box ? Please help me, and if possible suggest a aserver name , or … |
| | I m a freshman about JSP.Now I have a quesstion about sql. first I made a class.Code is [code]public class DataBase { protected String url = "jdbc:mysql://localhost:3306/lab?user=root&password=root&" + "useUnicode=true&characterEncoding=utf-8"; public Connection conn = null; public DataBase() { try { Class.forName("com.mysql.jdbc.Driver"); } catch (java.lang.ClassNotFoundException e) { System.out.println(e.getMessage()); } try { conn … |
| | Hi All, I'm a virgin to this site, so go gentle. :-) I'm using vb.net to write a web application and I was just wandering what was better and what the advantages/disadvantages to using the self-imported SQL file within VB.net or the SQL Server Management to create a database and …  |
 | Dear all, I have a problem for my session state. Previously, I used session state InProc, but because CPU usage was very high cause IIS sometimes restarts, so I changed it to SQLServer. but now, session doesnt want to expire even I set timeout to 1 minute !!!. this is … |
| | Hi guys i'm using the join statement and then display it into the data grid. the problem is table 1 and table 1 info display it together like this Badge_ID Emp _Name Active Badge_ID Emp _Name Active 1234 Nana Yes 1234 Hana No How can i show like this in … |
| | Hi guys i need help on this can help me can help me to correct it. I want the inner join table 1 & table 2 not show a row in the data grid in the vb6 my sql statement is like this: sql = " Select * from staff_badgeTracking … |
| | I am a beginner in VB 2008 and MS SQL Server 2005. How can I connect my vb app into a database in SQL Server? Any help is greatly appreciated.  |
| | [CODE]Imports System.Data.SqlClient Public Class Form3 Dim con As SqlConnection Dim cmd As SqlCommand Dim dr As SqlDataReader Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click con = New SqlConnection("uid=sa;pwd=igiat;database=harsha1") cmd = New SqlCommand("select * from student") con.open() dr = cmd.ExecuteReader() While (dr.Read()) If dr(0).ToString() = TextBox1.Text … |
| | I have been using VB.NET for a while now, and I can make a ton of things. But for some reason, I can't connect to SQL. I use SQL 2008 express, and Visual Basic 2008 express(will soon get Visual studio :)) So, I go to add a database, I enter … |
| | Hi, does anyone know how to access a sql .mdf file directly using c# without using SQL server. I am planning to make an portable application with a database on a flashdrive, i really need some help.. thank you :) |
| | hi there, i am coming up with a form. i have to insert data into the sql database. i am able to do that. The problem is that, when i insert, the data i entered one shows twice in the table. i just click once and there are the same … |
| | Hi All I want to check whether there is a record present in my database with value: StartDate="Todays's Date" where start date is the column name with datatype DATE. |
| | help! i have a gridview with checkbox item template, and on click, those rows that are checked will be inserted into the database. When i close and run my application again, i want those rows previously inserted to remain checked. Means that i have to retrieve data from the database … |
| | Can anyone tell me how should i use variable to take different value.here is the following code which is working fine. [code=vb] strsql = " SELECT *" & _ " From ALRAJHIBANK " & _ " WHERE (((ALRAJHIBANK.ID)=12))" [/code] But i want to use integer variable name instead of integer … |
| | Hi guys, i have this point of sale application which i did using VB6 n SQL2000. my question is can i migrate my mdf n ldf files which was created in sql2000 to sql 2005 or 2008. i need advise. Thanks |
| | Hi guys i'm writing a vb program which got using the sql statement i know the sql statement is using method insert but my one is much different. The code concept is like this If cmbActive= true then sql=insert into staff_badgeTrackingNew = txtEmpID, txtEmpName, TxtID Else sql= insert into staff … |
| | Hi guys i dont know why i can get the datas from the sql 7.0 Can help me check this code>>> [CODE] If txtFBadgeID = "" Then Exit Sub Else sql = "select from staff_badgeTrackingNew INNER JOIN staff_badgeTracking" End If Exit Sub Set rsTrack = New ADODB.Recordset With rsTrack .ActiveConnection … |
| | Hi Guys, I am doing a simple backup of sql server database through VB.NET form. It gets executed well but I want to display details of successful query execution in a label (i.e. time taken, database size etc.) The message which I want to display in label is like [B]"Processed … |
| | help! i have a gridview with checkbox item template. On confirm button click, it will insert the selected rows into the database. But, when i close and run the application again, i want those rows which was previously inserted to the database to remain checked. Means that on page load, … |
| | I downloaded MySql Connector/J, but i dont know how to install this driver in my JDK or Tomcat on windows XP. I read J/Connector documentation but i cant understand it. I copy jar file in JDK\lib\ext. Please Help me in this situation. Thanks you all.  |
 | Hi, anyways after few hours of searching why I was having adding a database to my application I found out i was having some permissions issues!! DAMN YOU VISTA! Anyway, now my question is how start using like Inserts, or just to be able to look at my table in … |
| | HI there guys, forgive the basic question but it is late Friday afternoon where I am and my brain is broken. I'm trying to make a very simple expression to control visability of a text box in Visual Studio for a SQL Report. It uses a cut down version of … |
| | hi all, i m working on a project(Inventry System) in which i have to update stock frequently. i have created a trigger in SQl for stock updation. if i insert for a particular product in stock table the previous quantity and the current inserted quantity must be added. Plus i … |
| | how can i connect SQL(local server) to VB6?? Please give me the STEP BY STEP PROCEDURE.. i dont really have idea on how to connect SQl to Vb6 |
 | Good Day all I have a Sp that is written like this set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER PROCEDURE [dbo].[Import_RegistrationsXM] @xml ntext AS set nocount on DECLARE @doc int EXEC sp_xml_preparedocument @doc OUTPUT, @xml TRUNCATE TABLE _RegistrationXM INSERT INTO _RegistrationXM SELECT * FROM OPENXML ( @doc , 'Import/Item' … |
 | Hi people. I have a time and attendance module in VB6 which saves transactions (ADO) in MS-SQL if there is a LAN connection, and save it locally (MS Access) when offline. The trigger is when someone logged in. This is what I did: [Code] Set cn = New ADODB.Connection cn.Open … |
| | We have an app that we put on MySpace - it is hosted on a dedicated box and is database driven. Game is a static game and performs updates to the database and queries on stats and such. It is a battle type game, where actions such as attacks will … |
| | ok so i created a database and made a table that i inserted data into it. i would like to know how would i be able to put the extension .sql at the end of my table? |
| | I have created a drop down list from a SQL query as follows: [code=php] <?php echo '<form action ="boat_info.php" method="POST">'; $query = "select SHIP_NAME from SHIP"; $result = mysql_query($query, $link); if (mysql_num_rows($result)) { echo "<select name='boat' value='bname'>Ship Name: </option>"; while ($row = mysql_fetch_row($result)) { print("<option value=\"$row[0]\" name =\"bname[]\">$row[0]</option>"); } } … |
| | i just downloaded a login script and the code below is the php backend for the login. It is originally using md5 encryption and decryption for the password. For some reason I want to manage the password without encryption for now. my database has a member with login name and … |
| | Hi all Problem is I want to return unique results based on 2 fields: I have a table tags_photos which is a join table and has 2 fields: tagId and PhotoId. I want to create a page which has a list of all tags and a thumbnail against each tag. …  |
| | Hi, I wrote a query statement in SQL server to take paramaters, and generate then run a sql statement based on which criteria were provided. The tables got pretty massive so I need the query only filter when the value to filter on was provided. When I tried to bring … |
| | I have created a database using MS SQL named "Company" and there is a table named "Employee". I need to print the records from the "Employee" table to a JTextArea keeping tabs for each columns in the JTextArea. How can i do it? Please help.  |
| | Hi, I used PostgreSQL and i want to populate its fields in combo box. Is anyone know how to make it. . Please help me. . . it is for my project. . :icon_sad: Here is my code: Dim conn As ADODB.Connection Dim rst As ADODB.Recordset Dim sSQL As String … |
| | Hi to our community! Just want to get some idea regarding the connection setup of SQL Server 7.0, I've been doing an application written in VB6 and I used SQL Server 7.0 as a storage of my database. On my local pc I can successfully connected to SQL and manipulate … |
| | hi I have to add nodes and subnodes to a tree view from sql database in asp.net(VB.Net) 2.0 How to do this i have 3 tables i want to add nodes from first table and respective childnodes from the 2nd table subsiquent child nodes from the 3rd table how to … |
| | hello evryone. please someone help me. I want to load the data frm sql server database at the button click...how to load the data using resultset rs.getString("column name") in the <option></option> tag using JSP codes?? |
| | hi there. i write a project using VS 2008 and Sql 2005.now i want to deploy it and make its setup.what should i do for sql part?it's too big to install this mass(Sql) on user system.i heard i have to use sql engine? is this true? if yes,what's that? and … |
| | Hello, I'm wondering if there is a way to retrieve the identity value from an identity column before saving a new register. When I run this query: "[CODE]SELECT IDENT_CURRENT ('alpa_Animais') AS AnimalID[/CODE]" directly using the SQL Server Management Studio I get this value. Does anyone know if there is a … |
| | Hi guys can you all help me with this. I need to sure will the this idea can be make in vb6. I have a update command button. When click then type the badge id , it will automatic get the data and show the employee name then the rest … |
| | Hello Everyone, I'm quite new to Linq and have had some problems updating my dabase. I don't know if it is actually happening for be using a global data context or I'm missing something. I have my typed DataContex and one Static Public Var to initialize it located within the …  |
| | i have a problem.. please help me..I have only one combo box and i want my combo box to have its value and i want to get it's value from my database??? how can i get that?? please help me to do this. thanks. here is my code please help … |
| | hey guys, I've just got sql server installed in my system but i dont know how to start it. There are 3 options when i click on "Microsoft SQL Server 2005" in the programs namely: SQL Server Configuration Manager SQL Server Error and usage reporting SQL Server Surface Area Configuration … |
 | hiii i am using the following functions in javascript to dynamically add and remove rows from a table... [code] function addRow() { //add a row to the rows collection and get a reference to the newly added row var newRow = document.all("applications").insertRow(); //add 3 cells (<td>) to the new row … |
| | Hi guys, I was trying to implement a friends script but I encountered this error Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'by) VALUES ('Toxikr3' , 'moderator')' at line 1 I … |
 | Hi I am totally new to crystal reports and i need to print invoices from C# with the data stored in SQL. Now i can retireve the data and display it in the report however, i cannot properly display it. The problem is that e.g. i want to print out …  |
 | Hi, Recently i have been creating a Generator. That extracts all the names of the tables from the database tables and generates the class file for each of the tables in the database. I have successfully extracted the names of database tables and their corresponding column names with thier data … |
The End.