[microsoft:sql-server] Forum Topics

i am new to vb.net i want to know how to create login form in vb.net & how to connect sql server 2000 for login id & password i.e. code for login & cancel buttons.

hi.... I have a gridview with rows of info which does not go into edit mode. A user clicks a checkbox which picks that item and adds a Unit Price What i need to do is when a user clicks on a button, it should scan through the gridview for …

hi friends can any one help me in deploying vb.net project with database(SQL SERVER)

OK, here's some background. The database I'm receiving an extract from is an in-house call-tracking system. Each call that comes in is assigned a ticket number (TICKET_NUMBER). Each ticket, though, may have several iterations (CALL_LEVEL) based on the number of updates a representative places on the ticket. Each iteration is …

I am trying a multi select query in management studio and I am only expecting a result that is a single output per row, however, when I tried executing it. The rows I called repeated once. For example I have 2 rows in my column1 and when I multi-selected my …

I am getting information from a database and reading it into an xml file - I've tested the SQL and it works just fine on the database I am using - but it won't return anything once I've got it and am trying to use it. Here is my code: …

I'm a beginner to VB.net 2005. I've started creating a small database project by refering to some VB.net books. I've know the use of dataadapter, datareader, commandbuilder etc which are required to connect to the database. I'm using Microsoft SQL Server Database File (SqlClient) for my project. I've used the …

When I try to add a SQL database using Using Add New Data Source Wizard I get a Error.You can see dat in this [URL="http://img156.imageshack.us/img156/8012/errorsa7.png"]screenshot[/URL] Anyone can Tell me whats the prob..

Hi, i have sql membership provider in my database and i want to join two different tables in sqldatasource i.e. i have this select statement in my aspx page. [code=asp.net]<asp:SqlDataSource ID="Games" runat="server" ConnectionString="<%$ ConnectionStrings:SecurityTutorialsConnectionString %>" SelectCommand="SELECT dbo.aspnet_Users.UserName, GameComment.Subject, GameComment.Body, GameComment.CommentDate, saquib.Reply.Subject, saquib.Reply.message From GameComment INNER JOIN dbo.aspnet_Users ON GameComment.UserId = …

Hi. Can anyone tell me how to copy data from a table from another database? I was able to copy but I only got the columns and not the data it contains. This is how I copied it: I tried this first: USE MMDA GO SELECT * INTO MMDAserver.Vio.ViolationList FROM …

Hello guys and girls, My self Anil and i m a BCA 3yr student. in this semester i have subject named HTML so i want some good ebooks on HTML in which the method of connecting to database ( specialy sql) is included. i.e how to connect database to the …

Hi All, Can you help me solve my problem. I am new to ASP.Net programming. In my job i have to create a Login Page which checks Username and Password with the SQLServer 2005 database and validates.

Dear friends, I am using Vb.net as front end and Sqldatabase as my database file. In my application actual data is not updaing in to the database. But it shows the data while running. Once if clsoe the eecution and if i check the table the data is not saved …

Hey All, i'm having real trouble with this. ok, i have a login page where the user logs in. they put items in the cart and then go to addorder from to place order in database. only problem is i can't get it to work. i think the problem is …

hai friend's i am beginner in MS sql db . so can any one explain me detail about Foreign key and primary key , please give example also , thank;s in advance.....

Private Sub btnedit_Click() Dim a As Variant Set conn = New ADODB.Connection strConn = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=SPUM;Data Source=(LOCAL)" conn.ConnectionString = strConn conn.CursorLocation = adUseClient conn.Open 'lblindexid.Caption = rs!Indexid strsql = " Select * from ES_otherSchools where Indexid = '" & lblindexid.Caption & "' " Set rs = conn.Execute(strsql) …

Hello Everyone! I just joined the community. I need to let you know up front that I am not a programmer. I am starting the journey by learning VB.NET. I downloaded MS Visual Basic Express 2008. I need to do some straight forward apps such as collecting user input to …

Hi there, I have a master detail set of tables with a one-to-many relationship. Let's call the tables Projects (master) and Markets (details). I need to allow users to query the database and be able to select projects by markets. In other words, users should be able to "say": "List …

Hi All I am currently using Vb Express.net 2008, MSSQL server express 2005 in conjunction with SQL server management express. I have created a database application within the express IDE, which I must say I am very happy with, as it was my first database app. I have now decided …

I have a MSSQL table that contains lots of duplicate records, is there a simple way to keep only one and remove all other duplicates? [CODE] mike M 60 mike M 60 mike M 60 [/CODE] I need only one record [CODE] mike M 60 [/CODE]

i found some codes on other forums concerning the cancellation of insert in formview if the record already exists. but its giving me an error stating that there is an incorrect sysntax near =?.... can you please tell me what's wrong with this syntax..i will post below the codes. [ICODE] …

Hello everyone, please i need help, i have been trying to send and retrieve password and username to the database using RMI. please i need a code snipet that can help me to achieve that. i use MS Sqlserver 2000.

Not being a SQL programmer please forgive the following but I need to know. I have a MSSQL database with a table containing a row defined as Column Name Data Type Length Turnover decimal 5 also in Enterprise Manager I see Precision is set to 7 and Scale is set …

I`ve just begun to learn delphi and sql server. I want to make small application using delphi and sql server, but i can`t make the report like this: Note Plus Minus Balance ------------------------------------------------------------------------- sell 5.000 0 5.000 buy 0 1.000 4.000 sell 3.000 0 7.000 sell 2.500 0 9.500 I …

Good day all! Need assistance with the following: I a table that houses information and want to create calculations based on the info. I have created a view to perform one of the calcs. Now I want to sum columns that will put info into another field that I can …

Hi all Just a quick question from a noobie! If i have a DB mirrored...if I apply schema changes to a table in the primary mirror db...will the secondary mirror DB get updated? or is it just data that get's mirrored? Thanks in advance

I would like to add a field from a table to an existing view without changing the structure of the existing. Below is the statement for the existing view and the result [CODE]SELECT (SELECT COUNT(*) AS Expr1 FROM dbo.BillsSections WHERE (BillIndex = a.BillIndex) AND (Type <> 7) AND (BillSectionIndex > …

Hi, the Microsoft SQL Server version is 2000 Basically I want use a basic regular expression but can't seem to get the syntax right. i want to compare ID_short = ID_Long ID_short is a truncated version of ID_Long, and I want to search on the beginning only (hence I can't …

please help for MsSQL stored procedure for ASP.net/C#. Inside stored procedure i used 4 different statements in where clause . first one is working but last 3's are not . Statements are given below- FILENAME LIKE ''%'+ @FILENAMETEXT +'%'' FILENAME LIKE '+ @FILENAMETEXT +'%'' SUBSTRING(FILENAME,1,4)='+@FILENAMETEXT+' LEFT(FILENAME,4)='+@FILENAMETEXT+' bunch of code for …

I have a login control, when user presses login I want to check if he exists in the table. I made a connection to database, and now how do I check if he exists? Protected Sub Login1_Authenticate(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.AuthenticateEventArgs) Handles Login1.Authenticate Dim sqlstring As String …

hi frds, we have the problem that we have created a datatable object (table) and want to add (export) this table in sql server any database. i have the destination connection object and the source table i need the way to export this .Tell me how can i do this …

Hello, Right now i am running SQL 2005 server and using Visual studio C# 2008 to program. I sadly have a Windows Vista professional, 320gbhd, 2gb ram, intel duel core processor, The problem is on C# you can attach a database to your program to retrive or import information from …

¤ Stored procedure does not allow addition of a record with rs.addrecord. ¤ Database is on SQL SERVER EXPRESS. ¤ An .adp ACCESS 2007 application is connected to it (easier to create/modify objects). ¤ Stored procedure was created with the .adp application. ¤ Any one can help? Thanks JL. ¤ …

Hi guys.. currently. i'm using SQL Server 2000 and Visual Studio 2003. i've already make some researches about System.Data>SqlClient. I've already followed the guideline which is right click on the project name>Add Reference and then click on System.Data.SqlClient. but under .NET tab, not included the System.Data.SqlClient. Where should i find …

Dear Friend, i m using VB.NET 2005 and SQL server 2000 as Back end. please someone tell me how to attach files of any type(or Jpg or BMP files) in windows apllication. Thanking you,

Hi All, Here is my question. Is this SQL Compact Edition 3.1 free to Develop,use and distribute it with my application? I have two SQL Compact Edition: One from : [url]http://www.microsoft.com/downloads/details.aspx?familyid=E9AA3F8D-363D-49F3-AE89-64E1D149E09B&displaylang=en[/url] And another from : [url]http://www.microsoft.com/downloads/details.aspx?FamilyId=85E0C3CE-3FA1-453A-8CE9-AF6CA20946C3&displaylang=en[/url] Help me which one to use and which is free as mentioned above as …

what is the difference between char and varchar data type ?

Greetings Daniweb! I am building a webapp business management system. The backend that supports the app is currently under design and I am wondering on the following: In reality, each business' records have nothing to do with another business' records. I would like to design my db to reflect this …

Hello, I have been searching everywhere to find out how I can save a picture from a PictureBox into SQL. Someone told me the best way to do it, is to convert it to a binary file and save it like that. This is what I have, it probably makes …

I would like to SUM two fileds from different rows from the same table but I don't know how to do that. E.g. BillingTransactionsIndex CreateDate UserType UserIndex TransType Reference Total Balance 2 6/5/2008 15:02 1 51 1 150 -288.2 -288.2 5 6/8/2008 11:55 1 51 1 157 -1.58674 -289.787 In …

hiiii..i am using asp.net 2005 in VB language and sqlserver 2005..in my form i am using 2 dropdownlist boxes..if i select a name in the dropdown list box1 then the corresponding last name is selected in the dropdwon listbox2...till now everything is working fine,,,now if i want to change the …

Hi guys ... today i am in the step of client side installation of my project. i need some information for that. what should be installed on client machine to run a vb.net 1.0 application smoothly and what should not be installed on client machine to run a vb.net 1.0 …

Hi Can anyone get me the codings for navigating the records in ASP.NET? ( VB Coding) Using SQl Server as back end.

Hello everyone I am building on a little project in .net, but I have ran into some problems on database - level. I am creating a view with data from a couple of tables. It all revolves around my main table (let's call it 'main' for now). In 'Main' there …

As a beginner, after creating tables, what is the next step?

Hey guys, I've gotten hold of a MS SQL Developer edition, installed it completely, now running off the HDD. However when I go to Start> Programs> MS SQL Server 2005... I only get these options: Notification Services Command Prompt SQL Server Configuration Manager Error and Usage Reporting Surface Area Configuration. …

hello.. can someone tell me how to save a text from a multiline textbox to a .doc format then save it to a sql server database

Hi I have a prob with my code. This way I get to see all the fields in table1 in the grid view but they hold no values! :( if u can help me make changes in this code..it will great! Imports System.Data.oledb Public Class Form1 Dim con As OleDbConnection …

Hi all, I'm working on some syntax highlighting code. Well, the code is finished, I just need a list of all of the syntax to highlight. I'm allowing the user to select the color and words per list of syntax, I just need to know what words to put in …

Hello all, What I want is to divide a string in timeformat, lets say 27:30. How can I do that? Eventually I can use SQL for it, because the string comes from the database. Thanks before!