passing file name to a method; how do you create null values in a SQL server database via a C# program

Craig

1.I've created code that reads in a text file from a particular format and creates a SQL server database. I would like to encapsulate this code in a method. I would like to pass a file name into this method as a parameter which would be used to define a stream reader object file dynamically:

StreamReader tr = File.OpenText("C://My Documents//filename.txt");

Does anyone know how to do this?

2. In created variables from my text files, some of the values are missing which I would like to convert to null values in SQL SERVER. How can I do this?

Thanks

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jan Montano19y ago
Here's one way of using DBNull
http://www.c-sharpcorner.com/UploadFile/sd_patel/EnterNullValuesForDateTime11222005015742AM/EnterNullValuesForDateTime.aspx
0
Craig19y ago
How do you use DBnull.value?

Thanks
0
Jan Montano19y ago
Have you also tried using DBNull.Value?
0
Craig19y ago
Thanks,

I'm new to SQL SERVER
0
Mahesh Chand19y ago
One way to solve this problem is, if a parameter is NULL, just don't pass that to SQL Server when you INSERT or UPDATE database and keep default value of the column in NULL.
0
Craig19y ago
Sorry guys! I'm new to C#. I found a solution.

Question 1)

I can pass in the filename verbatim using an @

string filestring = @"C://My Documents//cexercises//labtest1.txt";

I can pass this as an argument in the method:

public void dbrun(string sql90input, string sql00input, string filestringput)

I then can use the string in the file.opentext method of the streamreader class.

StreamReader tr = File.OpenText(filestringput);

A simple solution!

--------------

Using this approach, I can pass in different files to read in my method.
0