6,934 Topics
 | |
| | Are there different SQL extensions? What are the extensions for Data Mining and Warehousing? |
| | VB.NET:i want to select data from sql server 2005 DB table and displaying into text box that depends on combo box selection using VB.NET |
| | Can anyone tell me what is wrong with this code, i am trying to add information into a gridview from a sql datbase, thanks SQLSearch("SELECT * FROM engineerissues WHERE EngineerNumber = " & cmbRepTyp.Text) RS.AddNew() Dim dgvRow As New DataGridViewRow Dim dgvCell As DataGridViewCell dgvCell = New DataGridViewTextBoxCell() dgvCell.Value = … |
| | In my database I have a field date and eventname.I want to retieive eventnames after the current date.How can I do it?  |
| | If I build an application using BS 2008 in C# that uses an SQL database, Do I have to include SQL Express as part of the deployment package? In other words, does the user need SQL Express on his/her machine in order to use my application if my app does … |
| | [code]using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Data.SqlClient; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; namespace CarsRUS { public partial class Cars : Form { private SqlConnection conn; private SqlDataAdapter daAddresses; private DataSet dsAddresses; private DataGrid dgAddresses; private const string tableName = "CarRUS"; public class Customer { … |
| | I am building a site for my hockey league. I have been dealing with CF for a number of years, but would in no way class myself as any sort of expert. I am not sure if I am just having a brainfart, or what with this one! I have … |
| | what is the differances with SQL tables and relation modelling? |
 | I get the following message when executing a stored procedure. [COLOR="Red"]The query has exceeded the maximum number of result sets that can be displayed in the results grid. Only the first 100 result sets are displayed in the grid.[/COLOR] However , i cannot change the fact that the SP uses … |
| | PRACTICA EXAMPLE FOR Scheduling Jobs in SQL Server 2005 |
| | i hv to save some data in my sql table .. bt there is same prblm in my coding.. will you tell me the correct coding for this problem?? |
| | Hi,,, we have a database grown too fast... from 19GB last march 09 into 52GB this Nov 09... I search through internet on what happen why do database grow fast and i find nothing,, i found out on how to "sp_spaceused" query and the result says: database_name database_size unallocated space …  |
| | Hi to all I am working in ASP.NET. I need to fetch an Advertisement Message from Database into JavaScript Variable. For example [CODE] <script type="text/javascript" language="javascript"> function ShowMessage() { var msg; msg = [COLOR="Green"]//Here Get from Database[/COLOR] alert(msg); } </script> [/CODE] How can we do that? Thank You |
 | hi every one, i need your help how to upload and download any file type to/from sql DB (sql server 2005) using c# windows form application i need to upload and download image type and doc type or pdf type or any else type . i need these types to … |
| | Below is an extract from my code.. 1) insert code works fine, then.. 2) retrieves inserted record ID 3) then it SHOULD update the status of the performance with "booked" But it doesnt seem to update.. any ideas? [CODE]<% sql="INSERT INTO bookings (performanceID, customerID, bookingDate)" sql=sql & " VALUES " … |
| | VB.NET:i want to select data from sql server 2005 DB table and displaying into text box that depends on combo box selection using VB.NET |
| | Is this the right place to ask the following? I have 2 tables in two different MS Access DB's. Access allows the ability of inserting data from DBA.table1 into DBB.table1, using the format [dba].[table1].[dbb].[table1]. Here's my problem. Using a single SQL Statement I can't figure out the following. DBA.table1 has … |
| | I need a way of adding data to a database using my delphi form i can handle the sql to add data to a database on ms access but i just do not know how to do it through a delphi form. In other word i just need to know … |
 | hey, I'm working on a project, where I need to save data along with the image in Sql server, using Vb 2005. i just need the code for the above one. please post asap need it urgently. |
| | Hello friends, i m trying to input user : scott and pass : tiger also trying user : system pass : manager but even though its not going to start. i m getting following error [QUOTE]SQL*Plus: Release 3.3.4.0.0 ERROR: ORA-12154: TNS:could not resolve service name Enter user-name: Enter password: ERROR: …  |
| | HI guys I am just started learning SQL server. I have installed sql server 2008 in one laptop (call it 1) and it is connected to internet now [LIST=1] [*]i want to access it from another pc which is connected with 1 via WAN. [*]and how to connect to sql …  |
| | when I try to create a new mail account in my mail broadcast control center I get this message: SQL error: swd_act : ERROR: 1146 - Table 'craftyartsalesmailcatcher.swd_account' doesn't existContent-Type: text/html; charset=ISO-8859-1 SQL error: INSERT INTO swd_account (`isact` , `name`) VALUES ('1' , 'swd_act') : ERROR: 1146 - Table 'craftyartsalesmailcatcher.swd_account' …  |
| | Hi, I have a question regarding a SQL query. I am a complete noob, so please do not make fun of me. Here is a schema that I created: [code] JOURNALS(j_num, j_name, j_subject_area, chief_editor_r_ssn) ISSUES(j_num, i_num, i_date, i_num_pages) RESEARCHERS(r_ssn, r_name, r_address, r_phone, r_institution) ARTICLES(art_num, art_title, art_area_topic, art_abstract, j_num_submitted,date_submitted, j_num_published, i_num_published) … |
| | Hi, I am not sure about how to solve the following task: I have a number of distributed PCs each with MS SQL server and a database. I need to maintain the databases (schemer changes, table changes, F. key changes etc.). I have a main sever where I maintain the … |
| | i am trying to make a page that able to search the data that store in the sql database, i would like to have a field search which enable the user to choose the field they wan to search. the problem i facing is i dunno how to submit the … |
| | Guys please help me. I am kinda new to ASP.net Luckily I've manage log-in using forms authentication so that i could have a customize log-in page based on my Active Directory. Now a Problem arise. I have to connect to my SQL EXPRESS database using the log-in I use. My … |
| | I am new to aspx and sql. I have written some code with vb.net 2005 (visual studio) to do some calculations and poplate some textboxes on my web form. I dont understand how to pass those values to a paramerter then use that value to write to my sql database. …  |
| | Hi, hope you can help, i am quite new to this. I need to know who to write data from several text boxes on a form to a sql database. I have created the sql database on a localhost using myphp admin, i have created the connection in a module … |
| | [I m still a newbie in ASP.Net] I want to create an interface with asp.net for an SQL backend. On the interface i want the buttons to be able to execute some stored procedures. Any Ideas? Or code |
| | Hi guyz, i'm aiming for a php and My SQL dabase website, can anybody guide me plz? appreciate the help:)  |
| | Hi All, I have to convert Excel data to MSAcess .MDB file using VB.NET. VB.NET Code read the Excel fi;le and write ti to .MDB file. For the same I have below code, but I am stuck at the writing it to .MDB file which I have already created with … |
| | i live in Vietnam, so My English is so bad, but i hope you know what i mean. I want to setup a server that use : Apache, PHP, and Ms SQL server persional edition 2000. But i only can connect Apache 2.0 and PHP 5.x it run ok But … |
 | Hi I need a help in SQL,There is table called sales.Its contains the day,sales quantity.If I write sql like below [CODE]select day,Sales_quantity from Sales.[/CODE] Then result should be Day SalesQuantity Monday 20 Monday 302 Monday 50 Tuseday 30 etc.. The problem is I want to get result like below Day … |
| | Hi all... So, I am needing to sum all billable hours within a table... the problem is that it is returning rouded decimals instead... like .5 always comes back as 1 ... Here is my procedure: [CODE] Public Shared Function GetBillableTimeForTicket(ByVal SupportTicketID As Integer) As Decimal Dim conn As New … |
| | |
| | I am trying to write a bulk import routine so that i will be able to import text files or csv files to SQL i have tried this and it's giving me the following error message. P: is the drive where the file is in currently. [CODE] USE [XYZABQ] GO …  |
 | Hello, Is it possible to insert the data from dbgrid component into an SQL SERVER database table. The data that is in the grid is imported from Excel worksheet. It may look silly but I need to insert that data into a table. Any help is appreciated, thank you |
| | I want to calculate average of grades of each student with SQL command but I encounter problem with this code. I have 3 tables related to each other and want to calculate average of student grades. This is my SQL string but it dose not work. What is the problem … |
| | helllllo >>> i have worked on Functions and precuders in PL/SQL for alsmost two weeks until now !! ummm i had some blocks where i stop with >< having no idea how to deal with !!! one of those blocks checks wether a member team is nethier Manager non a … |
| | I have following tables table1 nr_key1 nr_dad1 table2 nr_key2 value (repeated ~n times with same nr_key2 and different value) in table2 nr_key1 = nr_key2 After I have iterated through nr_key1 I want to use recursion to select nr_key1 = nr_dad1 and iterate again table2 with the new nr_key1. This should … |
| | is there a way to caputre the values in a datagrid and bind them to a sql table? I have a datagrid bound to a sql query with some editable cells and I wanted to know if the updates could be sent back to the sql table. is there a …  |
| | |
| | Hi guys, I have created a site where users can upload videos(mp4) and images(jpg & gif). The upload script sends the uploaded file to a folder on a remote server, and the filepath is stored in MYSQL. Can any one tell how i go about playing the stored videos or …  |
| | Hi, I am trying to create a search function on an html page. I have written the page and part of a php page. I trying to get help with the search as there are 3 criteria; So far I have made this search form; (textbox name=searchterm) [B]Brand[/B]: (dropdown name=type) … |
| | Whenever I create a new database from a C# program and create tables for that database, the tables always show up under the creator's default database instead of being listed under the newly created database. This observation is from Microsoft SQL Server Management Studio Express. Is there some setting in … |
| | I need to write a query for the given crystal report. The database tables and the report is attached.Please see to it. |
| | Hello, I want to create database on SQL Server using Javascript and HTML. User will input following data. Server Name, Database name, File Sizes. When I will click "Submit" button database should be created on Selected server with entered name. I am using Client side HTML and Javascript. we need … |
| | Hello New member and pretty ignorant about SQL I should say. I have made regular backups of mySQL database and now that I need to restore it[B] I see all the characters (UTF-8) characters have changed to wierd characters [/B]that make no sense at all. I am using [B]phpMyAdmin's Export … |
| | m using visual studio 2005 and sql server 2005. i want to create a backup of the sql server which m doin using the following code.. [CODE] if (saveBackupDialog.ShowDialog() == DialogResult.OK) { SqlCommand cmd = new SqlCommand(); cmd.CommandText = @"backup database dbname to disk =@loc with init,stats=10"; cmd.Parameters.Add("@loc", SqlDbType.VarChar); cmd.Parameters["@loc"].Value … |
| | I have tried several different things with none providing the correct results. Any help is appreciated. I have the following: Table A Table B Pallet_No Pallet_No Qty Qty I need to return: - All of the Pallet_No's from Table A that are not in Table B - All of the … |
The End.