|
in database only its showing null...
|
|
|
|
|
So either you are getting it wrong from the spreadsheet or you are inserting it wrong.
|
|
|
|
|
I'm not sure this is correct forum, but it is used in Access DB.
I have existing XML file with following nodes (I think that is correct term)
<subname>
<name>SOME TEXT NAME</name>
</subname></code>
I would like to know how to construct a form (ASP or HTML) where I could have user enter the 'SOME TEXT NAME' part and it would APPEND to end of XML document.
I have seen some scripts and code that got close, but I did not understand how to modify to my needs. Any help would be appreciated greatly!
Thanks
|
|
|
|
|
gdmoland wrote: I have seen some scripts and code that got close, but I did not understand how
to modify to my needs.
That is called a learning process and for that you need a book and possibly a teacher. This is a support forum where we help developers solve problems not teach how to develop applications.
Your lack of understanding cannot be solved by a forum post!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
How can i connect SQL database with Vb6.0 application?
|
|
|
|
|
|
That's assuming that I know what ADO is and how to use it.
|
|
|
|
|
Not really. I don't.
|
|
|
|
|
Ngobi Arthur wrote: How can i connect SQL database with Vb6.0 application?
By writing code. VB6 is antique, there should be some manuals in the library. If there aren't, there's always the online tutorials[^].
If you are looking for a language to learn, then go for VB.NET.
Bastard Programmer from Hell
|
|
|
|
|
I'm trying to import an Access 2007 db using the SQl Sever Migration Assistant into a SQL Sever 2008 Express database. All the steps work fine in the migration assistant, and in the pane on the lower left I can even see the db in the target server, but when I open the SQL Sever Express db with SQL Sever Management Studio, the db is not there?
I can browse the following folder from windows and I can see the MDF file, but if I try to attach the db, I can browse as far as the DATA folder, but I cant open it to select the actual db.
C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\simmstock.mdf
Also if I try to move the mdf file, Windows wont allow it because it is being used by SQL Server???
Solved: I had another instance of SQL server installed on the machine that I was not even aware of (probably from a Visual Studio Installation) and I had migrated the Access database to the wrong server instance
modified 8-Apr-12 10:44am.
|
|
|
|
|
Is there a better way to get one row from a database. I have been using the Fill Method of the DataAdapter to fill a datatable, and then returning the first row of the table
Dim dr As DataRow
Using cn As New OleDb.OleDbConnection(cnStr)
Dim cmd As New OleDb.OleDbCommand(strSelect, cn)
Dim da As New OleDb.OleDbDataAdapter(cmd)
Try
cn.Open()
da.Fill(dt)
If dt.Rows.Count >= 1 Then
dr = dt.Rows(0)
End If
Catch ex As Exception
Finally
cn.Close()
dt = Nothing
End Try
End Using
Return dr
|
|
|
|
|
There sure is. For one thing, if you're using SQL Server you can use SELECT TOP 1 ...
If your database doesn't support that, you can use a DataReader and read only one row (but it won't be a DataRow).
|
|
|
|
|
Thanks PIEBALDconsult
The SELECT query should return only one row based on conditions in the WHERE clause, but I was wondering if there was a way to eliminate declaring a DataTable, and then equating the DataRow to the first row from the DataTable?
|
|
|
|
|
Richard.Berry100 wrote: only one row based on conditions in the WHERE clause
Oh, that's alright then. You probably needn't be too concerned in that case -- if it solves the problem so you can move on and then assess performance and such at a later date.
Other than that, I use a DataReader; I avoid DataAdapters except when I'm very lazy -- and then it always bites me back.
|
|
|
|
|
Richard.Berry100 wrote: but I was wondering if there was a way to eliminate declaring a DataTable, and then equating the DataRow to the first row from the DataTable?
Why? You can simply load the reader in your datatable and return the first row from a method. That way the table is out of scope and discarded.
If you really think that's consuming too much memory, then you should not use a DataRow , but an array of values[^].
Take a look at the section[^] that says "Working with DataReaders".
Bastard Programmer from Hell
|
|
|
|
|
I want to learn step by step implementation of the project tables
If someone can , please send it to me :confused:
|
|
|
|
|
Buy a book, work through some of the 1000s tutorials on the web and learn. Try sqlservercentral.com, they are always a good source of reference material.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
0) Get some data
1) Look for commonalities amongst the data
2) Draw diagrams of the data and the relationships therein
3) Create tables that reflect the relationships in the diagrams
4) Done
|
|
|
|
|
Hi,
I am trying to make Merge Replication for my .NET application and I manged to set it up but I have an issue. I am making the replication every 5 minutes where the publisher and the distributor are on the server and the subscriber on a local machine. Also, I am using pull type subscriber. Inside my .NET application I am accessing the data from my local machine(subscriber), but during the replication process,the data on the subscriber gets deleted which causes a problem to my .NET application and the end user cannot find his/her information because it being deleted and re-inserted into the subscriber later on. This is a serious issue because I am building a POS application and the user need the data instantly.
My questions, is there a way to make the subscriber to do make the pull data without deleting the current data? any idea is very welcome.
Thank you!
|
|
|
|
|
I have no help for you in the replication area, however this does sound like a really bad design. Some questions come to mind
Why do you need the data on a local machine
Why every 5 minutes
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I'm currently involved in migrating a few SQL apps that currently use DTS to SQL 2008 R2, and I'm looking at the SSIS development workflow.
Is it correct that you can *only* develop SSIS packages on a machine with a full version of SQL Server installed (i.e. not Express)? I've got the VS2008 BIDS installed, but if I try to create an IS project it complains that I don't have Standard, Ent, Dev or Eval versions of SQL installed.
Do people generally install these full SQL Server editions on their dev workstations, then deploy to the dev/test/prod servers?
Or do they use Remote Desktop? (Which seems a really clunky way tbh!)
What about the VS2010 SQL Data Tools? Do they overcome this limitation? (I would try but we're still on XP-SP3.
DTS seemed much easier, Enterprise Manager could develop packadges on whatever server it could connect to, or you could develop local files.
|
|
|
|
|
cjb110 wrote: *only* develop SSIS packages on a machine with a full version of SQL Server
That was my experience when I started using it two months ago.
|
|
|
|
|
The devs on our team doing SSIS do not have the SQL Server database installed, they use SSMS (I'd need to confirm this on Monday).
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Just wondering if your devs do have SQL installed?
I can't find any thing suggesting its possible!
|
|
|
|
|
Hi
I am receiving this error recently after i re-installed my windows OS in my project
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Arabic_CI_AS" in the equal to operation.
I should add that this was working before re-instaling the windows and sql server
|
|
|
|