|
You can do this in asp.net instead of in sql server
Load all the records and implement a function which you will call recursively to populate your data in any desired way
Alexei Rodriguez
|
|
|
|
|
HY,
i wanted to show de contents of a csv(comma separated file) file on a gridview(asp.net using c#)..can any one plz help me out
|
|
|
|
|
Read the file, load it into a collection or data table and use that as the data source for the grid view.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
You can use TextFieldParser class to do your task.
Something like this,
TextFieldParser fp = new TextFieldParser("mycsv.txt");
fp.Delimiters = {"\t"};
while (!fp.EndOfData)
{
}
|
|
|
|
|
In my .net projects I always tend to have an n-tier architecture.
I access the business layer from the presentation layer using references and code.
It seems the object data source does a similar task.
Am I right?
I have seen the object data source in action but it seems to me it does the same thing as what I am doing to access the business layer.
Am I right?
What do you think?
Thanks
|
|
|
|
|
Hello,
I am developing Intranet web site. run on IIS. I have a txt file save on server inculde 'n' no of lines. when this txt file upload on server and save on sql server then no probleam. Client access my web site and client Computer have a txt file. when client upload txt file. then show message file not found.
|
|
|
|
|
So are you saying a client is trying to upload a file to your server or are they trying to download it from your server?
Deliver yesterday, code today, think tomorrow.
"http://www.heuse.com/cphumor.htm"
|
|
|
|
|
Rinki Mukheraji wrote: I have a txt file save on server inculde 'n' no of lines.
Does this means, you the have the text file in the Server first?
Rinki Mukheraji wrote: when client upload txt file. then show message file not found.
Seems like your using FileUpload Control's FileName property to upload the client file. Use PostedFile property.
|
|
|
|
|
Hi, I'm trying to write a program that can access different databases(mainly Sql Server and Oracle).
I've thought about using the Database Application Access Block which seems to be the best way but can't find a decent example of how to use it with oracle. If anyone has any other ideas on how to accomplish this please let me know.
Thanks
|
|
|
|
|
I would like to add a control to a panel during runtime;
this is what im doing
TextBox str = new TextBox();
str.id = Test;
str.Width = Unit.Pixel(100);
str.Height = Unit.Pixel(100);
this.Panel3.Controls.Add(str);
to my suprise this conrol is not being added;
does anyone know whats wrong with this code;
|
|
|
|
|
What event are you adding the control in? Page_Load
Be careful where the controls are you have to take in to account postback
A good article to read would be on Page Life Cycle
Deliver yesterday, code today, think tomorrow.
"http://www.heuse.com/cphumor.htm"
|
|
|
|
|
Hi, Thank you very much, im page_load event.
Thank i will read the article you sent me.
|
|
|
|
|
I tried to export datagrid data to the excel. I got problem while exporting data to excel while working in IIS.It is showing COM file is missing.Please help me out
Haripriya
|
|
|
|
|
Hi,
Can you explain how you are exporting data to excel....It will help to get ur problem solve quickly..
If u want you can use the below code for exporting the data in excel.....
private void btnExportToExcel_Click(object sender, System.EventArgs e)
{
dataGrid1.DataSource=TT_Reports.getDefaultersList(DateTime.Parse(TxtFromDate.Text),DateTime.Parse(TxtToDate.Text ),ddnTeamList.SelectedValue.ToString());
dataGrid1.DataBind();
Response.Clear();
Response.Buffer= true;
Response.ContentType = "application/vnd.ms-excel";
Response.Charset = "";
this.EnableViewState = false;
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
Response.AddHeader("content-disposition", "attachment;filename=DefaultersList_"+DateTime.Today.ToShortDateString()+".xls");
this.ClearControls(dataGrid1);
dataGrid1.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();
}
private void ClearControls(Control control)
{
for (int i=control.Controls.Count -1; i>=0; i--)
{
ClearControls(control.Controls[i]);
}
if (!(control is TableCell))
{
if (control.GetType().GetProperty("SelectedItem") != null)
{
LiteralControl literal = new LiteralControl();
control.Parent.Controls.Add(literal);
try
{
literal.Text = (string)control.GetType().GetProperty("SelectedItem").GetValue(control,null);
}
catch
{
}
control.Parent.Controls.Remove(control);
}
else
if (control.GetType().GetProperty("Text") != null)
{
LiteralControl literal = new LiteralControl();
control.Parent.Controls.Add(literal);
literal.Text = (string)control.GetType().GetProperty("Text").GetValue(control,null);
control.Parent.Controls.Remove(control);
}
}
return;
}
|
|
|
|
|
Ya i used this code which u have pasted but it is not for multisheets of excel.Thats y i tried like this
Dim obj_xl As New Excel.Application()
Try
obj_xl = GetObject(, "Excel.Application")
Catch ex As Exception
obj_xl = GetObject("", "Excel.Application")
End Try
obj_xl.Application.Visible = True
obj_xl.Workbooks.Add()
obj_xl.Sheets("Sheet1").Select()
With obj_xl
For i = 0 To dt.Rows.Count - 1
For j = 0 To dt.Columns.Count - 1
If IsDBNull(dt.Rows(i).Item(j)) Then
.ActiveCell(i + 4, j + 1) = String.Empty
Else
.ActiveCell(i + 4, j + 1) = dt.Rows(i).Item(j) End If
Next
Next
obj_xl.Dialogs(Excel.XlBuiltInDialog.xlDialogSaveAs).Show()
End With
This was the method i using to export values from data table.
I used some COM components for excel
This worked fine in my system.When i try to run in IIS its showing error as COM file missing
|
|
|
|
|
Use This Code:
protected void bttbexcel_Click(object sender, EventArgs e)
{
Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=FileName.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter stringWrite);
GridView1.RenderControl(htmlWrite);
this.EnableViewState = false;
GridView1.AllowPaging = false;
GridView1.AllowSorting = false;
GridView1.Attributes["runat"] = "server";
Response.Write(stringWrite.ToString());
Response.End();
}
public override void VerifyRenderingInServerForm(Control control)
{
}
|
|
|
|
|
Sneha Bisht wrote: Use This Code:
protected void bttbexcel_Click(object sender, EventArgs e)
{
Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename=FileName.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter stringWrite);
GridView1.RenderControl(htmlWrite);
this.EnableViewState = false;
GridView1.AllowPaging = false;
GridView1.AllowSorting = false;
GridView1.Attributes["runat"] = "server";
Response.Write(stringWrite.ToString());
Response.End();
}
public override void VerifyRenderingInServerForm(Control control)
{
}
The Excel is not true excel.
|
|
|
|
|
I am adding controls to a placeholder on the fly.
I could have any number of controls in there but its usually about 5.
I am adding a label and a textbox to the placeholder.
Now when I loop the placeholder I have the following code:
The textbox value works fine it finds the correct value, but I cant find the label value, why is this?
Any help would be great.
thanks
PlaceHolder placeHolder1 = (PlaceHolder)FindControl("PlaceHolder2");
foreach (Control c in PlaceHolder2.Controls)
{
if (c.GetType().ToString().Equals("System.Web.UI.WebControls.TextBox"))
{
Label lb2 = (Label)c;
TextBox tb2 = (TextBox)c;
SqlCommand cmdinsertliftunion = new SqlCommand("INSERT INTO table(field1, field2) VALUES ('" + lb2.Text + "', '" + tb2.Text + "')", con);
cmdinsert.ExecuteNonQuery();
}
}
Deliver yesterday, code today, think tomorrow.
"http://www.heuse.com/cphumor.htm"
modified on Wednesday, October 8, 2008 5:39 AM
|
|
|
|
|
The code
if (c.GetType().ToString().Equals("System.Web.UI.WebControls.TextBox"))
{
spessifies that it only goes into the statment if it is an TextBox
try
Label lb2;
TextBox tb2;
foreach (Control c in PlaceHolder2.Controls)
{
if (c.GetType().ToString().Equals("System.Web.UI.WebControls.TextBox"))
{
TextBox tb2 = (TextBox)c;
}
else if(c.GetType().ToString().Equals("System.Web.UI.WebControls.Label"))
{
lb2 = (Label)c;
}
}
}
SqlCommand cmdinsertliftunion = new SqlCommand("INSERT INTO table(field1, field2) VALUES ('" + lb2.Text + "', '" + tb2.Text + "')", con); cmdinsert.ExecuteNonQuery();
|
|
|
|
|
But I need the sql statement to be in the loop, will this still work?
Deliver yesterday, code today, think tomorrow.
"http://www.heuse.com/cphumor.htm"
|
|
|
|
|
Are you adding multiple textboxes and labels to the placeholder?
In that case you need to know witch of the labels og textboxes pair you wan't to insert.
|
|
|
|
|
When I use the above code I get the following error:
CS0165: Use of unassigned local variable 'lb2'
Deliver yesterday, code today, think tomorrow.
"http://www.heuse.com/cphumor.htm"
|
|
|
|
|
try
Label lb2 = new Label();
TextBox tb2 = new TextBox();
foreach (Control c in PlaceHolder2.Controls)
{...
|
|
|
|
|
OK thanks
That now has got rid of the error. The problem is the sql statement doesnt do anything. If I hard code the value in for the label and the line of code for the label out it works. Seems weird, as if the format of the label is not correct.
Deliver yesterday, code today, think tomorrow.
"http://www.heuse.com/cphumor.htm"
|
|
|
|
|
The problem appears to be with the if statement. If I use label in the if statement and hardcode the textbox value it works and if I use the textbox in the if statement and hardcode the label it also works. it seems that I cant find the label and textbox values if Im using the if statement below, is there a way around it?
thanks so far
if (c.GetType().ToString().Equals("System.Web.UI.WebControls.TextBox"))
Deliver yesterday, code today, think tomorrow.
"http://www.heuse.com/cphumor.htm"
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
