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

Question

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

Jan Montano · Answer

Here's one way of using DBNull http://www.c-sharpcorner.com/UploadFile/sd_patel/EnterNullValuesForDateTime11222005015742AM/EnterNullValuesForDateTime.aspx

Craig · Answer

How do you use DBnull.value? Thanks

Jan Montano · Answer

Have you also tried using DBNull.Value?

Craig · Answer

Thanks I'm new to SQL SERVER

Mahesh Chand · Answer

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.

Craig · Answer

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.