9,022 Topics
Hi all, is there anyway to log SqlBulkCopy records, if that s correctly written over database table or not and if failed, the reasons? I am using C#. regards Jeet
Hai, Am Using SQL SERVER - 2000 Table Structure CARDEVENTDATE CARDEVENTTIME CARDNO 20090224 92007 485 20090224 92345 321 20090225 163932 168 20090225 164630 471 20090225 165027 488 20090225 165137 247 20090225 165147 519 20090225 165715 518 20090225 165749 331 20090303 162059 240 20090303 162723 518 20090303 155029 386 20090303 155707 …
Hi all, I need a help regarding with the extraction of a single value from the specific field that contains the datatype [B]nvarchar(MAX).[/B]
I am developing an application an am intrested in having to be able to backup and restore the full SQLServer database from the front end. i have succesfully done the the back up module using the code below [ICODE] Try Using dc As New SqlClient.SqlConnection(My.Settings.TRONICALConnectionString) dc.Open() Using dcom As New …
I am trying to connect to a sql server using login which accepts the username and password, instead of storing the credentials in the connection string. But whenevr I pass the variable in the connection string I am getting an error which says login failed for the user. Is it …
Hi, I already create connection to sql database and successfull. I need to know how to run two command together?...This is my problem:- [CODE] sqlcmd = New Sqlcommand ( "Select * from Staff_Main where Staff_id like '"&textbox1.text&"'",cn) dr = sqlcmd.executereader while dr.read() label1.text = dr.item(1) 'item 1 is name sqlcmd …
Hi, everyone this is my issue I have to read a binary record from the database and concatenate another string to it, the thing is that is just working one way, I ll put some code to explain better. [ICODE] buffer = rdGetBinary.GetInt32(3);//this is the length of the actual row …
I have a SQL Query build as a string but i cant seem to pass it into to the <cfquery> But it does not work any one can help me? [ICODE] <cfif ISDEFINED ('member')> <CFSET SQL = "SELECT * FROM precontract "> <CFSET SQL_Coubr = 0 > <cfif form.member neq …
I have followed the instructions on MSDN to "Display Related Data in a Windows Application" ( [url]http://msdn.microsoft.com/en-us/library/57tx3hhe(VS.80).aspx[/url] ). I have a data source that has a Customers table and a related Orders table. I can easily create a form which allows the user to select a Customer and display the …
Hi all I previously developed in Access and have recently decided to move over to SQL server back-end and vb2008 front-end. My Everest of problems which I can’t solve is the how to filter records by a user selected parameter. However, if the parameter is null then all records should …
Using vbscript I want to create a runtime html login page on the fly. The html page should have username/pasword form and I will use this username/password to connect to a sql database. Is there a way to create this runtimehtml page using vbscript and them collect the username/password from …
Hi all Sorry- The title was wrong, My problem is when I type a the ID number in the text box for updating the record, it gives me an error "Data type mismatch in criteria expression." Could anyone help me please in solving this problem? This is my update code. …
I'm trying to open a command prompt through the program and then run bcp. Here is the code. System.Diagnostics .Process proc = new System.Diagnostics.Process (); proc.StartInfo.FileName = "bcp"; proc.StartInfo.Arguments = @"select * from dbname" queryout C:\filename.csv -S servername\instance -U sa -P password –N; proc.Start (); On the queryout I get …
Dear Sir I have three tables 1. Categorys (ID, Name) 2. Definitions (ID, Name, CategoryID) 3. Versions( ID, Name, DefinitionID) I have generated three objects using EDM 1 Cagegorys Navigation (Definition) 2. Definitions Navigation (Category, Version) 3. Versions Navigation (Definition) I want to get latest versions against each category My …
I have Sql server 2000 personal edition which i always use.But today when i tried to copy the while CD to my system,every files are copied except (msolap which is 97.1 MB size).Can anyone please tell me the link where i can get msolap fresh copy for this particular Personal …
consider 5 subjects : A, B, C, D and E. subject A is the father of the subject B. Subject C is the brother of the subject B. subject D is the son of the subject B. subject E is the son of the subject C. Write a stored procedure …
Hi everybody, I want to join 3 tables and gain same data from these tables. 1.table: usr - user information usr_id 2.table: res- results res_usr_id res_exc_id res_result 3.table: exc- excercises exc_id exc_excercise_name Now I want print all results from one user and all excercises from one user.Can somebody help me?I …
Hi All, Can't insert data into SQL database... Keep getting error i dont know how to solve... Plz help Grtz Tiello [B]CODE:[/B] -------------------------------------------------------------------------------------- [code] Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim connetionString As String Dim connection As SqlConnection Dim adapter As New SqlDataAdapter Dim …
Please any one help me... I want to insert data automatically to the table while installing an application. how can i do this? Can I generate sql script for this??? Regards Jineesh
Friends, I would like to build a Commercial Of The Shelf (COTS) business application using ASP.Net & MS SQL. The application will be primarily used by many people located throughout India, Data volume shall be high at times & requires printing of Invoices and reports. I would like to know …
i have one student table stu id sex coloums 1 male 2 female 3 female 4 male 5 female i want retrieve the table male as female and female as male want the result table liek this stu id sex 1 f 2 m 3 m 4 f 5 m …
Hello to everyone !!! I have a problem with query in sql. Look in the photo and you will find details about my problem. Why i cant add a new record. When i will add ID, Emri and Cmimi i want to show them automatically... Does any one have idea …
Hello I am new to this forum. I am using MS SQL 2005 Express I have a database GK.dbo (the original databese) and I have created a database GK_2009.dbo (it is created from the original database, so it has the same structure) I want to create a script that would …
hi can u tell me how to develop an web application using vb.net and the application's data is stored in the database .and the database is mssql...
Okay so I have a multiline textbox that accepts user input and stores it in a database. I then have another form that queries for this field and displays it. Everything is working fine, except for the fact that it won't recognize new lines when the user presses enter. I …
I want to get the row number of a specific row in the table. Also is this legal? [code] INSERT INTO (SELECT * FROM myTable WHERE mynumber=2) VALUES ........ [/code]
Hello All. I am having doubt that, is MS SQL works on Apple Mac Os X AND ".NET" too ??
Hello All. I am having doubt that, is MS SQL works on Apple Mac Os X AND ".NET" too ??
I am having a problem running an ssis package from a service written in C#. Here is my code [CODE] try { //Package Path string packagePath = @"C:\\data_from_listcleanup\\programmability\\Package.dtsx"; //create an instance of the package Package goPackage = new Application().LoadPackage(packagePath, null); //execute package DTSExecResult result = goPackage.Execute(); //write results to file …
Hi, I have a MS access 2007 form with two fields TEST_ID and TYPE and a button. When button is pressed i want to populate all the entries matching TEST_ID and TYPE in datasheet view from table Test_Data. For this, i have added code for SQL query in FindData_Click. I'm …
I have a database, which has atable called Company. Inside are columns with the basic informations (company name, street, post, city, tel.numbers, ...). I would like to know to populate listBox with company names which have a "stationary number" in the database when checkBox is checked! But I mean if …
Hi all, I have a table named comments having columns id, name, email, comment, commentedon, approved, and approvedon. In some cases I would like to let the admin of my asp.net web page to approve all the comments at once. Which would be the effective sql code and why? update …
i need something like a function to do a specific job which work in a specific time.Like every first day of the year i want to sum all the members account amount to my tbl_information table's column. How can i do that?
Hi, I have 1 textbox and button to insert value into sql server database 2008. But the problem is in database it not appear correctly when had zero front of value....example :- 00001.....in database just appear 1...i try to use nvarchar,varchar,nchar but still same...] Can anyone guide me...tq
All, I have an issues form in a database (MS Daily log) and when you fill in the form it save the data into an issues table. Everytime you do this it gives each issue an ID number (auto number). Basically I want to fill in the form then before …
I have a data source. I want the null values of my text to be printed as a new line in my text area. How can I do it? Think of sql table 1-I am 2-null 3-good I want it to be printed on textarea like this. I am good
I am helping a friend with a project in Visual Basic, it is a program that uses a SQL database. There are some rows in the database, we can review them just fine. So the SELECT quesries are fine, it is the INSERT queries that we are having problems with. …
Hi and greetings to all members, I have MSSQL server 2000 instaled on XP SP2, and I am accessing him over internet and VPN connection, router and ADSL operational, and it works well. Now I added, on remote side, another computer, conected to LAN with first one, and I want …
Hye! i have some doubt that i am registered for mcp and now i dont know how many papers i have to given on c# and in sql server 2005 so plz guide me...... thankyou
Hi, noobie here. Anyone know how to tranfer my asp.net membership credentials from my localhost to online? I have a webhost that I am using to test stuff that I do offline, and have been uploading everthing after I try it on my local machine to see how it works …
[QUOTE=Richy321;880968]Thanks for looking btw.[/QUOTE] Hi I also try to connect sql with c++. Please if you connect than tell me how you connect it. And explain these two lines,I found only two errors of these lines. 4.import "C:\Program Files\Common Files\System\ADO\msado15.dll" \ 5.no_namespace rename("EOF", "EndOfFile") Thanks in advance.
Has anybody used this microsoft tool SSMA? I can connect the two databases OK, and can convert tables from ORACLE to SQLSERVER 2005, but the data refuses to go across. Any info will be helpful. Thanks, Jim
hello guys.! I just have 1 problem right here. I have a variable declaration below: [code=vb] myVar ="Argie's" "Select * from [my Table] where [my Field] ='" & myVar & "';" [/code] When i execute the query, it returns error because the myVar value contains Quotes and sql server does …
Hi, I'm pretty new to the whole SQL thing, and i'm basically self teaching using manuals, online help and the fact i pick things up quickly. I'm having a bit of trouble picking data up from 2 tables and i think i'm just beign really thick. This is what i'm …
I have the following data in a table named dtlstbl which has columns id and refid 100,1 100,2 101,1 102,2 103,1 103,2 I am fetching data from this table thus select id from dtlstbl where refid in (1,2) All the records are returned. I want a SQL 2000 query that …
Hi, I have a small problem, I am trying to insert a new row into a batabase table using linq to sql. I have Microsoft publication on Linq but it was based on the beta of Linq and does not match the current version completly. I have a class P11Entry …
Hi, i need to find tutorials or open source projects to build stuff (think it will only be security, which i think that [url]www.asp.net[/url] might be able to assist me in a tutorial, but i also need something that will teach me/let me include on my site to have text …
Hi, I've been asked to create a proof of concept for a new database tool we need to develop, combining various existing databases. It’s been awhile since I’ve touched any database work and I’m a little unsure how to go about it. Let me explain the problem...the analogy I’m using …
I'm trying to set the selected value from a combo box that is populated from my database, i cant seem to find a way to do that. I'm using this to populate my combo box: [I]Private Sub PopulateCountry() Dim country As New Client Dim contryList As OdbcDataReader = country.mpopulateCountry() Dim …
hi guys could you tell me where did i go wrong with this code , i managed to connect the php with sql server but when i want to do a login code... it always failed even though i have input the correct username and password(it's like the php does …
The End.