9,022 Topics
hi!!!!!!!!!! every body out there!!!!!!!! I have query for u all plz help me out!!!!!!1111 well I m working on project in which I m trying to use flash as frontened for making student information form with buttons such as 1)check (for checking whether this particular student exists or not) …
Hello Everyone, I need to upload excel sheet in to the database. Which i am doing with the query [CODE] SELECT * INTO temp FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\Dokumente und Einstellungen\l.varada\Desktop\BA-Control.xls', 'SELECT * FROM [qry_BA_Controlling (Report)$]')[/CODE] Here C:\Dokumente und Einstellungen\l.varada\Desktop\BA-Control.xls is the path from where the excel file needs to be …
hi every body when i add createuser control show me Configuration Error in line 140 of machine.config code [CODE]Line 138: <membership> Line 139: <providers> [COLOR="Red"][COLOR="Red"][COLOR="Red"]Line 140: <add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" connectionStringName="LocalSqlServer" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" applicationName="/" requiresUniqueEmail="false" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="7" minRequiredNonalphanumericCharacters="1" passwordAttemptWindow="10" passwordStrengthRegularExpression=""/> [/COLOR][/COLOR][/COLOR]Line 141: </providers> Line 142: …
I have a table for projects, it has two fields for [B]project_start[/B] and[B] project_end[/B] both have datetime data type. what should i do so that when the user insert dates on both field it will automatically subtract and place the answer on the [B]duration[/B] field... please help.. oh before i …
Hi all, I am developing an application which to use different local computers. There is a computer has a mssql 2005 express and my database on it, I want to use it all local computer (5 computers), connection string like that : [CODE]"Data Source=DARKOCEAN\\SQLEXPRESS;Initial Catalog=TestDB;Integrated Security=True"[/CODE] How can I use …
He friends, I have added a Local Database in My project(it's an SDF database) by following this: [COLOR="Red"]Right Click Solution Explorer > Add.. > New Item > Local Database[/COLOR] I have created a table in this database. Now I want to insert data into this database via windows form. I …
hi everybody i tried to use this code to made a query from ms sql 2005 using vb.net [CODE]com.CommandText = "(select [email],[lname] form users where [email] = ('" & TextBox1.Text & "') and [lname] =('" & TextBox2.Text & "')"[/CODE] my question is there any problem with it ???:icon_question:
Hi there, I have some questions regarding insert update and select queries in VS 2008. When writing select update and insert queries where should I write them. Is it in a class in visual studio or is it in the database as a stored procedure or something else. At the …
Hi team, I'm having some issues getting the results of my query to output on a data grid. I'm using an sql query to get the data from access, which is working fine, but then I want to output it onto a datagrid. My code is as follows just for …
hi everybody i dont now whats wrong whith this code below when i run it debug show an error with con.open() [CODE]Dim con As New System.Data.SqlClient.SqlConnection con.ConnectionString = "Server=iraq\\sqlexpress ; Database=stats ; Trusted_Connection=True ;" Dim com As New System.Data.SqlClient.SqlCommand com.CommandText = "insert into users values('" & TextBox1.Text & "','" & …
Hello So, recently I obtained a horrid assignment from lé boss, and I have yet to figure out how to do this. The idea is to select the ID(db_medlem) of all customers that have purchased for over 1000, in the year 2010. (I know its a funny syntax, but its …
I am creating a update member page. I would like the page to auto retrieve the information he or she originally used while registering on my site and display them into the individual textboxes of the update profile page, this is to prevent the hassle to rekey in every individual …
Hi, i have a problem trying to query my database based on a value in a label. Here is the code for the query, Dim myCommand As New SqlCeCommand("Select * from CDRecord where ArtisteName like '%(label4.text)%'", conn) It shows no errors but during runtime, i get a blank for the …
i want to create login form having password and username and validate the username and password inserted by user with data stored in sql data base .please can you help me with the coding how to validate?
Hi friends!! This is Sarmadi. I joined this website just a day back and till now i found it very interesting and useful for IT students. I am a computer science student. Doing BCA [Bachelor of Computer Application] along with DOEACC A level course. This is the last semester of …
I am trying to connect to SQL SERVER 2008 using a JDBC connection. I have read some older posts on this topic(SQL server 2000, SQL server 2005) and I feel there may be some minor variations and so am posting on this forum. I am running win XP with SP …
I have the following code: [CODE] Private Function BuildDataTable(ByVal fileFullPath As String, ByVal seperator As Char) As DataTable Dim myTable As New DataTable("MyTable") Dim i As Integer = 0 Dim myRow As DataRow = Nothing Dim fieldValues As String() = Nothing 'string FileToRead = Server.MapPath(fileFullPath); Dim myReader As System.IO.StreamReader = …
Hi!, when im trying to execute following code.i get this error.can any one help me to make it correct. java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression. at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source) at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source) at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(Unknown Source) at SelectApp.main(SelectApp.java:18) this is my …
Hi i m developing a payroll and attendance project in C# with MS SQL server 2005. currently i am facing a problem with one of my class. i can not understand the problem. now i would like to send my full code and database by email to anyone of your …
OK this is what I want to do: [LIST=1] [*]Log the User in by checking with a SQL Database with a table that has user name and password. Also that table is linked to another table with all there personal information [*]After they login, they have to enter information into …
Below are my stored procedure to change password and the VB.net code to call it. The Sored Procedure executes properly and returns correct values when executed from SQL Server directly, but it does not check its conditions and returns -1 when called from VB.net code. please help me in this …
Hi I have to save data in a TList and then save the setlist in a session and then set the gridview`s datasource to the session value. The problem is that the data is different all the time. I save the data in a sql server table. The data is …
NEED HELP !! Is it possible to run a DTS package( which has been saved as VB file) on a remote computer which does not have the SQL server installed? If yes, could u pls tell me in detail? I have searched a lot of inofrmation on internet like registering …
Hello everybody, I am c# developer but I have c# application and want to change it with Java because sometimes I have problem. I have 7 modems and my clients send package to my application and I want to listen it with thread ans produce an answer to them. I …
Can someone please help with the following problem I am trying to update a sql database through a command builder but I keep getting an sql exception (Additional information: System error.). I dont know where I am going wrong because I thought the command builder should carry out the update …
I need login form coding usin sql server with multiple user..[code][/code]
hi, not sure if im posting in the correct section but im working on a site registration for a mate this bit has been completed, however i am wanting to extend this and display a plethora of info but i have hit a bit of a wall. iam wanting to …
hi, I need to update my data in two tables simultaneously,for example if i update product id in one aspx page it should be updated in my sql tables where i use product id in all my pages we can join tables to view data but how to update.. hope …
Question: I just recently had a cut over for a web application using a SQL DB that was previously using xp_sendmail to dispatch messages to the users. In accordance with the cut over, xp_sendmail is no longer usable in Server 2005 and should be replaced with sp_send_dbmail. Previously, the emails …
Does anybody know if MS SQL Server has any built in functionality for preventing injection attacks? I remember I saw someone said SQL Server does have it. But I can't find it in a official source. So, If you know anything, please share it. Thank you very much.(an official link …
hi, Wen i give the submit button in my aspx page ,the datas is updating in sql,but the page refreshes with the old data,it should be clear in the corresponding fields. pl.guide me.
hi, i have create a program in C# windows application with backend SQl Server 2005. I have a done coding for save, delete,update. save and delete is working properly. But update in that i have an error message taht datetime is not in proper format.what should i do to convert …
hi! please help am still new on ASP and am having trouble deleting from a table please help. the code i used is this: [code=asp] <% set conn=Server.CreateObject("ADODB.Connection") conn.Open "Provider=SQLNCLI;Server=THABO-2A88C6501\SQLEXPRESS;Database=customers;User ID=sa;Password=thabo;" set rs=Server.CreateObject("ADODB.recordset") if request("Delete")="Delete" then sql="DELETE * FROM Details WHERE Cust_ID='4567'" end if%> <center><form method="post" action="Delete.asp"> <input type="submit" name="Delete" …
We have an app that uses a sqlexpress db. We need our customers to be able to swap the database for this app out for another sqlexpress db fairly easily. So we came up with a small launcher app that allows them to choose the db they want from a …
Hi... Am new to .net here. Hope am posting the question under the right category... My requirement is as follows: I have a gridview which is visible with an empty row on page load. It has four columns of which the first column is a text box item template. The …
Okay, so I've got THREE MSSQL Tables. First table is: Eponyms : ID, NAME, DESCRIPTION, CATEGORIES Second table: Categories : ID, CATEGORY Third is the intersecting table: EponymCategory : ID, EponymID<FK>, CategoryID<FK> The "Eponyms" table has the list of Eponyms, and the CATEGORIES column is inserted with data like "PSYCH …
Yesterday I converted my site over to MS SQL and now I'm having an issue with part of my site. The search box is supposed to check for a part number the user types in, but it doesn't even come close anymore. In Access the column searched was a Number …
I've tried reading through [B]datareader[/B] from the database. Tried dataadapter, reading from dataset and datatable. All of them generates an error when reading empty rows. Yes, I have used try and catch statements but the error still generated, that is transforming only in a messagebox. What I want is to …
I'm hoping someone can help me here. I have 2 tables in a access database. I'm trying to join certain data points from both, simple. I've done a few joins already for this site. But the problem I'm having is this one seems to be destined to annoy me. [code]sql …
I have 3 computers connected to each other, pc1 is the server while pc2 and pc3 are clients. I created a windows application using c# and MS sql server as database at pc2 where in the sql server was installed, anyway, i didn't installed sql at pc1 server coz of …
Hi, I'm a recent IT graduate, I want to upgrade my skills from what I learnt at college to the SQL Server 2008 platform. I want to also get certified with Microsoft, it seems a lot of companies are asking for this now. If you have gone through the certification …
I'm almost finish with my project that was made in visual studio 2008 using C#, so i want to ask this ahead of time. I want the project to be an executable file, this is my first time so how could I do it? One more thing, my form has …
Can u pls help me solve this problem iam using vb6.0 and sql 2000. when i insert the currnt date (as Now()) in the dbase with a colunm datatype date/time, it inserts the date 01/01/1900. In MSAccess it works by putting a # b4 and after the date e.g. #25/06/2010# …
Hello, In .NET im using the backend as SQL Server. but when i write codings for all insert,update and delete in .NET and run the form, the error it shows like "Oledb exception was unhandled by the user" and error in SQL query. the codings are....follows.. [code] imports system imports …
Hi I am trying to get information from two tables in the database but it gives an argument exception saying "Column 'SubContratorID' does not belong to table .” Which 'SubContratorID' is it referring to …?? [CODE]String query = @"Select ps.PSubContractID,s.SubContractorID,s.FirstName,s.LastName,s.Position,s.Email,s.TelNo,s.Agency From PSubContract as ps, SubContractor as s Where ps.ID=@id and …
Hi all, I'm working on conference room booking software with MS-Access as the back end. I need to retrieve the records which doesn't clash with the already booked dates. I have a table called conference_room_status which has the fields Conference_Room_Name | BookedPerson | DateFrom | DateTo | TimeFrom | TimeTo …
Dear Friendz Ihave face problem with null value i remove the chk from null value n sql server and when i direct save anything in table it dosen't accept null value but when i save these in my form it accept null value . i don't know why form do …
Hi there, I want to upload files with the extension pdf, doc excel and images to the MS SQL database from a C# desktop application. I am using C#.net and not asp. I want to upload a file from a interface to the ms sql database, Hey can someone guide …
Hi, Can anyone please help me in this. i want to retrieve a view in VB.i was able to do with the below script when using tables,but not with view [code] Dim strSQL_revenue As String Set rs_revenue = New ADODB.Recordset strSQL_revenue = " select * from dbo.PLAN_PNL_INTERUNIT_REV" With rs_revenue .Source …
sql 2000 i have this sql stored procedure i want the last coloumn fAcc_Total to be updated when a record is inserted. the value in the [COLOR="Red"]fBill_Amount[/COLOR] should be add to the value of the [COLOR="Red"]fAcc_Total[/COLOR] in the same time the record is inserted if there is a value in …
The End.