[microsoft:sql-server] Forum Topics

[CODE]Private Sub frmCust_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load dbSource = "Data Source=xx-B4C521B850\SQLEXPRESS;Initial Catalog=TT;Integrated Security=True" con.ConnectionString = dbSource con.Open() da.Dispose() sql = "Select * from Cust" da = New SqlClient.SqlDataAdapter(sql, con) da.Fill(ds, "Cust") da.Update(ds, "Cust") con.Close() MaxRows = ds.Tables("Cust").Rows.Count inc = -1 End Sub [/CODE] if after …

Good Evening All I want to create a unique value for my User in Silverlight and access this value on the asp.net page that is part of the silverlight website. So i cant use cookies because they wont work and i cant do the client site cookie thing because it …

hi there, i have a project which is build in visaul studio 2008 with the database used the mdf file. how can i keep the mdf file in a local network so that everbody can access if from the application. how can i do this. i want the mdf file …

Hi guys. I am an IT student currently 3 days into my work placement which is the mandatory 3rd year of my degree course. I am working for a charity in England and my first task is to transfer data from excel sheets to a microsoft sql management studio database. …

hihi... anyone of you know how to create a auto generate data which can recycle the data after 30 days , i already have a primary key and it is identity specification. Bascially i am doing a web service and gridview consume the data and i need this auto generate …

I have made the mistake of adding a large amount of comma separated data to a specific field in a certain table without adding spaces between each! (Stupidly didn’t realise the associated application requires spaces!) Now I am trying to create a query that can add these spaces in automatically …

I have two tables, Episodes and Seizures, with their respective Forms. On Episodes, I have a button the user clicks to open the seizure Form and its internal working is below. The problem is when the form is opened and filtered by parent form, the seizure form instead of filtering …

Code Giving Error is Given Below, and Error is 1) Make Sure your method arguments are in right format 2) When converting a string to DateTime, prase the string to take the date before putting each variable into the DateTime Object [CODE] using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; …

So for my website I'm trying to have a page where the user can type in literally anything and the page would output a list of stock symbols that are close to the input. Anything unrealistic (e.g. 3548 random letters) would obviously not work but if the user were to …

I'm having problems with my query below. Basically I need to calculate the feet between two gps coordinates. Basically once I can get this formula completed instead of manually entering the data I'll use a temp table and then select the top 2 rows and then delete these and keep …

hey acctually i want to retrive data from text file nd save it to sql database bt i just have to implement some conditions like if there are 3 entries exists in text file with the same ID but i just have to get only 2 of them so in …

Hi, Does anyone know how too solve this: I want to delete a row from database and I keep getting this error: [B]The ntext and image data types cannot be used in WHERE, HAVING, GROUP BY, ON, or IN clauses, except when these data types are used with the LIKE …

I have an event handler that is failing with an SqlException [icode]'{"Procedure or function 'SetClientEmail' expects parameter '@OldEmailAddress', which was not supplied."}'[/icode] However, the code for the SqlParameter '@OldEmailAddress' is no different than that for the other SqlParameters I am using, both for this command and for others I have …

Hi, I am a noob in C#, web development database knowledge. Hence, some of my terminology may be wrong. So please correct me wherever possible. One of my projects at work requires me to read information from a database (I have a connection string and command text) and an internal(intranet) …

Hello Every one , I try to make program .. which have to Gridview one contains all Data in the Databasae and another is contains some of these data and I try to compare between this Two GridView and show that gridview1 is contains the data in gridview2 by change …

Overload resolution failed because no Public 'Add' can be called with these arguments: 'Public Function Add(text As String) As System.Windows.Forms.ListViewItem.ListViewSubItem': Argument matching parameter 'text' cannot convert from 'DBNull' to 'String'. 'Public Function Add(item As System.Windows.Forms.ListViewItem.ListViewSubItem) As System.Windows.Forms.ListViewItem.ListViewSubItem': Argument matching parameter 'item' cannot convert from 'DBNull' to 'ListViewSubItem'. this is my …

I have been assigned a task to develop an online store.I am facing a problem at the time of insertion of records into SQL Database. I am using Type4 driver. The name of the DNS is SQL. here is my servlet code [CODE] protected void doPost(HttpServletRequest request, HttpServletResponse response) throws …

hi guys this is just a simple question i want to know how to store images in database here is my code that i used so far: [CODE]Private Sub btnOpen_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnOpen.Click OpenFileDialog1.ShowDialog() txtimg.Text = OpenFileDialog1.FileName PictureBox1.Image = Bitmap End Sub Private Sub …

I have varchar value 4890 And i am casting it to decimal and dividing by 100000 Its output is 0.0489000 But when i calculated the same on calculator it gives 0.04890 And i think it should be 0.04890 Please help me out Thanking in Advance

Evening, ive sucessfully managed to connect to a local copy of sqlserver via c# and input data into an existing database. Unfortunately im not too sure how to connect to the server and then create a database. Im assuming its possible?? If someone could point me in the right direct …

hi i have a drop down list where i select an employee id, once i click the button i want it to populate the Rate text box with the rate which matches the id from the table in sql. i have this so far but not sure if i have …

hi i have a drop down list where i select an employee id, once i click the button i want it to populate the Rate text box with the rate which matches the id from the table in sql. i have this so far but not sure if i have …

I wanna develop a fingerprint application for school project with sql server as backend. I have seen SDK's for Msoft fingerprint reader. I liked Gruila's SDK but it is very poorly documented and their discussion forum is dead community. I want to know how to initialize controls, save image and …

Hi, I wants to read data from a datatable, but after I executes the program it does not output anything. Can help me check what is the problem? [CODE] string SQLStr; string output=""; SQLClass Access_Db = new SQLClass(); AccessDbCmd AccessDb_Cmd = new AccessDbCmd(); try { Access_Db.OpenTransaction(); Access_Db.BeginTransaction(); DataTable myTable = …

Hi experts, I am trying to figure out code working for an auto testing as follows: (in C# code, SQL database used) 1. Check whether database (having credentials) is working fine or down? 2. If working, run a select query in it & check for succesful execution. 3. In any …

Hi I want to figure out a way to update multiple rows that depend on a couple of variables. I don't really know the syntax in SQL, but I know what I would do in C, so maybe if you could translate this... [CODE] switch (x) case 0: switch(y) case …

Hi folks, this is my first post in danniweb, please excuse me if I am in the wrong place or the thread title lacks self explanation. I am very disoriented in the field since im new in MS SQL. Before going into the problem, I'm going to give some context: …

I am debugging this error on my dataset table.I dunno what error is this should called.I calling store procedure then return to me this error.When i run in mssql is showing fine.But debug in C# ,1st table is showing fine but 2nd table is showing error mark in all my …

hi.... im getting this error "Syntax error converting datetime from character string" when im trying to insert values into the table in sql server 2000....here is hw my code goes... insert into vw_student(RegNo,StudID,StudName,FathName,Sex,DOB,Department,DOJ,Yr,ContactNo)values('0001','1101','Abilash','Ramankutty','Female','1989-02-03','B.com','1styear','2006-06-16','90451299098') pls help me in solving dis....

Hello, I'm writing a web application where I want the user to be able to configure settings of the web page. So lets say, I want to store several settings of how he can visualize the page,for instance in Facebook I can save which people can access my profile, which …

Hey All, I have built a client-server application with vb.net 2010 and sql server 2008. Now, I want to upload images of employees from registrar's office to the server. It is easy to do it with web-applications but not here. How do I go about it? I need a start.

Hai, I used a table for generating grade for students. for thati used the fields: UpperBound[int] LowerBound[int] Grade [varchar(50)] I have some datas such as : UpperBound LowerBound Grade 61 70 D 71 80 C 81 90 B I sent the value 80.09 to Stored procedure. Stored procedure something like …

hi, I wants to do register function in window form application microsoft visual studio 2008 and insert the data into microsoft Access 2007 table by using C#. Below is my codes: [CODE] SQLStr = "INSERT INTO RegisterEmployee(EmployeeName,Password,Gender,ContactNumber)" + "VALUES ('" + SQLStrCmd.ReplaceStr(nameReg.Text) + "', '" + SQLStrCmd.ReplaceStr(passReg.Text) + "', '" …

i have an interesting question for you guys. [CODE] SELECT S.SCHOOLID AS [SCHOOLID],S.SCHOOLNAME AS [SCHOOLNAME],SP.PHOTO AS [PHOTO] FROM SCHOOLPHOTO SP INNER JOIN SCHOOL S ON SP.SCHOOLID = SP.SCHOOLID WHERE S.SCHOOLID IN (SELECT SCHOOLID FROM #SCHOOLS) [/CODE] the Photo Field is an Image Datatype Field, i now you can use them …

hi guys i am wondering if anyone can direct me to a beginners tutorial on creating crystal reports that are specifically based off the sql server compact 3.5 database in visual studio 2008? most of the examples i can find are all related to Sql Server Full..or Access..ect. i have …

I have a table for Account Transaction. For each transaction a user must select a transaction category. These are stored in a second table which has a categoryID, description and a text box with only two values {'Income', 'Expense'}. Now in the report, I am grouping by Income/Expense. However, I …

when i try to use a sql sentence i juts get this error: An attempt to attach an auto-named database for file C:\Documents and Settings\User1\Desktop\aweb1\User\App_Data\ASPNETDB.MDF failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. now i am stucking …

Hi, I have a problem with asp.net insertion data in SQL data base. I am using SQL Express with ASP.NET 4.0. I had written the code correctly and it was working fine as well, but now it does not insert the data in the database. It started behaving abnormally when …

i have a project..i need to search the user info,, the search by cbo has this items : Finance Name Address Finance Type when i click the search button the data from database should load into the data gridview in the middle when i select one data it must be …

Hi All, I am using VS05 + Web application + C# + Crystalreport + SQL SERVER In my application i am using crystalreport.My report runs fine.I created almost 150 reports. Now my client wants to change the image on the report,which is a tedious job. Now I want to save …

Hi I am trying to update my database based on the selected values in two comboboxes. Combobox1 = Manufacturers Combobox2 = Orderlists In the App the user selects a manufacturer and then an orderlist and then presses Ok button which updates the default orderlist for the manufacturer. I am having …

hi every one, I m tring to make on webapplication with PHP and MSSQL2005.This simple website has some report and chart those r dynamically update from my MSSQL db.I m using fusion chart free for charting. I have used this codes for report.[CODE]<?php include('DBConn.php'); include("FusionCharts_Gen.php"); $link = connectToDB(); $stmt=mssql_init("AreaWiseMonthlyRpt", $link); …

I am new to SSRS, I need to to know basic concept of SSRS in PPT. Kindly help in this. Thanking in advance

Hi everyone, I'm having a bit of trouble figuring out what to do here. Basically I have 3 tables shown below User Table [CODE] ID Firstname Lastname etc.... 1 James Hay 2 Someone Else [/CODE] Permissions Table [CODE] PermissionID UserID 1 1 2 1 2 2 3 2 [/CODE] Permissions …

I'm designing a new intranet system but the requirements have changed and I've now been asked to make it more scalable and to allow any content to be integrated into the site seamlessly. Currently, the site is very simple using the IIS URL Rewrite module (basically the IIS answer to …

I have a table called UpdatedFigures with the following headings: ProductType, Month13, Month14, Month15.......Month24. Under each month there are numeric values and under Product type there is a row for ProductAlpha, ProductBeta and ProductGama. Each Row is populated with eh numeric values from the months. I have a separate table …

Hello ..... I writing sql statment on access 2007, all what I need to do is to get the max value of a column depending on the max of another column.. an exmaple of the data is as below: Invoice No-------- Document no--------Document Date-----Value 1001115600188757 /// 5100002019//////13/12/2010////////-30469.50 1001115600188757 /// 5100002018//////13/12/2010////////30469.50 …

Right, I basically want to develop some desktop-based software in c# .net that will execute simple queries on an sql database. I currently deal with this problem in my job, but it's all web-based, and I wasn't responsible for setting up the database and data context - so as you …

Hi, I am unable to run my c# application on a different computer other than my own computer. I have an attached mdf database file in my project. I have 'SQL SERVER 2008' as pre-requisite in the setup project. The application is installing & running fine on my machine, but …

Hi everyone, I have a stored procedure which takes 2 integer parameters and returns either a 1 or a 0. It's quite long so I won't post it here unless you feel it's nessesary. Currently I have a table named 'Books', a table named 'Filters'. Each row in 'Books' has …