[microsoft:sql-server] Forum Topics

Hello every body. I'm trying to connect my asp.net website with SQL server 2005 database. I have two copies of my site. One in File system and other one in local IIS. When I try to connect website in file system it is OK. But I am unable to connect …

hi please anyone solve this issue, i had stored an image in binary format from a windows form picture box control using VC#.net, it is stored in a binary format . i don't how to retrieve this back from the database and display it in the picture box. please help …

Hey, Well I go this problem, I'm using ADO.NET to manage my database on a project now the problem is that I need to get the values from an external Binding source and when I click save they will be saved in the database I'm using at that moment; for …

Hi, I have 2 tables that I have made using sql create table which seem to work ok until I try to insert data into the 2nd table then it throws a: didn't add 1 record due to key violations. When I use the design wizard and do exactly the …

First off I am not certified in anything and totally a hack. But I can read. I have no formal training in MS products. I have evaluation editions of SQL SERVER 2008 and Window 7 . I have successfully networked a DC on one server, to an SQL SERVER 2008 …

Hello, I have an access table where I have to import a csv file. I have a very simple code in the Click _ Event Sub. However it seems the code is ok, file gets imported but I get a separate table with errors in import. In that table two …

Hi to all , I am developing website in asp.net2.0 using VB. I wrote sored procedure, [code] ALTER PROCEDURE SELECTSC ( @cid INT ) AS BEGIN SELECT sc FROM collage_detail WHERE c_id=@cid END /* SET NOCOUNT ON */ RETURN [/code] and in vb I wrote on button click, [code=VB] cmd.CommandType …

I need to query a database of application titles and count the instances of each title. I've already got a list<string> of distinct values from a previous query, and now I need to count how many times each value occurs. I'm not sure if the query is correct, or how …

Hello, when i input to database show error cannot convert type varchar to type numeric.. I' m using convert(numeric, quantity). Where my quantity is empty. Please help me. Thanks

I need to query a database of application titles and count the instances of each title. I've already got a list<string> of distinct values from a previous query, and now I need to count how many times each value occurs. I'm not sure if the query is correct, or how …

I want to create a unique ID for a record being entered into a sql server database, in a web application. My logic is to count the number of records in the table, add a one to that number, then add a prefix to the new number. Check that the …

Hello, I have 3 Combos on a toolbar which i need to bind to sql database (using linq). On my form i have several data text fields. What i need to do is this: Combo1 = bind it to a specific linq query that i make that can bring my …

Hi, I'm trying to use datareader to retrieve a column and place the value in a textbox. When I try to assign the value to the text field, I get an error message "An unhandled exception of type 'System.NullReferenceException' occurred Additional information: Object reference not set to an instance of …

I have a table in which I have an auto-increment int ID column. Can I set this column to pad the zeroes at the beginning so as to store them as, say, 0001 instead of 1, 0002 instead of 2, and so on? Subsequently, when the table reaches 10 entries, …

Hi, i have created a window service with multithreading, but getting many deadlocks on sql in one Stored procedure when i start this service,and after that service does not do anything but in idle mode. the details of exception is below. Error :Wednesday, September 23, 2009 2:22:58 AM Method:UPD_CrawlerLastUrl 1. …

Guys, I need your help as I really can't seem to start on this query.I seem to not be able to come up with any logic. I have to create a query for a table. I have two tables in my DB . First one is a book table which …

hello, I'm trying to create a database in SQL Server management Studio for a project. I have created a tabel named Employee and I have 14 columns. I need to set the firts column (Emp_ID) as Primary Key (accomplished) and then generate a unique number for each Emp_ID that I …

1)Frnds tell me that is there any Lock statement in SQL?-Yes or No. 2)In my interview i was asked,What is deadlock??? But i dont know?Can u tell me out? 3)Then they ask me about the Lock.I answer Lock ensures that when one thraed is in critical section ,no other thraed …

Hey Everyone, So after weeks of torture, this things is near completion. We're using SSRS to display the report on the .NET side. However, I'm piecing together the last bits of the SQL query. So, I have three tables. One has names of all these buildings, one has contains reason_codes, …

I am new to this forum and very new to vb.net. The previous programmer wrote a program in vb.net that helps us with our merchandise received transactions. It is now getting the following error: "System.Data.SQLClient.SQLException Timeout Expired. The timeout period elapsed prior to completion of the operation or the server …

i am constantly receiving a 'failure audit' error 18456 state 14...login failed for user 'sa' on my sql 2005 server. this is occurring every 5 minutes. Can someone give me a direction on where to start? I have checked several forums on the web, but none seem to lead me …

Hi All, I'm new to ASP.NET, having knowledge of HTML, VB 6.0. I myself studying VB.NET 2008 & ASP.NET 3.5, though i'm interested. For practical implementation I'm seeking you experts help. Please help me to develop a simple web application. 1. [B]'Student Login form' [/B]has to accept user name & …

I was asked Suppose there is table A in DB,Suppose when we update that table,whose are two tables(Magic tables) that are updated other than table A?

Was just wondering if anyone here is an Access master have this code that I want too add a CHECK too but keeps on throwing a syntax error [code] CREATE TABLE Email ( userEmailAddress memo not null, timeDate datetime not null, contactEmailAddress memo not null, emailBoxType text(6) not null, readStatus …

Hi experts I have a problem for data entry to grid like control. I have a relational database part of my data is for entering grades for each student. (I have a tables with student, courseStuJunc and course names). I want to make query with sql and show only the …

Hi, I developed a webpage in which the first page contains a textbox in which if we enter a customer name and click button get details it should display all the details from database. in another page i have written code to insert values into database. the values are getting …

I m getting problem while creating a dynamic website. In Ajax I have good tutorial book. but it missing, "how to create XML file filled with data which comes from SQL server. Second thing is that: How to retrieve the data from XML file. Please Help out me for this …

Hi I like a query to check a proxy bid, wondering the best way around this, my tables are the product table holding the start bid and highest bid and a bidhistory table with all the bids, I use both idcustomer to check different bidders... appreciate the help.

hi PLZ .. Im searching for an online exam applicatoin (MCQ exam ) using ASP.NET (C#) and this application read Questions randomly from a list of questions Stored in database like MSSQL2000 PLZ any one can help me to find this application because I Know this type of application available …

[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; namespace WebApplication5 { public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { SqlConnection conn = new SqlConnection( " Server =localhost\\SqlExpress; Database= …

Hi guys, i am faced a problem here where is i need to select a query where the column name is dynamic: table a col1 | col2 ---------------- A | Ali B | Abu C | Kawan A | Bayu B | Cawam C | didik how i write a …

how to install the FRx reporting server software and on which PC(SQL server PC or Application(Microsoft Dynamics PC)) and how to install on Server and how to install on client Mechines. An earlier response in this regard will be highly appreciated. Regards, Rashid Iqbal

How i store and retrieve office files(.ppt,.doc,.html,.xls) & pdf in sqlexpress 2005 using vs.net 2008. Please Send me the steps in details. [B]Please give the answer in vb.net code (except asp.net or c++, java etc)[/B]

Good day.! This will be my problem regarding on how to update the listview when one of the data in the field in sql server tables has been changed.basically, i have achieved the result by looping on the table continuesly with a timer. But is there any other way to …

Hi, I have a table structure like this in mysql [code=sql]CREATE TABLE abcd ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `path` varchar(500) NOT NULL, `tag` varchar(100) DEFAULT NULL, `name` varchar(45) NOT NULL, `type` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `SRCHINDEX` (`TAG`,`TYP`) USING BTREE ) [/code] How do I …

My App updates two tables at once(username from accounts and orders), but if second tables does not contain the same record(no orders) then it only updates first table(accounts) This code works, but I am trying to merge them into a single string [CODE=vb] ' Multi: True = Update Both Tables …

this is products.vb code file [CODE]Imports Microsoft.VisualBasic Imports System.Data.SqlClient ' Use the unique namespace for this application Namespace Proj06Web ' ' Name the Class Public Class Products Function GetAllCategories() As SqlDataReader ' Get all products as return a dataset to the caller ' uses sp_Get_Products stored proc to return all …

How i access vs.net project using sql express 2005, From Multiple Pc. Tell me about the process in details to make access the project in a server network. Please Help me.

After all the next next work, i reach the Install button and when i click on install it says "TITLE: Microsoft SQL Server 2005 Setup ------------------------------ Could not find a package to install on the installation media." How to solve this problem..

Hello, Have a Access problem. I have 1 master table with records by Sales Rep ID (80001, 80002, and so on). For each of these ID's, i have multiple lines of records that show their sales (Revenue) by customer like follows: 80001 5,000 IBM 80001 7,000 Staples 80005 6,000 Motorola …

Hi all, recently I had have to import a text file ( row are separated by TAB and each column by a space) into a new database. Here i will try to give example: this is how the text file looks LUA 25.614397 43.06958 261 0 1 7 0 57:51.8 …

I have to select one table out of two to fetch data depending on particular condition i.e. month less than current month will fetch data from table [B]A[/B] and month equals or greater than current month will fetch data from table [B]B[/B] <FAKE SIGNATURE>

Right away, Im fairly new to vb.net. Is there a way to have a local db cache that will use a connection string saved in settings? IE: program obviously has a central db remote computers will sync with when connected. can I save the connection string in the program settings …

Hello My Friends, I have a question... How can i add a photo/picture into SQL Server 2000....? Need advice please.

This may seem like an easy question, but I am new to vb and though I have searched and searched I have come up empty. What I am trying to do is create a piece of software that will give users access to certain things based on their level. almost …

I using Visual studio 2008 to connect to SQL server 2000,while I run the application there is exception,but sometime there is no exception is generating.Below I mention the exception. [COLOR="Red"]Exception Error at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, …

Hi all; I'd be really grateful if someone could assist me with this problem. What i am trying to do is create a query that pulls information from two different tables: tblBooking and tblConcessions. tblBooking holds the ID number of tblConcessions as a ForeignKey. What i need within my statement …

Hi, need help on coding. I would like to create a table from another table, including relationships/index/keys. I know I can do this: [code=sql]Create Table New_Table as (Select * from Old_Table) where 1=2[/code] but that would not include the relationships/index/keys. I wonder if it is possible to clone entirely by …

Hi all, I have a program that need to insert the data to the database. In the form, I have 5 textbox control which required the user to insert the data in the database. To create this, I am using the visual studios 2005 and sql server 2005 for the …

Hello My name is Richard Am 25 yrs old Am a web developer and currently am working as a webmaster / assist system administrator (UNIX) Am specialze in Javascript , PHP , ASP , AjAX , Mysql , postgre , JAVA and C++ (For scripting dll extensions for my customized …