|
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.
|
|
|
|
|
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
|
|
|
|
|
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!
|
|
|
|
|
<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>
|
|
|
|
|
know means this what dont I. Sorry!!
|
|
|
|
|
Questions is not clear. Could you please elaborate
Education is not a way to escape poverty — it is a way of fighting it.
|
|
|
|
|
the force strong in you is
|
|
|
|
|
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.
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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.
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
|
|
|
|
|
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?
|
|
|
|
|
The best thing is if you can log onto the server and view the site locally on the server, through something like gotomeeting. Failing that, you can probably catch the error in your global.asax file ( and if you don't have one, add one from the add new file, it will fill it for you )
void Application_Error(object sender, EventArgs e)
{
// Code that runs when an unhandled error occurs
}
is the event you want to log your error in.
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
|
|
|
|
|
protected void Application_Error(object sender, EventArgs e)
{
Exception err = Server.GetLastError();
Response.Clear();
Response.Write(("<h1>" + err.InnerException.Message + "</h1>"));
Response.Write("<pre>" + err.ToString() + "</pre>");
Server.ClearError();
}
Thats what I have at the moment but it doesnt change anything. Do I have to declare it in web.config or something?
|
|
|
|
|
|
Thats where I got the above code but it doesnt seem to change anything. Thanks though 
|
|
|
|
|
|
hi
Image Moving and Editing in ASP.net using C#.net
Please suggest whether it can be able to do
Is there is any tool available for moving the image around anywhere in a web page
as well as to edit the image(rotate,re size,color change) etc
i tried a lot but no one fulfill my needs, i am also ready to pay for this tool
|
|
|
|
|
Atalasoft have some good imaging tools, including AJAX ones. Your options are VERY limited, because of how the web works.
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
|
|
|
|
|
thanks for your reply, that is my client need, is there is any CMS(content management system) tool for this. In this web page there is some text and image(passport size photo), the client need to change the text content and also move the image from left to right, vice versa...
Pls give some url's for Atalasoft Imaging editing tool.
Thanks
|
|
|
|
|
KKK MCA wrote: is there is any CMS(content management system) tool for this.
No, it's not really related to a CMS, it's a different tool.
KKK MCA wrote: In this web page there is some text and image(passport size photo), the client need to change the text content and also move the image from left to right, vice versa...
Have you seen what ebay does ? Most image editing tools of any value, are an activeX component. The only reason I did not suggest that, is because you seem to want to also move the image around the page, which means that part needs to happen in the HTML. An ActiveX is still the best way to get remotely rich image editing, tho.
KKK MCA wrote: Pls give some url's for Atalasoft Imaging editing tool.
www.Atalasoft.com[^]
I'm sure they have links to their AJAX stuff from there.
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
|
|
|
|
|
FYI - a 1 is a bad vote, a 5 is a good vote.
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
|
|
|
|
|
I want to post some HTML data( contain in a div on the Default.aspx page) in jQuery using $.ajax method.
But it is not working.
---------
----------
Kindly suggest.
modified 21-Mar-14 7:18am.
|
|
|
|
|
Is url provided by you is ok?
where is the method name in url.
himanshu
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
