Comments by Om Prakash Pant

Om Prakash Pant 18-Jun-15 0:21am View

I think in this statement,"dbo.BuildClientSchema" should be in single quotes as well.
select * from sys.objecs where name=dbo.BuildClientSchema ....

Om Prakash Pant 16-Jan-15 0:17am View

Your question is not clear. please add some more details

Om Prakash Pant 24-Jul-14 10:35am View

value will not be null. I think u can check for IsEmpty

Om Prakash Pant 18-Jun-14 9:29am View

Check the example for insert here:
http://msdn.microsoft.com/en-us/library/system.data.oracleclient.oracledataadapter.insertcommand(v=vs.110).aspx

Om Prakash Pant 26-Mar-14 3:19am View

see this thread for an example
http://lazyloaders.com/threads/stored-procedure-foreign-key.2144/
if you are looking for specific issue then please provide more details.

Om Prakash Pant 21-Feb-14 4:45am View

Can you provide more details with an example on what you are trying to accomplish?

Om Prakash Pant 4-Feb-14 0:58am View

declare final as variable and print.
or you can also do the following:
Select 'Dear Student, thanks for contacting HIMT. Batch dates for ' + @Keyword + '. ' + @Batchdate

Om Prakash Pant 23-Aug-13 1:11am View

Try running the query and see if you are getting records.

Om Prakash Pant 30-May-13 2:58am View

what all code have you tried so far?

Om Prakash Pant 9-Apr-13 0:58am View

Can you show us the SQL queries you have tried so for?

Om Prakash Pant 22-Feb-13 6:24am View

insert data in parent table first and then in child table

Om Prakash Pant 22-Feb-13 6:01am View

try this:
ConfigurationManager.ConnectionStrings["con"].ToString();

Om Prakash Pant 21-Jan-13 3:58am View

remove "on error resume next" to see the actual error.

Om Prakash Pant 15-Jan-13 8:27am View

can you provide more details? the information you have provided is not sufficient.

Om Prakash Pant 11-Jan-13 9:04am View

As an example, i have added some value. "Select" is text and "NA" is value in above example.

Om Prakash Pant 11-Jan-13 4:10am View

both the result in a single column? not clear
Can you show us what output you need?

Om Prakash Pant 15-Nov-12 6:25am View

see the updated SQL query in above solution

Om Prakash Pant 8-Nov-12 7:03am View

yes, it has to be the other way

Om Prakash Pant 8-Nov-12 6:56am View

do you have all the data in the same format?

Om Prakash Pant 7-Nov-12 7:29am View

not clear, can you please elaborate?

Om Prakash Pant 1-Nov-12 6:59am View

Your question is not clear. you provide file name and you need full path of file?
test.tx is in same folder?

Om Prakash Pant 10-Oct-12 5:38am View

Agree that you want to create a query, but what all you have tried so far?

Om Prakash Pant 9-Oct-12 8:52am View

Can you show us the code which you tried so far?

Om Prakash Pant 8-Oct-12 8:56am View

also, in the sample data you entered, the city is 'D' and not 'dubai'

Om Prakash Pant 1-Aug-12 4:17am View

your table has identity column. you need to set the identity insert before inserting the data.

SET IDENTITY_INSERT dbo.City ON
GO

Om Prakash Pant 25-Jul-12 2:51am View

what all you tried so far?

Om Prakash Pant 9-Jul-12 9:05am View

can you show us the code that you tried so far?

Om Prakash Pant 9-Jul-12 9:04am View

so you only want the age and not date of birth?

Om Prakash Pant 6-Jul-12 7:43am View

what you want to perform is not clear..
If the value in <%=rs1("tradename")%> is null then you don't want the textbox to be displayed. is this correct?

Om Prakash Pant 27-Jun-12 7:30am View

Can you print "sqlString" and show the output?
Also, convert other variables like dte, takenby used in the query to string (if they are not string variables).

Om Prakash Pant 30-May-12 4:22am View

if your table has primary key then this should be simple

Om Prakash Pant 21-May-12 8:24am View

Can you show us the code that you have tried so far?

Om Prakash Pant 18-May-12 8:39am View

How do you want to display the result?

Om Prakash Pant 15-Mar-12 7:24am View

this is not a good design..

Om Prakash Pant 23-Feb-12 1:12am View

select 'STT' as tournamentID from tblTournaments

Om Prakash Pant 23-Feb-12 0:49am View

then in that case you only need this
select 'STT' from tblTournaments

Om Prakash Pant 17-Feb-12 5:46am View

can you paste the exact error that you are getting?

Om Prakash Pant 17-Feb-12 5:39am View

what result you are getting?
you should get distinct records on prl.description ,convert(varchar,prl.effective_date,103) effective_date, b.description brand , pc.description cat

Om Prakash Pant 20-Jan-12 0:53am View

yes :-)
i was looking at multiple posts of same question

Om Prakash Pant 19-Jan-12 9:00am View

in HRISDetails table, do you also have managerId which is Ecode? or you need to match with the managername & ename?

Om Prakash Pant 18-Jan-12 7:19am View

what is the error you are getting?

Om Prakash Pant 17-Jan-12 8:25am View

Can you show us the table structure of feedback & product details?

Om Prakash Pant 16-Jan-12 22:19pm View

put the code in form load event instead of cbo_StartYear_SelectedIndexChanged

Om Prakash Pant 13-Jan-12 7:44am View

what are the datatypes of each column?

Om Prakash Pant 13-Jan-12 5:15am View

please elaborate more and show us the code that you have tried so far

Om Prakash Pant 13-Jan-12 3:01am View

will the length of data that you want to extract remain same?

Om Prakash Pant 12-Jan-12 6:57am View

i am not sure you will get count by setting the rs. pl see the following link for options:
http://www.devx.com/tips/Tip/14143

Om Prakash Pant 11-Jan-12 0:58am View

Here is another example:

CREATE TABLE tbl_bankmaster (bank_id int, bank_name varchar(100),status char(1))

insert into tbl_bankmaster values (5, 'Bank5',0);
insert into tbl_bankmaster values (28, 'Bank28',0);

create procedure [dbo].[sp_proc_select] (@bankId varchar(4096))
as
begin
exec ('update tbl_bankmaster set status = 1 where bank_id in (' + @bankId + ')')
end

exec sp_proc_select '5,28'

SELECT * FROM tbl_bankmaster

Om Prakash Pant 11-Jan-12 0:57am View

call the SP as follows:
exec sp_proc_select '5,28'

Om Prakash Pant 2-Jan-12 0:43am View

does your data contain "Female BC-" for all records?

Om Prakash Pant 29-Dec-11 1:48am View

please elaborate

Om Prakash Pant 27-Dec-11 5:35am View

"Please give your answers as soon as possible" - Is this a Quiz?

Om Prakash Pant 27-Dec-11 4:07am View

input to form? please elaborte

Om Prakash Pant 19-Dec-11 7:13am View

didn't saw your post !!

Om Prakash Pant 24-Nov-11 6:25am View

can you paste the code

Om Prakash Pant 11-Nov-11 0:52am View

can you show the code which you have already written for this?

Om Prakash Pant 3-Nov-11 8:34am View

can you show what code you have written?

Om Prakash Pant 3-Nov-11 4:36am View

your query is not clear. do you want to store image in access database using vb6?

Om Prakash Pant 31-Oct-11 9:02am View

not clear. can you please elaborate?

Om Prakash Pant 31-Oct-11 8:59am View

why not use a stored procedure & store in temp table or use with statement.

Om Prakash Pant 24-Oct-11 6:50am View

in that case you need to add this in where clause. something like:
and (isnull(@parm,0) = 0 OR columnname in (select idfield from otherTable where param_field = @parm))
Otherwise it will return all values.

Om Prakash Pant 24-Oct-11 6:05am View

directly go to the Sql Server create open dialog? - please elaborate

Om Prakash Pant 5-Oct-11 6:20am View

check the following FAQ
http://www.internic.net/faqs/domain-names.html

Om Prakash Pant 3-Oct-11 8:58am View

check the following kb article on managing FKeys:
http://msdn.microsoft.com/en-us/library/ms177463(v=sql.90).aspx

Om Prakash Pant 28-Sep-11 6:34am View

what is the sequence of data? is it random or how the data is placed?

Om Prakash Pant 28-Sep-11 3:49am View

Make sure you have set the correct references.

Om Prakash Pant 28-Sep-11 3:46am View

"Locate" a file? not clear.
you can view all files in solution explorer.

Om Prakash Pant 28-Sep-11 3:44am View

pl check this one
http://stackoverflow.com/questions/5512943/linq-interrupt-execution-of-stored-procedure

Om Prakash Pant 26-Sep-11 7:25am View

the value of objDataSet.Tables[0].Rows[i]["Excl"] is -562,000.00? and what is the datatype of this column?

Om Prakash Pant 21-Sep-11 7:02am View

any specific reason for creating date fields as nvarchar?
(compdate,comptime,forwardeddate,forwardedtime)

Om Prakash Pant 19-Sep-11 4:41am View

you said you have 2 different tables with same schema and you want to subtract the cost. correct?

Om Prakash Pant 16-Sep-11 6:04am View

you want this in c# or you need one time database backup and restore?

Om Prakash Pant 13-Sep-11 9:24am View

you can get number of columns for a table, for a select query i don't think you will get columns from sql server.

Om Prakash Pant 13-Sep-11 8:29am View

do you have an identity column in the employee table? how come employee table has duplicate data?

Om Prakash Pant 8-Sep-11 9:38am View

Create table #test_table (grade varchar(10), tot_pass int, tot_num int,PasRate Decimal(3,0))

Declare @TotPass int,@TotNum int, @PasRate Decimal(3,0),@intFlag INT = 7

insert into #test_table
SELECT grade, COUNT(ProgressionStatus),0,0 from LearnerProgression
where AcademicYear='2010' and EmisCode='500171421'
group by Grade

--update total pass column and total column using the "update" statement..

Om Prakash Pant 8-Sep-11 9:32am View

Not necessarily group by will always return more than one value. it depends.
Instead of array, create a temp table and store the result and do the processing..

Om Prakash Pant 8-Sep-11 7:16am View

check the following articles:
http://www.jrsoftware.org/iskb.php?vb
http://techdos.com/index2.php?option=com_content&do_pdf=1&id=74

Om Prakash Pant 24-Aug-11 4:05am View

is it an update statement?

Om Prakash Pant 11-Aug-11 6:25am View

emp code and id stored in separate columns or in single column?

Om Prakash Pant 5-Aug-11 3:42am View

Your question is not clear.
You can use joins to get data from 2 tables.

Om Prakash Pant 28-Jul-11 6:59am View

If you mean how to pass parameters to stored procedure from asp.net page, then check the following link:
http://www.java2s.com/Tutorial/CSharp/0560__ADO.Net/Callstoredprocedureandpassintheparameter.htm
http://www.c-sharpcorner.com/UploadFile/gtomar/storedprocedure12052007003126AM/storedprocedure.aspx

Om Prakash Pant 11-Jul-11 9:21am View

One option is to use XML.
Combine all the data & create XML, pass it to the stored procedure

Om Prakash Pant 6-Jul-11 3:07am View

try this, this will work irrespective of any number of zeros

Om Prakash Pant 9-Jun-11 5:38am View

and based on what criteria?

Om Prakash Pant 18-May-11 8:46am View

your question is not clear. can you add some code and more details?

Om Prakash Pant 18-May-11 7:23am View

you mean to get the selected value of listbox in asp.net?

Om Prakash Pant 16-May-11 7:08am View

can you paste code that is been used?

Om Prakash Pant 11-May-11 0:59am View

last name will come since the name field is different correct? or you want the first name with whatever name if there are multiple IPs?

Om Prakash Pant 26-Apr-11 2:59am View

Try :
dsData = Data.GetDataSet(sqlData, GlobalParameters.conn)
if (dsData.Tables.Count > 0)
For Each dr As DataRow In dsData.Tables(0).Rows
.
.

Om Prakash Pant 26-Apr-11 2:54am View

you mean when you change the value from client side of a textbox, on submit you need the text box value?

Om Prakash Pant 22-Apr-11 3:25am View

to display records from both tables, you have join these tables.

Om Prakash Pant 14-Apr-11 2:56am View

If Framework 2.0 PRE SP1 is used then Use Path.GetFileName
else use openFileDialog.SafeFileName

Om Prakash Pant 7-Apr-11 7:34am View

The position of columns does not matter. By using the select statelemt you can have it at the place you want.
SELECT col1,col3,col2 from table_name

If you want to rearrange then you have to use SELECT ... INTO .. which will create new table with the order you want.

Om Prakash Pant 7-Apr-11 2:50am View

your question is not clear. do you want to rearrange the columns of existing table?

Om Prakash Pant 29-Mar-11 3:37am View

you are already provided the code to insert data in temp tables and do calculations. what is the issue that you are facing?

Om Prakash Pant 26-Mar-11 2:47am View

can you provide the database schema for both the tables and the relation between them?

Om Prakash Pant 16-Feb-11 6:02am View

for more examples on join, please check the following link:
http://www.plus2net.com/sql_tutorial/sql_inner_join.php

Om Prakash Pant 29-Sep-10 1:17am View

Well, the question is generic and there can be more than one answer..

Om Prakash Pant 29-Sep-10 1:14am View

It is not about column is unique or not. you cannot convert any data to any format. see this link on what you can convert and to which datatypes..

http://msdn.microsoft.com/en-us/library/ms187928.aspx

Om Prakash Pant 28-Sep-10 7:23am View

Another guide for beginners:
http://www.codeproject.com/KB/database/sql_in_csharp.aspx

Om Prakash Pant 27-Sep-10 7:35am View

make sure the fields already exists in the excel sheet

Om Prakash Pant 27-Sep-10 5:10am View

Can you show us the code which is being used for updating the data?

Comments by Om Prakash Pant (Top 102 by date)