9,022 Topics
Hey guys. I have a program that does a SQL query and parses the info into a text file. The problem is it misses the first row every time it loops. I know the root cause here is my double use of the read function. I'm hoping to gain some …
I am a newbie with sql and need some help. Question Details: ARTIST.Name Artist.Nationality Transaction.purchaseDate Transaction.SalesPrice... Customer.Name Customer.Phone.AreaCose Customer.Phone.LocalNumber Customer.Name... (The Ellipses(...) refer to the structures that can repeat. Code SQL statements to update this view as follows: a. Change the spelling of Mark Tobey (ArtistName) to Mark Toby. I …
Can anyone help me out with this? SalesPerson Name Age PercentOfQuota Salary Abel 24 63 120,000 Baker 56 38 42,000 Jones 34 26 36,000 Murphy 64 42 50,000 Zenith 45 59 118,000 Kobad 43 27 36,000 Order Number CustName SalespersonName Amount 100 Abernathy Construction Zenith 560 200 Abernathy Construction …
I would like to add a column to an existing table, where the new column would only have running numbers starting from 1. If I've understood correctly, the "create index" command is not the right way to do this, as that's attached to just certain columns to speed up querying. …
I need help I want to updated table(userlogin) in MS-SQL that should synchronize with another database (MySQL) having same table name(userlogin) and also fields. I need code for this.By Procedure,PLSQL or JAVA programming
Hi, I have a table in which there is a field for mobile no. Currently the data in the field has been entered with a dash(-) after the code. eg- MobileNo (this is the field name) ------------------------------------- 1. 6016-2880537 2. 6012-3137200 so there is about 400 records in the table …
Hi! :)))) I have to use sql connection to take queries from user by using textbox structure .How can I provide this .I don't find it anywhere . especially how can I connect sql and textbox structure together I do not know anything about this subject. I know c and …
This is a very important issue to consider when you're using form/url variables in databases. A user can cleverly put in SQL statements and manipulate your db server as he sees fit if you don't take the necessary precautions. I get the feeling that there are several people that aren't …
I have a problem. I hope that someone can help me. I have to do an analysis of an student course registration database. The Case is that I have an database application of a student registration system. Students can enrolll for one or more courses, When they enroll, there will …
Hi, We have schedule a job through SQL agent in which We want to access the data of a specific field from SQL table For example we have a field named interviewDate, we have to compare it with current date. now we have to write a stored procedure to read …
Hi All Ok this is a bit of a doozy for me. Work related question, I have been tasked with sorting out this issue at work, but don't really have much background in this field, but theres no one else in my team that can do it. Bit of a …
Hi! I have to use sql connection to take queries from user by using textbox structure .How can I provide this .I don't find it anywhere . especially how can I connect sql and textbox structure together I do not know anything about this subject.
hi How to Upload PDF, Zip, etc into a MS SQL Server Varbinary(max) then how do I get it back out un corrupt? I have some code which works for jpeg, doc, xls files. However if I upload Zip, mpeg or PDF it does not work. It looks like the …
hi...I've tried to think about this for 2 days but I can't really find the solution. Hope anyone can help. What statement should I write for this:There is a table of Parcel. In the table there are ParcellId and the timestamp. I have to select parcels that have the time …
i have 3 tables Category, CityMaster and Data Next, i Have 2 comboboxes For City and Category. In my Category Table i have Two columns Category and Category ID which is unique for each Category. In my CityMaster table i have 2 columns CityName and CityID wherein each CityName has …
Hi, I need to compare MySQL, MS SQL 2008 and Oracle. Do you know of any link where this comparison takes place? I found a few comparign MySQL and MS SQL 2000 but not with MS SQL 2008 and Oracle too. Can you please help? Thanks Josh
Good day! I am having problem inserting records to sql server. I have ten records to be inserted in database that is stored in an arrays(). When it reach to a value that has a quote or double quotes in returns error. Please help. What will be the best solution …
Well I am a PHP fan, (HAIL OPENSOURCE) Its just so happen I will have a ASP.NET PROJECT, In short I need to run MS VISUAL STUDIO and MS SQL SERVER in my machine together with XAMPP. I just want to confirm first If I will have a problem installing …
Hi everyone, I have a database that looks something like this: [CODE] [B]Name Week1 Week2 Week3[/B] user1 10 15 7 user2 3 24 2 [/CODE] I need to write an sql select statement that returns 2 columns: the Name column and a Total column which totals that users points for …
I was trying to install sql server 2008, and came across a problem. After testing the setup files, I got this result: passed 10; Failed 0 and Warning:1. The warning is for the windows Firewall image. Can someone please quickly tell me how to handle this an continue with my …
Hi guys need your helps. Now i doing the update part for my program. How to i get data from two table after i type the badge id and employee id then i will show other detail in the same form. So how to do that, need to use what …
Alright, so right now I have a GridView on my aspx page. It is set to run a stored procedure, get some data and display it. The parameter for the stored proc is set to come in through a query string. So the sqldatasource atuomatically looks for a query string …
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 I got a error message once ,I read datareader.The error message is"Invalid attempt to read when no data is present". Previously I go this error,coz I missed the sqldatareader.Read() method.once I put the datareader.Read method still I got the same error. String str_string1="select ID,renew,reminder,heading from dbo.StockModifications"; ContractID_Reader2 = db.getdatareader(str_string1); …
[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 …
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 …
Hello, I have a DataGridView that displays all the columns in the DataGridView Column from my database. The problem I am having is that my Row_id column, which is the primary key of the table, will not display the data within the Row_id column. Is there a way to retrieve …
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 …
I would like to get assistance on how to retrieve data from MS SQL database to view it on a listbox.In my db i have two columns.
I have a gridview on my "second" page with a SqlDataSource. The data source is configured to take the qurry string "arg" from the url and run a stored procedure with it. On the "first" page i have a gridview and one collumn is links. Click on this link and …
Hi, I am writing a VB.NET application, and I'm having a little trouble writing to the database (via ODBC). I can read from it perfectly well, but when I send an "UPDATE" command via ExecuteNonQuery(), I get a "System Error". Can someone help Identify the problem, or maybe propose alternatives? …
newbie help needed im new to asp.net (vb) can anyone help me ive written some code (see below) to pull some vars from a string in the url i needed to send these to a mssql database any ideas how i do this, any code would be much appreciated thanks, …
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 …
Hi ppl, Now this is very funny, luk, my company is a small 1, i just completed a project, this is connected to backend (MS SQL). since itis small, my company canot keep a server for the client alone. now, how can i deploy. I tld my MD tat the …
Hi there! I made a backup of my database (MandoTECA) using the following code: [code]CREATE PROCEDURE [dbo].[CreateBackup] @uri nvarchar(MAX) AS BACKUP DATABASE MandoTECA --TO DISK = 'C:\Users\Pedro\Desktop\MandoTECA.Bak' TO DISK = @uri WITH FORMAT, MEDIANAME = 'Z_SQLServerBackups', NAME = 'Backup Completo da MandoTECA'; [/code] And used it a restore procedure to …
Hey Guys, I have a template field in a DetailsView. In this field i have added another SqlDataSource and a textbox. I want to displat the result of the sqldatasource in the textbox. Is there anyway to do this??
Hello, While working on setting up user accounts, I wanted to see if the values already existed in a database to alert the user before submitting the data. While doing this, I came to an issue. The issue is when I went the MS SQL SMS and tried writing a …
I'm in the process of converting two columns in two separate tables... One column in Table A has a hexadecimal number (with a nvarchar data type) i.e. "A5000000020" and converting it to a decimal it should be "11338713661472"... In Table B the column has a decimal number (with a bigint …
Hey all, I have a listbox, textbox, and search button on my form. I am populating my listbox with data from a sql database. I need to be able to seach my listbox and filter it. Here is what I have so far: [code] Sub RefreshListBox() Dim DSDept As New …
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 …
IIS 6.0 Does not log every hit on are web site with ODBC Logging and we find a bunch of errors loged in the Evenet Viewer: [B]IIS ODBC Logging failed to log data to data source HTTPLog.[/B] Event ID: 6 Looked every where for some help have yet to solve …
Hello, Does anybody know if there is a Search Replace function in MS SQL2005 to lets say search for the @ charter and replace it with another character or number in the specified columns? If there is please can you give me a sample. I found the replace function but …
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, there, i am coming up with a dropdownlist that needs to get list from the sql database. the dropdownlist must get its data from the database. i am getting error in this codes: It says that it is not declared. at the same time i can not get the …
hey frnds, I m creating the database at page load,I m able to do dat.I just want to do check that if the table is already existing,then do not create the table.below code create table- [code] using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; …
hi there, i would want to change the mysql to mssql. please help [ICODE]<%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.SQLClient" %> <script language="VB" Runat="server"> Dim blHasRows as Boolean Sub doInsert(Source as Object, E as EventArgs) Dim strConn as string = "server=YourServer;uid=YourUID;pwd=YourPWD;database=YourDB" Dim MySQL as string = "Select * from samples …
Hi, [CODE]I'm trying to allow sorting my gridview writing in the code behind page. My code for Bind the GridView is like this: Private Sub BindMyGridView() Dim DatabaseConnection As New SqlConnection(ConfigurationManager.ConnectionStrings("MyServer").ConnectionString) Dim adapter As SqlDataAdapter = New SqlDataAdapter Dim selectSQL As String = "SELECT * FROM Clients WHERE id = …
Hi I’m pretty new to this so I’ll start at the beginning. I'm trying to run a report on consumption of server disk space in reporting services. I have a view in the data base that has fields ServerName, Drive, Year, Month & AvgFreeGB. In a calculated column in the …
The End.