[microsoft:sql-server] Forum Topics

Hi I have a webform to allow users to register this information is stored in a Clients tables but I would like some of the information to be stored in another table that will store the username, security question and answer. I tried using two separate insert commands but it …

I m using VS2010 with SQL server 2008 at the backend. I m creating a windows application in which I have 2 listboxes.the data is being retrieved from SQL server database in listbox1.i want to select all itms from this listbox1 and add them to listbox2. And remove itms from …

I m getting the following error when trying to add a .mdf file and .log file to my account on somee.com ERROR--> "You don't have the permission to open this file, contact the file owner or a administrator to obtain permission". I need to get my database on the server …

1. For all the accounts that have authority="admin", set permision to modify all of the files (attribute changes is datatype YES/NO),,, so basically a user can set yes or no depends on his will. 3. For each directory, print out his name, in which directory it is located, and how …

Hi , I m using VS2008 with SQL server 2008 at the backend. I m creating a windows application in which I have 2 listboxes.the data is being retrieved from SQL server database in listbox1.i want to select few itms from this listbox and add them to second one through …

Greetings, I'm having a table that I need to retrieve its data in a specific order based on a column value(s). I need to retrieve first all rows that have the value 0 in that column in ascending order (default order) then rows that have value(s) greater than 0 in …

Hi guys, A problem came up when i tried to copy record from the temp. table to the main one.I was copying records to two main tables but one table is empty but the other works fine.Here's the code i used: projcode = TextBox4.Text projname = TextBox5.Text description = TextBox6.Text …

How to connect sql database to your c# program

Hi all , can you pls say how i able to send the email notification alert with the datas getting from Sql server 2008 using windows service . - Thanks in advance

hi, i'm wondering how can i make my project running in to another computer without changing the connectionstring. i am using this connectionstring("Server=GEN-PC;Data Source=GEN-PC/SQLEXPRESS;Initial Catalog=Brgy;Persist Security Info=True;")

[Click Here](null)Friends... Good Evening... I am final year student of UG Computer Science.. I am creating my College Admin Project using Vb.net 2010 with SQL server 2005. When i am trying to complete my project , i have to connect all my different modules (Admission, Fee Management, Students Profile, Attendance …

I made an online application to store employees information in MS SQL,I used Disconnected model and I made my class for "DataSet configuration" and call method in it in The "Form_Load" event. This is the class public static string constr = ConfigurationManager.ConnectionStrings["cnn1"].ConnectionString; public static DataSet GetDataSet(string stored_name, string table_name, params …

I have a table with the following fields: client, project number, project manager, project manager email I have a form with text fields for each field of the table and I want to have a query run when the user presses a button on the form. How to i make …

Hi everybody!! I'm starting with asp.net and i would like to try my code online.. can you advise me some free hosting for asp.net with the possibility to use sql server? Thanks

Does anyone know how to query a dropdown list to a website from SQL server 2012 in WebMatrix Using PHP? PLEASE HELP!

Hey guys, what am i missing here: Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click Using sqlConn As New SqlClient.SqlConnection(sqlConnString) sqlConn.Open() sqlConn.Close() End Using End Sub Public Property ServerName() As String = "myip" Public Property DatabaseName() As String = "mytable" Public Property Login() As String = "sa" Public …

How can I perform SQL Server backup recovery task? Please recommend solution for my query.

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.Linq.Mapping; public partial class Default3 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } public void showgridview() { DataClassesDataContext dc = new DataClassesDataContext(); var q = from a in dc.GetTable<bio>() select a; GridView1.DataSource = q; …

I want to store my databases only on RAM. I see that in MySQL server I can choose the "MEMORY" engine and the table with be stored only in the RAM. How about MS SQL Server? How can that be done there? Thank you

i need to build a program in web developer with ASP.NET. the purpose of this program is to see what and who sold something to which customer. i need to use a SQL database in it. i'm not so good in programming, i can't find to put a query on …

Hi, is more than a week that i try to resolve this error on my app but i can't... The problem is the following : I have a menu and submenu table and i show this records in this mageMenu.chstml (list of menus and submenus to generate the menubar of …

Hi I am using MSSQL ODBC Connetion for my project in PHP. I have created login form with PHP and MSSQL with ODBC Function. Can any one please help how to use SESSION to carry on to next page without get function.

I've developed an application in vb 2010 and my back-end is sql server 2008. What are all the softwares i need to install in the client machine ?

this prog for database to edit and search database using sql by vb I want the search results appear in DataGridView only Dim winclass As New Class1 btnsearch.Enabled = True 'btnsearch.Enabled = True btnnsearch.Enabled = True If txtsearch.Text.Trim = "" Then MsgBox("enter value of search", MsgBoxStyle.Information) txtsearch.Focus() ' Lablerror.Text = …

I'm a beginner in MVC application development. I'm just trying to make a MVC application getting help from internet. That was a simple example and working properly. The article is said the database is in app_data folder. But actually there is no any database in that folder. Then I just …

Hallo, I get stuck when installing SQL Server 2012 : Services Account Name Password SQL Server Agent SQL Server Database Enginee SQL Server Analysis Services SQL Server Browser This Sharepoint Server connected to DCSHARE1 (Domain Controller) The problem is I do not know what to fill for Account Name & …

hi..... i want to show data i datagridview...  This is my function codes : Public Function AutoNumber() As String Dim cnn As New SqlConnection(StrConn) Dim cmmd As New SqlCommand Dim dreader As SqlDataReader Dim KODE As String Dim TAMPUNG As String Dim KONTER As String Dim SQL As …

Friends , I have a database in sql server named "Deposit" with a table "Receipts" .I want to display the data in a list box.My code is given below Imports System.Data.SqlClient Public Class Form1 Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click Dim cnn As New SqlConnection("Data Source …

Hello Experts Here is my connection string [CODE] string con = "Data source =YS-8462BA359936;Initial Catalog = Schooldata;Integrated Security = True";[/CODE] and my store procedure is [CODE] SqlConnection objCon = new SqlConnection(con); objCon.Open(); SqlCommand cmd = new SqlCommand("Studentinsertadmission", objCon); cmd.Parameters.Add(new SqlParameter("@Studentid",Convert.ToInt32( studentid.Text))); cmd.Parameters.Add(new SqlParameter("@StudentName", firstname.Text)); cmd.Parameters.Add(new SqlParameter("@Image", image.image )); cmd.CommandType = …

I have to insert a image file into sqlserver 2005 in asp.net with c sharp. please provide me with the detailed code

Dear there, I am planning to develop database application in c# and SQL. But i face the problem, the problem is HOW TO INTEGRATE DATABASE INTO SOFTWARE DURING CREATION OF SETUP? Any help please!

how to get all available SQl SERVERS on the network and their databases?

how can connect database to SQL?

Hiya guys, I am wondering whether anyone can help me, I have been stuck on this for weeks. I have got a similar thing working but I just cannot get this working. I have got a SQL Server Database integrated into my VB application. There is a table called 2HaulierLogIn …

i am creating a form in vb.net, the aim is to be able to insert data to the sql server from the form interface. the form's textboxes fields include Name, DateofBirth, Address, Telephone, PostalCode, Nationality, DateofRegistration Sex (ComboBox), plus two buttons names, Submit and Cancel. kindly assist with a code …

I'm using: Windows 7 Word 2010 Visual Studio 2013 Express for Desktop An Access database with one table As this project is for proof of concept I'm keeping things very simple until I can get the VB working correctly. The project consists of one form (Audit.vb) which contains one textbox …

Hi. problem in where insert data into table. Using vwd 2012 and Mssql 2012. Insert command is working fine in first record. If add another record, it shows "Procedure or Function has too many argument" I have tried may way, I could not solve. Pls help me. Below is my …

i connect my access to vb2010 using adodb. but i cant display the datas in my listview. can someone help me to solve my problem. i would really appreaciate any help. what i need is to get the column per column datas.. like how it is shown in the access. …

Hello everyone I have DataTable in C# Windows Application and I want Send This DataTable to SQL. In SQL This DataTable as Table variable but i cant do this because i must create datatype as table But i dont know the total code for this first in C# second in …

We have 2 Tables, One is Primary Table and another one is a Transaction Table. Both Tables are identical. We have to insert or update the record in Primary Table, based on Transaction Table. If a record is found identical on primary keys for Primary and Transaction Table, we would …

Hi, I just recently started a website with the hope of connecting a program I made with the licensing database that I've already created. I have all the usernames and passwords I need. on a side note, I'm using Visual FoxPro 9. But each time I try to connect I …

i have 2 database (access,SQL) with 2 different connection string i want to select a table from the first database insert it to the second database any help

Why I can't update data in my database MSAccess? though, it's already working, but no changes. Pls help me... Here's my code for Update I have 10 Fields in my table Personaldata try { Records f1 = new Records(); BlockNo = textBox1.ToString(); LotNo = textBox2.ToString(); Numberofoccupants = textBox3.ToString(); Firstname = …

I wrote my first trigger and it giving error UES TRY GO CREATE TRIGGER cust_update ON TRY FOR UPDATE AS IF UPDATE (custno) BEGIN TRANSACTION RAISERROR('CUST NO CANNOT BE UPDATED',10,1) ROLLBACK TRANSACTION END Any idea `

I setup Merge Replication between SQL server 2000 and Windows 7 64-bits. It setup successfully and working fine in LAN and WAN. But the replication will fail after run few times successfully in WAN. The error msg :"The process could not not connect to distributor ''. SQL server does not …

i really have a problem to this code. can anyone help me? Try Dim fBrowse As New OpenFileDialog With fBrowse .Filter = "Excel files(*.xls)|*.xls|All files (*.*)|*.*" .FilterIndex = 1 .Title = "Import data from Excel file" End With If fBrowse.ShowDialog() = Windows.Forms.DialogResult.OK Then Dim fname As String fname = fBrowse.FileName …

What is the meaning that Database management systems allow access to and storage of data independently of the interal representation of the data? what is meaning of independently of the interal representation of the data?