15,893,668 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View Python questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by Kumar Kovuru (Top 40 by date)
Kumar Kovuru
24-Jan-18 0:32am
View
code is not need, while creating empty application it self getting error
Kumar Kovuru
24-Jan-18 0:32am
View
Deleted
code is not need, while creating empty application it self getting error
Kumar Kovuru
26-Aug-14 3:15am
View
yes..but am not able to run am getting 404 error
Kumar Kovuru
26-Aug-14 3:15am
View
Deleted
yes..but am not able to run am getting 404 error
Kumar Kovuru
26-Aug-14 2:46am
View
i can run using http://localhost:8080/projectname but i can't able to run http://192.168.1.14/projectname in the same machine..is there any way to run?
Kumar Kovuru
23-Dec-13 0:12am
View
Hi srivastava.,
it is not working..display same as before...
Kumar Kovuru
16-Dec-13 23:41pm
View
Hi Sergey.,
i have to run my site in local server..i.e IIS Server
Kumar Kovuru
6-Dec-13 1:52am
View
thanQ k :)
Kumar Kovuru
6-Dec-13 1:46am
View
Hi Leuava..
am looking for online shop...i don't think so that Code project is open sourse
Kumar Kovuru
6-Dec-13 1:44am
View
i know that, but which is better...
Kumar Kovuru
6-Dec-13 1:17am
View
Thank you for Your Reply....
Pls check your mail...i sent a mail to you...
give reply for that...
Kumar Kovuru
5-Dec-13 4:32am
View
Not working... :( please any one...
Kumar Kovuru
5-Dec-13 0:25am
View
not working these too :(
Kumar Kovuru
3-Dec-13 4:45am
View
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
Kumar Kovuru
3-Dec-13 4:37am
View
that port no is not affected to my current site..is it?
Kumar Kovuru
3-Dec-13 1:27am
View
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..
Kumar Kovuru
3-Dec-13 1:21am
View
where can i change that remote access?
Kumar Kovuru
3-Dec-13 1:17am
View
Hi C@dER@j,
where can i see port no 1433?
Kumar Kovuru
2-Dec-13 23:05pm
View
Hi Anupkumar,
Pls explain Clearly...because am new to asp.net.....
Kumar Kovuru
2-Dec-13 4:35am
View
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...
Kumar Kovuru
29-Nov-13 8:34am
View
Phil.o, Please... :)
Kumar Kovuru
29-Nov-13 8:15am
View
Sure next time i will do like that,,,please help me regarding this...
Kumar Kovuru
29-Nov-13 8:04am
View
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..
Kumar Kovuru
29-Nov-13 5:13am
View
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
Kumar Kovuru
27-Nov-13 1:11am
View
Deleted
Hi Samisi,
thanks for your replay...
here u wrote many function, which one i want to use...don't mind any thing..please give me reply for this message..
Kumar Kovuru
22-Nov-13 5:19am
View
then how should i do?
Kumar Kovuru
22-Nov-13 3:56am
View
How should i follow in web.config?
Kumar Kovuru
22-Nov-13 3:53am
View
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)
Kumar Kovuru
22-Nov-13 3:44am
View
i did it but am getting same error...
Kumar Kovuru
22-Nov-13 3:16am
View
is there any other way to do this for connect..
Kumar Kovuru
22-Nov-13 2:42am
View
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)
Kumar Kovuru
22-Nov-13 2:30am
View
Sorry Rk, It is not Working..........Please Help Me..
Kumar Kovuru
21-Nov-13 8:33am
View
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...
Kumar Kovuru
21-Nov-13 8:03am
View
Superb......
Kumar Kovuru
21-Nov-13 3:41am
View
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)
{
Kumar Kovuru
21-Nov-13 1:24am
View
Deleted
can you explain clearly, am not getting...
Kumar Kovuru
21-Nov-13 1:08am
View
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...
Kumar Kovuru
21-Nov-13 0:37am
View
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...
Kumar Kovuru
21-Nov-13 0:35am
View
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...
Kumar Kovuru
20-Nov-13 8:58am
View
i did search, but i was confuse..
Show More