6,934 Topics
 | |
| | Hi, looking for help and need pointing in the right direction, can anyone assist? Have a data file (txt) that contains 10000 numbers/data points. Storing the data file as varbinary(MAX) in an SQL table. My goal is to retrieve the file on user request and plot/chart the numbers as a … |
| | How to write a linq query for the following SQL statement select * from XYZTable where ColumnA in ( select ColumnA from XYZTable GROUP BY ColumnA Having Count(*)>1 ) order by ColumnA |
| | hi i have retrieved data on data grid from backend. i want to write a code with which i will be able to retrieve the complete data related to the editable field from backend to front end. The edit and delete button needs to be seen on the right click … |
| | In this days, I am making dictionary site with PHP & Mysql. I write SQL like this [CODE]select * from dblist where `Word`='A' Union select * from dblist where `Word`like 'A%' Union select * from dblist where `Word`='%A%' Union select * from dblist where `Word`='%A'[/CODE] I don't use [CODE]`Word`='A' OR …  |
| | Hi all, I want to send mail attatchment from SQL server. I have a Image field and i have stored word documemts in it. I am designing a form where an Email has to been sent with(attatchment) the word documents in the image field. So, i am looking for code …  |
| | |
| | Hi everyone; I have table contains question and answer columns , the answer either yes or no , I want to count the answer yes and answer no then compare the two results and if the count(answer) yes is greater than count (answer) no print yes else print no I … |
| | This may seem like a simple question but I for the life of me cannot seem to get this working. I have an ASP page that I need to set a dropdown box to a value from sql. I have the dropdown getting filled from sql no problem. [CODE=c#] private …  |
| | Regrading to the topic can anyone help me about this and give me some example code for add and update data to ms sql 2000. I'm using the ADODB connection for the vb program! Help me i newbie on it. Please! |
| | I am wondering if anyone can point me in the right direction so I can save the returned identity value from one of my stored procedures. How can I save it into a variable. Any help or examples is appreciated thanks!  |
| | Hi, I've got 2 columns of numbers and need to divide the SUM of COLUMN 1 by the SUM of COLUMN 2. I've tried [code] (SUM(col_1))/(SUM(col_2)) [/code] AS col_3 but this doesnt work. Please help. Kind Regards Asil |
| | Hallo i'm Rinning an application with a sql database on pc1 it works fine but if i install the application on another pc i can't connect to the database i'm using SQL Server Management Studio Express 2 setup the connection but i cant find the 2nd pc where the data … |
| | hi all, i have a simple problem with the reporting services. i have configured the reporting server and it is working fine when i browse the reports through the report server. i have another application in which i have made use of a report server. when i try to browse … |
| | ...hope some body can help me resolve the problem....where i have to update a particular data , the datas are retreived from the db using a dropdownlist,selected data are updated inside a textbox........... .....where there are constraints set by validators for space and !^#$%&*^----charaecters: My problm is data is not … |
| | Hi guys do anyone know how to change the code line from sql express to ms sql 2000. Below is my code help me to check it? web.config [CODE]<?xml version="1.0"?> <!-- Note: As an alternative to hand editing this file you can use the web admin tool to configure settings … |
| | Hi guy it is possible two table information with same information expect the badge ID display it on one vb datagrid??? |
| | Hi all, I am creating a windows application. I have a column in the backend - MS sql server 2005 as ID which stores Patient Id. The values for this column should start with PT and contain the serial numbers in ascending order. Eg. PT001 PT002 PT003 I want to … |
| | (And before anyone points it out; I know they're not calling it DTS any more!) My problem is as follows: Whenever I go to import a flat file using the DTS import it's setting the default column sizes to be ludicrously small (50 characters) and it doesn't subsequently matter HOW …  |
| | Hi all, I need a favor on SQL this time There are 4 tables as follows Employee(EmpID,EmpName,...........) Designation(Des_ID,Designation....) EmpProfInfo(EmpID,Des_ID,..........) Training(TrainingTypeID,EmpID,TrainingType,.......) When an employee allocated to a training their details will be inserted in to the Training Table I want to write a sql query so that I can select EmpID,EmpName,Designation …  |
| | Hello All, I'm wondering if anyone can help me by either directing me towards a source that would help me understand Access syntax better or help me figure out if it's possible to convert this SQL syntax to Access. I've tried but can't seem to get it to work. my … |
| | I have a datagridview that tracks when employees clock in and out. I used the datetime data type in sql but I dont want the year to display. How would i go about doing this? Do i have to modify my select statement, or can I do it with vb … |
| | hi guys ; i have a code for read txt and later write to sql database but its not working :( can you help me _? Best regards [code] using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.IO; using System.Data.SqlClient; using Utilities; namespace …  |
| | Hi Alls, I'm really need your's help... I develop console application as a engine to pull data from oracle to SQL...the connection to both database is ok..but when to insert got problem....somebody help me plz.... [CODE] 'Connection To Sql Dim sqlcn As SqlConnection Dim sqldr As SqlDataReader Dim sqlda As … |
| | I am having problems with a data entry issue i have a field in my database which is called headline it is set to varchar 255 when i insert for example something with for eample. [code] The 'dogs' are very big. [/code] the code is sent by normal $headline=$_POST["headline"]; then … |
| | Hello Everyone, I am using ths class as my reusable SQL select for my queries in other classes. But when I used this in other classes, it generated me this error: java.sql.SQLException: Network error IOException: Address already in use: connect Can anyone give me some idea or advise on how … |
| | I wonder if i could pick anyones brains on somthing? [CODE]public void show(String add) { try { statement.execute("select * from Staff_Details WHERE Address2 =" + add); [/CODE] This is a section of code im working on. The string variable add at the end of the SQL statement is not working … |
| | Hi guy i need some help on checking this table structure is right or wrong. PLEASE CORRECT id i'm wrong [U]tblBadgeNew[/U] iBadgeID (Foreign Key) iEmpID (auto number) iActive iRecycleStatus iIssueDate [U]tblBadgeOld[/U] iBadgeID (auto number) iEmpID (auto number) iActive iRecycleStatus iIssueDate This two table will send data to the data grid … |
| | hey frnds, tell me one thing as in VB.Net suppose if we want to connnect to SQL,then in form coding itself.We create the database,Create table ...& insert values... WE do that cz if we run the project at Client side,even if no database is there our project automatically creates it … |
| | Hi evrybody, My sql SP takes around two to three minutes which is quite long time to execute the SP select data from three tables publicity(29000 row) publicitysubject(29000 row) & lookuptable(50 rows) all three tables have clustered index How can i reduce the time [code] USE [ReadWorthyPublication] GO /****** Object: … |
| | HI All, Another Question: I have created another program that queries the StockTracker database for all users and the stocks held by each user. The program compiles, but at run-time i get the error: [COLOR="Red"]"Exception in thread 'main' java.sql.SQLException: Column not found at sun.jdbc.odbc.JdbcOdbcResultSet.findColumn<JdbcOdbcResultSet.java:1833> at sun.jdbc.odbc.JdbcOdbcResultSet.getString<JdbcOdbcResultSet.java:395> at StockByUser.main<StockByUser.java:43>"[/COLOR] I am … |
| | Do anyone know how to use the vb to retrieval data from MS SQL ? Do anyone have a good tutorial about it can post it?? |
| | how to create a table using date data type i am getting error during creating table create table mrf(fr date); error: cannot find data type date |
| | Hi...new here. :) Trying a sql insert inside a foreach loop, getting "Variable name has already been declared...must be unique" error. I think the structure of my code or my parameter statements are incorrect. Any help would be greatly appreciated! Thanks! [code] // open connection mySqlConnection.Open(); //enumerate the items in … |
| | Hi there, im new to VB and am trying to work out how i can check that my database connection info is correct before i connect. error example with incorrect info: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or … |
| | I am trying to figure out how to set multiple text boxes/labels with one sql query. I dont need help connecting to the database or anything like that I just need to know how I can write one query to and set multiple text boxes with that one query. here … |
| | Need help can anyone give some example of the code to retrieval data from Microsoft sql to the vb datagrid |
| | Hi, I want to use VB.NET to connect to sql server remotely and input and receive data from the server. Can anyone help me to do it? I really appreciate code example. Thank you very much!! |
| | Hi. I have strange problem with sql query results. I am joining two tables and displaing result with order by clause. But results on MS SQL and Sybase are different. After removing order by clause in both queries results are equal. I am using the same table so I do … |
| | am doing my class project but am stuck i want to oepn the administrator category in valid_user table is Administrator and if Normal user to open welcomepage here is the code it only open admnwelcom.html even when the catagory is Normal_user.here is the Php code [code=php]<?php // This code will … |
| | The configuration in our setup is one Web Server and one database server running SQL Server. With the current connection string it works. Recently we moved the database server to another machine with a different ip but with the same name. We used the name and not the ip in … |
| | please.. i need help can you please post simple sample code on how to insert and retrieve image in sql 2000 im a beginner.. :) thank you so much |
| | I don't use combo boxes very much, so I basically forgot how to use them. Im connecting to an SQL database and I just want to populate a combo box with a users first name. Heres what I have so far: DBATimeOff.SelectCommand.CommandText = "SELECT FName FROM tblEmployee" DBATimeOff.Fill(DataTimeOff) CmbEmployee.DisplayMember = … |
| | Hi guys, I has a question to ask it is possible to call out the same ID on two different table. Example i have same ID like said 123 on table 1 & table 2 it is possible to call then out and show out on the data grid when … |
| | Hi, PO-1-09/09 is a data stored in varchar column. When i do [inlinecode]select * from table myid='PO-1-09/09'[/inlinecode], it doesn't return any value. If i change PO-1-09/09 to 5, and search for it, 5 returned related data. Why PO-1-09/09 doesn't work? Thanks |
| | i am building some thing that will grab part numbers and description from a data base works great when you type in part of a word or part of the part number the issue i run into is when i type in the full part number for example A11-123 this … |
| | I am trying to query my SQL Server database to populate a dataGridView. The user clicks on an item in a comboBox to select a 'program' to view. The where statement in the quers used the Text property from the comboBox. The code is: SELECT CAMPAIGN_ID, CREDIT_GRADE_PRE, SUB_GRADE, APR, ANNUAL_FEE, … |
| | I am REALLY new to SQL. Teaching myself C#; downloaded SQL Express 2008. (Not sure of the terminology either...) Successfully created several tables for my desktop customer database. I am not able to populate the database yet... Do I have to create my own application to add data to the … |
| | Hi there, Being new to Vb.Net 2003, I need help to determine whether to Create new Record or Update an exisitng record in SQL SERVER table. In VB6 I used this logic to do that but in Vb.Net 2003, I am totally lost at it. Please Help me. Thanks. VB6 … |
| | Hi, i really need help with this :/ the export field in my localhost PHPmyadmin has many fields and I must be doing something wrong, because the receiving end doesnt load the database at all. I set: SQL in STRUCTURE: Add AUTO_INCREMENT value Enclose table and field names with backquotes … |
 | hi I am badly stuck with inserting and retrieving Date in SQL DB from C#. I have a C# application which needs to save date in SQL 2008 Database for various purposes. The format in DB is DateTime for my DateColumn and i am using Datetime Picker in my c# … |
The End.