[microsoft:sql-server] Forum Topics

Hey.. I have a form consisting of datagridview and two buttons of update and load all.. I have used fillby method to obtain data from database. The query seems to be working fine, except that the data is not shown in the gridview. As in, for the qeury, if the …

I want to create menu structure from a database. For example, the database is the following: id name parent 1 x null 2 y 1 3 z null 4 a 3 5 b 2 The result should be: -x --y ---b -z --a Now, the algorithm I have on mind …

I have a stored procedure. This proc returns some data that needs to be put in an excel format. Is it possible to create a excel file to have the result of a select statement from the database? please help me out. Thanks

So heres my code: using (SqlDataReader reader = cmd.ExecuteReader()) if (reader.Read()) SearchingDate = (DateTime)reader[0]; The third line of code is where im stuck. In my app, im trying to compare the current datetime against the value of a members date column value. Unfortunately, the third line of code sets the …

I'm using this to match a phoneNumber that is 10 characters in lenth. Is there a cleaner way to write this? [CODE]select * from a where TelephoneNummber not like '[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]'[/CODE]

NEED HELP~! Does anyone know how to import exel data into sql server using vb.net? I want to create a openfiledialog and allow user to choose which exel file to be imported into the server. Thank you so much~~ >.< PS. I am just a beginner of vb.net. So would …

What's wrong with the code, pls help: setCon adoJOReport adoJOReport.RecordSource = "Shape{Select SUM(Cost) as SC,SUM(Price) as SP,Brand From Temp_JOMaster Where JoNumber='" & txtJO.Text & "'Group by Brand} " _ & "Append ({Select * From Temp_JOMaster " _ & "Where JOnumber='" & txtJO.Text & "'} Relate Brand To Brand) As Command2" …

Hi I have a MS SQL db script, I have the same temp table declared more than once. I keep getting this error: There is already an object named ????(question marks are representative of table name) in the database. the following resembles what my script looks like. [CODE] IF OBJECT_ID('tempdb..#table123') …

Hi All, I'm running an application in VB.NET 2003 that loads huge amounts of data into a sql server database ( a conversion project) When the application has run for some time the windows form freezes and displays a (Not Responding) message in the title of the form. In the …

Hi I would like to know how one can create reports in Vb.net using sql server 2008 Thanks

Hye, I had a difficulties to insert the data in vb.net into sql, I had try few times, but it seems the data can't be read in the database, I hope anyone could help me :(

i want to create a table where i can input data in it when the form was runnig and when the button save was clicked it will pass the data being inputted .. to the sql server. what tool should i use to do such thing.

can any one tell me to find out the list of databases that have “.ldf” size greater than “.mdf”.

Hello, I'm using MySQL for a database containing 1 table with 10 columns. The point is to get a view of a few columns and use it in a web application So, I need 2 columns from this table - Pad(varchar) and Sequence(integer), then I create 8 views like this: …

[CODE]UPDATE table2 SET table2col1 = table1.col1, table2col2 = table1.col2, ... FROM table1, table2 WHERE table1.memberid = table2.memberid[/CODE] will the above query help me to update fields from one table to fields in another table base on a common id between the two tables?

Hi I have a issue that my application in currenlty doing number validation with an issue. I have a query that checks number is stored procedures but need more checks. [-d0-9] and checking that the lenth is 10 characters, all that is working as it should. The issue I'm having …

Hi all. I am trying to create a search that displays 3 columns. Analysis, Amount, Amount of Positiv results I have nailed down Analysis, Amount, but have problems displaying Pos. result. [CODE] SELECT DISTINCT SP.ANALYSIS AS Analysis,COUNT(SP.ANALYSIS) AS Amount FROM SAMPLE S INNER JOIN SAMPLE_PARTS SP ON SP.SAMPLEID = S.SAMPLEID …

Hi everyone; I'm working on a c# service that queries the DB and checks if the right info is available for users. It's an Airline tickets reservation system. I am not sure why my code is breaking after it gets the query and it gives an error about sqlclient.. [CODE] …

Hello I'm new to sql (sql 2000 database) and i'm trying to get two simple things. I have two sql queries that i run in order to display a result and to update another one. The queries that i run in sql query analizer are: 1. select memb_guid from MEMB_INFO …

hello, i have a problem with combobox to stored in sql database this is my code cmbDept.Items.Add("" & dtUser.Rows(i).Item(0) & "/" & dtUser.Rows(i).Item(1) & "") how to take the first item from combobox "dtUser.Rows(i).Item(0)" and stored in sql database. ??

I am creating a DataReport using the Data Report Designer (VB6) and using the following SHAPE command to create a hierarchical recordset. Dim cmd As New ADODB.Command Dim rz As New ADODB.Recordset With cmd .ActiveConnection = CN .CommandType = adCmdText .CommandText = " SHAPE {SELECT * from Relation where Institution …

Hello all, I used to be relatively well versed in .Net back when 2.0 was still the latest framework and I have stayed out of the loop for a few years. Looking to kick in a new pet project, I am interested in developing in Visual C# / SQL again. …

I'm trying to save data from textboxes in visual studio using vb.net to sql server 2008. the coonectiong is working perfectly but is not displaying the data output in data grid. This is the part of the code. [CODE] Imports Microsoft.VisualBasic Imports System.Collections.Generic Imports System.Data Imports System.Data.SqlClient Imports System.Text Dim …

hello i have 5 text boxes and labels and database in sql server so just need coding for the next and the previous button any one can help please thanks

Hello I'm doing a mini project of student management system. i need to take the attendance of all the students and store it in sql server. plz help me i need to submit my project on 25th of this month. i am left out with only this form :( or …

Hi all, I am attempting to connect to a MS SQL Server Express Edition with Advanced Services (MS SQL10) on a remote Windows NT 5.2 machine on the LAN. My driver is [B]net.sourceforge.jtds.jdbc.Driver[/B] My url for the connection string is [B]jdbc:jtds:sqlserver://127.68.0.201:1433/LOD[/B] My user is [B]d[/B], password is [B]d[/B]. Now, when …

Hello, I need to connect to a DSN on a remote computer. I have found a lot of a lot of info on how to connect to a remote database from a local DSN, but nothing on connecting to a remote DSN. I am using asp.net, but help on solving …

Hi, Here's the code of my listview,.It's already working well. It have a search box in my form, then if the use type in the search box, the result will display at the listbox. Now, what I want to do is when I choose an item in the listview, the …

[CODE] Imports System.IO Imports System.Data.OleDb.OleDbException Public Class Form2 Inherits System.Windows.Forms.Form Dim inc As Integer Dim MaxRows As Integer Dim con As New OleDb.OleDbConnection Dim ds As New DataSet Dim da As OleDb.OleDbDataAdapter Dim sql As String Dim username As String Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) …

Hi I want to load data from a flat file into a SQL table. The file has a header row and detail rows, all of which need to be loaded. I've tried various suggestions I came across in forums and EndOfStream is the one that loaded all the rows. The …

Hey, I new in MS SQL I got one question don,t know how to solve..? Display code, name, place , total contract quantity for top 10 buyers how to write in MS SQL/...?

My web application has the ability to process data from word docs and PDF files. We recently had a client who attempted to run files that are of a significantly larger size than anything we tested with. 50MB-500MB PDFs compared to our test files of 1MB-30MB files. If they don't …

Hi, can anybody, please help me out. [CODE][B]select * from log where id <='%07%' [/B][/CODE] Am facing the syntax error, what is the actual query? my id look like this: 1.mtg10kl 2.mtg07kl 3.mtg06kl 4.mtg09kl I need the output this: 1.mtg07kl 2.mtg06kl please help me out .thanks in advance

So this is my problem my fellow programmers: In my C# app, I have one button and a datagrid that is showing info from a sql table. Everytime I add a person into my datagrid, the data replicates instead of updating certain columns for that member. I need to somehow …

this thing is getting into my nerves and i really don't know what to do.. i tried a lot of variations in my code and even sql statement but still nothing happens.. i really need to do thing messed up project of mine and put all my efforts here.. but …

I'm sorry if this should have been posted in the c# forums..... I have created a database for my website and am using MS SQL. This database will need to be accessed by users on the site itself, and from a .NET application. I am comfortable using MS SQL through …

i have an existing database and i want to attach that database one time to sql server and when thee database is attached then it open that database

I want get smaller number of Qty from select record in datagridview. after that insert to another Table. For Example, datagridview A got 5 record with same PONO, when I move these record to datagridview B, they will become a summary record and 5 records become 1 record. like picture …

I am pretty new to C#. I am a Borland c++ developer and is used to "newing" and "deleting" objects programmatically. I understand that with C# the garbage collector is responsible for the deleting of objects. It seems though that I have a memory leak. I am developing a SQLServerDBInterface …

Hi friends... I have a variable $datetime= 140811 060632. Here 140811 represents date in ddmmyy format and 060632 represents time 06:06:32 and both are in string type. I have a column name "DtTime" in MSSQL of type "Datetime" stamp. Now when i try to insert my variable $datetime in above …

i am a newbie so bare with me.. can anybody help me solve this prob. input string was not in a correct format this is my code... i can figure out what wrong with this .. [code] using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using …

Hello:), I am returning to a theatre ticket booking project after about three months and trying to get my head around how to show the prices in a list box (lstTotal). I have three radio buttons three for three ticket types. Adult Full Concession Friend When one of these is …

I'm attempting to create a program where the login and password will be verified on an SQL database of user information. I keep getting the error "SQL Execution was unhandled" I marked the code that was causing the error in red. I'm using Visual Studio 8. Keep in mind I …

Hi, Guys i have an xml file containing near about 6,000 thousands questions in rtf format while inserting these questions into sql server it will give me an error, 2500 records inserted successfully .......... but from that point it will show error, [COLOR="red"]The CLR has been unable to transition from …

I'm attempting to create a program where the login and password will be verified on an SQL database of user information. I keep getting the error "SQL Execution was unhandled" I marked the code that was causing the error in red. I'm using Visual Studio 8. Keep in mind I …

Hi , i'm doing a project which invovles time and attendance management. When i download datas from the biometric reader , i got the records in the following format, empCode date time 5001 12/09/2011 09:05:34 5002 12/09/2011 09:33:13 5001 12/09/2011 13:05:53 5002 12/09/2011 13:22:24 5001 12/09/2011 14:05:22 5002 12/09/2011 14:33:53 …

I have one Access Database and in one of the column I need to store image file, how can I do that? Can anyone help me. I know how to do this is MS SQL Server Database but not about Access Database.

Dear Sir, I want to silently instal SQLEXPRESS 2005 it is not working.... Please reply...becs i want to install SQLEXPRESS 2005 through my application... The command line used by me is "START /wait sqlexpr.exe /QS /ACTION=Install /IACCEPTSQLSERVERLICENSETERMS /ERRORREPORTING=0 /FEATURES=SQLEngine /INSTANCENAME=MSSQLSERVER /BROWSERSVCSTARTUPTYPE=Disabled /SECURITYMODE=SQL /SAPWD=123 /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" /SQLSVCSTARTUPTYPE=Automatic /TCPENABLED=1 /SQLSYSADMINACCOUNTS=".\User" ".\Administrator" /AGTSVCACCOUNT="NT …

i want to search name form table but problem is tha when some one write query it also give value by this any one can delete my data to pls tell me a way to remove sql injetcion [CODE]protected void Button2_Click1(object sender, EventArgs e) { //SqlCommand cmd = new SqlCommand("DELETE …

hi, i have a question in C#.net report viewer. i want to create a report which will take a user input and generate a report. what i want is get the month from the user input and get it as a parameter for the sql query go get the result. …