|
Thanks for your reponse!
Don't Quit
|
|
|
|
|
Hi , i am exporting datagrid to excel sheet..
Here is no problem at all,as far as i dont allow paging for datagrid.
But if i allow paging to datagrig, it doesnt work properly.
The error comes while exporting data to excel sheet.
I am sending my code as follow :
-----------------------------------------------------------
Response.Clear()
Response.AddHeader("contentdisposition", "attachment;filename=FileName.xls")
Response.Cache.SetCacheability(HttpCacheability.NoCache)
Response.ContentType = "application/vnd.msexcel;charset=windows-1251"
Response.Charset = "UTF-8"
Dim stringWrite As System.IO.StringWriter = New System.IO.StringWriter
Dim htmlWrite As System.Web.UI.HtmlTextWriter = New HtmlTextWriter(stringWrite)
DataGrid1.RenderControl(htmlWrite)
Response.Write(stringWrite.ToString())
Response.End()
-----------------------------------------------------------
when i use paging in my datagrid, and in debug mode , when i try to find the value of StringWrite object, it shows nothing in it... and fires an error..
prakash sawant
|
|
|
|
|
I am having a calendar in my asp application. This is working fine. But only one of the user getting the calendar improperly.
When he clicks the calendar button, The calendar is displaying only one day(starting day of the month ie.,1).
Any suggestions?????
Regards,
Bhasker P
|
|
|
|
|
I m taking values from a database. There are more then one values. I m storing these values in a string. But there only come first value, not other. what should I do. Please help with coding example. (ASP.NET and VB.NET)
|
|
|
|
|
Safecom wrote: I m taking values from a database. There are more then one values. I m storing these values in a string. But there only come first value, not other. what should I do.
I have no idea what you mean.
What do you mean by "But there only come first value, not other". What exactly are the values, and what exactly do you want to do with them? (Yes, I know you said you were storing them in a string. But for what purpose?) And how are you receiving the values?
|
|
|
|
|
From where r u taking those values ?
Plz. give details
prakash sawant
|
|
|
|
|
It is very difficult to answer if you do not give details as others have also told.
In general I can say that use a DataReader and then iterate on it, to get the values into string using concatenation. If the list of values in large, use StringBuilder for optimization.
Please give some more details of your problem.
Pradipta Basu
|
|
|
|
|
hi!
i am new to .net i m using asp.net 1.1 with c# can any one guide me how rewrite the url like i click on a category name and id is send it in url and its sub categories shown on the page again we click on some sub category we call the same page with the id of that sub category then again but if there are no further sub categories then products will shown now i am trying to do that the url looks some thing like this
site url/category/sub category/..../product name
while only one page is called again and again with just one parameter id
(e-g example.com/cat.aspx?id=1)
can any body guide me in this regard
thanx in advance
shezi
|
|
|
|
|
|
Hi friends,
I am using template fields in my gridview to display the contents. I am also including Edit and Delete CommandField. Its working perfectly. When I click Delete the particular row is deleted. But for me, when i click delete it should give some confirm msg like "Do u want to delete" if i click yes it should delete that row r no then it should leave that field.
Please Help Me.
Thanks in Advance.
Regards,
Prya
|
|
|
|
|
Hi
write following code in RowDataBound events of gridview.
If e.Row.RowType = DataControlRowType.DataRow Then<br />
Dim btn As Button = e.Row.FindControl("BtnRemove")<br />
btn.Attributes.Add("onclick", "return DelChk();")<br />
End If
pathan
|
|
|
|
|
Hi ALL
I want to share a web.config file for two projects.
I am using .Net 1.1 to create the web application.
I am having a solution and two different projects under the solution.
I want to keep one web.config file for these two projects.
Can I ?
Thanks in advance.
"I firmly believe that
any man's finest hour,
the greatest fulfillment of all that holds dear,
is that moment,
when he has worked his heart out in a good cause
and lies exhausted in the field of battle - victorious..."
|
|
|
|
|
Ok so I have an aspx page with a function in the backend aspx.vb page to display a div(has to be done server side) I have a usercontrol on the page which contains a grid. Now onclick of a button on the grid in the usercontrol, I want to call the function on the main page from the usercontrol. Is there an easier way than to make the function on the main page a shared function, this seems messy, could I somehow use the parent attribute??
Thanks a mil in advance
Colum
|
|
|
|
|
You should be able to access page containing user control as this.Page, cast it to type of your page and then you can call its public methods.
"Throughout human history, we have been dependent on machines to survive. Fate, it seems, is not without a sense of irony. " - Morpheus
|
|
|
|
|
That is excatly what I was looking for, Thank you very much dnh, but I think you have to use Parent.Page for the usercontrol and not this.Page, maybe that is just for my case but anyway thanks again
|
|
|
|
|
cullyk wrote: think you have to use Parent.Page for the usercontrol and not this.Page
hmm not really, Control.Page[^] property really points to aspx *page* where your user control is, on the other hand Parent points to control that directly contain your user control, e.g. if it is in Placeholder, Parent will be that placeholder. They both should have same Page...
"Throughout human history, we have been dependent on machines to survive. Fate, it seems, is not without a sense of irony. " - Morpheus
|
|
|
|
|
Well I want to access Functions on the page that the user control is contained in. So if I have a page called Maintenance.aspx which contains a usercontrol now I want to access a function on maintance.aspx.vb from the usercontrol I would have the following code in the usercontrol server side:
Dim maintenance As Maintenance
maintenance = CType(Parent.Page, Maintenance)
maintenance.viewQuestions() 'where viewQuestions() is a public function contained on the main page
This works fine for me as is, yet I stand to be corrected, I am I missing something?
Sorry if I have not explained this properly
|
|
|
|
|
cullyk wrote: maintenance = CType(Parent.Page, Maintenance)
could be as well
maintenance = CType(Page, Maintenance)
It's just that you said you have to use Parent.Page. 
"Throughout human history, we have been dependent on machines to survive. Fate, it seems, is not without a sense of irony. " - Morpheus
|
|
|
|
|
You can do this by Delegates and Events
|
|
|
|
|
My application needs Exports to Excel and From Excel to Database
for that ,i have used the code
For Export:
Dim mySQLCommand As New SqlCommand
Dim myConnection As New SqlConnection
Dim datagrid1 As New DataGrid
Dim DS As New DataSet
Dim DT As New DataSet
myConnection = New SqlConnection("Password=technologies;Persist Security Info=False;User ID=sa;Initial Catalog=Lims_Demo;Data Source=VISHWA") 'ConfigurationSettings.AppSettings("MyConStr"))
myConnection.Open()
Dim da As New SqlDataAdapter("SELECT top 30 ProductCode,ProductName,GenericName,RetestPeriod FROM Results where status=0", myConnection)
da.Fill(DT)
datagrid1.DataSource = DT
datagrid1.DataBind()
Response.Clear()
Response.ContentType = "application/vnd.ms-excel"
Response.Charset = ""
Me.EnableViewState = False
Dim tw As New System.IO.StringWriter
Dim hw As New Html32TextWriter(tw)
datagrid1.RenderControl(hw)
Response.Write(tw.ToString())
Dim path As String = "C:\...\abc.doc"
Response.AddHeader("content-disposition", "attachment; filename=Worddocument.xls")
Response.End()
'FileStream sourceFile = new FileStream(path, FileMode.Open);
'long FileSize;
'FileSize = sourceFile.Length;
'byte[] getContent = new byte[(int)FileSize];
'sourceFile.Read(getContent, 0, (int)sourceFile.Length);
'sourceFile.Close();
'Response.BinaryWrite(getContent);
'dim SaveFileDialog1 as System.
'If SaveFileDialog1.ShowDialog() = DialogResult.OK Then
' RichTextBox1.SaveFile(SaveFileDialog1.FileName, _
' RichTextBoxStreamType.PlainText)
'End If
myConnection.Close()
the above coding is working very good and giving the required results
but when i am going to Import Excel data to Database
I have used the code, which i found in Msdn help
'---------------------Importing Data From Excel to Database
If Not FILE1.PostedFile.FileName = "" Then
FilePath = FILE1.PostedFile.FileName
End If
'Excel Work Sheet Database Connection
MyConnection = New System.Data.OleDb.OleDbConnection( _
"provider=Microsoft.Jet.OLEDB.4.0; " & _
"data source=" & FilePath & "; " & _
"Extended Properties=Excel 8.0;")
'Select the data from Sheet1 of the workbook.
'MyConnection.Open()
'Dim dt As Table = MyConnection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null)
Dim f As Array
f = Split(FilePath, "\")
Dim k As Integer = f.Length
Dim str As String = f(k - 1)
Dim filename As String = str.Substring(0, str.LastIndexOf("."))
'str.Split(".xls")
'Dim f1 As Array
'f1 = Split(str, ".")
'Dim str1 As String = f1(f1.Length - 1)
Try
Dim str2 As String = "select * from [EXPnIMP$]"
'Select the data from Sheet1 of the workbook.
'MyCommand = New System.Data.OleDb.OleDbDataAdapter( _
' str2, MyConnection)
''' Select the data from Sheet1 of the workbook.
'MyCommand = New System.Data.OleDb.OleDbDataAdapter( _
' "select * from [" & filename & "$]", MyConnection)
MyCommand = New System.Data.OleDb.OleDbDataAdapter( _
"select * from [" & filename & "$]", MyConnection)
DS = New System.Data.DataSet 'DataSet
MyCommand.Fill(DS) 'Filling The dataset
------------------------------------------------------
it is also working fine,but it is working only for Excel sheet , which i create
it is not working for the excel sheet which i created by using the above code
it is giving the below error,
i think the errror may be in exporting to excel,
when i put google search,it is showing that, file should be exclusive,how can we set exclusive to a file
the error , i am getting is :
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access 97 Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
kishore
|
|
|
|
|
After you export the data to the excel file close it and then try to export the data from excel to database.
Best Regards,
Apurva Kaushal
|
|
|
|
|
Thanks Apurv
but Even Iam doing same thing what u said, it is giving same error
kishore
|
|
|
|
|
Hi Friends ,
I want to put the repeater control on my webpage , and want to develop the functionality for Editing and Deleting like datagrid .Is it possible to inser Edit and Delete Functionalities using repeater like datagrid?
If it is possible , please guide me
Thanks
param
|
|
|
|
|
i have placed an image in the datagrid bound columns as
e.Item.Cells(i).Text = ""
it will display an image "red.gif" in the bound column.
this will call a javascript fn, which will send two values to it. Its working fine. At the same time, when i click the bound column, i want to change the image to green.gif using javascript.
same like toggle button.
How to perform this, please its urgent.
Regards,
abul.
|
|
|
|
|
hello Technicals
This is ajay.
when i m trying to run(pressing F5) my web application in Asp.net, i get the following error
"Error while trying to run project.The project is not configured to be debugged.Unable to start debugging on the web server."
I have done a lot of brainstorming on it but unfortunately could not fix it.
I have followed a lot of forums including 'support.microsoft.com/kb/306156'
i am the member of debugger users group.And am loging through administrator.So i also have the enough rights.......
Any help regarding this...
I am very worried.
one thing more when i m going through Debug->Start without Debugging
then it works fine.
Is there any error in my web.config file or something else....
plz plz help
thanks in advance
Ajay
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
