[microsoft:sql-server] Forum Topics

When the exchCode is empty the record shouldn't be displayed. However the code below display the records. SELECT * FROM( SELECT bhCliCode, exchCode = CASE X.Which WHEN 'accSgx' THEN accSgx WHEN 'accHk' THEN accHk WHEN 'accIdx' THEN accIdx WHEN 'accUs' THEN accUs WHEN 'accSet' THEN accSet WHEN 'accPhp' THEN accPhp …

Hi all, Quick one for you, designing a bit of software in VB.net for a company that inputs data into an mdb file and then uses a web service to take this data an insert into an SQL server 2008 R2 database. I know I can have to instances of …

ok i need help with this code i more than triple checked the spelling so i dont know what is wrong anymore and i have checked that i inserted the right data also. This is my code i use to insert into my DB when i break it i get …

hi, frnds i am making a project on Grading System of school and i am using vb.net 2010 as my front end and SqlExpress as my back end . i have a Marks_Table in my database in which user stores student marks info . i want to generate marksheet on …

hey every one . i write a atm program and neew to read some information from sql server db . and give service to costomers . what i need . 1. read from server and check user and pass . 2. if its correct read the data and load it …

Imports System.Data Imports System.Data.SqlClient Imports System.Configuration Partial Class books Inherits System.Web.UI.Page Dim con As New SqlConnection Dim cmd As New SqlCommand Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load If Not IsPostBack Then BindRatingControl() End If End Sub Protected Sub RatingControlChanged(ByVal sender As Object, ByVal e …

I used to code on MS Visual Studio 2008. It had MSSQL Server 2005 installed with it. Recently I uninstalled MS Visual Studio 2008 and installed MS Visual Studio 2010. But it didnt uninstalled MSSQL Server 2005. And MS Visual Studio 2010 installed MSSQL Server 2008. So basically I have …

Hi I have two tables Employee and Job, Employee's prmary key is EID and in Job there is a EID that is a foreign key to Job. job has another column as the status of the employee. first the employee is added to the database and then the job detils …

How do you display an image in a dgv..i can display all the other info in the table, just need to know how to display an image.

I've inherited a small C# command line program that takes a date and creates several spreadsheets containing data pulled from a microsoft sql server database based on that supplied date and some names hard coded into the program. I'm looking to change the program to pull the data from a …

i have a database table and it has some column with duplicate values , and i want to get that column value of the table in a combobox, but i want every value single time not repeatedly ... i tried but it is still giving me all values in the …

I am having trouble figuring out how to execut the following SQL query. Say for example I have the following 2 databases. Db1 Col_1 Col_2 1 a 2 b 3 c 4 d 5 e 6 f 7 g 8 j 9 h 10 i Db2 Col_1 Col_2 1 j …

I am using VS2010 and created a database using SQL server residing in VS2010. the database is stored in the folder APP_DATA with an extension .mdf My PC name is rvivek and it resides in a domain. below is my connection string. myConnection = New SqlConnection("server=rvivek; uid=; pwd=; database=Database1.mdf;") when …

Hi everyone ; i using to VS2008 -- devexpress V10.1.2 and MSSQL i make to same project .. my project setup is work my computer but same setup doest work to another computer error: ERROR DETAILS Following errors were detected during this operation. * [07.11.2012 02:17:57] System.Deployment.Application.InvalidDeploymentException (SignatureValidation) - Strong …

Hi all! I think I need some help moving data from one table to another. Here is the scenario: I have two tables, tblDetails (studentID,Name, Class.....) and tblPhysics (StudentID.....). Now, I want to SELECT StudentID from tblDetails WHERE Class = 1 (SELECT tblDetails.StudentID FROM tblDetails WHERE tblDetails.Class = '1') So …

Hallo good people, Am doing a project in which every time a delete record is done i want it to fire a trigger which then helps me capture who deleted the record and at what time this happened. All this details should be written in a flat file. Any help …

i am trying to do something like this but it gives me error that **cannot convert int to string** , even the field which i am accessing from db is int and i parsed it into int but why ? here is my code: userId = (int)com.Parameters["@ReturnValueUserId"].Value; Response.Write(userId); SqlDataSource1.InsertParameters["@userId"] = …

Hi, I am stuck on this two sqldatadapater and sqldatareader,we can display records in listview by using this sqldatadapter and sqldatareader.my question which is more effecient and secured to use?does this two matters in populating data in database?

Please help me I got a error:Incorrect syntax near ')'. It pointed to the update_product.ExecuteNonQuery() Dim update_product As SqlCommand = New SqlCommand("Update sell Set Mode_Of_Payement(Cash)='" & TextBox9.Text & "',Payement='" & TextBox6.Text & "',Balance='" & TextBox8.Text & "', Mode_Of_Payement(Cheque)='" & TextBox9.Text & "',Cheque_No='" & TextBox4.Text & "' where Bill_No='" & txtbillno.Text …

So I have a business object, data access layer and processes folders that hold code to select data using a stored procedue in SQL Management Studio. This is fine and I know how to code it all to select data. However now I need to write code for it all …

Hello dear ALL I am working with a form in vb.net which have the follwing attribute i.e BOOK TITLE(text box) , CATEGORY NAME(combo box) ,YEAR PUBLISHED(t.box) and SAVE button .the CATEGORY combo pickup data from CATEGORY TABLE on cat_name . on back end (SQL SERVER) there are two tbl i.e …

I'm managing a server running Windows Server 2008 R2 for a client and after investigating some high memory usage, I discovered that the Windows Internal Database SQL instance is using over half of the server's RAM. Capping the instance's memory usage is easy, but unfortunately my user account (which is …

Hi all, I had originally installed MS SQL Server 2008 R2 in my C: when I was developing the application. While I had the SQL DErver in my C:, everything was fine, no problems at all. Then I began getting low disc space messages, so I uninstalled it from my …

i want to connect the sql dabase to vb.net form. can anyone tel me how to do it. i tired google. but it only says about ms access database. please help me

see i am using this mode of SQLDATASOURCE configuration  and now on the basis of this sql statement i want to generate UPDATE, INSERT, DELETE queries, especially UPDATE and i tried my best to do it but can't. this thing is quite possible in the mode given below …

Hi all, I have a very nasty issue here where SQL values are changing but I haven't been hacked because the changes are just too abnormal. People vote for their servers and every so often the top few servers values roll back. For example at 03:00 a server has 66 …

i got error when making this code. Here is i attach my code and tables: My Tables are =============================== **PRODUCT** **TR_RECEIVE_PRODUCT** >ID_PRODUCT >ID_RECEIVE_PRODUCT >NAME >ID_PRODUCT >CURRENT_STOCK >DATE_IN >STOCK_IN ==================================== ============================================================================= Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click Dim cmd As New SqlCommand Dim connectionString As …

Greetings, I want to know what is the pest practice in the following issue. I have a From for releasing decision such as hiring employee, discharging employee etc. The process of releasing a decision takes the following steps 1- You fill the necessary data within the from and then click …

Imports System.Data Imports System.Data.SqlClient Partial Class test Inherits System.Web.UI.Page Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click Dim txtName As String = TextName.Text Dim txtcomment As String = TextComment.Text Dim txtemail As String = TextEmail.Text Dim con As SqlConnection Dim cmd As SqlCommand con.ConnectionString = "SqlData Source=(LocalDB)\v11.0;AttachDbFilename=App_Data\library.mdf; Integrated …

I'm trying to do, an order and some orderline. Imagine that the user come and select several item from the shop then when he click on the checkout, the reference number in the order is send back to the several item in the orderline table. How would i insert that …

Hi, I have 2 Columns in DB ex: EMP_Name,age I want to display 3 Columns in Jtable EMP_Name,age,Minor?(it will be check box always false) EMP_Name and Age Column will be Readonly. Please suggest me how to achieve this?

i made a login table and i am filling records in it through my datagridview but when i delete all the records and make the table empty and then when i put the record in the login table it takes 1 no ahead of last deleted record .i want it …

i want to Calculate and list the average response time taken from the current set of job recruitment records, i.e. all the communications between the School and casual candidates for the express Job, and then update the response time for each casual staff according to updated response time =(currentresponse time …

i made a login table and i am filling records in it through my datagridview but when i delete all the records and make the table empty and then when i put the record in the login table it takes 1 no ahead of last deleted record .i want it …

Hi, I am new to mobile app development. I would like to know what is the best way to connect to backend, I have a database in sql server 2005, and a web application in C#.NET. Now I would like to have a mobile app of that application. But fairly …

Hi, I want to get last working day data from database(SQL database). For example, if today is Tuesday, I want to get Monday data. I can get the data directly using strtTime = Date.Now.AddDays(-1).ToString("yyyy/MM/dd") & " " & "06:15:00" But the problem is if today day is Monday. Since the …

when user login it will check if user exist in database or not what is wrong with this code Dim a As New System.Data.DataView Dim b As New System.Web.UI.DataSourceSelectArguments Dim usname As String Dim password As String SqlDataSource1.SelectCommand = " select usname , password from userinfo " a = SqlDataSource1.Select(b) …

Hi,I have problem on my code,it will not insert to the database can you pease help me on this.Thank you in advance. Imports System.Data.SqlClient Imports System.Data Public Class Form1 Private m_con As New SqlConnection Private m_DA As SqlDataAdapter Private m_CB As SqlCommandBuilder Private m_dataTable As New DataTable Private m_rowPosition As …

AoA I am Inserting Data From DataGridview to Sql2005.It Insert Perfectely. The Problem is that when i insert record it alway insert 0 row with my other rows The Code is below try { string con = "Data Source = FLOWER-PC;Database = MYFIRSTDATABASE;Integrated Security = True"; SqlConnection cn = new …

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); PrintWriter out = response.getWriter(); try { int c=0; String u1=request.getParameter("u1"); String e1=request.getParameter("e1"); String user=request.getParameter("user1"); request.setAttribute("u1",u1); request.setAttribute("e1",e1); request.setAttribute("user", user); out.println("welcOme"); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con =DriverManager.getConnection("Jdbc:Odbc:db5"); String str = "select * from Table1 where email=?"; out.println("welcOme"); PreparedStatement statement = con.prepareStatement(str); statement.setString(1,user); ResultSet …

Hello! This is my first post to this forum, so I'm kind of losing my virginity right now I am also new in VB. I hope that somebody would help me! Ok, I have a problem with a database. I want to make a program which has one input textbox, …

`hi good day does someone have an idea on how to create a backup sql database.? my front end is asp.net and my back end is sql server database 2005. thnx a lot!:]

hi i need some help, i need to creat a file in access 2003 running a aplication asp.net (c#) using a sql query, if anyone knows that plz tell me:) thanks

When i try to run my webpage with database connection i am getting this error. Unable to find the requested .Net Framework Data Provider. It may not be installed. Visual Studio 2010 and SQl Server .. Kindly advice..

Hi, i have a Sql Server 2008 database, with a table that has around of 2.000.000 registers. The schema of the table is the following: idSpecie (PK, int) | Kingdom | Phylum | Class | Order | Family | Genus | Specie The kingdom, phylum, class, order, family, genus and …

Greetings. I'm having a problem that is we have a fingerprint devices in the factory, we have 2 work shifts OK so the security guys must switch the devices from "in state" to "out state" so that the [in/out mode] in the database being 0 "means attend state" it changes …

Hi ok so i want to read images from an sql server database..the images are saved in bytes but im struggeling to retrieve them my code for the retrieving this is the code i used to save the image and its working. Dim sql As String = "INSERT INTO item …

Hi, I have a stored procedure that will display an activity if the user enters the correct appref. This stored proceudre works fine on SQL management. However when i bind it to the gridview on my page it doesn't work on the internet, keep getting the error. Cannot open database …

i am retrieving textual data from database on my page , asp.net(c#), now i want to save in pdf format and want to store that pdf file on my server(localhost) so how ?

i wanted to know the code for putting values from comboxes into Datagridview but i tried but im getting coversion exception.. Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim conn As New SqlConnection("Data Source=.\SQLEXPRESS;Initial Catalog=grade;Integrated Security=True;Pooling=False") Dim cmd As SqlCommand If ComboClass.SelectedItem <> "" Or …