ASP.NET

Re: data set break through loop in vb.net

16-Jun-09 16:28

This is a disaster

prabhat kumar mokama wrote:
If fileNamePart(filterarr).ToString.ToLower = "the" Or fileNamePart(filterarr).ToString.ToLower = "be" Or fileNamePart(filterarr).ToString.ToLower = "is" Or fileNamePart(filterarr).ToString.ToLower = "an" Or fileNamePart(filterarr).ToString.ToLower = "a" Or fileNamePart(filterarr).ToString.ToLower = "are" Or fileNamePart(filterarr).ToString.ToLower = "of" Or fileNamePart(filterarr).ToString.ToLower = "for" Or fileNamePart(filterarr).ToString.ToLower = "in" Or fileNamePart(filterarr).ToString.ToLower = "on" Or fileNamePart(filterarr).ToString.ToLower = "at" Or fileNamePart(filterarr).ToString.ToLower = "to" Or fileNamePart(filterarr).ToString.ToLower = "shall" Or fileNamePart(filterarr).ToString.ToLower = "will" Then

Consider writing code that's not case sensitive, and storing these words somewhere so it's easy to add/remove them

I can't work out the rest, or what you're asking. Perhaps if you point out where in the code you need help ?

Christian Graus

Driven to the arms of OSX by Vista.

"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.

I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp

souravghosh1816-Jun-09 22:07

souravghosh18

16-Jun-09 22:07

First of all don't give others code to net.
Second what are you doing in the above code do not matches with your Query.
Third First clear your logic then learn .net and then post a query.

SQLBulkCopy & Adding values [modified]

munklefish16-Jun-09 0:43

16-Jun-09 0:43

Hi,

I am using the following code to take data from a csv file then adding it to an SQL database using SQLBulkCopy.

I need to add an additional column of data to each record transfered. This extra column is present in the SQL2005 database but not the CSV file, and relates to the users unique ID.

At present i have this:

    using (OleDbCommand dcmd = new OleDbCommand("SELECT * FROM " + strUPloadFile + "", dconn))
    {
        try
        {
            dconn.Open();

            using (OleDbDataReader dreader = dcmd.ExecuteReader())
            {

                // Bulk Copy to SQL Server
                using (SqlBulkCopy bulkCopy = new SqlBulkCopy(WebConfigurationManager.ConnectionStrings["######"].ConnectionString))
                {
                    //bulkCopy.ColumnMappings.Add("adds_ABMId", 45);
                    bulkCopy.ColumnMappings.Add("adds_Email", "E-mail Address");
                    bulkCopy.ColumnMappings.Add("adds_RecipientForename", "First Name");
                    bulkCopy.ColumnMappings.Add("adds_RecipientSurname", "Last Name");

                    bulkCopy.DestinationTableName = "tbl_AddressBookAddresses";

                    // Set the BatchSize.
                    bulkCopy.BatchSize = 500;
                    try
                    {//perform copy
                        bulkCopy.WriteToServer(dreader);
                    }
                    catch (Exception ex)
                    {//error
                        throw(ex);
                    }
                }

            }
        }
        finally
        {
            dconn.Close();
        }
    }
}

I could really do with some help on this.

Thanks guys!
Confused | :confused:

modified on Tuesday, June 16, 2009 6:49 AM

himanshu256116-Jun-09 1:32

himanshu2561

16-Jun-09 1:32

Add column this way

string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + filepath + ";Extended Properties='Excel 8.0;HDR=YES;IMEX=1;'";
       DbProviderFactory factory = DbProviderFactories.GetFactory("System.Data.OleDb");
       DbDataAdapter adapter = factory.CreateDataAdapter();
       DbCommand selectCommand = factory.CreateCommand();
       selectCommand.CommandText = "SELECT Fname FROM [Sheet1$]";
       DbConnection connection = factory.CreateConnection();
       connection.ConnectionString = connectionString;
       selectCommand.Connection = connection;
       adapter.SelectCommand = selectCommand;
       DataTable dt = new DataTable();
       adapter.Fill(dt);
       DataColumn dc = new DataColumn();
       dc.ColumnName = "Lname";
       dt.Columns.Add(dc);
       foreach (DataRow dr in dt.Rows)
       {
           dr["Lname"] = "LastName";
       }

himanshu

munklefish16-Jun-09 1:50

16-Jun-09 1:50

Himanshu,

I see this creates a data table, which isnt what i really wanted to do.

Thanks for the suggestion, but how do i then extend this code to perform the SQLBulkCopy over to the server????

Thanks.

himanshu256116-Jun-09 21:44

himanshu2561

16-Jun-09 21:44

Hi,
i dont think there is any way to add columns to datareader.
try this

string connectionString1 = @"Data Source='local\SQLEXPRESS';Integrated Security=True;Pooling=False;Initial Catalog='MASTER'";
         
            string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " + filepath + ";Extended Properties='Excel 8.0;HDR=YES;IMEX=1;'";
            OleDbConnection con=new OleDbConnection(connectionString);
            using (OleDbCommand dcmd = new OleDbCommand("SELECT Fname FROM [Sheet1$]",con))
                {
                    try
                    {
                        con.Open();

                        using (OleDbDataReader dreader = dcmd.ExecuteReader())
                        {
                            DataRow myNewRow;
                            DataRow[] drcol ;
                            DataTable dt = new DataTable();
                            dt.Columns.Add("Fname");
                            dt.Columns.Add("Lname");
                            myNewRow=dt.NewRow();
                        
                             while (dreader.Read())
                             {
                                 myNewRow[0] = dreader.GetValue(0).ToString();
                                 myNewRow[1] = "Test123";
                                 dt.Rows.Add(myNewRow);
                                 
                             }
                            drcol = dt.Select();
                            using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connectionString1))
                            {
                                bulkCopy.ColumnMappings.Add("Fname", "FirstName");
                                bulkCopy.ColumnMappings.Add("Lname", "LastName");
                                bulkCopy.DestinationTableName = "T_EmpDetail";
                                bulkCopy.BatchSize = 500;
                                bulkCopy.WriteToServer(drcol);
                                
                            }

                        }
                    }
                    finally
                    {
                        con.Close();
                    }
                }

himanshu

munklefish16-Jun-09 23:40

the force strong in you is

16-Jun-09 23:40

I managed to come up with a very similar solution to this but a little simpler since i only need to add a column and populate it, rather than adding new rows.

Ill post the details later.

Thanks again for all the help everyone!

what mean this write

jason_mf16-Jun-09 0:09

jason_mf

16-Jun-09 0:09

<asp:LinkButton ID="lnkUpdate" runat="server" OnClientClick='<%#Eval("Sys_TV_Id","return update({0})") %>' OnClick="lnkUpdate_Click">修改</asp:LinkButton>

this linkbutton in repeater.
I do not konw " Eval("Sys_TV_Id","return update({0})") ".

<script type="text/javascript">
function update(ID){
var data=new Array();
if(ID==null ||ID==""){
temps=eval('document.form1.id');
var j=0;
for(var i=0;i<temps.length;i++)
{
if(temps[i].checked==true){
data[j]=temps[i].value;
j++;
}
}
}
else{
data[0]=ID;
}
if(data==""){
alert('请选择操作对象!');return false;
}
else{
$("updateId").value=data;return true;
}
}
</script>

Re: what mean this write

pompeyboy216-Jun-09 0:38

pompeyboy2

16-Jun-09 0:38

know means this what dont I. Sorry!!

Re: what mean this write

Baran M16-Jun-09 0:46

Baran M

16-Jun-09 0:46

Questions is not clear. Could you please elaborate

Education is not a way to escape poverty — it is a way of fighting it.

munklefish16-Jun-09 0:51

16-Jun-09 0:51

the force strong in you is

Re: what mean this write

Christian Graus16-Jun-09 18:32

16-Jun-09 18:32

For future reference, if you google the Eval method, the MSDN docs give you the overloads.

This evaluates Sys_TV_Id, and puts it in place of {0} in the string provided. In other words, it calls string.Format.

Format GridView

yesu prakash15-Jun-09 23:48

yesu prakash

15-Jun-09 23:48

Hi,
I need to display diffrent images in a cell of a gridview according to the value to be filled there.

Eg:
My gridview display:

100 200 400 100 600
200 200 100 400 100

I want to display diffrent images for each number, If 100, image1. for 200, image2...etc.
thks

Re: Format GridView

Baran M15-Jun-09 23:57

Baran M

15-Jun-09 23:57

in GridView1_RowDataBound event you can check the value of the cell and you can add controls to that cell accordingly

You are best person who knows about your problem.
-------------------------------------------------
More pain more gain

Re: Format GridView

Abhijit Jana16-Jun-09 0:02

Abhijit Jana

16-Jun-09 0:02

Then what is the problem, when before bind the Grid, check the value and based on that bind image path with the Grid image control.

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net
View My Recent Article

Re: Format GridView

Christian Graus16-Jun-09 0:04

16-Jun-09 0:04

Read this:

http://msdn.microsoft.com/en-us/library/aa479350.aspx[^]

It's definitely nicer to call a code behind method to return the URL, but you can also have the datasource return the image filenames based on content.

Getting debug info

Matt Cavanagh15-Jun-09 23:47

Matt Cavanagh

15-Jun-09 23:47

Ive got a page which works fine on my home IIS test server but throws a runtime error once ive copied it to shared server.

Runtime Error
Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.

Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".

Ive done the custom error thing mentioned above, and set debug to true but It still just shows this generic error. And I cant catch it with a try catch because it happens even before the page load(so I presume its a problem with web.config?).

So how do I turn errors on?

Re: Getting debug info

Christian Graus16-Jun-09 0:02