Rule “Oracle JRE 7 Update 51 (64-bit) or Higher is Required for Polybase” Failed in SQL 2016

we will are going to see how we can fix the error Rule “Oracle JRE 7 Update 51 (64-bit) or higher is required for Polybase” failed. You may get this error when you try to install SQL Server 2016



Now we have option to disable the Java SE from the features selected. For that, go back to the feature selection.

Feature Selection Installation Center SQL Server

Now uncheck the selection PolyBase query service for external data.

Thank you.

Social Profiles

LinkedIn
in

Facebook
f

Gmail
id :- arjundhilod@gmail.com

............................Thank you ...................

Default Access modifiers in C#?

We have the following access modifiers available in C#.

• Public
• Private
• Protected
• Internal
• Protected Internal   

• A Class has default Modifier as Internal ,An Interface has default Modifier as Public,  An enum has default Modifier as Public,  A struct has default Modifier as Internal

Using MongoDB .NET Driver with .NET Core WebAPI

Hi Friends,

This is very good and useful  post from Mr.

Petru Faurescu (https://www.codeproject.com/script/Membership/View.aspx?mid=12827123)

How can we use MangoDB .net driver with Core webAPI (https://www.codeproject.com/Articles/1151842/Using-MongoDB-NET-Driver-with-NET-Core-WebAPI).

Thank you,

if you like pls share to other 

Cannot create/reset deployment credentials on an Azure Web App?

Introduction:-

Today i will explain you "Cannot create/reset deployment credentials on an Azure Web App?"How can resolve the issue.

Having typed a (valid) user name and (valid) password, I pressed the tick to confirm creation/reset. It led me to error message like this (Failed to Set Credentials with error: "Please, try again. If the problem persists, contact support."

Solution (workaround)

Set Username and password and save it,After saving below output get. 

IF you follow all step than your problem will resolve.

-------------------------Thank you----------------------------

How to fill gridview from datatable in asp.net

Introduction:-

Hello all today i will explain you "How to fill gridview from datatable in asp.net"

Please follow the below steps:-

1)Create a connection string in Web.config File.

 <connectionStrings>

    <add name="sqlConnecrtion" connectionString="Data Source=MICROSOFTDOTNET;Initial Catalog=SEPTNew;Trusted_connection=True" />   

  </connectionStrings>

2) Drag the GridView on to the .aspx page.

3) write the below code in your .aspx.cs file.

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

using System.Data.SqlClient;

using System.Configuration;

namespace WebApplication1

{

    public partial class WebForm1 : System.Web.UI.Page

    {

        string _con = ConfigurationManager.ConnectionStrings["sqlConnecrtion"].ConnectionString;

        protected void Page_Load(object sender, EventArgs e)

        {

           if (!IsPostBack)

            {

               

               getdata();

            }

            }

        private void getdata()

        {

            DataTable dt = new DataTable();

            using (SqlConnection con = new SqlConnection(_con))

            {

con.open();

                string str = "Select * from City_Master ";

                using (SqlCommand cmd = new SqlCommand(str,con))

                { 

                    using(SqlDataAdapter sd=new SqlDataAdapter(cmd))

                    {

                        sd.Fill(dt);

                    }

                

                

                }

            

            }

            GridView1.DataSource = dt;

            GridView1.DataBind();

        

        }

        

    } 

}

Execute your program using F5 or start project.

--------------------------Thank you ------------------------- 

How to fill the GridView using SqlDataReader in asp.net C#

Introduction:-

Hello all today i will explain you "How to fill gridview from SqlDataReader in asp.net c#"

Please follow the below steps:-

1)Create a connection string in Web.config File.

 <connectionStrings>

    <add name="sqlConnecrtion" connectionString="Data Source=MICROSOFTDOTNET;Initial Catalog=SEPTNew;Trusted_connection=True" />   

  </connectionStrings>

2) Drag the GridView on to the .aspx page.

3) write the below code in your .aspx.cs file.

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

using System.Data.SqlClient;

using System.Configuration;

namespace WebApplication1

{

    public partial class WebForm1 : System.Web.UI.Page

    {

        string _con = ConfigurationManager.ConnectionStrings["sqlConnecrtion"].ConnectionString;

        protected void Page_Load(object sender, EventArgs e)

        {

           if (!IsPostBack)

            {

               

               gatdataUsingReader();

            }

            }

        private void gatdataUsingReader()

        {

            using (SqlConnection con2 = new SqlConnection(_con))

            {

                con2.Open();

                using(SqlCommand cmd1=new SqlCommand("Select * from sales",con2))

                {

                    SqlDataReader dr = cmd1.ExecuteReader();

                    GridView2.DataSource = dr;

                    GridView2.DataBind();

                } 

            }

        }

        

        }

        

    } 

}

Execute your program using F5 or start project.

--------------------------Thank you ------------------------- 

Read value from database using dataset with StoredProcedure and bind in GridView.

Introduction:
In this article I will explain how to bind gridview with datareader in asp.net using C#.net

Implement 

Open Your IDE
 File ----New----Project



Click on project----Web

 
change Name What you want---Click Ok Button



Click on Default.aspx page and Drag the gridview from Toolbox.




The connection string in web.config file 
e.g:-
<connectionStrings>
    <add name ="DBM" connectionString ="Data Source=your system name;Initial Catalog=your database name;Integrated Security=True"/>
  </connectionStrings>

Note:- I am using window authentication  so using Integrated Security=True;

Add the following namespace:-

Using Sysytem.Data;Using System.Data.SqlClient; Know time to come you  write code in Page_load
        string strcon = System.Configuration.ConfigurationManager.ConnectionStrings["DBM"].ConnectionString;
        protected void Page_Load(object sender, EventArgs e)
        {
if(!IsPostback){
            BindGridView();
}
        }
        public void BindGridView()
        {
            //connect to database via dataset & dataadapter
            SqlConnection con = new SqlConnection("server=localhost;Initial Catalog=databasename;uid=;pwd=;");
            DataSet ds = new DataSet();
            SqlDataAdapter da = new SqlDataAdapter("GetstudentnameInOutputVariable", con);
            da.SelectCommand.CommandType = CommandType.StoredProcedure;
            da.Fill(ds);
          gridview1.DataSource =ds;
gridview1.DataBind();      
        }

       

 


------------------Thank you-------------------------