[microsoft:sql-server] Forum Topics

I am working on an online project ...... i have two links on one of the page..... say home page.... having two links One Say Shirts and Other Say Casual Shirts.... So when user click on Shirts he will be shown all Shirts from Shirts Table for men and when …

I have a small program that works when I hit start. I want to add two fields. One being a hard coded username and another taking the timer (after it has stopped) and recording it to a table in SQL. I'll have two tables. One called "username" and another called …

Hello, I have a Form A, Form B, Form C. . . and FormSearch. FormSearch can be use by A,B,C... The purpose of FormSearch is to display data in search for the data you want depending on the query that have been pass on it example FormSearch has a method …

All, I can't seem to find a good example of how to work with databases in C#. I'm using sqlserver and I can do simple things like insert and retrieve data, but when I am retrieving data I have to refer to the ordinal index values of the columns (reader[0], …

Try Dim I As Integer For I = 0 To DataGridView1.Rows.Count - 1 Dim ordernumber As String = DataGridView1.Rows(I).Cells(0).Value Dim repairinvoice As String = DataGridView1.Rows(I).Cells(1).Value Dim itemname As String = DataGridView1.Rows(I).Cells(2).Value Dim orderedquantity As String = DataGridView1.Rows(I).Cells(3).Value Dim itemcost As String = DataGridView1.Rows(I).Cells(4).Value Dim saleprice As String = DataGridView1.Rows(I).Cells(5).Value Dim …

hello,, i have a multithread application.. my application connects to the database can i open 2 connection at the same time? or can i thread the connection also. thanks in advance.

Hi,everyone I am trying to develop a simple program that will register Users with the following requirements as reflected with the fields on the interface: imgPassport.Picture ‘This is the Image for accepting Passport Size provided by the user lblPicture_Name.Caption = "User's Passport Size" ‘This is the Label to display the …

I got SQL Server Compact I got a database called Pages and a row called pName the row contains page names, but some are upper-case I now want to make all these lowercase. So there is a page like Downloads, I want to change it to downloads is this possible …

Good day. I have this running query that I want to pivot the sum of CurrentBalance where in Monthdate =[2011-11-30],[2012-12-31]...etc. But everytime I try to put the Pivot, it cannot detect the CurrentBalance column alias. Here is my query so far. use MFR_Merchandise go declare @MonthColumns as nvarchar(max) declare @SQLtext …

Hello I am new to T SQL. I tried some project with sql command using C# coding. But now I am willing to consider running T SQL commands like making procedures using C# coding. ie. I want to my program run T SQL query/command. What/ How to do this? Thanks …

hi! Im new to ADO.NET and i want to enter data into a database via a windows form application. my database has been created using sql management studio. Please do help as im pretty confused. Thanks!!

ASALAM ALIKUM Dear !... I'm doing INVENTORY PROJECT... I'm using Ms sql 2005 as BACK-END... My tables are PURCHASE and SALES... In PURCHASE table, fields are CODE(primary key), PRICE, DATE, TOTAL, QTY... when I'm entering datas in form and when i click submit, the data stored on database... but when …

Hi, I've been working on getting a GUI connected to a database so I can input data into the database. However when getting to the 'making a save button' I get this problem on line 14: Private da As New SqlDataAdapter("Select Name, Number, Email From Contacts", cs) Private ds As …

Dim sqlconn As SqlConnection = New SqlConnection("data source=MCKAYLA\SQLEXPRESS;Initial Catalog=jhen_reg;Integrated Security=True") Dim sqlda As New SqlDataAdapter Dim sqlcmd As New SqlCommand Dim dt As New DataTable Dim sqlstr As String = "SELECT * FROM reg where Username=@Usernametextbox.text AND Password=@Passwordtextbox.text" With sqlcmd .CommandText = sqlstr .Connection = sqlconn .Parameters.AddWithValue("@Username", UsernameTextBox.Text) .Parameters.AddWithValue("@Password", PasswordTextBox.Text) …

Hi all, To perform the delete data from Product table by ProductID of Adventure Works database needs to use delete cascade. Has anyone done this yet? Can provide for me examples to do it? Thanks a lot!

I 'm doing an application using vb.net 2008 and sql 2005 i want to know whether it is possible load data into message box from database when form is loaded......

Hi! I'm having a problem in database.. I have this SQL for my vb.net project Sql = "SELECT STUDENTS.stud_id, STUDENTS.stud_no, [stud_last] & '" & Me.Label1.Text & "' & [stud_first] AS Expr1, STUDENTS.gender00, STUDENTS.course00, SECTION00.sec_code, STUDENTS.Q1, STUDENTS.Q2, STUDENTS.Q3, STUDENTS.Q4, STUDENTS.Q5, STUDENTS.Q6, STUDENTS.Q7, STUDENTS.Finals, STUDENTS.username00, STUDENTS.stud_id FROM SECTION00 INNER JOIN STUDENTS ON …

Parse error: syntax error, unexpected T_DNUMBER in D:\InetPub\vhosts\xdran.com\httpdocs\settings.php on line 7 heres my configuration <? error_reporting(E_ALL ^E_NOTICE ^E_WARNING); $web['connection'] = 'mssql'; $con = mssql_connect("203.143.82.98:1433","sa","z09184049210); //$mssql_server = "203.143.82.98"; //MSSQL server name or IP //$mssql_username = "sa"; //MSSQL username //$mssql_password = "z09184049210"; //MSSQL password $web['database'] = 'Rancp'; $web['database'] = 'RanGame1'; $web['database'] = …

Here is the code I'm running into an error with: FROM IndexPID INNER JOIN Demographics ON IndexPID.NDoc_Number = Demographics.NDoc_Number, PatientSupply INNER JOIN Demographics ON PatientSupply.NDocNum = Demographics.NDoc_Number I also tried it this way: FROM IndexPID, PatientSupply INNER JOIN Demographics ON IndexPID.NDoc_Number = Demographics.NDoc_Number INNER JOIN Demographics ON PatientSupply.NDocNum = Demographics.NDoc_Number …

Can you guys please tell me whats wrong on my code. Im trying to get the data of Title, Author, Price, Stock from DB and output it on my textboxes. Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load connstring = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Csrp2_DB.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True" conn.ConnectionString …

Good day everyone, so here, i have a problem with my repeater control's sql query, what i would really want to happen, is i have a randomized number from 1 to 60, that will tell the database which test question to select, (if it's only one, it's not a problem, …

protected void button1_Click(object sender, EventArgs e) { SqlConnection con = null; con = new SqlConnection(@"Data Source=(LocalDB)\v11.0 ; AttachDbFilename=C:\Users\Bhawna\Documents\Visual Studio 2012\Projects\WindowsFormsApplication2\WindowsFormsApplication2\Database2.mdf;Integrated Security=True ; User ID=sa ; Password=123"); try { con.Open(); String Sqlquery = (" Insert INTO adb (Studentid) values (@S)"); SqlCommand sqlupdate = new SqlCommand(Sqlquery, con); sqlupdate.Parameters.AddWithValue("@S",Convert.ToInt16(textBox1.Text)); //sqlupdate.Parameters.Add(new SqlParameter("@S", SqlDbType.VarChar, 50)).Value …

Hello! I need to write a query that selects TableID (a previously concatenated string) and also selects a substring of TableID as another column. All data in TableID is in the format %System.Variable, %Class.User, etc. I need to select from the % to the '.' to return something like %System …

Dim major As String = TextBox1.Text Dim depa As String = TextBox2.Text Dim sname As String = TextBox3.Text Dim tbStudent As DataTable Dim dcPrimaryKey(0) As DataColumn tbStudent = sqlDataset.Tables("Major") Dim c As Integer 'selecting the entire rows from dbase myCommand = New SqlCommand("SELECT count(*) FROM Major", myConnection) myConnection.Open() 'sqlquery1 = …

Sqlconnection conn; Sqlcommand cmd; conn = new SqlConnection("Server=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\Database.MDF;Trusted_Connection=True;User Instance=yes"); conn.Open(); string cmdString = "Insert into Customer Detail (Customer_id,Name,Address,Contact_Person,Contact_Person_no)Values ('" + TextBox6.Text + "','" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox5.Text + "','" + TextBox4.Text + "')"; cmd = new SqlCommand(cmdString, conn); cmd.ExecuteNonQuery(); Label2.Visible = true; Label2.Text = …

I am having a rquirement that I need to save details of Event in one table and PassTypes of that Event in another Table.Like ID EventID EventTitle EventDescription 1 E00001 EventTest This table Conatins all Event Related info… 2 E00002 EventTest2 This table Conatins all Event Related info… ID EventID …

Hi, I want to create a procedure to delete Production.Product table by ProductID in AdvetureWorks Database. How to do it? Because Table Product's too many relationship :( THANKS!

Hi, I have a simple question On my page I have two text boxes, a button and a label. I have a database DB_rental which contains a table TB_credentials (empID, username, password) User enters the username and password in the textboxes and clicks the button. The application should check the …

I have sets of data that i want to put in tables, however the data is big and want to put it in different rows, something like have a table like MSISN DBSG OSB1 OSB3 BS2G BS3G TS11 TS21 TS22 CSP NAM 256392999829 1 1 1 1 1 1 1 …

Hello! It's me again. I making a library software and I using DataBase. When I remove any record from database and then click save i got a error message: **Update requires a valid DeleteCommand when passed DataRow collection with deleted rows.** , and one line of code with yellow background: …

HI, I want to retrieve list of executed query for a specific date in sql server. Thanks in Advance

hi all! i have two combo box in my program one has the subteam for example if you click the 1st combo box, the items would be A1 A2 A3 A4 A5 what i want to happen is that if i chose A1 only the members of team A1 would …

Hi, Please i want my application to display the autogenerated ID in a messagebox after an insert has taken place and this autogenertaed id is a GUID form. Please help, i have tried @@identity and select_identity() but it wont display any value. Heres how my code is from d insert …

Here is the code that can be copied into sql server to better assist with what I am trying to accomplish. Hope it makes sense and post back with any questions you may have: create table #temp(period int, location int, custnum varchar(10), driver varchar(25), dollar decimal(10,2)) insert into #temp values(201201,221,'ABC123','dwcustcomm',52.37) …

i installed .net framework windows installer and then sql server 2008 then sql server management studio 2008 iam using windows xp it shows very less shared features while installation... i want to know why it showed so less features? is it because of poor hardware resources?

i have a database ,i want to make it accessible to 3 type of users(admin,applicant,official) with different permissions .... how can i resolve,what i modifications it gonna need like to table , relations etc

Hi Friends Iam newbie to vb.net .iam creating a registration form.iam also creating database table in sql server.now how to store record in that table.how to do this? regards apking

my adaptor is giving me problems , i thought that maybe it is because of the SQL environment that i was using , but it is giving me the error report : System.XML.XMLException: an error occured while parsing Entity Name , line 2 , position 57. though am using a …

now im doing project in asp.net by using visual studio 2008. im having some doubt in connectivity by usiny sql.So can anyone suggest some links to help me

Dear All ! I have developed a Software for a Hospital using vb.net 2005 & Sql Express. Now i want to connect this data through lan. What connection string should i give. Please suggest. Below is my current connection string which i have used for it. Dim conn As New …

hi i am working with an application where i have to enter dob in textbox in the format "dd\MM\yyyy".what i have done yet is as below: Private Sub txtDOB_LostFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles txtDOB.LostFocus If IsDate(txtDOB.Text) = True Then MsgBox("correct date") Else MsgBox("input correct date") End …

Hi, I have EntityDataSource1 and i am allowing user to edit Primary Key column. the column is 5 characters code (string) that user has to enter. I am using telerik Grid and inline editing. Obviously if duplicate is entered it will thow this error, but i am confused, where in …

I have been struggling with this for awhile now. lol I have no code to post because I haven't even started it. I can do the insert statement just fine from vb.net code to a sql database. That's fairly easy. However to do an update statement from a combobox to …

Example data in column1 2|3|3|3GES|5|3 |3|334|3ere||343 I would like to split this by pipes so I can update the corresponding other blank 6 columns in each row. Example Col1 Col2 Col3 Col4 Col5 Col6 Col7 2|3|3|3GES|5|3 2 3 3 3GES 5 3 I hope this makes sense! Any help is …

Hi, *I have installed sql server 2008 management studio with "use sql server authentication". *I have created a database with database name:stock owner:<default> *In Vb.net created a windows application;clicked on Add datasource;changed d datasource to microsoft sql server database file(SqlClient);clicked on option button use sql server authentication n then provided …

In this assignment, I am having to insert user information to tables that we have created and I am having this error that keeps on telling me " Code No: 80040e14 Code Message: IDispatch error #3092 Error Source: Microsoft OLE DB Provider for SQL Server Error Description: The name 'Br' …

Im having trouble with nested for loops. I have have a SQL database with a few tables i need data pulled from. So in my first for loop i search for all materials in a product, i insert the data into a datatable then i do the for each dr …

i need to filter my table between 2 dates but it makes wrong filtering really i dont understand why. but it might be my wrong codes here is my codes... what should i do? Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim da As New …

Hi, I have to make a GUI to input data into an SQL server 2008 r2 database, and I was hoping someone could give me a heads up about the how to do it? I remember the basics of doing it in Access but of course its different with each …

how to link vb.net with already created website???? i want to fetch the data from sql server and put them in the textboxes which are already created in the website