[microsoft:sql-server] Forum Topics

Friends, I have a Database in Access, Table Name- Master . Structure is given below Mno=Membership no in digits Name=Member's Name Fno=Family number in digits Fname=name of the family Faddress=Address of family Fphone=Telephone of Family The database contains several records where some members come under the same family.In other words,Suppose …

Hi, I want to make my application for online registration based software,any customer register my applcation from anywhere. actually my applcation made in vb 6.0 and sqlserver 2005

Hi all, Im working on a page that sends information to a mssql database. Its a basic registration page with a UserID, Password, First Name, Middle Name, Last Name, and Email box. When Sign up is clicked, all the information in the textboxes should be sent to the Users table …

When I try to migrate from SQL Server 2000 to SQL Server 2008 R2 Express, when I run the application program there is an error message transaction aborted by the trigger, whereas before when I was using SQL Server 2000 does not exist error. after there was a note on …

I have two dropdownlists on my page containing semester number and subject names respectively. When I select First semester from dropdownlist1 and click on go button then the dropdownlist2 contain subjects of first semester fetched from database in sqlserver.... it is working fine, but when i select semester Second from …

Hello. I'm trying to use SqlDataReader to return information from my database. It works fine until it comes to a datetime field. I'm getting an error saying: " Input string was not in a correct format." on the line where I'm declaring a variable to hold my field. Here is …

Hi guys, I'm stucked at (as it seems to me) a very strange problem. I have a listview on my form to which a list of users is populated from mssql db. In the same table but different column I have user_id. I have a textbox and a textbox_keydown control …

Hi all. I need your help. Iam using vb.net 2010 and sql server 2008. I have problem when retrieve multiple rows from database to datagridview. All rows have the same identification number(patient registration number).I have problem in loop to show the all rows in datagridview. Pleaase anyone knows that help …

Hello. I have an old access data project. I need to convert it to sql and .net. How can I do that?

Hi I am beginning by final year project which is an appointment system. I had planned to use Visual Studio and SQL Server for this but at the end of the year I have to submit my system to the uni on a disc, I was just wanting to know …

how to get only the edited row and save the date as modified date? i have 6 fields in sql server: dtl_id = int cost = decimal startdate = datetime enddate = datetime status = varchar modified_date = datetime (modified_date is declare in sql as getdate) . this is my …

Hi I installed mssql200. It works fine, but outside application can't communicate with it because it doesn't open port 1433 as it is configured to do. Instead it opens 2 other ports that communicate with the DNS server. What is required to change in order to open port 1433? Ronni

Hi, We have MS sever 2012 and MSSql Server 2012. ODBC Connection in Server is fine. But If create the odbc from Client PC (OS Windows 7 profession SP1), it could not connect Error : Server not found or Access Denied. Even in Admin level also, it shows same error. …

How do I connect from another machine to SQL Server 2008 R2 Express installed on Windows Server 2008? I've setup the network configuration to be enabled and the TCP port is set to 1433, but I still can not connect to an existing database on the server when creating ODBC …

Hi all, I really need your help on this one. I have a MSSQL db table with two columns-ID and name. Each row in this two columns contains an unique ID and a name. Now I have a query that imports just a name in the listview (I don't want …

I am creating registration Form, here's the code SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["RegConnectionString"].ConnectionString); con.Open(); string insCmd = "Insert into Registration(UserName, Password, EmailAdress, FullName, Country) vaues (@UserName, @Password, @EmailAddress, @FullName, @Country)"; SqlCommand insertUser = new SqlCommand(insCmd, con); insertUser.Parameters.AddWithValue("@Password", TextBoxPass.Text); insertUser.Parameters.AddWithValue("@EmailAddress",TextBoxEA.Text ); insertUser.Parameters.AddWithValue("@FullName",TextBoxFN.Text); insertUser.Parameters.AddWithValue("@Country", DropDownListCountry.SelectedItem.ToString()); try { insertUser.ExecuteNonQuery(); con.Close(); Response.Redirect("Login.aspx"); } catch …

here is screenshot. http://i.stack.imgur.com/0LAQZ.png and here is code. using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; using System.Data.SqlTypes; using System.IO; using System.Drawing.Imaging; namespace SampleApplication { public partial class AddNewUser : Form { public AddNewUser() { InitializeComponent(); } // set the …

hi anybody can tell How can session store in mssql database? How to do SQLServer Session Mode start? Pls help me Maideen

Good Day, I would like to ask if it possible that i have my Local Database(MSSQL) but i would like to put it Online? I need some idea on this Daniwebers. Your response is Highly Appreciated. Thank you, EOS

cnsrvlist3.open "Provider=SQLOLEDB.1;Data Source="& strDrserver &";Integrated Security=SSPI" msgbox("ABC") msgbox(cnsrvlist3.state) cmdsrvlist3.activeconnection = cnsrvlist3 I am trying to check the state of connection, The code works fine if the connection is fine but when any Database server is down then in that case the state should come as 0 instead of that it …

protected int getRowCount() { int RowCount = 0; SqlConnection conRowCount = new SqlConnection(ConfigurationManager.ConnectionStrings["connMSJ"].ConnectionString); SqlCommand cmdRowCount = new SqlCommand("SELECT Category FROM MonthlyBudget WHERE (Username=@username AND CurrentMonth=@current) GROUP BY Category", conRowCount); cmdRowCount.Parameters.AddWithValue("@username", Master.getUsername); for (int i = 0; i < intMonth.Length; i++) { cmdRowCount.Parameters.AddWithValue("@current", Convert.ToDateTime("1/" + intMonth[i] + "/" + ddlYear.SelectedItem.Text)); conRowCount.Open(); …

Hi All, I'm trying to use jdbc connection with sqlServer 2000. I'm using j2sdk1.4.2. And i have service pack2. I've installed the .jar files mssqlserver.jar, msutil.jar, msbase.jar. I have these jar files in E:\j2sdk1.4.2_04\lib. I'm trying to connect with the following program. [CODE] import java.*; import java.io.*; public class Connect{ …

Question: Given the relational schema: ENROL (S#, C#, Class) - S# represents student number TEACH (Prof, C#, Class) - C# represents course number ADVISE (Prof, S#) - Prof is project guide of S# PRE_REQ (C#, Pre_C#) - Pre_C# is prerequisite course GRADES (S#, C#, Grade, Year) STUDENT (S#, Sname) - …

So I have a table I am trying to create, but as I am working on this, I am worried that the idea is flawed. Here's the SQL code to create the table so far: CREATE TABLE #ConversionLog ( EventTime DATETIME NULL, EventType NVARCHAR(20) NULL, RecordID INT NULL, EventTarget NVARCHAR(255) …

I want to retrive data from table to combobox I used this coding though I didn't get an error the outpiut(data) is not displaing in the combobox Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click MessageBox.Show("Please Insert the Sample note no", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information) Try myConnection …

## Hey Guys ## , I've recently stopped doing some of the projects which I wanted to do and took a look at SQL and came across Microsoft SQL and i was pretty pleased with wha tit can do so i downloaded the program and watched some basic MSSQL tutorials …

How to deploy a windows application (in VS 2010) with database. I know to do the setup project for the windows application. I have to give demo that one machine act as client and another machine as server. I have to deploy the setup on one machine which will work …

how to insert data into datagridview from sql table using recordset in vb6.0

i have four tables (1) tbl_module: modNo | modName _ _ _ _ _ _ _ _ 1 | module 1 2 | module 2 (2) tbl_subject subNo | subName | modNo _ _ _ _ _ _ _ _ _ _ _ _ 1 | a1 | 1 2 …

THIS CODE IS WORKING,, BUT WHEN THE SECOND TIME LOGGING IN IT DOUBLE CHECKED LIKE 2 FORMS OPEN and 4 MESSAGE BOX APPEAR Private Sub btnSign_Click(sender As Object, e As EventArgs) Handles btnSign.Click Dim connectionString As String connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Renz\Documents\Visual Studio 2012\FINAL\Database\AuditDB.mdb" sql = "Select ID, LASTNAME, FIRSTNAME, LOGINSTATUS …

hi dani im just starting to program displaying datagridview(or listview) to another datagridview using sql server2005 connections..but i dont know how to code it in c#...

hi i want to show entire column data from sql and show in a single textbox with ","

Please help me to Checking for Duplicate Record of SQL Database before Inserting & Updating this my code please may anyone check my code If class1.sqlcon.state = connectionstate.open then class1.sqlcon.close() End If class1.sqlcon.open() dim cmd as new sqlcommand dim Qresault as integer cmd = new sqlcommand (" SELECT COUNT (*) …

This SP is working well. But when recordcount in dbo.PTSGELEN is over 1000000 approx. it comes timeout error. ALTER PROCEDURE [dbo].[PTS2Tabloya] @KOLETIK nvarchar(40), @SIL tinyint , @EKLENEN int OUT AS BEGIN SET NOCOUNT ON; set @EKLENEN = 0 IF @SIL=0 AND LEN(@KOLETIK)=20 begin INSERT INTO dbo.URUNGIR (GTIN,SN,XD,BN,CLABEL,SLABEL) SELECT GTIN,SN,XD,BN,CLABEL,SLABEL FROM …

Hi, I have problems with getting data out of the **MS SQL Server 7.0** database in right encoding using **odbc** connection: $conn = odbc_connect("Driver={SQL Server};Server=$server;Database=$database; CharacterSet => UTF-8", $user, $password); I had the same problem when I used MS SQL Server 2005 and sqlsrv connection, but I found the solution. …

1.code -------------------------------------------------------------------------------------------------------------------- static void Main(string[] args) { SqlConnection sc = new SqlConnection("Data Source=pc3490ierf43;Initial Catalog=Persons;Integrated Security=True"); sc.Open(); SqlCommand command=new SqlCommand("Select Name from Persontable",sc); SqlDataReader reader= command.ExecuteReader(); while (reader.Read()) { Console.WriteLine("{0}", reader.GetString(0)); } Console.ReadLine(); } --------------------------------------------------------------------------------------------------------------------- ** 2.code** static void Main(string[] args) { using (SqlConnection sc = new SqlConnection("Data Source=pc3490ierf43;Initial Catalog=Persons;Integrated Security=True")) …

I will make the process of looping the data to save data into SQL Server database, but field data that must be stored is retrieved from the database access, data taken later not only a record, but a lot of records, so it takes a process of looping in it, …

Hi all! I have a user interface where I want to filter a datagridview.. I 've achieved to create filters but I 've failed to filter tha data by date.. I have a sql db and the column of date is of datetime type. When I try to filter the …

hello, i am coding for my project, i want to read data from excel file to to a table in sql server 2008 R2. It work ok in window 7 32 bit but not working window 7 64 bit. Please help me. My sostware in this link: http://www.biframework.com.vn/page/products/id/9/phan-mem-quan-ly-doanh-nghiep.html

I had two versions of SQLEXPRESS on my computer earlier ,now I have uninstalled 2012 SQLEXPRESS from my computer Now when I try to attach .MDF file made in 2012 version it gives me error. TITLE: Microsoft SQL Server Management Studio ------------------------------ Attach database failed for Server 'My-PC\SQLEXPRESS'. (Microsoft.SqlServer.Smo) For …

good day! im working on a migration tool for mysql to mssql. is there any references or codes that you guys can share to me to create databases and transfer data from mysql to mssql? ive just got this idea of using dump mysql files since they also have sql …

hi i'm new here and new in the programming world i started about a year ago to learn about programming i didn't went to school i just studied from books and tutorials and with friends help i learned visual basic the main i learned from the book "programming with visual …

hi Iam using sql server 2008 r2 with database that saving Arabic and English with it, when i use this sql statement SELECT * FROM Land_Files WHERE Briefness LIKE '%Qusin%' it gives me aresult but when i use the same sql Statment with small difference : SELECT * FROM Land_Files …

I have a transaction, there is a method calling in the tran. which makes insertion into a table, after that when i select the row that i have inserted, i find no result how can i solve this problem without changing this structure or what else can i do? Thanks …

I have data grid and I have two radio buttons in the datagrid i.e approve or reject and also one button in datagrid i.e submit what i want to do is when approved button is selected and submit button in the datagrid is clicked for one row I want the …

Hi there, Once i am on my second page where i have open the record from the database with my id record, how can i populate my textboxes with the values of my record? And ho can i populate a select with another table containig the type of user by …

Hello friends, I am using sql server 2005 as a backend. I want to filter the datagrid based on fromdate,todate,companyname,employee name. I have done the date filter's.... The problem is with the other two filters. The actual problem is.. The application has to filter based on company only if the …

Hi. I have developed project using visual studio 2012 in vb code. Application is running fine in my local machine. But In server it will show the error once excuting report. server is MS Server 2008 R2 with SP2. Here is the error . This is my senario Database: MSSQL …

Good morning strangers! I haven't posted in a while, but you always seem to be helpful... I have an application that uses SQL as a back-end to store data so that multiple users can access it at once. The question I have is, the requirements have changed and the SQL …

i'm inserted a image in sql server2008 as varchar(max).How to retrive in Data Grid view photo column ..i need code ...i tried many ways still getting Confused.