6,934 Topics
 | |
| | Hi, I am unable to create a new database within Visual Studio. I can however create a database in SqlExpress and then see it in Visual Studio, but once in Visual Studio I can’t seem to do anything, e.g. If I right click the ‘Tables’ icon within a database in … |
| | hi i aam trying to develop a project using vb and access i have got a problem i have 3 tables in access 1.Cust info table(fields are listed below) cust id,name,age,sex,country...etcxc(primary key cust id) 2,indate(fields are listed below) custid ,packageid,date,intime,outime(no primary key) 3.package info table(fields are listed below package id, … |
| | I have 3 radio buttons and each connected to a SQL statement..the first one 'NVIDIA*' does not get executed whereas the other two do because they dont have wildcard character in them. Can you please help me with this ? I tried 'NVIDIA*' in Access query and they worked perfect … |
| | Hi everybody, I have a ntext problem. There are MS SQL SP in my project.And I am taking mssql_bind() warning and mssql_execute() error. But the problem is that I cannot make changes on these SPs. Because these Sp are used by other programmers who are using cold fussion as programming … |
| | I am pretty sure that the VB.NET code is right but I am sure my SQL statements are completely wrong ..can anyone help me figure out my mistakes and as to how the SQL statements need to be framed to get the results correctly from the Access Database ? Thansk, … |
| | Hi I am writing a program that will take in a CSV file and then write it to a database (MS Access). So far, i can create a table, add fields to the table and insert one record. Im inserting the pieces of data one at a time using a … |
| | Hello, I am an intern at my company, and they are pushing me to start learning MS SQL. Primarily, I have been instructed to start learning scripts and query syntax. Thus, I searched for forums that could help me learn SQL and scripting, and here I am registering!. Can someone …  |
| | Edit/Update records in the Access DB Using ASP Hi im trying to update products related to company ID entered in the database each time a product is entered related to the that ID the ID gets repeated as im adding the record in a loop. SO like i got 20 … |
 | I heard that sql injections are causing to our databases by spammers... Can anyone please tel me how it is possible ? And very importantly how to escape from sql injections... I expect more answers from you...And Thanks for those .... |
| | hi guys, im having problems connecting to my database using vb.net and sql server 2k5. below is the code im currently using and it is having problems. please help me solve this problem. Thanks adapter.connection = conn is the one having problems the problem is connection is not a member … |
| | vista home premium sql server 2005 installer help |
| | OK, here's some background. The database I'm receiving an extract from is an in-house call-tracking system. Each call that comes in is assigned a ticket number (TICKET_NUMBER). Each ticket, though, may have several iterations (CALL_LEVEL) based on the number of updates a representative places on the ticket. Each iteration is … |
| | Hey All, i'm having real trouble with this. ok, i have a login page where the user logs in. they put items in the cart and then go to addorder from to place order in database. only problem is i can't get it to work. i think the problem is … |
| | Hello Everyone! I just joined the community. I need to let you know up front that I am not a programmer. I am starting the journey by learning VB.NET. I downloaded MS Visual Basic Express 2008. I need to do some straight forward apps such as collecting user input to …  |
| | Does anyone know how i can get a list of the java stored procedures that are inside the oracle database using oracle sql developer? If anyone has used Toad, i m referring to the list of java classes that comes up when u click the Java tab in Toad. Thanx. |
| | how to to "ondelete cascade" command with the phpmy admin? I know how to link the relation between different tables and primary key and foreign keys in the tables but unsure how to put constraints such as "on update cascade" with phpmyadmin...... is it needs to be done just by … |
| | I have written a small code to parse and execute a sql statement but it fails to execute statement if it caontains ['<=','>='.'!=','<>'] how can i make changes in following regex. rawstr = r"""(.*)[( *)?]?([|=|>|<])[( *)?]?(.*)""" string_to_join="([ *]?and|[ *]?or|[ *]?not)[( *)?](.*)[( *)?]?([=|>|<])[( *)?]?(.*)" sql statement ="select name from table_name where … |
| | Hi, I am novice in PHP & Mysql. I am facing a problem when I put a command in Mysql the following error is showng. Please help me to solve this problem. Mysql> create database xx; ERROR 1044(42000):Access denied for user ' '@localhost' to database 'xx' Thanks Susanta |
| | hi frds, we have the problem that we have created a datatable object (table) and want to add (export) this table in sql server any database. i have the destination connection object and the source table i need the way to export this .Tell me how can i do this … |
| | Hello, Right now i am running SQL 2005 server and using Visual studio C# 2008 to program. I sadly have a Windows Vista professional, 320gbhd, 2gb ram, intel duel core processor, The problem is on C# you can attach a database to your program to retrive or import information from …  |
| | ¤ Stored procedure does not allow addition of a record with rs.addrecord. ¤ Database is on SQL SERVER EXPRESS. ¤ An .adp ACCESS 2007 application is connected to it (easier to create/modify objects). ¤ Stored procedure was created with the .adp application. ¤ Any one can help? Thanks JL. ¤ … |
| | Hi All, Here is my question. Is this SQL Compact Edition 3.1 free to Develop,use and distribute it with my application? I have two SQL Compact Edition: One from : [url]http://www.microsoft.com/downloads/details.aspx?familyid=E9AA3F8D-363D-49F3-AE89-64E1D149E09B&displaylang=en[/url] And another from : [url]http://www.microsoft.com/downloads/details.aspx?FamilyId=85E0C3CE-3FA1-453A-8CE9-AF6CA20946C3&displaylang=en[/url] Help me which one to use and which is free as mentioned above as … |
| | Hello, I have been searching everywhere to find out how I can save a picture from a PictureBox into SQL. Someone told me the best way to do it, is to convert it to a binary file and save it like that. This is what I have, it probably makes … |
| | hiiii..i am using asp.net 2005 in VB language and sqlserver 2005..in my form i am using 2 dropdownlist boxes..if i select a name in the dropdown list box1 then the corresponding last name is selected in the dropdwon listbox2...till now everything is working fine,,,now if i want to change the … |
| | |
| | Hey guys, I've gotten hold of a MS SQL Developer edition, installed it completely, now running off the HDD. However when I go to Start> Programs> MS SQL Server 2005... I only get these options: Notification Services Command Prompt SQL Server Configuration Manager Error and Usage Reporting Surface Area Configuration. … |
| | hi all, how can we have a select satement in an SP?(i want to return a result set from the SP). i want to migrate from SQL Server to MySQL and i don't know what to do with these SPs. it can be done in MySQL client, but it gives … |
| | im Indian a novice and in php. I installed the wamp server2 that has the apacheserver,phpmyadmin and mysql but when I try to connect mysql through PHP code a error message is comming so I cnat connect mysql. can someone help me. Thanks Susanta |
| | Hi I have a prob with my code. This way I get to see all the fields in table1 in the grid view but they hold no values! :( if u can help me make changes in this code..it will great! Imports System.Data.oledb Public Class Form1 Dim con As OleDbConnection …  |
| | I have this Insert Statement code in C# window application.... String MyString = @"INSERT INTO tblUsers(userID, Name, Position) VALUES('a','b','c')"; how if I would like to give values from a textbox: //Please correct this code because it is not working.... String MyString = @"INSERT INTO tblUsers(userID, Name, Position) VALUES('"txId"','"txtUser"','"txtPosition"')"; I need … |
| | Hello! Please I need your help on this part. I've just developed a vb6 program and ms sql express as backend. I setup the ms sql express in a pc working as a server (windows xp). And i also installed the vb6 program on the same pc. I setup also … |
| | hai all Good Morning. I am trying to show a OLAP Report created (using cube in SqlServer 2000) in crystal reports in a asp page. i used smart activex viewer for this but the data alone in the crystal reports r shown. the drill down structure does not appears. Also …  |
| | I have already connect my SQL database in C# windows application, Now, can somebody please give me sample codes for data manipulation, add/edit/delete of records....THANK you! |
| | Please correct me if there's something wrong with my codes...It already have SQL Database connection and I successfully display my record from the database.... Please help me...here's so far I have...I need codes for data manipulation adding/edit/delete records....im using C#Windows Application THANK YOU...you're a big help... using System; using System.Collections.Generic; … |
| | hi i am just starting with vb.net and have set a connection to an existing access db that i have and am able to get the data displayed on a form. my problem lies where as i want to setup a basic search. i have added a query to a … |
| | How to write a procedure which takes integer N as its IN parameter and print a number series (up to N) in the Following format. 1 2 2 3 3 3 4 4 4 4 : - - - N N N N N…………N  |
| | Hi I have a form and I have a list of checkboxes I am trying to check 2 or all of them and get them to insert into one sql column in my database. When I select them it submits ok but in the cloumn on the database is storing … |
| | Hello All I am Using sql2005 My Doubt is How To Format Numbers in Sql Query Like Format(NOS,"0000") in vb ie I have Table Tbl1 Fields Nos1 Datatype int values 1,2,3,4,................1000 When Simple Query Select * From Tbl1 We got Following o/p 1,2,3,4 But I want Out Put Like below … |
| | Please help me with this CODE. What I want to do is to update the existing data in my database. Imports System.Data Imports System.Data.SqlClient Imports System.Data.SqlClient.SqlDataReader Imports System.Transactions Imports System.Collections Imports System.Collections.Generic Public Class SelectStaffManager Const strConnectionString As String = "Server=(local);Initial Catalog=VideoClub;User ID=sa;Password=" #Region "SQL Statements" Private Const SQL_SELECT_STAFF As … |
| | Does anyone know a way in which I can execute PL/SQL statements in a VB.NET program? Any input is appreciated. Thanks. |
| | Hi frds, I want to add msc dynamically in my application. Does it is possible? If yes then plz provide help . thanks in advance. |
| | can any one Suggest me a good E-BOOK for SQL server 2005??  |
| | Can someone help me convert this SQL SELECT statement to ASP.NET code (if possible): [code] SELECT * FROM tblCategory RIGHT JOIN tblInventory ON tblCategory.categoryID = tblInventory.categoryID WHERE (((tblInventory.type)=[strSearch])) OR (((tblInventory.country)=[strSearch])) OR (((tblInventory.date)=[strSearch])) OR (((tblInventory.eventSeries)=[strSearch])) OR (((tblInventory.grade)=[strSearch])) OR (((tblInventory.comment)=[strSearch])); [/code] I'm trying to use it as a SelectCommand. |
| | Hi, I would like to know if there is a way to link to a sql table, but not be able to edit it, the table is part of another program data and I just want to look at data, maybe copy to spreadsheet. I figured out how to get …  |
| | hi friends... can anyone tell me how to do this task. in a vb form i should input a sql query and should get the output. how to do this???? plz help me  |
 | How could I put the following sql statement into a php variable? [code=sql]load data local infile ".$filename." INTO table testtsttbills FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'(account,service,date,time,timebandtype,destination,callednumber,mins,airtimecharge,tollcharge,amt,privatenumber)[/code] when I tried to putting it in the variable...it's showing not working because it recognizes the double quote in …  |
| | I need to create a query of records in one table along with a count of how often those records occur in 2 other tables and the difference between the counts. |
| | Hi Guys I have a List Box ("LISTJOBTYPE") and so the User can select more than one Item: Junior Stylist Hair Stylist Senior Stylist Principle Stylist In my database I have the following: APP_NAME Jack APP_JOBTYPE Hair Stylist, Senior Stylist APP_NAME Jill APP_JOBTYPE Hair Stylist This is my SQL: SQL …  |
| | Hi people I'm pretty new to this and I was wondering what c# code you would put into the button event handler to allow the person who presses it to browse for an excel file then use that data to populate the sql database that you can make using visio … |
 | Please help me i try to display all instances of SQL Server in a combobox. Any help is greatly appreciated. |
The End.