9,022 Topics
please check my code: it use to generate number in date format my problem is that it doesnt show any output in the textbox nor in the database the last num in my database is 2012010001 [CODE] Dim i As Integer Dim strSQL As String Dim strMonth As String Dim …
I have an access database where one of the fields is named 'mod' and it contains string HEX codes such as AE093C, 00C394, 405FD0 etc. I am trying to use a data control to do a 'findfirst' on this field but I keep getting the error 3077 'syntax error (missing …
hi there i have problem with my MS SQL server some one execute unwanted update statement on huge table and make loss for my data i fix it by using available backup but, i need to know who,can i do it if there are some logs for sql statement please …
hi friends. Im currently working in integrating GR Fingerprint SDK with vb.net application. I am using MSSQL 2008 as my database and vb.net as the front end. I have completed almost 90% of the application and im stuck in integrating this SDK with my application. It has an error such …
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.SqlClient; using System.Data.Sql; using System.Data; using CrystalDecisions.CrystalReports.Engine; using CrystalDecisions.Shared; namespace test { public partial class WebForm1 : System.Web.UI.Page { string username; string fname; protected void submit_Click(object sender, EventArgs e) { username = nametxtbox.Text; fname = fnametxtbox.Text; CrystalReport1 …
I have a storedProcedure in SQL-Server that I am using to delete duplicates from one of the tables. This storedprocedure makes use of a cursor. I tried to create the same storedprocedure in microsoft access by just replacing the 'CREATE PROCEDURE' with 'CREATE PROC' but it didn't seem to work. …
Hi, I have a table that stores records of students. Now what I want is that after a particular period of time the account of the student gets disabled automatically. Is there any time based trigger that can be hit automatically if i set the time limit for that. Or …
Hi guys, Need your advice. I ask my boss if i could have a training for SSAS and he replied positively, im not connected in IT we are different department but were using MS SQL and we do some analysis and reports using excel and SSRS. im helping other department …
Guys I am having problem restoring the database from a created backup file.. Actually the situation is like this: 1> I created a backup for my database from my office 2> I mailed that database to myself so that i could use it in my home.. 3> I tried to …
I need to count the number of records in an SQL database and compare it to a text file that contains a records number. Although I know how to access a SQL database in C#, I do not know how to count the number of records, or how to access …
Hi, For the users, i grant the permissions to create a table and then i also given the permission to alter table i.e grant alter on san to user; Logging as user: Table (design mode), am getting the error: "You are not logged on as the database owner or system …
I'm lost on this one. I've got 3 tables involved here. An Accounts table, AccountsContacts table and a Contacts table. The AccountsContacts is a junction table between the two. The key columns for the tables are: Accounts: ID AccountsContacts: AccountID, ContactID Contacts: ID I need a way to select from …
VB.net 2010 How I want the date: 2012-01-24 11:48:40.000 How I my program is exporting the date: 1/24/2012 11:48:40 AM currently I am using the sqlreader myreader.GetDateTime(10) which is giving me the format of 1/24/2012 11:48:40 AM
i want my order id to be autoincremented and stored in textbox and when i hit click, it gets stored in datagridview, so i can save my order in bulk from datagridview again. my code have some issue [CODE] 'i put this on formload (order page) Dim order As String …
I am having a table named "Society" And 5 master tables "BlockA","BlockB","BlockC","BlockD","BlockE". The "Society" table contains the foreign key columns of all the 5 master tables. Now when i write the select query it takes a lot of time to execute, as 5 tables are referencing one table and joining …
So I've looked for an answer to this question on the web but couldn't find anything that covers this specifically. Our database stores the project version in the format #.#.# (Rev_#) so there is both text and numbers in the string. I have no control over the data so I …
Hi. I was creating an enrollment system for my Thesis, and my adviser told me that I must have a Code in my program that Synchronize database from client and server so that if the terminal connection is "Up" the data will go to the server and if the connection …
Hi, I'm trying to use filestreaming (SQL 2008) with Visual Studio 2008 to load a file into a folder. I have a window that allows the user to select the file he wants to load into a SQL Server table called Available_files and then my code loads the document into …
I Build an ASP.NET project with PL,BL,DAl, BE of Entity Data Model(=.edmx) which I generated from a service Based DB (= .mdf) which is located in my DAL project. I did copied the connectionString from the BE app.config to the PL web.config what's wrong? why I get this error: System.Data.SqlClient.SqlException: …
I've successfully developed a software using VB.Net and SQL server 2005. i have this problem. when i create exe, it can use to my computer because of SQL server is already installed in my computer. but if i want to use that software in some other computer, must i install …
Hi a have 4 tables Table A ID | Data 1 --------------- 1 | A Table B ID | Data 2 ----------------- 1 | B 1 | C Table C ID | Data 3 ---------------- 1 | D 1 | E 1 | F Table D ID | Data 4 …
Guys, Need your help. i need to obtain the nearest date from 3 tables. attached my scripst. th problem with this scripts it creates double entry in receipt date with the same transaction specially for this ESN "268435459407885398". [CODE] SELECT p.ESN, p.ReturnDate, s.Receiptdate, e.Shipdate FROM #Product p with (nolock) CROSS …
I have Sql2008 enterprise edition and want to install on windows 7 ultimate edition,it is giving error for version compability.what is required to do?
This is my very first trigger and I'm not sure I have it set up correctly. I have a table called PayTypes. Here is my trigger syntax: [CODE] ALTER trigger payTypes_trigger on PayTypes AFTER INSERT, UPDATE, DELETE s PRINT 'AFTER TRIGGER EXECUTED SUCESSFULLY' [/CODE] I run this with a breakpoint …
Hi, I am having trouble with retrieving records on my database. My layout was this.. [CODE]UsersList Username Firstname LastName Role Records TheUser ApprovedBy DateApproved [/CODE] The first text are the table names while the indented once are the field names. I have a table named Records. TheUser and ApprovedBy was …
Using VWD Express 2008, GoDaddy Hosting, SQL Server, ASP.Net VB I am very new to ASP.Net and have been working on a site and at one point, everything worked properly on local server. However, I have uploaded the site to GoDaddy hosting and the log-in function of the site does …
Hi, I want to convert Single Column values to Row. Table Original Content: Code Amount Expenditure 10027 5000.00 LOCAL CONVEYANCE 10027 320.00 LOCAL CONVEYANCE 10116 1589.00 TRAVEL EXPENSES 10095 350.00 LOCAL CONVEYANCE 10095 1215.00 TRAVEL EXPENSES Expected Output : Code LC TE 10027 5000.00 NULL 10027 320.00 NULL 10116 NULL …
hi, can someone help me? i am using vb.net2010 and mssql as my database. what i want to do is when i open the form, the database will auto increment the student id and show it on the text box.
I am writing an application which calculates profit from 3 column values. The SQL is as follows in vb dataset designer; [CODE]SELECT ID, Sale - (Weight * 20) * (Rate -5) AS Profit From AgencyRegister WHERE (DatePart('yyyy', ArrivalDate) = ?) ORDER BY ArrivalDate[/CODE] I want to add another column of …
Hello Every one ! i am trying to make query to show the growth of sale of the product month wise ,i have one table name Sales .having following fields , SalesID,ProductID,amt,Qty,SalesDate i use this query to show my records [CODE] select ProductID,Amt,Qty,substring (datename(month,SalesDate ),1,3)as months,DATENAME(YEAR,salesdate ) as years [/CODE] …
Hi, I am trying to use the PIVOT function in SQL Server 2008. I have a query that I think should work, but whenever I execute it, I get the errors: Msg 265, Level 16, State 1, Line 25 The column name "CompleteTime" specified in the PIVOT operator conflicts with …
Whats up guys, So I am debugging my companies program that the previous programmer has created. It is buggy and an annoyance in my life and I want to get this done as quickly as possible. Ive already fixed some bugs and published the updated version onto our server. HERE …
i was using ms access as my database where my default value for coloum was "" empty string . now i have shifted to sql 2008 where i cannot put empty sting as default value in the same manner as in access i.e "" . here i have to put …
hi, what i need to do is to get information from 2 tables and show it to the listview. for example, i want to get the surname, first name and middle name from the student_info table and the Payment_Status from the accounting_system. i don't want to show the information that …
Hi, I seem to be getting the error "Syntax error in UPDATE statement." when attempting to update my database through visual studio 2008, using forms. Here is the code for the connection: [CODE]Private Sub btnLoadDB_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLoadDB.Click Provider = "PROVIDER=MICROSOFT.ACE.OLEDB.12.0;" Source = "Data …
Hi Guys , i have faced a sql command problem. That is currently i have 2 different table [ICODE]a) Select ID, Name from Table1 where ID >=1 and ID ID <=3 ID | Name 1 | Alan 2 | Amy 3 | Andrew [/ICODE] [ICODE]b) Select ID,Sum(Points) as [Total] from …
I need to store data to isolated storage with simple entry form,currently using class to load data but what i need to insert data and load it after emulator is restarted.I'v seen you can use sql ce database and xml file to store data,but which method will be best?Tried to …
I am using Visual Studio 2010 for ASP.Net web development. I am newbie in web development and using VS. I am making a website which requires storing user information in database. Here are the steps I followed for connecting 1. Open Server Explorer 2. Add new connection (I am using …
i want to create a stored procedure that can return the initial character of two string inside the description field. ex. Computer Security -> in one data only if i use this statement select left(description) from table1 i want to return only CS when i run my script. is there …
I have this OLEDB connection string connectionstring as string = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _ data.toString & ";Extended Properties=""Excel 8.0;HDR=Yes;IMEX=2 I just want to know what is the meaning of HDR and IMEX, and what are their purpose on the connection string Thanks..
I know to work with VB.net + crystal report + SQL server. But now i want to work with SQL server compact edition instead of SQL server. When we creating Crystal report it is asked provider in one moment. If we work with SQL server we select "Microsoft OLE DB …
I have an application and an sql server i would like to add Registration Code for the system. that should include the number of user
I have a form where a user can search for properties from a database. Everything is working except for the suburb search. I would like the user to be able to search for more then one suburb. At the moment I have the information from the textbox being separated into …
Some one help me here my problem is on the [CODE]conn.Open()[/CODE] it stated that "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to …
please tell me how to create database in sql server and also give me code for connectivity using visual studio 2008 and sql server.
Hello Every One ! I m working on a software , i have one field name expiry_Date , now i want to make an query which subtract the current date from the expiry_date and give answer in no.of days , i use getdate() for current date , can any one …
Good Morning Guys/Gals. Need some help with this. How long does it take to dispose of da and confdt? What im trying to say is, that this function works fine if i execute it every 5 seconds or so, giving it enough time to close the controls, but if I …
Good Day. I am using VB.net 2010 and SQL client server. I have to make a Weekly Report Manager that stores an Trainees' weekly activity, which would probably be in a paragraph form. I think I can use Textbox (multilined) or Richtextbox for this. But When I tried to store …
Hello everyone , I Want to make a news site , I have a sqlconnection but when i want someting between grid view and details View but its more like Details View , my only problem in details view is that i cant put paging number to say like take …
Parse error: syntax error, unexpected T_IF in C:\Program Files (x86)\EasyPHP-5.3.8.1\www\test\fuction\register.php on line 3 I get this error at my register page [CODE]<?php include('conn.php') do($_POST['register']); <form action="register.php" method="post" { $username=$_POST['username']; $password=$_POST['password']; $password2=$_POST['password2']; $date_now=date('Y-m-d'); if($password==$password2 ){ $query = "SELECT * FROM Member Where ID='$UID'"; $result_ = mssql_query($query); $numRows = mssql_num_rows($result_); if($numRows==0){ $sql="dbo.up_CreateMemberAccount …
The End.