9,022 Topics
Hi, I am developing a website for a club and I am trying to get the next games to show up. I am trying to get some info out of one database and then use that info as a key for the next query, then display all the results that …
i have a file excel and i imported it into sql 2005 with it's name is QLHP ,now i want to delete QLHP database in sql 2005 using c#. Please help me! Thanks so much!
G'day, I'm wanting to generate non-sequential 12 character codes to use as coupon codes or gift vouchers in mssql server 2008. I wanna avoid generating a random and checking existing, but i don't know if it's possible to generate shortened guids? like maybe a nuid or a suid? any advice? …
Hey All, I'm struggling with a project set to me that involves allocating shifts to staff that work within an Event Venue. Basically, staff only work when there are events on. Therefore, I have a database that contains tables showing: - Staff - Events - Shifts (for the above events) …
Thanks to you guys I have been able to get my first application halfway going. But I have a question about data integrity. The application that I am developing utilizes a single sql server and multiple work stations accessing that sql server. What is the best way to maintain data …
Hi, I have a little problem with a macro I'm working at. I need to pull data from a database and then show it in an excel sheet. Everything work fine till the moment when I want to close the recordset . Then my application freezes and I have to …
I've got a form prepopulated from a row in a database (grabs the querystring from the URL to determine the row) and this works fine. I'm using the pageload function on the code-behind file to do this. The button onclick has a function that is supposed to take the data …
Hi this is the code i have [CODE]NewCustomerTable.Clear() NewCustomerconnection.ConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source=G:\Shop.mdb" NewCustomerconnection.Open() NewCustomerAdapter = New OleDb.OleDbDataAdapter("INSERT INTO Customers VALUES ('" & txtNewID.Text & "','" & txtNewFirstName.Text & "','" & txtNewLastName.Text & "','" & txtNewAddress1.Text & "','" & txtNewAddress2.Text & "','" & txtNewPostcode.Text & "','" & txtNewPhoneNumber.Text & …
I have a combobox that is populated by a SQL querry. Problem is the first item of the comboBox where normally the comboBox.text go is blank. You have to drop down the menu item for the items to appear. I want to comboBox to populated with the first item in …
Hi everyone, This is the error i am getting when i try to do SqlCommand.ExecuteNonQuery(). My application runs on multiple threads and constantly opens, executes and close connection. This error i am getting after running the application for some time. Error: System.Data.SqlClient.SqlException: A transport-level error has occurred when receiving results …
Hi Guys, I am currently creating an application to track timekeeping (a clock in/out system) and I am trying to work out the best way to do this. I have a Main Form which contains buttons to ; - Log in - Out for Break - In from Break - …
I've got a form prepopulated from a row in a database (grabs the querystring from the URL to determine the row) and this works fine. I'm using the pageload function on the code-behind file to do this. The button onclick has a function that is supposed to take the data …
Like below quotes for serial no. for VB.net, do you have codes for ms access? Anil Gamare *********** [QUOTE=Jx_Man;682096]Try This : [code=vb.net] Public Sub GenerateNotaId() Dim myReader As SqlDataReader conn = GetConnect() conn.Open() Dim temp As String Try Dim sql As String = "SELECT MAX(IDNOTA) AS 'KODE' FROM Nota " …
[B][I][COLOR="Green"]Hi,[/COLOR][/I][/B] i am currently doing a project that will be used to add employees to a database. I have already designed the form and have gone ahead to do some coding. Though am stuck a bit, i can not be able to detect whether the employee does exists in the …
Hi, Does anyone know how i can AutiFix (ie check that all tables and primary keys are setup) an SQL database? A company i was working for a few years ago had this facility on their software and i was really handy. Daniel.
Hello, I'm using Windows 7 Ultimate 64bit. I'm on admin account and all I want is to develop my ASP.NET pages on my main system - not only on virtual machine with XP istalled. The problem is that I cannot access the database on Win 7. IIS is working, ASP.NET …
Hi, Hello all. I installed SQL Server 2005 on Windows 7 together with SP3. I set the surface area configuration to allow TCP/IP and named pipes. When i try to connect the machines running SQL, i fail, i cant access it. Neither can i change any settings in the surface …
Hi, i'm not sure this is in the right place but here goes: I'm currently using ADO in VBScript to access a SQL Server database and one of my current issues is returning the full error message that a stored procedure generates. I can get a brief error description and …
How do I prompt the user to enter an 8 character code that I will use in an MS SQL query script?
Hello. I'm using Visual C++6.0, and Windows XP. I am trying to connect to a database. I want to add some records to it, reading the values out of edit boxes. Here is my Code: [code=cpp] CDialog::EnableConnections(); ::CoInitialize(NULL); _ConnectionPtr con; con.CreateInstance(__uuidof(Connection)); con->Open(L"Provider=Microsoft.Jet.OLEDB.4.0;DataSource=C:\\Documents and Settings\\204504519\\Desktop\\webcam.mdb",_bstr_t (""),_bstr_t(""),adOpenUnspecified); _CommandPtr cmd; cmd.CreateInstance(__uuidof(Command)); cmd->ActiveConnection = …
[B][I]download our free dating software worth over $350 for free asp.net with sql server software is available with full source code [url]www.websol-dating-software.com[/url][/I][/B]
Dear all, I have this query to generate sql row to XML Mode. [CODE]SELECT CurrencyID, CurrencyName FROM MasterCurrency ORDER BY CurrencyID FOR XML RAW ('Currency') , ELEMENTS;[/CODE] the result is : [CODE]<Currency> <CurrencyID>AUD</CurrencyID> <CurrencyName>AUSTRALIAN DOLLAR</CurrencyName> </Currency> <Currency> <CurrencyID>CHF</CurrencyID> <CurrencyName>SWISS FRANC</CurrencyName> </Currency> <Currency> <CurrencyID>EUR</CurrencyID> <CurrencyName>EUROPEAN EURO</CurrencyName> </Currency> [/CODE] I want the …
So the deeper I get into my first Windows Forms application the more I'm questioning myself. In the VB6 days I would distribute my apps with a password protected MS Access db (not very secure) and hope nobody hacked into it. In this app. I created my MDF in MS …
Looks like I can't stop having problems with SQL haha I'm trying to delete a value from a database using the following code, and I have no idea where it's going wrong. It gives the messageboxes saying the operation goes through ok, but doesn't actually delete the data. Here's my …
Newbie SQL programmer. Here is my issue. I have a field, memid, varchar 30. I want to look at positions 1-9. If all are 9 positions are numeric , move those to memssn int field. Can anyone assist me? thanks
When I try to find some old post that was solved a while ago, and search my 'Solved' threads in my profile page, I find multiple entries for the same thread. Is this by design or is it poor sql. Would it not be easier to the get a 'distinct' …
Wat i need to choose in sql db tabel "Collation" to make posible to read russian letters please help THX
Dear All, I have search a lot of forum or blog for this problem and have yet come up with a solution.. Hope anyone can help me here... Thanks a lot!! I am using Ms Visual Basic 2008 Express Edition (vb.net) Here is my code: [CODE] Private Sub btnUpdate_Click(ByVal sender …
In my program theres a form where the user enters the ID number and other details of a customer. i want the program to be able , If the ID number already exists when the user enters it and clicks on ok, to display an error message telling them that …
Hi all... I got a stored procedure to compare dates and if the date is not valid it returns an error in sql server. I need to know how i carry that across to vb. Thanks..
I Have Created Following tables 1.Test_Student(Master) table which will contain StudentId(primary key), StudentName and StudentAddress as columns. 2. Test_Subject(Master) table which will contain SubjectId(primary key) and SubjectName as columns. 3. Test_StudentSubjectTrans (Transaction) table. This will be a transaction table between Test_Student and Test_Subject. This table will contain StudentId and SubjectId …
Heya guys, this is my first post - this forum has been loads of help in the past :) Anyway, I am currently coding a program that requests a user's Log In name and password, and then (via a SQL query) checks it against a record in the database, and …
hi, i work on a csharp application with sql server ce database and i have this code: [CODE] private void recherchebtn_Click(object sender, EventArgs e) { SqlCeConnection con = new SqlCeConnection(); con.ConnectionString = @" Data source= `|DataDirectory|\Database1.sdf"; try { con.Open(); } catch (Exception ex) { MessageBox.Show("connection failed"); } finally { SqlCeDataReader …
Hey Everbody, Iam quite new to web development. I have this issue to design a search engine and I cant figure out where to start from.Following is the problem statement 1.Users access our website and send a request. For each request, . In response to each query, the 3rd party …
I have Column named 'Price' in a table.I want to update the 'Price' Column by adding 5 .But i have some Null values in 'Price' Column.Whenever i update the 'Price' Column.All Values Updated Except the Null Values Column.So how can i update the null Column.Pls Help Alok
in the below quote i took from Devasya i implemented in SQL MS VS 2008, and there is an error coming any idea about it???? The code is : [code] db.openConnection(); int j = 0; int k = 0; string[,] a = new string[100, 100]; string data = "\""; for …
Guyz, i just want to ask if you know any links regarding Crystal Report Tutorial, Or Video Tutorial of it that will teach on how to create a Crystal Report. If someone who can teach me on how to create it then it would really be fine for me.. Im …
Hello, I’m using Perl script where executing SQL query which connecting to SQL loader to insert my data into table. When the script runs the success status returns, but the loader doesn’t load anything to DB, I want to get the Perl return value to compare it. Here is the …
hello all, i have the following VB code which is expected to activate a storred procedure from SQL DB. for some reason i recieve a msg that the procedure does not recieve the inpute parameters. the code: [code] Sub Validate_Data() 'check if data is there: If Cells(5, 6) = "" …
hi, how to i get the data i the dategrid view and save it in the SQL database in C#. and also how to aloow the user to enter details from the grid view. thankxxxx
I'm lost. I've been trying to do this for a while now and I can get halfway what I need. But I can't tell if it's working or not, or where my problem is. I don't want to use the wizard in VS to add a data source, I'd like …
Hi everyone, I'm a graduate student, hoping to graduate in December. I'm currently taking a database course and I'm having one tough time doing the assignments. My professor is pretty inept so I'm hoping some of you will be able to help me with my assignments. Don't worry, I'm not …
Hello All i have a query on (Union all) clause i want to create a table through union clause. the code i am trying to execute is: [CODE] select * into table1 from (select * from partmst union all select * from importexcel) as mytemp [/CODE] but it shows error …
hello all, i want to save the web page content into a database. how can i fetch data from that website and save into a sql database. im using c# as front end. need help. expecting reply soon since it needed for my project. thanks.
Hi, I am new to xslt creation. I need some clarifications on xslt creation. Is it possible to connect the database using xslt? For example i have one request_details table in sql server. i want to connect to this database using xslt and get the maximum request_id value from the …
Hello friends, I have a membership site where members will submit their data and choose a template to display their information. On this site, I want each member to have his own subdomain (eg membername.mysite.com) whereby anybody that enter the subdomain into the address bar will be directed to the …
Hello I want to compare an inserted date against two stored dates in order to validate an entry. The date entered is being stored in a separate table from the stored dates. I am not sure how to go about this. So far I have this: [CODE]create PROCEDURE sp_GetTime @FullName …
I've created an SSIS package where I have an FTP Task inside a ForEach Loop container. I am trying to loop through each file in the particular folder and send it to the FTP site. I am sure that I got the For Each Loop working, as the error message …
Hi Everyone, Can you tell me how to change this code so the value in my DatePicker control will update to the database in this update statement? [CODE] strAttendanceUpdateStatement = _ "UPDATE Attendance " & _ "SET DateOfClass = " & DatePickerDateOfClass.Value & ", " & _ "Absent = " …
Hi, I am using Python 2.3.4 in Linux environment. I have some sql files, I execute sql files in a loop. I want to generate seprate log files for every sql files in loop. How can I do this. regards pankaj
The End.