|
Suppose if i give 5 names in to field seperated by commas, i want to insert the data for those 5 names seperately.
|
|
|
|
|
Split the values into a string array(String.Split()), loop through it and insert one by one.
|
|
|
|
|
1.create an array
string[] names = {"a", "b", "c", "d"};
2. loop through all values
foreach (string name in names)
{
//do what ever you want to do with a single values.
}
Prince
Team Lead
Quest Solutions
www.imaginethinkact.com
|
|
|
|
|
In my application I want to open a new window on click of a gridview record. The hyperlink is in an ItemTemplate Column.
On click of that i need to open a new window passing the rid also in querystring how can i do this?
<br />
<asp:HyperLink ID="hRequestID" runat="server" Text='<%# Eval("Request ID")%>'<br />
NavigateUrl='<%# DataBinder.Eval(Container, "DataItem.Request ID","SearchEdit.aspx?rid={0}") %>'><br />
</asp:HyperLink><br />
SAJAN A PILLAI
ASP.NET,C#.NET Programmer
BANGALORE
"Winners don't do different things. They do things differently. ...
|
|
|
|
|
Set the Target[^] property of HyperLink to _blank
|
|
|
|
|
I am trying to opening Word file in asp.net application. I Try Following Code For That,
Private oWordAppl As Word.Application
Private oDoc As Word.Document
Public Sub New()
oWordAppl = New Word.Application
End Sub
Public Sub Open(ByVal strfileName As String)
Dim fieName As Object = strfileName
Dim readOnly1 As Object = False
Dim isVisible As Object = True
Dim missing As Object = System.Reflection.Missing.Value
oDoc = oWordAppl.Documents.Open(fieName, missing, readOnly1, missing, missing, missing, missing, missing, missing, missing, missing, isVisible)
oDoc.Activate()
End Sub
And this code for Opening file,
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click
Dim Test As New WordAppl
Dim TamplatePath As String = ConfigurationManager.AppSettings("WordMod")
Dim DocumentPath As String = ConfigurationManager.AppSettings("WordDoc")
Test.Open(TamplatePath & "Test.Doc")
Test.SaveAs(DocumentPath & "Test.Doc")
Test.Open()
End Sub
All this works fine in View In Browser, But when I publish that Page The file not opening and on Click of Button, Browser running continuosly, but cant find file.
Please Help ME out,
Thanks.....
|
|
|
|
|
Try stepping through in debug and see what is happening, thats the easiest way of fixing it.
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
Hi
I have made a report to print a Bill. every thing is working properly but Hight of Table varries according to the no of items.
I m putting Partnos , description , qty, rate, total in TABLE BODY section.
I have used footer section of TABLE control for tax and total amount display.
I have fixed 8 rows/ page.
when 8 rows r in report Tax comes at right place but when 2 or 3 rows r thier then Tax section comes immediatly after item rows.
I want it to come at fix place.
PLease help me out this problem.
Thanks in advance.............
amitendra
|
|
|
|
|
Hi,
Consider two websites hosted in different services:
Web X (Hosted in IIS)
Web Y (Hosted in Tomcat)
I have made a successful integration between tomcat and iis using isapi_redirector. Now, i can access the Web Y through IIS. How can we connect web X with web Y? Like how can i access the site (Y) using site (X) through IIS.
Thanks.
|
|
|
|
|
Hi,
I have an excel containing mail address For example: In excel "column B" i have a number of email address in B1,B2,B3.... Now the thing i want each email address from B1,B2,B3 into my TextBox1.Text.
Am using vb.net with c# language.
Can anyone send me the code or give me some idea?. Thanks in advance.
With Regards,
Samson
|
|
|
|
|
If your spreadsheet is structured as a table in a database would be, you can use OleDb to connect to it, select the Column you want (select [column b] from $Sheet1), and then iterate through the collection to put stuff in the TextBox.
private void ConnectToExcel(string Location)
{
string ConnectionStr = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended properties=\"Excel 8.0;HDR=YES\"", Location);
try
{
OleDbConnection Connection = new OleDbConnection(ConnectionStr);
Connection.Open();
string SelectString = "select [column b] from $Sheet1";
OleDbCommand Command = new OleDbCommand(SelectString, Connection);
OleDbDataReader olDbRead = Command.ExecuteNonQuery();
while (olDbRead.Read)
{
textBox1.Text += olDbRead[0].ToString();
}
}
catch{}
finally{Connection.Close();}
}
samsonx wrote: Am using vb.net with c# language.
Well you lost me here...
var question = (_2b || !(_2b));
|
|
|
|
|
hi weather this code works perfectly or not i don't know bcoz when i wanted to use oledb connection for excel sheet my program didnt accept that one.it says it as unrecognized format.how to connect excel sheet using oledb connection plz explain step by step.
|
|
|
|
|
I am dealing with word automation in asp.net 2.0 and when i am debugging my web application in VS in XP OS it is quite fine running. Then I deployed this site into server (OS is Windows 2000 advanced server) where I met with problem. So I installed VS 2005 in this server and I debugged where I got this error..
Unable to cast COM object of type 'Word.ApplicationClass' to interface type 'Word._Application'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{00020970-0000-0000-C000-000000000046}' failed due to the following error: Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED)).
If anyone helps to solve my problem that would be appreciable as I have been struggling with this problem for last week.
I have office 2000 premium in my server machine as well.
I give my coding part also here,
public class WordApp
{
private Word.Application oWordAppl;
private Word.Document oDoc;
public WordApp()
{
oWordAppl = new Word.Application();
}
public Word.Document Open(string strFileName)
{
try
{
object fileName = strFileName;
object readOnly1 = false;
object isVisible = true;
object missing = System.Reflection.Missing.Value;
oDoc = (Word.Document)oWordAppl.Documents.Open(ref fileName, ref missing, ref readOnly1,
ref missing, ref missing, ref missing, ref missing, ref missing,
ref missing, ref missing, ref missing, ref isVisible);
/*Above line i am gettin error {"Unable to cast COM object of type 'Word.ApplicationClass' to interface type 'Word._Application'.
This operation failed because the QueryInterface call on the COM component for the interface with IID
'{00020970-0000-0000-C000-000000000046}' failed due to the following error: Library not registered.
(Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED))."}
*/
}
catch (Exception ex)
{
throw ex;
}
finally
{
//object missing = System.Reflection.Missing.Value;
//oWordAppl.Documents.Close(ref missing, ref missing, ref missing);
}
return oDoc;
}
}
|
|
|
|
|
Textbox firing when an Enter key is Pressed....giv me a solution dat worked in both iexplorer and firefox.
Thankz in advance.
|
|
|
|
|
Masood Kochi,SSF wrote: Textbox firing when an Enter key is Pressed
Firing what? Your question is not clear. Please rephrase it.
|
|
|
|
|
You can write the JavaScript Code and Get the Value of TextBox
<asp:textbox id="txt" onkeypress="CheckEnter_Onclick(event)" runat="server" xmlns:asp="#unknown">
---- This is Javascript Function that show the Value of Textbox in alert Box when Enter Key is Pressed--------------
function CheckEnter_Onclick(e)
{
var key;
key=(e.which) ? e.which : e.keyCode;
if(key==13)
{
var x= document.getElementById('<%=txt.ClientID %>').value;
alert(x);
}
return true;
}
|
|
|
|
|
the user enters an url , and i want to get the html source code of that webpage(url) on button click. can we get the solution using innerHTMl ??? any ideas ??
|
|
|
|
|
|
|
Manish Thaduri wrote: can u be more specific. temme what exactly i hve to do..
Have you tried that suggestion? Spoon feeding is bad and we don't do it here. I have given you the class and method you need to work with. Look at the method's documentation and learn how to use it. If you face any issues, come back with specific questions. If you are not understanding the MSDN documentation and sample provided, you need to take a book and improve your knowledge.
|
|
|
|
|
|
Manish Thaduri wrote: so i need to pass the proxy ip,port no, username , password etc. and im working on it.. but cudnt resolve it !!
As I said, go with WebClient class. It is the easiest one. Use the WebProxy[^] class and set it to WebClient.Proxy property.
|
|
|
|
|
|
Manish Thaduri wrote: I need to use internet explorer object,shdocvw.dll & innerHTML !!
Your user is entering the required URL in text box and you need to get the HTML of that page on button click, right? If yes, WebClient or any request/response classes is the way to go. Alternatively, you can use JS and send AJAX request to the page. Get the response and read values from it. InnerHTML may work in this scenario(I haven't tried it). But I'd suggest the webclient rather than JS.
|
|
|
|
|
I think the main problem is that you obviously have many missing keys on your keyboard - or you are sending in your posts by txt msg
There is no charge for using full words
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
