Comments by Sharmanuj (Top 55 by date)

See the steps in the answer to achieve this.

To show the selected value in the comboBox control from the data base use this

cbCountryCode.SelectedValue = dataTable.Rows(0).Item(2).ToString()

Give some more details what you want to achieve.

Check these URLs. May these help you.

http://www.codeproject.com/Articles/86631/Search-Engine-Optimization-SEO-Enhancement-in-ASP
http://devproconnections.com/aspnet-mvc/simple-technique-improving-seo-aspnet-mvc
http://msdn.microsoft.com/en-us/magazine/ee405899.aspx

you have this requirement for ASP.Net application or winForms application.

Is the webservice returning Json data or Xml format data?

could you elaborate a bit more on this question

See that is based on the application format. I gave you the example for WPF application in which ComboBox class is under namespace "System.Windows.Controls".
The same ComboBox class exists in Winfroms under namespace "System.Windows.Forms".

I hope this is clear to you.

kindly explain you question

Pass the Datatable to bind the value. you are passing DataAdapter object in method.

add a new parameter in the method as fieldName and pass the value as provided below.

BC.BindComboBoxDataContext(cmbSession, dt, dt.Columns[0].ToString());

can you access some folder of other machine from your machine. If not then check the firewall settings for both the machine.

If folder is accessible then check with the Url which you are trying to access.

Could you post your code here in which you are getting error

Which version of .Net framework are you using?

For ComboBox controls we have 2 basic values
a. Id and b. Text

In the same manner DisplayMemberPath is the Text Value and SelectedValueMemberPath would be ID.

you can pass same values in both the parameters if required. but the best practice is to bind with ID and Text.

Right click on the ComboBox and resolve it. That will include the namespace in your current class.

Try This code

using System;
using System.Collections.Generic;
using System.Text;

namespace MINE.classes
{
class bc_session
{

public void BindComboBoxDataContext(ComboBox comboBox, DataTable dtDataContext, string displayMemberPath, string selectedValueMemberPath)
{
try
{
comboBox.DataContext = dtDataContext;
comboBox.DisplayMemberPath = displayMemberPath;
comboBox.SelectedValuePath = selectedValueMemberPath;
comboBox.SelectedIndex = -1;
}
catch (Exception ex)
{ }
}
}
}

you have to include the required namespaces as well on the class which you'll prepare.

This is the method provided which you have to embed into a class. Then use on your forms.

Check with firewall settings. if those are on, Off the firewall features

you should try this

DateTime currentDateTime;
currentDateTime = Convert.ToDateTime(dbr["RealnyCzas"].ToString());

dateTimePicker5.Value = currentDateTime ;

Yes

What is the error/issue you are getting?

See the upper comments to open the inetmgr

In the command prompt type the command "ipconfig". That will give your machine IP address.

Machine name can be find from MyComputer property

Here you have to make changes. That is the example url i've given, you have to fill the right attributes in that.

While accessing the final url change "localhost" with Machine name or Ip address of your app hosted machine.

I guess you've got what to do.

Yes, you can also browse the application by giving the proper path of the page in web browser.

like
Http://localhost/VirtualDirName/Default.aspx

later on you can change localhost with machine name and VirtualDirName by your application name given in Inetmgr.

you've to open the path

cd C:\Windows\Microsoft.NET\Framework64\v4.0.30319 then press enter

Start->Microsoft Visual Studio 2012->Visual Studio tools->VS2012 x64 Cross tools command prompt.

to register the framework 4.0 version follow these steps first.

1. Run visual studio command prompt with "Run as Administrator" option.
2. Open this path if you are using 64bit OS.
C:\Windows\Microsoft.NET\Framework64\v4.0.30319
3. copy this path and paste into command prompt.
4. run this command "aspnet_regiis -i" and press enter.
5. once done then reset iis with "IISreset" command.
6. Go to IIS server with Inetmgr and change the app pool.

Regards
Anuj Sharma

Follow these steps
1. Open Inetmgr
2. On Left panel, right click on "Default web sites" under the sites.
3. Choose Add application option and a new window will open
4. Give alias name for your application e.g "MyApp"
5. Provide the physical path of the web site content
6. Choose the application pool according to your .Net framework.
7. After filling all information click on OK. And then browse your application.

Regards
Anuj Sharma

1. Open IIS server from your machine by command "inetmgr" in run window.
2. Make a virtual directory/Application in IIS server. Name it like "MyAppTest".
3. Specify the physical path of the web site content for this virtual directory/Application.
4. Set the desired application pool to this application. If your website is developed in .Net framework 4 then set Application pool 4.0 framework.
5. Browse the application from web browser.

for example :
http://MachineIP/MyAppTest/Page1.aspx

give some more information regarding the desired output

Hi Bhushan,

what you can do on this code, rather than working for single input/output, you can pass an array or collections of input values and loop it through for input range. get the output in same length of array or collection.

This would lead an upper loop and internal loop you can take as given. "foreach" loop.

Regards
Sharmanuj

Hi Sadhna,

please see the below solution provided.

Hi Sujay,

could you provide some more information regarding what you want to achieve.

Kindly provide the table design for this page as well. i guess you should use <td> tag before the Panel and close it after Panel.

See the updated code below.

use the below code
cmdUpdate = "UPDATE db1 " + "SET Names = '" + textname.Text + ",'Number = '" + textmarks.Text + "' WHERE ID = " + lbl.Text;

Hi,

Kindly mark answer if working.

Hi

Set the CommandType Property for command object before adding the parameters

command.CommandType = CommandType.StoredProcedure;

Hi Dipika,

could you please share your code, so that i can look into this. \


Regards,
Anuj Sharma

Hi Dipika,

rowX and rowY would be type of DataRow

i.e
DataRow rowX = dtGZData.Rows[0];
DataRow rowY = dtGZData.Rows[1];

Hi Deepika,

here is the updated code. instead of row[0] kindly use rowX which holds 1st row object from datatable.

int totalColumns = dtGZData.Columns.Count;
rowX = dtGZData.Rows[0];
rowY = dtGZData.Rows[1];
double[] x = new double[totalColumns];
double[] y = new double[totalColumns];

for(int index=0; index

Hi Rahul,

thanks for marking the solution.

Regards
Anuj Sharma

Hi Venga,

this would come in the different cell as required. I did some modification in code. use the html table control to create rows and cells.
Kindly see the below code

Protected Sub GenerateXls(ByVal fileName As String, ByVal dtData As DataTable)
Try
HttpContext.Current.Response.Clear()
HttpContext.Current.Response.ContentType = "application/ms-excel"
HttpContext.Current.Response.AddHeader("Content-Disposition", "inline; filename=" + fileName + "")
HttpContext.Current.Response.Flush()
Dim colCount, rowCount As Integer
HttpContext.Current.Response.Write("<Table>")
HttpContext.Current.Response.Write("<TR>")

For colCount = 0 To dtData.Columns.Count - 1
HttpContext.Current.Response.Write("<TD>")
HttpContext.Current.Response.Write(dtData.Columns(colCount).ColumnName.ToString())
'HttpContext.Current.Response.Write("\t")
HttpContext.Current.Response.Write("</TD>")
Next
HttpContext.Current.Response.Write("</TR>")

For rowCount = 0 To dtData.Rows.Count - 1
'HttpContext.Current.Response.Write("\n")
HttpContext.Current.Response.Write("<TR>")
For colCount = 0 To dtData.Columns.Count - 1
HttpContext.Current.Response.Write("<TD>")
HttpContext.Current.Response.Write(dtData.Rows(rowCount)(colCount).ToString())
'HttpContext.Current.Response.Write("\t")
HttpContext.Current.Response.Write("</TD>")
Next
HttpContext.Current.Response.Write("</TR>")
Next
HttpContext.Current.Response.Write("</Table>")
HttpContext.Current.Response.End()

Catch ex As Exception

End Try

End Sub

Hi Venga,

I could see there is a line mistake in the for loop. kindly use the below updated code and that will work to get all the data in separate columns

Public Sub SaveExcelFile(ByVal fileName As String, ByVal dtData As DataTable)

HttpContext.Current.Response.Clear()
HttpContext.Current.Response.ContentType = "application/ms-excel"
HttpContext.Current.Response.AddHeader("Content-Disposition", "inline; filename=" + fileName + "")
HttpContext.Current.Response.Flush()
Dim colCount, rowCount As Integer
For colCount = 0 To dtData.Columns.Count - 1
HttpContext.Current.Response.Write(dtData.Columns(colCount).ColumnName.ToString())
HttpContext.Current.Response.Write("\t")
Next
For rowCount = 0 To dtData.Rows.Count - 1
HttpContext.Current.Response.Write("\n")
For colCount = 0 To dtData.Columns.Count - 1
HttpContext.Current.Response.Write(dtData.Rows(rowCount)(colCount).ToString())
HttpContext.Current.Response.Write("\t")
Next
Next
HttpContext.Current.Response.End()
End Sub

Hi Venga,

As you want to achieve this in VB.net and the solution is in C#.Net. could you please share your piece of vb.net code so that i can check the same.

Regards,

Anuj Sharma

Hi Venga,

The data will be palced in different rows and columns according to your data table values,
to separate data in column we use
HttpContext.Current.Response.Write("\t");
and to put data in next row
HttpContext.Current.Response.Write("\n");

could you please share your data result so that i can check in that.

Regards
Anuj Sharma