Ravi Luhar

Search This Blog

Sun pic

on March 13, 2020

Get link
Facebook
X
Pinterest
Email
Other Apps

Download

Sun pic

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Nainital trip

Me and my wife namrata in trip.This trip actually our honeymoon. I started my journey on 21st January 2017 from Ahmedabad.I covered many places in it like Delhi,nainital,ranikhet,agra.Complate trip in a week. On 21st January ,I had started from ahmedabad railway station.I had train for delhi, ashram express at 6.30.We reached delhi approx 10.30am.book hotel and fresh.After that went to akshardham in metro. Metro's first time experience.It is very huge temple.cameras and mobile not permitted there.other wise can catch awesome pics. take coffee at metro station. after we visit palica bazar.return to hotel,take dinner and pack up for nainital.pick up bus. We reach nainital on 23th Jan morning.bus take break at 6 O'clock.We wake up after that and we see natural scenes of nainital.It was awesome, like an a hevan.Hill views, way of turning and little afraid and excitement.Near 9 O'clock we reach nainital.Hill view take cup of tea from hotel balcony Fe...

How to find all tables containing column with specified name - MS SQL Server

Hello Friends, sometime you face in database where we use same colums in database, or where this colum is connected. Today i face this thing so i get this solution fom MS SQL Server's INFORMATION_SCHEMA. Check this Quarry for find tables where we can find colum. select * from INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME like '%COLUMN_NAME%' order by TABLE_NAME Here check this Quarry,replace your column name to COLUMN_NAME and run in sql server, you get list of data that contain column related tables where colun are used.

call store procedure and action for insert and get data

here i create call for store procedure and action for insert and get data,check the code create web confing connection string for db add key="ConnectionString" value="Data Source=###;Initial Catalog=db;User ID=sa;Password=#pwd#" Create class for sql operations using System; using System.Data; using System.Xml; using System.Data.SqlClient; using System.Collections; using System.Configuration; using System.Data.Common; public class SqlHelper { private static string SetConnection() { return Convert.ToString(System.Configuration.ConfigurationManager.AppSettings["ConnectionString"]); } public static int ExecuteNonQuery( CommandType commandType, string commandText, params SqlParameter[] commandParameters) ...

Powered by Blogger

Sun pic

Comments

Post a Comment