9,022 Topics
I am using vb.net ajax to load a crystal report located on the server - sometimes it works and other times the call to .export just hangs sql server and we have to restart the sql server. I can't find any discussions of this error anywhere and I'm sick of …
One of the people where I work did a migration from Access to SQL Server and just about everything migrated okay. However, all of the UPDATE and DELETE queries, when they were migrated, ended up having the "`" character interspersed throughout the query, which causes errors when trying to run …
how to create xml file from a database table using vb.net I tried a code but it doesn't retrive values from the database table How to resolve this And my code is: <%@ Page Language="VB" ContentType="text/html" ResponseEncoding="iso-8859-1" Debug="true" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> …
Hi, I'm just confuse about this.. I am making a form with 2 datetimepicker controls which are the Start and End date and when I click the action button it displays all the departments covered with the start-end date and it works fine but the problem is it loads all …
sir i have three sheet in excel..first sheet i have many colounm with filder option..in second sheet i have same coloum with filder option .IN third sheet also same ..sheet name only varying ..what i want is in first sheet i have one colounm name is form with filder( C,F,S)..IF …
I need the steps to make an daily Back Up to my data base i am using SQL 2008 and when i do the backup job it gives me an error unsuccessfull complete , any one can tell me why ??
hi every one , can some one give me an idea or code of how to save .PDF file and .dwg into sql server and preview these file using image box in vb6 if can ????
Hi guys, I added a extra line of code to test for records in the database and if they exist to update them before inserting them instead. For some odd reason it's not working and it simply just inserts the data causing duplicates. Any suggestions? <%@ Import Namespace="System.Data"%> <%@ Import …
I am working in a dataware house and few things are not clear to me that is why I wanna discus here. For example, I have 10 MS Access files, and each of they have more than 5000658 number of rows, and data is in such a format like **Plz …
Imports System.Data.OleDb Public Class LoginForm1 Private Sub OK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK.Click Try Dim con As New OleDbConnection("Provider=Microsoft.jet.oledb.4.0;data source=C:\Users\Documents\VodStore\VodStore\bin\Debug\VodStock.mdb") Dim cmd As OleDbCommand = New OleDbCommand("SELECT * FROM Users WHERE userid = '" & UsernameTextBox.Text & "' AND password = '" & PasswordTextBox.Text & "' …
Hi All, I have an SSIS question regarding looping through CSV files with the Foreach Loop Container. What I have: 1. A string variable named fName - Global 2. A Foreach Loop Container 2.1 User::fName mapped to the loop container with an index of 0 3. A Data Flow Task …
Hi, i have a database with the following details: SCHOOL CAMPUS ADMINNO MODULECODE MODULEGRP SEG AMK 100810R EG3932 EG3932-G1 SEG AMK 100810R EG3933 EG3933-G1 SEG AMK 101427Y EG3901 EG3901-G1 SEG AMK 101427Y EG3902 EG3902-G1 SEG AMK 101427Y EGS650 EGS650-G1 SEG AMK 103852S EG3901 EG3901-G1 SEG AMK 103852S EG3904 EG3904-G1 now …
Hi All, Hopefully I don't get too scolded here for this question but I can't commit my mind to answer this as I have been ill and am still not fully recovered. In saying that, I have the following set of tables (see pic) and I need to fill in …
i want save image in directory path and also save path in database...sqlserver 2005 and retrive in in same folde and path
Ok so im working on a mapping library for my pathfinding system and im trying to figure out what Data structure would be best to use for rapid calls up to several hundred a second, as low memory usage as possible, and not too difficult to store and load pieces(chunks) …
Good'ay all, I'm looking for a method of saving a users session (I.e. automatically logging them back into the same page they logged out from). But I have a few things to consider: 1) Will they logout or will they just close the browser? This means I can't add the …
Greetings fellow developers, can you guys give me a hint on how to check if the datacolumn or datarow on the database has a value or null value what i want to happen is if the column1 has a value then the button is disabled. Dim Str As String Str …
Hi All I just want to know the following thing; When SQL Functions are used? Provide a couple of examples of situations in which they are necessary. Awaiting response... Also can anyone refer me a ebook for SQL for beginners in which Functions is desscribed detailed...
I've built a SQL report in MS SQL Server Report builder for our ticketing backend. I want to be able to do custom reporting. I've created this report by using the following query: SELECT SR_Service.Date_Closed ,SR_Service.Date_Entered ,SR_Service_SLA_Workflow.Responded_Minutes ,AVG(SR_Service_SLA_Workflow.Resolved_Minutes) AS Avg_Resolved_Minutes ,SR_Service.Hours_Budget ,SR_Service_SLA_Workflow.SR_Service_RecID AS [SR_Service_SLA_Workflow SR_Service_RecID] ,SR_Service.SR_Service_RecID AS [SR_Service SR_Service_RecID] ,SR_Service.Company_RecID …
Hi All I have googled this exception extensively, and all the discussions I've found seem to be related to file uploading and exceeding the allowed file size limit. In my case however, I am not uploading anything, it is a simple postback. I have a gridview displaying the results of …
Hi All, Is there any way to read/extract data from sql server backup file without restoring it? Thanks.
Write a select statement that will display student id, student last name and the number of courses a student has been enrolled. You will need to join two table, use a COUNT aggregate and a GROUP BY clause in your SELECT statement. this is something i found on internet, im …
I'm trying to delete a couple of rows USING SQL Server management studio, for 2 rows only i get the message No rows were deleted Error message A problem occurred attempting to delete row #X Error Source: .Net SqlClient Data Provider Error Message: String or binary data would be truncated …
Hello, I use OleDbCommand object to make Insert, Update and Delete statements in SQL Server database but I don't destroy that <b>OleDbCommand object</b> and I wish to know what is the most optimal procedure to destroy it? I have 3 choices: <big>- DISPOSE in Finally section...</big> <small>Imports System.Data.OleDb Public Class …
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; namespace WindowsFormsApplication4 { public partial class Form1 : Form { SqlConnection clientConnection; string connString; public Form1() { InitializeComponent(); connString = "Data Source=ASPEE56\\SQLEXPRESS;Initial Catalog=Test;Integrated Security=True"; clientConnection = new SqlConnection(); clientConnection.ConnectionString = connString; } …
1. Display student id, student first name, student last name, the students’s faculty advisor id, advisor last name, advisor location and phone number. You will join uc_student and uc_faculty 2. Write a SELECT statement that will return the faculty last name, faculty first name and the room for faculty whose …
I am currently working on a report and I am trying to build a query that keeps giving me this error: `"Data type mismatch in criteria expression"` In my first query, I am calculating the difference between two dates to get a day until our ship leaves port (ex. 6/12/13 …
> I have 1 form whose columns are slno,type,shape and another form where i want to retrive data from database using combo box. if i select slno from combo box in form2,then rest of the fields should display in other textbox in form2. Dim cn As New SqlConnection("Data Source=.\INSTANCE;initial catalog=record;user=sa;password=gariahat") …
Hi, I want to use session state in mode SQL Server I googled some parameters to add in `<sessionState mode="SQLServer" />` in web.config file like: * Sql command time out. * State network time out. * Compression enabled. * Max pool size. * Min pool size. So I have some …
hi i have 4 DropDownList i made connction with database sql server 2008 and create 2 button NEW , SAVE button here funtion to DropDown Protected Sub DropDownList_Init(ByVal sender As Object, ByVal e As System.EventArgs) Handles RadComboBox6.Init If flagNEW <> "NEW" Then Dim adapter As New SqlDataAdapter("SELECT ID,DESCR , ACCT_NO,MAISTAKE_ID …
## Before You Ask ## - Engage your brain! We understand that running into a problem can turn off the rational centers of the brain, but please sit back and think for a bit about your problem before running off to find help. All too often a little common sense …
Hi All, What Wrong with my QUERY ! it show Repetition of Record in INNER Join i.e when i have 3 record in database it show it 9 time using This query.... SELECT dbo.EmployeeSetup.EmpID, dbo.EmployeeSetup.EmpName, dbo.EmployeeSetup.FatherName, dbo.EmployeePayment.Designation, dbo.EmployeePayment.Department, dbo.EmployeePayment.Salary, dbo.EmployeePayment.Advance, dbo.EmployeePayment.Deduction, dbo.EmployeePayment.OvertimeAmount, dbo.EmployeePayment.PaymentDate, dbo.EmployeePayment.ModeOfPayment, dbo.EmployeePayment.NetPay, dbo.EmployeePayment.PayMonth, dbo.EmployeePayment.Fine, dbo.EmployeePayment.Fund, dbo.EmployeePayment.Insurence, dbo.EmployeePayment.Tax, …
Ok so im reading int values from an sql database but then the "Executor" comes back as a hex value and it is declared as a int value in sql..all the bit field values i have comes back correctly accept the int values. can someone help me ons this, what …
:Notes Repeater :Dim Notes RepeaterDataSource As sqlDataSource = e.Row.FindControl("DataSource1") :NotesRepeater DataSource.Select Command = "SELECT *FROM [contact.Notes] WHERE Type = 'POC' AND ContactID = " & Me.ContactsGridview.Datakeys(e,row.RowIndex).value
Hey guys, New to the site, new to writing SQL queries and have no background in this type of thing. But I've been googling my way to victory for the most part. I'm struggling on probably a very simple problem. I'd like to Sum the contents of a column, if …
Good Afternoon, I'm looking to connect to a MSSQL database on an external windows server, I'm creating a PHP script (on a linux server) which will pull data from the database so I can enter into my new MYSQL database. I would also be looking to specify the port number …
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim b As String = "" If TextBox1.Text = "" Or TextBox2.Text = "" Then MsgBox("Data tidak lengkap", MsgBoxStyle.Information, "Login") Else conect = "select * from tbl_id" cmd = New SqlCommand(conect) dr = cmd.ExecuteReader() Try While dr.Read If …
I am trying to build a crystal report view. As a newbie here, i have no idea how connect it to my database. I am refering to a tutorial in here (link) [URL="http://csharpdotnetfreak.blogspot.com/2009/07/creating-crystal-reports-in-aspnet.html"]http://csharpdotnetfreak.blogspot.com/2009/07/creating-crystal-reports-in-aspnet.html[/URL] In the tutorial it teaches the connection of the database using OLE DB(ADO). But i failed, because …
Hi, I have a string formula and I wanted to execute it in sql server 2008 UDF function. Please suggest to proceed. P.S. I have tried with exec () - error occurred.
hello...i am doing a project on connecting c language with sql. but i am unable to write the program in c language by using the sql code for connectivity. plz advise me as how to learn to write the c program using sql.
i would like to be helped on how to get sql and php tags for an online application system
hi i need to save rss to sql every day first load read and write sql and other read from my db Imports System.ServiceModel.Syndication Imports System.Xml Imports System.Data Imports System.Data.SqlClient Partial Class _Example4 Inherits System.Web.UI.Page Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Dim RSSReader As …
Hi All, This is something I should know but for whatever reason today it is eluding my mind. I'm trying to query our database to provide me with data between March 2012 and March 2013. Initially, I had the following line: where a.IPI_Ref_Date between '2012' and GETDATE() and the output …
Need some help here. I was trying to make a Stored Procedure in MS SQL 2008 which will make use of comma delimited string as Parameter in my WHERE [COLUMN] LIKE [PARAMETER] condition. Somehow, I was able to select rows of data from my DB table that matches the set …
Dear All ! I have a table member_email. i have 4 columns in it. Id Email CellNumber Carrier I want to create constraint who check following conditions, 1-Email can be null if Cellnumber is given , and Cellnumber can be null if email is given. 2-both email and cell number …
What are the function of SQLAllocHandle() SQLSetEnvAttr() SQLFreeHandle() SQLBrowseConnect() Can any onw help me understand them in detail I searched and understood them slightly. However, I'm reading a project without a documentation in which they are used and I'm confused too.... much. Thanks in advance
Group, I may have made a huge mistake repairing SQL Server Management 2008 Express. Here are the details: I'm running Windows 7 on a Toshiba Laptop. SQL Manager 2008 had been installed and was working fine. I had some registry errors popping up, so I ran ARO 2013 to do …
i have crated a job to backup automaticly my database , when procees happen failure message appear , anyone can help me ?? thx BACKUP DATABASE [MYDATABASE] TO DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup'
hi. i have a problem in printing the report to printer. Now i can print the php reports, but it will open both printer dialog and page together. But I need only one to printer dialog box. Pls help me Below my code Connection database ` <?php try { $hostname …
Hi, As part my developement I would like to keep all employees document stored in database table rather in folder. I dont want to store the files in folder and keep the file location in table so that get the file from the location. I tried my level best in …
The End.