Comments by Anshumaan Chaturvedi (Top 52 by date)

Thanks.

Guys...chill... we solved it. :D Thanks for your support... I am learning something fruitful at last

thanks, it worked. So irrespective of what the root node is, it will eventually find the descendant node. Am i correct?

IT's throwing :XMLException
Message:
Name cannot begin with the '/' character, hexadecimal value 0x5C.

Hey, I have tried to get Firmware_Crc but the element is under another node

.how do i resolve that?

I am sorry but I didn't get the part :
XElement xml=XElement.Parse(stringWithXml);

this stringWithXml is what actually?
P.S. I am fairly new to .NET

Thanks you Sir. Yes I am a beginner. 3 months only into .NET. Long way to go.
Cheers!!
thanks again for your help and sharing the knowledge

some implementation example links ?

please see the updated question

Well, the case was handled already. Irrespective of what case it is,the elements are read in Datatable except Settings.

The statement in Procedure was working fine with previous table. Same Schema, Same Structure

It is actually PluginSettingXrefValue and no , there is no trigger, the values are populated from code side. Code side implementation is correct.

my bad .... let me update the question

thanks Praveen. Awesome.

This one is far more easier and optimized. you guys rock.

Bravo Pikoh... this initiated my thought process of generating the series.

it is coming as 1.0.1.71 and not 1.0.1.8

No, only the PluginVersion variable. that's it.
if (checkExists(pluginRegistrationEntity))
{
pluginRegistrationEntity.PluginVersion += 1; /// Errorneous logic
string cmdText = "Update PluginRegistration set PluginVersion='" + pluginRegistrationEntity.PluginVersion + "'where PluginName='" + pluginRegistrationEntity.PluginName + "' && Device Type='" + pluginRegistrationEntity.DeviceType + "' && DeviceManufacturer='" + pluginRegistrationEntity.DeviceManufacturer + "' && DeviceModel='" + pluginRegistrationEntity.DeviceModel + "'";
SqlHelper.ExecuteReader(Dsn, CommandType.Text, cmdText);
return 1;

This data is being read from an xml file and before storing it in a particular table of a DB
it needs to be increment in a conditional code section.

It's not throwing any error but just not loading 69 projects in solution.. I am not able to view them in my solution explorer

Please elaborate.....if you can

Sir, let me be honest, i don't know up to your "esteemed level", I am just a college grad in intern, and people instead should encourage for the efforts any fresher puts,not discourage them :) Thanks for your kind words

Could you elaborate? Please if you can..

I have been able to compare but still stuck for inserting value.Any suggestion

exactly, property names with data column value to map setting value.

I do. I should attach it to .exe project but i am not allowed to do that. It is working with unknowing thing.

public SqlDataReader GetRegistrationInfoSetting(string categoryName, int instanceID)
{
string sqlCmdText = "usp_GetRISettingByInstanceIdAndCategoryId";
SqlParameter[] param = new SqlParameter[1];
SqlParameter InstanceId = new SqlParameter("@InstanceId", instanceID);
SqlParameter Category_Name = new SqlParameter("@CategoryName", categoryName);
param[0] = InstanceId;
param[1] = Category_Name;

SqlDataReader reader=SqlHelper.ExecuteReader (Dsn, System.Data.CommandType.StoredProcedure, sqlCmdText,param);


if (reader.HasRows)
{
while (reader.Read())
{
var dataRead = reader.GetValue(0).ToString().Trim();

}
}
else
{
reader.Close();
}
return reader;

}
}
This reader which is of SqlDatareader type, will it hold all the records present in table?

I have to save it in a list or may be in an array

I have but duplication arises. I mainly wanted to have a review.

Thing is the database name was manually changed in the SQl Server Management studio.The user is recreating the database with the same name that is present in physical drive.My requirement is to rename the .mdf and .ldf file in DATA folder.

Say for example i created a database 'abc'
I manually went and changed it to 'abc_old' but in physical path that is in
"C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\" the name is still 'abc' and not 'abc_old'

Now to resolve the problem i wanted to rename the file in DATA folder. For that i have to fetch the path for both the files. I am getting .mdf file but not .ldf file.

How should i proceed now?

Brother, I am new and have very less knowledge. If you could show me how to do it properly?

string dataFilePath;
string logFilePath;
SqlCommand cmdspText = new SqlCommand("GetAllPhysicalPath", conn);
cmdspText.CommandType = CommandType.StoredProcedure;
cmdspText.Parameters.AddWithValue("@txtDatabaseName", userSpecifiedDBNameInTxtBox);
cmdspText.ExecuteNonQuery();
SqlDataReader reader = new SqlDataReader();
while(reader.Read())
{
//what should i write here
}

string dataFilePath;
string logFilePath;
SqlCommand cmdspText = new SqlCommand("GetAllPhysicalPath", conn);
cmdspText.CommandType = CommandType.StoredProcedure;
cmdspText.Parameters.AddWithValue("@txtDatabaseName", userSpecifiedDBNameInTxtBox);
cmdspText.ExecuteNonQuery();
SqlDataReader reader = new SqlDataReader();
while(reader.Read())
{
//what should i write here
}

How to do it? Could you explain?

Hey that works. Thanks Alexander

Will try it now

Thanks Phil....

I guess, i should use executeReader because there are more than one rows which needs to be read.

Getting InvalidOperationException
String[0]: the Size property has an invalid size of 0.


Eagerly waiting for your reply

Getting InvalidOperationException
String[0]: the Size property has an invalid size of 0.

My stored Procedure :

USE [master]
GO
/****** Object: StoredProcedure [dbo].[CleanInstall] Script Date: 06/16/2014 15:54:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- Batch submitted through debugger: SQLQuery9.sql|7|0|C:\Users\c5038671\AppData\Local\Temp\~vs3ACC.sql
ALTER PROCEDURE [dbo].[CleanInstall]
@backUpDirectoryPath VARCHAR (500) OUT
AS
BEGIN
IF OBJECT_ID('tempdb..#instances') is not null DROP TABLE #instances
IF OBJECT_ID('tempdb..#directories') is not null DROP TABLE #directories

CREATE TABLE #instances (Name VARCHAR(255), InstanceName VARCHAR(255))
CREATE TABLE #directories (TypeName VARCHAR(255), DirPathName VARCHAR(255))
DECLARE @regInstanceKey VARCHAR(500)
DECLARE @instance VARCHAR(255) -- current instance
DECLARE @ver VARCHAR(255) -- MS SQL version
DECLARE @key VARCHAR(255) -- Registry key on server side
DECLARE @value_name VARCHAR(255) -- Registry value name
DECLARE @instance_name VARCHAR(255) -- Key value name for the instance of SQL Server 2000
DECLARE @version INT -- SQL Server version (integer)


DECLARE @ic INT
SET @instance_name = ''

INSERT INTO #instances
EXEC xp_instance_regread @rootkey = 'HKEY_LOCAL_MACHINE',
@key = 'SOFTWARE\\Microsoft\\Microsoft SQL Server',
@vn = 'InstalledInstances',
@backUpDirectoryPath = @regInstanceKey OUTPUT;

SELECT @ic = COUNT(*) FROM #instances
WHERE InstanceName = @@servicename
IF( @ic = 1 ) BEGIN
SELECT @instance = InstanceName FROM #instances
WHERE InstanceName = @@servicename

SELECT @ver = SUBSTRING(CAST(SERVERPROPERTY('productversion') AS VARCHAR(255)), 1, 2)
IF(RIGHT(@ver,1) = '.') SET @version = CAST(LEFT(@ver,1) AS INT)
ELSE SET @version = CAST(@ver AS INT)

IF ( @version = 8) BEGIN
IF (@instance <> 'MSSQLSERVER' ) SET @key =
'SOFTWARE\\Microsoft\\Microsoft SQL Server\\' + @instance + '\\MSSQLServer\\'
ELSE SET @key = 'SOFTWARE\\Microsoft\\MSSQLServer\\MSSQLServer\\'
END
ELSE IF ( @version > 8) BEGIN
EXEC xp_instance_regread @rootkey = 'HKEY_LOCAL_MACHINE',
@key = 'SOFTWARE\Microsoft\\Microsoft SQL Server\\Instance Names\\SQL',
@vn = @instance,
@value = @instance_name out
SET @key = 'SOFTWARE\\Microsoft\\Microsoft SQL Server\\' + @instance_name + '\\MSSQLServer'
END

SET @value_name = 'DefaultData'
EXEC xp_instance_regread @rootkey = 'HKEY_LOCAL_MACHINE',
@k = @key,
@vn = @value_name,
@backUpDirectoryPath = @regInstanceKey OUTPUT;
IF @regInstanceKey = @instance_name SET @regInstanceKey = NULL

INSERT INTO #directories
VALUES ('DefaultData', @regInstanceKey)
SET @value_name = 'DefaultLog'

EXEC xp_instance_regread @rootkey = 'HKEY_LOCAL_MACHINE',
@k = @key,
@vn = @value_name,
@backUpDirectoryPath = @regInstanceKey OUTPUT;

IF @regInstanceKey = @instance_name SET @regInstanceKey = NULL
INSERT INTO #directories
VALUES ('DefaultLog', @regInstanceKey)

SET @value_name = 'BackupDirectory'
EXEC xp_instance_regread @rootkey = 'HKEY_LOCAL_MACHINE',
@k = @key,
@vn = @value_name,
@backUpDirectoryPath =@regInstanceKey OUTPUT;

INSERT INTO #directories
VALUES ('BackupDirectory', @regInstanceKey)
IF @regInstanceKey = @instance_name SET @regInstanceKey = NULL




END

END
SELECT * FROM #directories
SELECT * FROM #instances
DROP TABLE #instances
DROP TABLE #directories

Yes

USE [master]
GO
/****** Object: StoredProcedure [dbo].[CleanInstall] Script Date: 06/16/2014 15:54:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- Batch submitted through debugger: SQLQuery9.sql|7|0|C:\Users\c5038671\AppData\Local\Temp\~vs3ACC.sql
ALTER PROCEDURE [dbo].[CleanInstall]
@backUpDirectoryPath VARCHAR (500) OUT
AS
BEGIN
IF OBJECT_ID('tempdb..#instances') is not null DROP TABLE #instances
IF OBJECT_ID('tempdb..#directories') is not null DROP TABLE #directories

CREATE TABLE #instances (Name VARCHAR(255), InstanceName VARCHAR(255))
CREATE TABLE #directories (TypeName VARCHAR(255), DirPathName VARCHAR(255))
DECLARE @regInstanceKey VARCHAR(500)
DECLARE @instance VARCHAR(255) -- current instance
DECLARE @ver VARCHAR(255) -- MS SQL version
DECLARE @key VARCHAR(255) -- Registry key on server side
DECLARE @value_name VARCHAR(255) -- Registry value name
DECLARE @instance_name VARCHAR(255) -- Key value name for the instance of SQL Server 2000
DECLARE @version INT -- SQL Server version (integer)


DECLARE @ic INT
SET @instance_name = ''

INSERT INTO #instances
EXEC xp_instance_regread @rootkey = 'HKEY_LOCAL_MACHINE',
@key = 'SOFTWARE\\Microsoft\\Microsoft SQL Server',
@vn = 'InstalledInstances',
@backUpDirectoryPath = @regInstanceKey OUTPUT;

SELECT @ic = COUNT(*) FROM #instances
WHERE InstanceName = @@servicename
IF( @ic = 1 ) BEGIN
SELECT @instance = InstanceName FROM #instances
WHERE InstanceName = @@servicename

SELECT @ver = SUBSTRING(CAST(SERVERPROPERTY('productversion') AS VARCHAR(255)), 1, 2)
IF(RIGHT(@ver,1) = '.') SET @version = CAST(LEFT(@ver,1) AS INT)
ELSE SET @version = CAST(@ver AS INT)

IF ( @version = 8) BEGIN
IF (@instance <> 'MSSQLSERVER' ) SET @key =
'SOFTWARE\\Microsoft\\Microsoft SQL Server\\' + @instance + '\\MSSQLServer\\'
ELSE SET @key = 'SOFTWARE\\Microsoft\\MSSQLServer\\MSSQLServer\\'
END
ELSE IF ( @version > 8) BEGIN
EXEC xp_instance_regread @rootkey = 'HKEY_LOCAL_MACHINE',
@key = 'SOFTWARE\Microsoft\\Microsoft SQL Server\\Instance Names\\SQL',
@vn = @instance,
@value = @instance_name out
SET @key = 'SOFTWARE\\Microsoft\\Microsoft SQL Server\\' + @instance_name + '\\MSSQLServer'
END

SET @value_name = 'DefaultData'
EXEC xp_instance_regread @rootkey = 'HKEY_LOCAL_MACHINE',
@k = @key,
@vn = @value_name,
@backUpDirectoryPath = @regInstanceKey OUTPUT;
IF @regInstanceKey = @instance_name SET @regInstanceKey = NULL

INSERT INTO #directories
VALUES ('DefaultData', @regInstanceKey)
SET @value_name = 'DefaultLog'

EXEC xp_instance_regread @rootkey = 'HKEY_LOCAL_MACHINE',
@k = @key,
@vn = @value_name,
@backUpDirectoryPath = @regInstanceKey OUTPUT;

IF @regInstanceKey = @instance_name SET @regInstanceKey = NULL
INSERT INTO #directories
VALUES ('DefaultLog', @regInstanceKey)

SET @value_name = 'BackupDirectory'
EXEC xp_instance_regread @rootkey = 'HKEY_LOCAL_MACHINE',
@k = @key,
@vn = @value_name,
@backUpDirectoryPath =@regInstanceKey OUTPUT;

INSERT INTO #directories
VALUES ('BackupDirectory', @regInstanceKey)
IF @regInstanceKey = @instance_name SET @regInstanceKey = NULL




END

END
SELECT * FROM #directories
SELECT * FROM #instances
DROP TABLE #instances
DROP TABLE #directories

Coudl you find any fault in this.??
using System;
using System.Data;
using System.IO;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace TestForLogic
{
class Program
{
static void Main(string[] args)
{
string[] targetPath;

using (SqlConnection connection = new SqlConnection("Server=BNGTSIDTPC0738;User=sa;Password=login@234;Initial Catalog=master;Connection Timeout=120"))

using(SqlCommand cmd = new SqlCommand("CleanInstall", connection))
{
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter backUpDirectoryPath = new SqlParameter("@backUpdirectoryPath", SqlDbType.VarChar)
{
Direction=ParameterDirection.Output
};
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(backUpDirectoryPath);

connection.Open();

cmd.ExecuteNonQuery(); //it is giving an Exception . String[0] has size 0

connection.Close();



}
}
}
}

could you elaborate please, i,m a freshmen. Don't know much about coding. It's for practice.

So this gets me all the instances of SQL server installed on local machine or on network also??
Finally this stored procedure will give me a path name or what ?

Is traversing through this path "C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA" possible when the file is having read-only property on. I am actually running the search engine code for searching a file with particular name.