[microsoft:sql-server] Forum Topics

hi, i have a table stu_record and a field name is image_student as a image type and image save in it in binary form. nor when i'm login i want to store this image into a session variable. and on other pages this session value store into another table as …

I want to show record list in Datacombo through coding , using SQL Server 2000,VB6. Following are the coding. ******************************** Private Sub Form_Load() Dim CNN As New ADODB.Connection Dim RST As New ADODB.Recordset Set CNN = New ADODB.Connection CNN.Provider = "SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Maintenance;Data Source=YASIR" CNN.Open Set RST = …

HiEveryOne, Does anyone know how to get the data where startdate is more than today'sdate and enddate is less than today'sdate and if enddate is NULL. Thanks for the help

i'm not too familiar with java...though... actually i'm trying to insert the values entered by the user into the access table but every time i click the add button on my application it shows [I]java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. [/I] error... [CODE]String str="insert into …

Hello Everyone For a project from skool, I been in charge of development, and we already have the system, but they wanted to add images to the project, and since i been using the TableAdapter.Insert commando to add records to the database, I need to know how to send an …

what is the .net code for adding year in this form like 2001-2002,2002-2003, in dropdown with the asp.net

Hello everyone! I want to write my connection strings and functions in a class and always call the class when i need to make a connection to my database to avoid code repetition and increase code reuse but i have an error. Here is my code below [ICODE]Public Class ConnectionString …

Hello everyone, I am developing a form in VB.Net and ASP.Net that enables a user to grab data from a SQL Server 2005 Express database and display the data on the screen depending on the search criteria that they provide. What would be the best way to go about doing …

Could you please tutor me on how to make this connection? (using visual studio 2008) @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\DBRestaurant.mdf;Integrated Security=True;Persist Security Info=False;User ID=annamarie;TrustServerCertificate=False;User Instance=True"

please tell me where am i wrong [CODE]try { OleDbCommand cmd = new OleDbCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "insert into purchase(pdate,bill id,ritem,suppname,smobno,qty,rate,amount,payment,balance) Values('" + dateTimePicker1.Text.ToString() + "','" + textBox15.Text.ToString() + "','" + textBox7.Text.ToString() + "','" + textBox12.Text.ToString() + "','" + comboBox2.Text.ToString() + "','" + textBox14.Text.ToString() + "','" + textBox13.Text.ToString() …

Hi All, When I run this script using bulk insert i got an error message but when I try the first 6 records there is no problem. can anyone give the reason and what is the problem? [CODE]Use chrisMartin Bulk Insert SampleTable_Jonel FROM 'c:\planning\ProductRecoveryDataFeedytd_3.csv' --Sheet 1 With ( DATAFILETYPE = …

hi you all, I am creating an application which requres generation of random keys cosisting of 4 numbers(0-9). However, i realized that at some point,the random numbers repeats themselves. how can i avoid this repetition.the numbers form the primary key of a column in sql database table.

Hello Everybody prop lame i am making a access sql helper and for writing the insert this code [CODE] Dim i As Integer TextBox6.Text &= "Insert Into " & ComboBox2.Text & " (" For i = 0 To ListBox1.Items.Count - 1 TextBox6.Text &= ListBox1.Items.Item(i).ToString() & "," Next TextBox6.Text &= ")"[/CODE] …

[code]StrSQLQ1 = "SELECT " & _ "CustomerCharges.JobOrderID, CustomerCharges.ClientID, CustomerCharges.ActivityDate, CustomerCharges.TaskName, CustomerCharges.Charges, CustomerCharges.LineSeqID, CustomerCharges.IIDNo,CustomerCharges.consignee CustomerCharges.marking, CustomerCharges.rate, CustomerCharges.m3, CustomerCharges.tonn,CustomerCharges.labor, CustomerCharges.storg, CustomerCharges.overtm, " & _ "JobOrderHeader.JobType, JobOrderHeader.CustomerName, JobOrderHeader.LedgerNo, " & _ "JobOrderLine.LorryOutDt, JobOrderLine.FL, JobOrderLine.VesselIn, JobOrderLine.ContainerTruckNo, JobOrderLine.ContainerSz " & _ "From " & _ " { oj (WMS.dbo.JobOrderLine JobOrderLine INNER JOIN WMS.dbo.CustomerCharges CustomerCharges ON …

i makinh MCQs question as my mini project in windows form application i m facing few problem plzz solve that 1. to count the score of total correct question and show at the last in windows form 2. when i selct any option(radiobutton) then next question appears with same number …

I'm want to join 2 table from access database and Microsoft SQL Server 2008 In microsoft visual studio 2008. Display join data in datagridview.

I want compare 2 datagridview table for calculation purpose. This is because this 2 table is come from different database. 1 is access and 1 is sql server. therefore I cannot join table.So I have 3 datagridview table to display data. I'm want datagridview3 ItemPerPack Column * datagridview1 Qty when …

I want get data from database SQL with ADo.net connection string in three text boxes by studentid. 1- studentid int (Textbox1.text) 2-Studentname varchar(50) (Textbox2.text) 3-StudentAddress varchar(100) (textbox3.text) --------------------------------------- when i insert Studentid. All data get automatically in others two textbox. How Can I Do It? Please Answer as soon as …

Hi, My requirement is to delete a selected row in the datagrid from SQL server. If no row is selected then nothing should happen. Below is my code [CODE] Private Sub BT_Remove_Click() On Error GoTo ErDsc: Dim MyConn As ADODB.Connection Dim MyRecSet1 As New ADODB.Recordset Set MyConn = New ADODB.Connection …

I created a new item > local database. I'd like to access the data from the database but I can't open a connection. I have, [CODE]SqlConnection con = new SqlConnection("DataSource=|DataDirectory|\\testDB.sdf");[/CODE] debugging will always halt at [CODE]con.Open();[/CODE]

i am creating an invoice creation project where every client has a certain date for payment per month. how do i put the system to update next payment date e.g if client x is supposed to pay on 6th every month and has paid for april,the system should automatically update …

So i have this problem with a database. Under a section Date of Birth there are about 110000 entries. There are some that just have the year, for example 1978, I'm wondering if there is a way where it can automatically put in /00/00 after the 1978? so it would …

I have a database in which customerid CustomerName 1 ------------- Yousaf 2 ------------- Aslam 3 -------------Manga 4 ------------- ABC ================================================= Now I want Count customerid Row. How can i do it In SQL SERVER I write the query [CODE]Select Count(Customerid) from studentinfo [/CODE]And I get Total Customer. [B][COLOR="Red"]I want display …

I'm running sql server 2005 and I need to pull information from 2 of the databases(all from the same server). All of the databases are identical minus the data. database1 = LCDEL database2 = LCDFV I need all of the location data from each database and instead of querying them …

You guys are always so helpful, this is like my "go-to" forum for bizarre questions :P Not sure if this should be enforced by the SQL server or the Application itself. If we have a table with 2 columns of type int, ColumnA and ColumnB, is there a way to …

If my application was designed to generate a "schedule" or list of dates, and I wanted to store those dates in a SQL server as an array, what SQL data type would I pick? [COLOR="Red"]ntext [/COLOR]seems excessive, and I don't think [COLOR="red"]date [/COLOR]would work...any suggestions?

Hello Guys, I need your help to obtain this records. I could not figure how how to do this in script. I would like to get the RMA # 3. but the records will pull out based on the type equal to 2 and date range.. Here is sample data: …

Hi Everyone, Thanks for your time. I have a question about COUNT in sql. Does anyone know how to display the COUNT if it is equal to 0? Please feel free to ask me any question if you don't understand my enquire. Thanks for the post.

Hi, I am new to the field of SQL and C#. In my form I have few textboxes whose values are to be inserted into SQL table on Submit button click. I have created Insert.cs App_code class which handles the Database operations. And code behind will insert the textbox values …

Can anyone tell me whats wrong with my script? sql server 2005 Error: Incorrect syntax near ')'. I have a feeling there is more wrong than that. [CODE]SELECT a.* FROM OPENROWSET('Data Source=10.10.1.31;Initial Catalog=RFDG;User Id=admin;Password=342ds2sa12e;', 'SELECT * FROM location') AS a[/CODE]

I have Following Procedure [CODE] alter PROCEDURE GET_REQUEST_FOR_LEAVE_N_ATTENDANCE @ENAME VARCHAR(100), @FR_DT DATETIME, @TO_DT DATETIME AS BEGIN SET NOCOUNT ON SELECT B.CEMPLOYEE_NAME,A.* FROM TRN_EMPLOYEE_ATTENDANCE_REQUEST A INNER JOIN MST_EMPLOYEE B ON A.EMPLOYEE_ID = B.EMPLOYEE_ID WHERE B.CEMPLOYEE_NAME LIKE '%' + @ENAME + '%' AND ABSENT_DATE BETWEEN @FR_DT AND @TO_DT SELECT B.CEMPLOYEE_NAME,A.* FROM TRN_LEAVE_REQUEST …

Hi Guys, I encounter error when i converting the string into datetime. My datetime field is shipdate and returndate. also there is a Null value both of this field. btw, here is my code. can you please modify my code any idea that you can share with me to fixed …

Hi I am creating an store procedure in sql server 2005. i want to pass table name as parameter dynamically in sp. here is my sp but it give me an error [CODE]ALTER PROCEDURE dbo.ImportToTable ( @TableName nvarchar(100), @que_id int , @sub_code int, @chap_no int, @que nvarchar(max), @opt1 nvarchar(max), @opt2 …

Hi Expert I am working with a project in c# vs.net 2005 and sql express as backend. I have successfully completed the works.i want to connect my application and sql express on lan. I have successfully connected the data base one day before but because of some problem i have …

Hi, Anyone please help out. By using select query i am getting this following output. [B] itemname idno name price A B01 sa1 10 B B01 sa1 40 C B01 sa1 50 D B01 sa1 100 [/B] But i don't want this(as above one) type of display in my browser. …

Hello Everyone! Am working on a project and its ready for the production server. I used the windows login controls and ASPNET.mdf as the default database. I have moved the folder containing the project to the production server and deployed it on IIS but when a uer tries to access …

Hi, I have a table field with var char data type having values like TVM/345/2000,TVM/01/00,TSR/42/01 etc.I want to extract the sub string from first location to the second '/' location as TVM/345/. Is there any built in function to solve is? Thanks

I am new to SSRS 2005 and in my report my results are all be displayed page by page as in 1 record per page and I would like multiple records per page. My data is simply select address1, city from location These are my two values. =Fields!address.Value =Fields!city.Value How …

I have a PHP shopping cart system and it's using MS SQL for the backend. Currently it's using the mssql driver. Now I want to move it to Windows Azure and I'm required to change the driver to sqlsrv 2 in order for it to work there. Can anybody tell …

Hello, Please could someone help me on this. I have a button on which when clicked will display the crystal report. This report displays as required but when I want to view the report the second time, there's this error message: "Index 0 is out of range, Parameter name:index". FYI …

help please.. how can i store the selected value from my database to a variable in my c# form... (eg. variable=select idnum from tblename)<--- i know i cant do that.. how can i pass its value?? im talking about a specific value from the database. lets say i log in …

Dear All, I am writing a web application based on C#. What I would like to achieve is the following: an application that uses a single, global SQL connection. Which can be opened or closed when querying the db. I think it would be nice to avoid instantiating an SqlConnection …

Syntax Error in Insert Into statement. pls give correct code for me.[code]Imports System.Data Imports System.Data.OleDb Partial Class login Inherits System.Web.UI.Page Dim cn As OleDbConnection Dim cmd As OleDbCommand Dim dr As OleDbDataReader Dim icount As Integer Dim str As String Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) …

Hi, I followed the following [URL="http://www.coderanch.com/t/424312/JBoss/Configuring-Eclipse-JBoss-MySQL-EJB"]http://www.coderanch.com/t/424312/JBoss/Configuring-Eclipse-JBoss-MySQL-EJB[/URL] to configure JBOSS and MSSQL Server in Eclipse. But I'm getting an error and I tried many ways but I'm still there. (In this guide "5. Copy the driver libraries to jboss-5.0.0.Beta4\server\default\lib" means copying jdbc.jar ??? right?) When I run an EJB project I'm …

I have a simple C# windows form which acts as a login, but also has a form to change the password of a user. When you click on Change Password the form loads with a text box of current password, new pass and confirm new pass, and one save button. …

I have developed a system which should be accessed remotely. the system reads sql credentials from a notepad file to authenticate to the remote sql server. however, when trying to connect, the system says: "request for odbc permission failed". but if i put the application on the client machine together …

Hi All, i am creating a Desktop application using Microsoft Visual Studio .NET 2008.. i am using .sdf file as my database... my problem is that when i am making changes to my records (add new, deleted, updated) then the changes reflects only till my application is running when i …

I have developed a system which should be accessed remotely. the system reads sql credentials from a notepad file to authenticate to the remote sql server. however, when trying to connect, the system says: "request for odbc permission failed". but if i put the application on the client machine together …

hi guys, i'm hoping some one will be able to help. i basically want to create website where people can upload pictures and then other people can view them and leave comments iv created the website of how i want it but i dont know how to create the database …

hi... im not able to update data in vb.net....here is my code: cmd = New SqlCommand("update tbl_Account_charts set AccountTypeid='" & cmbAccountType.Text & "',AccountNumber='" & TxtAccountNumber.Text & "',AccountName='" & txtaccountname.Text & "',Status='" & chbmark & "',UpdateDate='" & sys_date & "' where AccountTypeid=" & AccountID, con) cmd.ExecuteNonQuery()