Comments by Kumar Kovuru (Top 40 by date)

Hi srivastava.,
it is not working..display same as before...

Hi Sergey.,
i have to run my site in local server..i.e IIS Server

thanQ k :)

Hi Leuava..
am looking for online shop...i don't think so that Code project is open sourse

i know that, but which is better...

Thank you for Your Reply....
Pls check your mail...i sent a mail to you...
give reply for that...

Not working... :( please any one...

not working these too :(

ThanQ for Your Reply...am checking now..i will get you my status later...can I have your Facebook Id..Please send it my gmail kumarkovuru@gmail.com

that port no is not affected to my current site..is it?

Configuration Manager:
i have this option...
1)SQL Native Client 11.0 Configuration..
Client Protocols
Aliases
2)SQL Server Network Configuration
Proocols for MSSQKSERVER
3)SQL Native Client 11.0 Configuration
Client Protocols
Aliases...
here where can i change TCP/IP Enable..

where can i change that remote access?

Hi C@dER@j,
where can i see port no 1433?

Hi Anupkumar,
Pls explain Clearly...because am new to asp.net.....

i gave like that only..but am not able to connect to remote server database..
i want to change any thing in remote database settings...

Phil.o, Please... :)

Sure next time i will do like that,,,please help me regarding this...

Hi Phil.o,
i was tried with the first one of yours...
have a look on this code..
-------------------------------------
SqlDataAdapter sda = new SqlDataAdapter("select * from Product", conn);
DataSet ds = new DataSet();
sda.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
----------------------------------------
am getting error on third line i.,e " sda.Fill(ds);".
Error:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Please have a look on it..

Hi phil.o,
please go through it once,
http://www.codeproject.com/Answers/685750/How-can-i-connect-server-Sql-Database-from-my-Loca#answer2

then how should i do?

How should i follow in web.config?

Am Getting This error when i connect to server database
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

i did it but am getting same error...

is there any other way to do this for connect..

yes..
SqlConnection conn = new SqlConnection("user Id=aaa; Password=********; server=abc.de.fgh.ij/SqlExpress; Database=xyz;");
But am getting like this...
Error:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Sorry Rk, It is not Working..........Please Help Me..

SqlConnection conn = new SqlConnection("user Id=xxxx; Password=yyyy; server=.\\SqlExpress; Database=zzzz;");
this is my local machine connection then how can i update server database details here...

Superb......

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Data.OleDb;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}

protected void insertdata_Click(object sender, EventArgs e)
{
OleDbConnection oconn = new OleDbConnection
(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("example.xls") + ";Extended Properties=Excel 8.0");//OledbConnection and
// connectionstring to connect to the Excel Sheet
try
{
//After connecting to the Excel sheet here we are selecting the data
//using select statement from the Excel sheet
OleDbCommand ocmd = new OleDbCommand("select * from [Sheet1$]", oconn);
oconn.Open(); //Here [Sheet1$] is the name of the sheet
//in the Excel file where the data is present
OleDbDataReader odr = ocmd.ExecuteReader();
string Name = "";
string ShortDescription = "";
string FullDescription = "";
string AdminComment = "";
string ProductTemplateId = "";
string ShowOnHomePage = "";
string MetaKeywords = "";
string MetaDescription = "";
string MetaTitle = "";
string AllowCustomerReviews = "";
string ApprovedRatingSum = "";
string NotApprovedRatingSum = "";
string ApprovedTotalReviews = "";
string NotApprovedTotalReviews = "";
string SubjectToAcl = "";
string Published = "";
string Deleted = "";
string CreatedOnUtc = "";
string UpdatedOnUtc = "";
string ProductOffer = "";
string CityId = "";
string AreaIds = "";
string ShowOnHotOffersPage = "";
while (odr.Read())
{
Name = valid(odr, 0);//Here we are calling the valid method
ShortDescription = valid(odr, 1);
FullDescription = valid(odr, 2);
AdminComment = valid(odr, 3);
ProductTemplateId = valid(odr, 4);
ShowOnHomePage = valid(odr, 5);
MetaKeywords = valid(odr, 6);//Here we are calling the valid method
MetaDescription = valid(odr, 7);
MetaTitle = valid(odr, 8);
AllowCustomerReviews = valid(odr, 9);
ApprovedRatingSum = valid(odr, 10);
NotApprovedRatingSum = valid(odr, 11);
ApprovedTotalReviews = valid(odr, 12);//Here we are calling the valid method
NotApprovedTotalReviews = valid(odr, 13);
SubjectToAcl = valid(odr, 14);
Published = valid(odr, 15);
Deleted = valid(odr, 16);
CreatedOnUtc = valid(odr, 17);
UpdatedOnUtc = valid(odr, 18);//Here we are calling the valid method
ProductOffer = valid(odr, 19);
CityId = valid(odr, 20);
AreaIds = valid(odr, 21);
ShowOnHotOffersPage = valid(odr, 22);
//Here using this method we are inserting the data into the database
insertdataintosql(Name, ShortDescription, FullDescription, AdminComment, ProductTemplateId, ShowOnHomePage, MetaKeywords, MetaDescription, MetaTitle, AllowCustomerReviews, ApprovedRatingSum, NotApprovedRatingSum, ApprovedTotalReviews, NotApprovedTotalReviews, SubjectToAcl, Published, Deleted, CreatedOnUtc, UpdatedOnUtc, ProductOffer, CityId, AreaIds, ShowOnHotOffersPage);
}
oconn.Close();
}
catch (DataException ee)
{

it is exactly working in my local system.........
but i want to do this modifications in server database..HOW?
can i give server database user name and password...

i got this article in codeproject...
http://www.codeproject.com/Articles/32581/Import-Data-from-Excel-to-SQL-Server
but am getting error in con.open();
then where can i give my database user name and passord...
please help me regarding this...

i saw that article but it is showing error in con.open();
"Data Source=.\\sqlexpress;AttachDbFileName=|DataDirectory|exceltosql.mdf;Trusted_Connection=yes"
i was given like above, then where can i give my database user name and passord...
please help me regarding this...

i did search, but i was confuse..