|
Hello:
I get this error when trying to add a series of datarows to a datatable
Any Ideas, Here Is the Code:
Public SaveIt()
{
DataRow dr;
for(int i=0;i<12;i++)
{
dr["Months"] = arrMonths[i]; //Throws Exception
MyDataTable.Rows.Add(dr);
}
MyDatSet.GetChanges();
MyDataSet.WriteXml(strFileName, XmlWriteMode.DiffGram);
}
TIA
GostWrtyer
}
|
|
|
|
|
GostWryter wrote:
I get this error when trying to add a series of datarows to a datatable
"this" has no associated context as you have not actually given an error message.
There is no data row object here.
DataRow dr; does not actually create a DataRow object, only a reference to one, and since you don't reference one then the line fails because you are trying to use a DataRow that does not exist.
To create an appropriate DataRow object use DataTable.NewRow()[^] before trying to use dr. e.g.
dr = MyDataTable.NewRow();
My: Blog | Photos | Next SQL Presentation
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More
|
|
|
|
|
Colin Angus Mackay wrote:
"this" has no associated context as you have not actually given an error message.
Yes he has, it's in the subject line 
Seriously, while looking at the code, I would expect that it would generate an "Object instance not set to an object" exception instead of that column not found in table.
For GostWryter, yes, the solution given by Colin should fix your problem. A little more explanation. You need to use the DataTable to create a new DataRow so the row contains the table's schema (columns for example), even if the row itself is not in the table yet (that's why you Add it to the Rows collection later.)
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
|
|
|
|
|
|
Hello all:
First...Pardon My Grammar !
Second The call to dr=MyTable.NewRow(); was not there .
Thanks
GostWryter
|
|
|
|
|
in Layout Design,
Is there anyone know the trick, how to put some field(s) into the Page Header Section ?
coz, in every page i wanna show those field(s) shown.
Thank You.
email : sukasukabo@hotmail.com
|
|
|
|
|
Hi
I have a basic question. I want to copy a table in a db to another db (in the destination the table has to be created first with proper columns). the table name and schema will remain same. (I'm using sql server 2000).
Can you provide sample ado.net code, by which I can achieve that?
Thanks
|
|
|
|
|
Aha - so you did post here as well. See my response in the C# forum, you sly dog.
Click here.[^]
The most exciting phrase to hear in science, the one that heralds the most discoveries, is not 'Eureka!' ('I found it!') but 'That's funny...’
|
|
|
|
|
This method is fine only when source and destination tables are in the same server.
What if they are in different servers?
|
|
|
|
|
hi,
is there any other way of executing a sql script in sql server 2000 besides using the sql query analyzer or the enterprise manager itself?
for example my database server (sql server 2000) is up and running.
what i want do is to change one of the stored procedures. i have made the changes and generated the script.
now is there any way that i could upload this script to the deployed sql server and automatically execute it at some fix time?
please do answer this question, even if the answer is "no" or nobody knows!!
thanx in advance
☺«««DTA»»»☺
|
|
|
|
|
In C:\Program Files\Microsoft SQL Server\80\Tools\Binn you should fine a program called osql.exe. This is a command-line query running tool.
Alternatively, many installation tools (Installshield, wise, windows installer) support some method of executing SQL on a server.
my blog
|
|
|
|
|
thanx a lot Steven. osql.exe was just the utility i needed! works great for me!
One thing that comes into my mind now is that, if sql server 2000 provides such a utility, does this mean that there might be a tool or program for the versioning of all the Stored Procedures, or any objects in the database? if you could refer such a tool/program, it would be Heaven on Earth for me! 
thanx a lot!
☺«««DTA»»»☺
|
|
|
|
|
Sorry to disappoint, but there is no built in versioning support in SQL Server, at any level. The best you can do is manually include comments at the start of your stored procedures, to indicate change history.
There are some 3rd party tools that do database comparisons, and will be able to tell you when database structures are different. I cannot recommend anything specific though.
my blog
|
|
|
|
|
no disappoint at all!! not after "oslq.exe".
i think i will go for the manual approach, because third party tools usually involve some sort of licensing problems, and versioning in my case has the lowest priority. so i dont think that i'll be spending any money for this purpose!
thanx anyways!
☺«««DTA»»»☺
|
|
|
|
|
Anybody know about a good document to learn and set up replication?
Cheers
Al
|
|
|
|
|
No, as far as I can figure, there are no good ones. I think the reason is that there are so many "ifs and buts", i.e. technique x works, but only if you structure your inserts this way, but if you have a BLOB column then you have to do it another way unless the planets are out of alignment, and then you have to apply the "jupiter" hotfix. Its just too complex to write about in any meaningful way.
Unless you are willing to put many many hours into the learning effort, my best advice is to hire a consultant. As a bonus, you'll have someone to blame when things go wrong.
my blog
|
|
|
|
|
Hi,
As far as SQL Server replication goes, the best bet is http://msdn.microsoft.com/librarydefaul.asp?url=/library/en-us/replsql/replover_694n.asp
You could also learn to implement replication on the internet through the front end e.g using SQL Merge Replication Object for Merge Replication. The URL for the same is at MSDN , a few links below the link given above
|
|
|
|
|
What to do if I like to store an XML-file of size up to 10MB in SQL 2000 Server? What is the “best” solution of that problem. What type of column should I use and can I use the regular “INSERT INTO” SQL statement…
_____________________________
...and justice for all
APe
|
|
|
|
|
Best solution do not inster that into SQL 2000, Save it into the hard disk and just store the path in SQL.
Cheers
Al
|
|
|
|
|
Don't store files in the database if not absolutely required. It will put a large load on the database server and the network. If it is a web app, it can also tie up valuable threads for extended periods and cause delays for users.
If you must do it, store the file in text, ntext, or image field types. To store the file use a TEXTPTR and the UPDATETEXT commands. If you google on these, you will find some examples.
|
|
|
|
|
of course ! i added a textbox in my application and user can input some text in english like : The message you are replying to , then i split the textbox values into the array and search each word and fill in datagrid but the datagrid show me database where it store . for example like this
1. are
2. the
3. to
4. message
5. replying
6. you
|
|
|
|
|
Hello!
I would like some help with the following:
I want to get one (1) result out of two columns. I have for example "user1" and "user2". I would like to have "user1" as the result if "user2" contains the word "flintstone" and I would like to have "user2" as the result if "user1" contains the word "flintstone". I would like either of these to merge into a common name such as "user" or something, that I can use further with ASP.NET DataRepeater. Hope you understand, I have a sketch as well:
SELECT user1 FROM table WHERE user2='flintstone' --\
>-- user
SELECT user2 FROM table WHERE user1='flintstone' --/
Thank you!
|
|
|
|
|
Hi,
I am not clear with ur Query but just try this............
SELECT user1 User FROM table WHERE user2='flintstone'
UNION
SELECT user2 FROM table WHERE user1='flintstone'
I hope this will help u.............:->
Regards,
Ritesh
|
|
|
|
|
:-Dhai,
iam connecting the ado.net through a wizard or server explorer or manually using adapter. it is connecting in the dataset but iam getting error as given below:
An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll
Additional information: System error.
can anyone help me to solve this problem
Even i need a manual source code connectivity of ado.net
Success in Career
|
|
|
|
|
Hi,
Try this code.........
<code> Private Sub PullData()
'DECLARE VARIABLES
Dim ds As New DataSet("DataSetName")
Dim dr As DataRow
Dim myConnection As New SqlClient.SqlConnection("Data Source={Local};database=Northwind;user id=sa;")
Dim myAdapter As New SqlClient.SqlDataAdapter()
Dim myCommand As New SqlClient.SqlCommand(("SELECT LastName, FirstName, Title, BirthDate FROM Employees"), myConnection)
Try
myCommand.CommandType = CommandType.Text
myAdapter.SelectCommand = myCommand
myAdapter.SelectCommand.Connection = myConnection
myAdapter.Fill(ds,"Employee")
Catch ex As Exception
lblMessage.Text = ex.Message
End Try
'Close connection
myConnection.Close()
dataGrid.DataSource = ds.Tables("Employee")
End Sub</code>
I hope this will help u.............:->
Regards,
Ritesh
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
