|
try this code below, get the data from the oracle database to a datatable, then write the data in a html format on the page.
dtTable = Methodtogetdatatable(); //from the oracle database
string strHTML = "";
//string strStr = common.c_EMPTY;
foreach(DataColumn col in dtTable.Columns)
{
strHTML += "";
//strStr += col.ColumnName + "|";
//Response.Write(col.ColumnName + "\t");
}
strHTML += "";
foreach(DataRow row in dtTable.Rows)
{
strHTML += "";
int intCnt = 0;
foreach(DataColumn col in dtTable.Columns)
{
if ((intCnt % 2) == 0)
strHTML += "";
else
strHTML += "";
intCnt++;
//strStr += row[col.ColumnName].ToString() + "|";
//Response.Write(row[col.ColumnName].ToString() + "\t");
}
strHTML += "";
}
WriteText(strHTML);" + col.ColumnName + " | " + row[col.ColumnName].ToString() + " | " + row[col.ColumnName].ToString() + " |
|
|
|
|
|
Hi
Can anyone please tell me how to pass the imageUrl of a ImageButton through Querystring to another WebForm and assign it as the ImageUrl of the ImageButton placed there?
Thanx..
|
|
|
|
|
what you need to do is append the imageURl to the current URL like this:
string str = "../webform1.aspx?IURL=" + "imageURl";
Response.Redirect(str);
to get the imageURl from the querystring:
str = request.querystring["IURL"].tostring();
Best Regards,
Apurva Kaushal
|
|
|
|
|
Hi apurva,
Thanx.
But i need to pass the querystring while opening the form as 'Popup'
I tried ,i couldnt make out.
Please help me ...
|
|
|
|
|
Then also the method is same. You can retrieve the querystring value in the popup page also.
Best Regards,
Apurva Kaushal
|
|
|
|
|
Ya ... i do know that
I tried in the same manner.
But when i set the QuerySTring to the ImageUrl of the ImageButton in the popup form,its not displaying the image.
When i checked the string,it was not in the format of filepath.It looked like a series of string...
Like "DImagesOne.jpg" instead of "D:\Images\One.jpg"
Thats the problem..
|
|
|
|
|
Use "D:\\Images\\One.jpg" in place of "D:\Images\One.jpg".
Best Regards,
Apurva Kaushal
|
|
|
|
|
i want to play sound in web page without breaks in the sound if any one has idea or experience in this problem i will be grateful to tell me
thanks in advance.
haitham
|
|
|
|
|
Hi,
We are developing an web application. Now we have a situation like, we need to give the BUILD for testing team but this BUILD should not have in going (in progress) developmental activites. For example, a developer is adding some controls in the "AddEmployee.aspx", but testing build should have the previous version of the "AddEmployee.aspx". We are using VSS for our project. Please help us.
Teja
|
|
|
|
|
You can label the project in VSS and then send the labeled build.
Best Regards,
Apurva Kaushal
|
|
|
|
|
Hi,
Most of the projects are facing this situation. I suggest you to have different versions for test and production in the VSS. Otherwise it is difficult during the build for test and production.
Ram
|
|
|
|
|
i have developed a project.First time when i login by entering the login information and then log out by clicking log out button. After log out when i click the "BACK" button from control tool bar ("Green") then i login automitically without entering the login information. how i can remove this bug.
|
|
|
|
|
|
how to copy data from different servers(both sqlserver2000), same table names with same structure without using queryanalyser/enterprisemanager editors, through only aspx pages
|
|
|
|
|
First of all you have to write connection string for both sql server.Then write "insert into tablename" query for both connection string.But make sure,you have to open one sql server connection at a time.For example write
ConnectionString for first server
connection open
insert query for first server
connection close
ConnectionString for Second server
connection open
insert query for second server
connection close
|
|
|
|
|
Hi,
I have a User Control which contains a Link Button. This Link Button is supposed to redirect a user to another webform as well as hide certain other link buttons on the same User Control.
The problem is that the Link Button in the User Control MUST be in a FORM tag with "Runat='server'". When I run the program, I am told that there must only be ONE form tag on a page.
Admittedly there is a FORM tag on the webform which is linked to the User Control. So BOTH the User Control AND the Active Webform HAVE FORM tags, which is apparently NOT allowed.
Any ideas on how to bypass this issue?
Thanks.
|
|
|
|
|
What i can tell you is remove the form tag from the user control and then place the user control(without form tag) inside the form tag in the webform.
Best Regards,
Apurva Kaushal
|
|
|
|
|
I had thought of that.. but I really need the Link Button to be in the User Control rather than in the Webform because the Link Button is a part of a long list of other Link Buttons which control the whole site.
In anycase, I have decided to use asp:Hyperlink instead of asp:LinkButton seeing as the asp:Hyperlink does NOT require to be place inside a tag.
Thanks for your reply.
|
|
|
|
|
I want to display animated image in my XAML(WPF) application.Can anyone help me for that?
|
|
|
|
|
The code i have given to move the records when i click buttonNext,but it is not moving forward.
when i click on Next it has to show the reocrds as per the code i have given.To get previous records also.
Corrrect my code and giving exception as Parameter value cannot be null.
Dim ds As DataSet
Dim dr As DataRow
sedr = New SqlDataAdapter("Select * from Offices", dbconn)
sedr.Fill(ds, "Offices")
DG.DataSource = ds
For Each i In ds.Tables("Offices").Rows
TextBox2.Text = ds.Tables("Offices").Rows(0)("Office_id")
TextBox3.Text = ds.Tables("Offices").Rows(0)("address1")
TextBox4.Text = ds.Tables("Offices").Rows(0)("address2")
i=i + 1
Next
kissy
|
|
|
|
|
Hi kissy,
There is no need of using datagrid for moving to next records or retrieving the records into datagrid.
You can have a look at the following code, it will help u out of your problems:
Private Sub btnnext_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnnext.Click
Try
Dim sqlstmt As String = "select * from orders"
Dim ds As DataSet = New DataSet
Dim ConString As String = "server=.;database=Northwind;user id=sa;password=sa"
Dim con As New SqlConnection(ConString)
Dim myDataAdapter As New SqlDataAdapter(sqlstmt, con)
myDataAdapter.Fill(ds, "orders")
If Session("sessionid") <= ds.Tables(0).Rows.Count - 1 Then
txtretrieve.Text = ds.Tables(0).Rows(Session("sessionid"))("ShipName") 'retrieves values into the textbox using datasets
txtretrieve.DataBind()
Session("sessionid") = Session("sessionid") + 1
End If
Catch ex As Exception
lblexception.Text = ex.Message
End Try
End Sub
Hope this will help you out of your problems.
Thanks & regards,
Suresh Dayma
-- modified at 6:32 Monday 4th September, 2006
Everything is Possible!
|
|
|
|
|
But in my form i am not using any session,a simple record navigation using Datareader and dataset.Like that i have to do.
Dim ds As DataSet
sedr = New SqlDataAdapter("Select * from Offices", dbconn)
sedr.Fill(ds, "Offices")
For i = 0 To ds.Tables("Offices").Rows.Count - 1
TextBox3.Text = ds.Tables("Offices").Rows(i)("address1")
TextBox3.DataBind()
TextBox4.Text = ds.Tables("Offices").Rows(i)("address2")
TextBox4.DataBind()
TextBox5.Text = ds.Tables("Offices").Rows(i)("pincode")
i=i+1
Next
Will it work properly,or do i need to change any modifications.I have to use for next record,DataReader and for previous records,Dataset.
-- modified at 7:33 Monday 4th September, 2006
kissy
|
|
|
|
|
Kissy16 wrote: Dim ds As DataSet
sedr = New SqlDataAdapter("Select * from Offices", dbconn)
sedr.Fill(ds, "Offices")
For i = 0 To ds.Tables("Offices").Rows.Count - 1
TextBox3.Text = ds.Tables("Offices").Rows(0)("address1")
TextBox3.DataBind()
TextBox4.Text = ds.Tables("Offices").Rows(0)("address2")
TextBox4.DataBind()
TextBox5.Text = ds.Tables("Offices").Rows(0)("pincode")
i=i+1
Next
I think in this case only the last record will be displayed in the textboxes. What i will suggest you is to put the dataset in viewstate and then navigate it.
Best Regards,
Apurva Kaushal
|
|
|
|
|
But in my form i am not using any session,a simple record navigation using Datareader and dataset.Like that i have to do.
Dim ds As DataSet
sedr = New SqlDataAdapter("Select * from Offices", dbconn)
sedr.Fill(ds, "Offices")
For i = 0 To ds.Tables("Offices").Rows.Count - 1
TextBox3.Text = ds.Tables("Offices").Rows(i)("address1")
TextBox3.DataBind()
i=i+1
Next
Will it work properly,or do i need to change any modifications.I have to use for next record,DataReader and for previous records,Dataset.
-- modified at 7:36 Monday 4th September, 2006
kissy
|
|
|
|
|
Yes , you have to make modification to your code because your FOR loop is not coded properly.
The code which you have written in for loop is getting executed multiple of times.So, Try to do debugging.
and also let me know why you want to use both datareader and dataset for retrieval of next and previous records.
and yes u can use both of them.
If you dont want to use session then u can make use of label control(Server)
and assign 0(Zero) to it and if you dont want to show it(label) to user then you can hide it by setting its visible property to false.
So have a look at this code and make changes to it as per your requirements.
If lbl1.Text <= ds.Tables(0).Rows.Count - 1 Then
txtretrieve.Text = ds.Tables(0).Rows(lbl1.Text)("ShipName") 'retrieves values into the textbox using datasets
txtretrieve.DataBind()
lbl1.Text = lbl1.Text + 1
End If
Thanks and regards,
Suresh Dayma
Everything Is Possible!
|
|
|
|