User Profile

skumar11523 · Sep 4 '14, 09:03 AM

This is my data in Exmaple.csv
SYMBOL :20MICRONS
SERIES :EQ
OPEN :30.5
HIGH :33.6
LOW :30.5
CLOSE :31.15
LAST :30.55
PREVCLOSE :32.1
TOTTRDQTY :101214
TOTTRDVAL :3286508.05
TIMESTAMP :1-Mar-13
TOTALTRADES:989
ISIN :INE144J01027

this is my Table in sql
Collapse | Copy Code
CREATE TABLE [dbo].[cmpDailyRateMas ter](
[SYMBOL]...

skumar11523 · Sep 3 '14, 06:41 PM

Code:

private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                SqlConnection sc = new SqlConnection(@"Data Source=KALAS-PC\SQLEXPRESS;Initial Catalog=master;Integrated Security=True");
                sc.Open();
                using (sc)
                {
                    // FILEDOWNLOADED();

                    SqlCommand

...

User Profile

Profile Sidebar

Bulk load data conversion error

sqlexception was caught in c#and sqlserver running code