Comments by Karwa_Vivek

Karwa_Vivek 10-Feb-15 1:52am View

Post you Comments in
Have a Question or Comment ?
Section.
Not Here, this space is meant for Solutions.

Karwa_Vivek 10-Feb-15 1:49am View

Check the C# version. Hope this helps u.
for conversion you can visit.
http://converter.telerik.com/

Karwa_Vivek 12-Jun-14 7:24am View

Thanks for reply.
Found the Solution
I have Concatenated all the Values in a Single Field.
That Solved my Problem

Karwa_Vivek 30-Aug-13 5:49am View

thanks for your valuable comments.this Really helped me a lot.
trying to find the solution my way.
Just "dumped" my code so that someone could understand my Question .
thanks Again enhzflep

Karwa_Vivek 9-Aug-13 2:44am View

why dont you use the IMPORT and EXPORT wizard of SQL Server

Karwa_Vivek 6-Aug-13 8:59am View

According to your Question you want the Records ,who have not paid there total Installments yet and who have to pay the Remaining Installments ,Right ??

Karwa_Vivek 20-Jul-13 7:58am View

ok that means ..you want to answer only a problem.anyways thanks for ur comment

Karwa_Vivek 8-Jul-13 9:46am View

select Distinct DATEPART (year, column) FY from TableName order by FY ASC
--thanks I used Like this

Karwa_Vivek 1-Jul-13 3:20am View

Are you Using DateTimePicker Control To Input the Date or you Using a textBox

Karwa_Vivek 18-Jun-13 2:31am View

what you really want.unable to understand your need.
provide some example.
what you mean by dd/mm/yyy
do you want like this in 24/12/198.check ur question

Karwa_Vivek 17-Jun-13 8:07am View

Deleted

your output :06/17/2013

Karwa_Vivek 22-Apr-13 8:22am View

Thanks for help

Karwa_Vivek 29-Mar-13 6:24am View

thanks

Karwa_Vivek 7-Mar-13 7:13am View

same site ,not any external site

Karwa_Vivek 7-Mar-13 7:07am View

The problem is that the page in which frame is set
thats not getting timeout
but the src page of frame is getting time out.

Karwa_Vivek 21-Feb-13 6:14am View

thanks Abhinav

Karwa_Vivek 11-Feb-13 7:37am View

I didnt undestand what you trying to say.
How should i use this

Karwa_Vivek 9-Feb-13 7:02am View

On click event of Label .I want to fetch the text of that Particular label which is clicked.

Karwa_Vivek 5-Feb-13 8:38am View

I have checked that folder and is empty.
Also I have closed the excel in program .
But the Issue is not solved.

Karwa_Vivek 3-Jan-13 1:52am View

Yes both site can share data..What is GUID ..at this point,Security issue is not so important.
Can you describe it a bit more

Karwa_Vivek 22-Dec-12 5:39am View

id is just integers like 1,2,3,4 like this
page.Width.Point and page.Height.Point is the page width and height
and i agree that each call is drawing in the same place.that is the problem

Karwa_Vivek 17-Dec-12 5:47am View

No I want that how to show the graph of strength of Employees and corresponding to company name .how i should link the values with graph. i mean in X axis name of company and in Y axis number of employees

Karwa_Vivek 8-Dec-12 0:49am View

use like this
select CONVERT(VARCHAR(8), dob, 5) AS BirthDate from tablename

add the Tablename also .the name of your table containg the dob field

Karwa_Vivek 17-Nov-12 7:05am View

No its Not working

Karwa_Vivek 16-Nov-12 6:31am View

I think thats not the matter here.I am getting correct values for Single items.
How can I get data for all the items. the above function and procedure is working fine ,when I am passing itemID .I just want that how i should proceed to get openings for all the items .May there be some synatax mistakes but am asking about the logic

Karwa_Vivek 16-Nov-12 6:23am View

because i am passing formatted date from Front end as varchar
and then Converting the date in smalldatetime.

Karwa_Vivek 16-Nov-12 5:15am View

Updated my Question With My Function and Procedure .Please see.Thanks

Karwa_Vivek 16-Nov-12 5:14am View

I have added the Procedure.please see If you can help

Karwa_Vivek 7-Nov-12 9:22am View

can you explain your solution with an example

Karwa_Vivek 7-Nov-12 9:21am View

my problem is how to do this.how can i store these values in a string one by one as user enter the values.

Karwa_Vivek 7-Nov-12 8:30am View

I want to clear my query More .
Let for Example user enter id =1 and Fetched the related Data in datagridview.
Now next user enter id =2 .here I just want that the related data with id 2. will get filled just below the related data with id 1 previously user has entered.
I have understood the "RetriveDataTable" method.which will fetch the data related to ID =1.. but what to do when user enter ID =2 and again press enter.Here the Requirement is that Datagridview should not get clear only the data related to ID =2 get filled below it.

Karwa_Vivek 7-Nov-12 7:16am View

I think you can help me.
Please explain your second way more.

Karwa_Vivek 7-Nov-12 7:03am View

Can you explain this a little Bit

Karwa_Vivek 7-Nov-12 6:31am View

i am setting the Datasource to the datagridview.

Karwa_Vivek 16-Oct-12 7:22am View

Thanks for your help.
Actually i was referencing
the style sheet under <style type="text/css">
</style> Tags.which was my mistake.I just placed out side the tags and is working fine now.

Karwa_Vivek 16-Oct-12 7:13am View

IE 8

Karwa_Vivek 16-Oct-12 6:44am View

Pasting my code here please help

<html>
<head>
<title></title>
<script type="text/javascript">
function changeRowColor(currentRow) {
$(currentRow).css('color', 'green'); // change clicked row to active color
$(currentRow).parent().siblings().css('color', 'red'); // change all the rest to non active color
}
</script>
<script type="text/javascript" src="Scripts/jquery.min.js"></script>
</head>
<body>
<table>
<tr>
<td önclick="changeRowColor(this)">ABC
</td>
</tr>
<tr>
<td önclick="changeRowColor(this)">DEF
</td>
</tr>
<tr>
<td önclick="changeRowColor(this)">...
</td>
</tr>
<tr>
<td önclick="changeRowColor(this)">XYZ
</td>
</tr>
</table>
</body>
</html>

Karwa_Vivek 16-Oct-12 6:43am View

have some problem that
after clicking on other link the visited link is not resseting its colour.
wheres the problem

Karwa_Vivek 16-Oct-12 5:41am View

below is the CSS under the style sheet

<style type="text/css">
.divM{
position:absolute;
top:122px;
left:376px;
}
.divHome{
position:absolute;
top:12px;
left:20px;
width:75.6%;
z-index: 1
}
BODY
{
FONT-SIZE: 9pt;
MARGIN: 5px;
FONT-FAMILY: Verdana
}
TD
{
FONT-SIZE: 8pt;
FONT-FAMILY: Verdana, Arial
}
P
{
MARGIN-TOP: 8px;
MARGIN-BOTTOM: 8px;
LINE-HEIGHT: 150%
}
.P4
{
MARGIN-TOP: 4px;
MARGIN-BOTTOM: 4px
}
.PtyAdd
{
MARGIN-TOP: 0px;
MARGIN-BOTTOM: 0px;
MARGIN-LEFT: 15px
}

img { border: none ; }

</style>

Karwa_Vivek 16-Oct-12 5:39am View

am using a stylesheet
and calling on the particular page

Karwa_Vivek 16-Oct-12 5:33am View

its working in IE too
But the problem is that
when the page is loading for first time
then CSS is not working .

Karwa_Vivek 15-Oct-12 6:49am View

Actually I am Fetching the Database Values
and storing the same in a String
and then passing the string to other page using a link reference
and then showing the value in other page .I am using SQL Database. and VB.net

Karwa_Vivek 15-Oct-12 3:33am View

Deleted

Yes in anyway if this can be done
can you please explain your code little
bit more .how i can implement this

Karwa_Vivek 5-Oct-12 1:07am View

Yes @Andy411 you are right.
I want to clear the Scenario more clear here
that when I am Installing the Windows Service.
The app.config File is placed in C drive under Program files
as Normally what haappens when we Install.

I have managed to read the app.config file using the External(Independent) service controller by hard Coding the Path of the app.config file. and fetched the service Interval value in a form . But Here Am struck as I am not getting any Idea to convert this value as 10am or any..My need is that to set the time such that service starts Daily or weekly at particular time or Day of the Week.am able to sart and stop the service from service control to but the Main problem is how to convert the service interval time to Day or particular time.

Karwa_Vivek 1-Oct-12 6:10am View

ok thanks a lot
was missing the xLoad.Save() function.

Karwa_Vivek 1-Oct-12 5:51am View

Ok i managed to get the value ,but while updating its not getting updated below is my code,please assist where am missing something

Imports System.Xml
Imports System.Collections.Specialized
Imports System.IO
Imports System.Configuration
Imports System.Diagnostics
Imports System.Configuration.ConfigurationSettings

Public Class Form1
Dim xDoc As XmlDocument = New XmlDocument()
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Call FindValue()
End Sub
Public Sub FindValue()

xDoc.Load("SynbatAutoUpdater.exe.config")
Dim xNode As XmlNode = xDoc.DocumentElement.SelectSingleNode("UpdaterConfiguration/service")
Dim value As String = xNode.Attributes("updateInterval").Value
TextBox1.Text = value
End Sub
Public Sub UpdateValue()

xDoc.Load("SynbatAutoUpdater.exe.config")
Dim xNode As XmlNode = xDoc.DocumentElement.SelectSingleNode("UpdaterConfiguration/service")
xNode.Attributes("updateInterval").Value = "0.00:04:00"
MsgBox("updated")
End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
UpdateValue()
End Sub
End Class

Karwa_Vivek 1-Oct-12 2:27am View

Am trying YOur Code to implement.
But while Loading the XML and to fetch the value
I am Getting as error "Data At the root level is Invalid ,Line 1 Position 1"
I tried using a simple XML file .wheres the Problem

Karwa_Vivek 18-Sep-12 3:47am View

Superb..Thanks a Ton

Karwa_Vivek 12-Sep-12 2:07am View

Why dont you Use CSS to Achieve this

Karwa_Vivek 6-Sep-12 2:07am View

you must have to fill gridview with Datasource First

Karwa_Vivek 6-Sep-12 2:07am View

NOT POSSIBLE

Karwa_Vivek 5-Sep-12 0:39am View

What you Have Tried Till Now ...?

Karwa_Vivek 4-Sep-12 6:51am View

Boss Cant you see the Link i posted to Convert it into C#...

Karwa_Vivek 3-Sep-12 5:32am View

Are you Using GridView to Save the Details ...?

Karwa_Vivek 29-Aug-12 1:29am View

you can't Set Session Variables to Null.
Session["Employee"]=null will return you a "Null constants is no longer supported.

Karwa_Vivek 25-Aug-12 9:35am View

yes have tried InitialDirectory Property.
But this is taking me to that path which i have provided in that property.
But the requrement is that I want to get in the last opened Path only.

Karwa_Vivek 14-Aug-12 7:48am View

Deleted

No this syntax is not valid for Array Declaration. If you try like this you will get an exception of unused variable..

Karwa_Vivek 14-Aug-12 7:46am View

The problem is That in One project it is working fine with count property.but in another its giving the error. Length property solves my problem for now. but why this that in different projects is not behaving the same. anyways will find the reason.. Thanks for your quick reply.

Karwa_Vivek 11-Aug-12 5:24am View

My query Doesn't Deal About the Solution you posted.
Anyways thanks.

Karwa_Vivek 11-Aug-12 3:13am View

Did you have created the HTML table Dynamically in your Project.
I have created the html table using String Builder .and appended the HTML tags with in . Am sure you are not using this code on Dynamically created Table in your project.this Code is working Fine when am using on a Static page.Anyways thanks for your attention

Karwa_Vivek 11-Aug-12 2:47am View

Have tried your Solution "onClientClick " event is not working with
the html button created dynamically. i tried using onclick event .
but am getting a blank page. i also set the Id of the control / div to print.

Karwa_Vivek 11-Aug-12 2:33am View

not working for me

Karwa_Vivek 11-Aug-12 0:32am View

Christian Amado I have a Query ... can a VB or C# code can be Called
from the Onclick event as Here we calling the Javascript ???

Karwa_Vivek 10-Aug-12 8:53am View

Thanks I was also Thinking that only.Is working .
But One thing you must have noticed that when mouse is over the image then
its not showing any change in mouse as we see hand cursor normally.Anyways will find it .Thanks again

Karwa_Vivek 10-Aug-12 8:53am View

Thanks

Karwa_Vivek 10-Aug-12 8:44am View

javascript code can be called on onclick event of image..

Karwa_Vivek 10-Aug-12 8:42am View

I have created Whole page Dynamically using string Bulider and appending the html tags... I have not used any asp controls on the page..

Karwa_Vivek 10-Aug-12 8:13am View

Thanks I got it Working

Karwa_Vivek 9-Aug-12 1:57am View

where Should I write this Code..in code behind or in aspx source page.In which event ?

Karwa_Vivek 26-Jul-12 8:36am View

I want to hide a Particular Treeview Parent Node
Not all

Karwa_Vivek 26-Jul-12 8:29am View

thanks for the Edit Prasad

Karwa_Vivek 21-Jul-12 13:23pm View

can you please explain this a bit..

Karwa_Vivek 21-Jul-12 9:24am View

Have Fetched the Data using dataAdapater.
But How I will Check that in loop thats the Issue

Karwa_Vivek 21-Jul-12 9:23am View

Yes I am Using Css accordingly.
But Confused to fetch the Data and to check that with the label names.
I know have to use loop for checking. But I am not getting any clue how to check

Karwa_Vivek 17-Jul-12 2:30am View

thanks

Karwa_Vivek 17-Jul-12 2:21am View

this will require to create a stored procedure
can this be done in a single query

Karwa_Vivek 16-Jul-12 6:05am View

But I want it to be visible when user scroll down the page.
this is always visible.

Karwa_Vivek 16-Jul-12 2:15am View

ok thanks

Karwa_Vivek 16-Jul-12 1:33am View

Its Cutting In Report Viewer...
thats the problem
user is unable to view the whole data

Karwa_Vivek 16-Jul-12 1:30am View

how can i can you please explain it a bit.. where should i change the option

Karwa_Vivek 5-Jul-12 7:04am View

its windows application DatagridView ..not in asp.net web.

Karwa_Vivek 29-Jun-12 2:02am View

I have just Disabled The "Just My Code " option under Menu >Tools>Option>Debugging>Enable Just My code.

Due to which When Error Or Exception Ocuurs It was Taking me Out side of My code and Showing me the controls cs files.
You can try and See this happening,
Anyways Thanks For your Kind Attention.

Karwa_Vivek 28-Jun-12 9:05am View

Thanks..Finally I got it.
Enabled "Just My Code"

Karwa_Vivek 28-Jun-12 8:05am View

Anyways Thanks For Your valuable time and Attention.

Karwa_Vivek 28-Jun-12 8:04am View

you must re-Read my Posted Question..

Karwa_Vivek 28-Jun-12 7:53am View

AM NOT GETTING ANY ERROR ..... BUT WHEN I AM GETTING ANY ERROR OR EXCEPTION..
ITS NOT SHOWING IT IN THE RIGHT PLACE ,WHEREAS ITS SHOWING ME THE EXCEPTION OR ERROR UNDER THE CLASS FILE OF THAT CONTROL IN WHICH THE ERROR OCCURRED.
MAY YOU UNDERSTAND ME NOW..

Karwa_Vivek 28-Jun-12 7:52am View

AM NOT GETTING ANY ERROR ..... BUT WHEN I AM GETTING ANY ERROR OR EXCEPTION..
ITS NOT SHOWING IT IN THE RIGHT PLACE ,WHEREAS ITS SHOWING ME THE EXCEPTION OR ERROR UNDER THE CLASS FILE OF THAT CONTROL IN WHICH THE ERROR OCCURRED.
MAY YOU UNDERSTAND ME NOW..PROVIDE YOUR MAIL ID SO THAT I CAN SEND YOU SOME SCREEN SHOTS

Karwa_Vivek 28-Jun-12 7:26am View

But Agin its Not working .
The same problem again.

Karwa_Vivek 28-Jun-12 3:36am View

Thanks

Karwa_Vivek 27-Jun-12 8:09am View

Have DOne like This
Private Sub CreateDataGridView(ByVal ChallanID As Integer)
Dim sSQL As String = ""
Dim MyRecordset5 As Data.DataTable = Nothing
MyRecordset5 = New Data.DataTable

sSQL = "SPIS_GetTransDtl " & ChallanID
MyConnection.ExecuteSQL(sSQL, MyRecordset5)
If MyRecordset5.Rows.Count > 0 Then
rowCnt = MyRecordset5.Rows.Count
'lblTotal.Text = MyRecordset5.Rows.Count.ToString & " Items"
dgv.AutoGenerateColumns = False
dgv.DataSource = MyRecordset5
dgv.Columns("SlNo").DataPropertyName = "Slno"
dgv.Columns("Item").DataPropertyName = "Name"
dgv.Columns("ItemId").DataPropertyName = "ItemID"
dgv.Columns("ItemCode").DataPropertyName = "ItemCode"
dgv.Columns("Quantity").DataPropertyName = "Qty"
dgv.Columns("Description").DataPropertyName = "Description"

End If

End Sub

Karwa_Vivek 27-Jun-12 7:37am View

I have tried This .. But It Throws error that Adding Rows Programmaticaly is not valid in bound DatagridView.
I have Filled the Datagridview With Database Values using Stored Procedure.

Karwa_Vivek 27-Jun-12 7:33am View

Can YOu please Explain a bit How Can I Do that.
How Can I Add new Item In Datasource.
I am using a Stored procedure To Fetch Data And To Fill the Datagridview.
Thanks

Karwa_Vivek 14-Jun-12 9:08am View

welCome

Karwa_Vivek 12-Jun-12 8:46am View

Use BreakPoints and Watch the Values.....

Karwa_Vivek 9-Jun-12 7:42am View

Deleted

how to place this code ? ? ?

Karwa_Vivek 9-Jun-12 7:40am View

your code is nit clear.
please clarify.will i do this in form load Event.
is not possible.please assist
HOW TO PLACE THIS CODE

Karwa_Vivek 7-May-12 2:54am View

Thanks A Lot..That's What, I was in need Of.Thanks Again

Karwa_Vivek 7-May-12 2:33am View

No its not InI file.I Just working on .txt
file.

Karwa_Vivek 27-Apr-12 6:49am View

But how can I find the end of First line so that i can append the text at that position..Reading back is ok but how i will append it in the end of first line

Karwa_Vivek 24-Apr-12 2:44am View

td.column_style_left
{
border-left: 1px solid black;
}
td.column_style_right
{
border-right: 0px ;
}

Karwa_Vivek 21-Apr-12 8:50am View

I tried this from sql
SELECT [tstDate], [Name1] AS Name1, [Name2] AS Name2,[Name4] AS Name4
FROM
(Select [tstDate], wb.[Name], SUM(Marks) Marks
from ( select tstDate, count(*) Marks
from sch_table where tbID='09'
AND convert(char(6),[tstDate],112)='201204'
AND subType=2 Group By [tstDate], studID ) x, sch_main wb
WHERE x. studID=wb.[ID]
Group by [tstDate], studID , wb.[Name]
) ps
PIVOT
(
Sum( Marks)
FOR [Name] IN
( [Name1], [Name2] ,[Name4])
) AS pvt
Order By [tstDate]

but getting tstDate repetitve for Each Name
means Showing
01/12 --- 66 (for name1)
01/12 ----44 (for name2)

and so on ..may you getting me

Karwa_Vivek 8-Sep-11 3:23am View

Goggle this Question First .you will find your Solution.

Karwa_Vivek 11-Aug-11 9:22am View

using the Second Command [List1.Items]
you will Get the exact path of your File where it is located.
Go there and get it.And if you want it through the app only ,then
Is better to Post a new Question out there.You know Points Matters

Karwa_Vivek 11-Aug-11 8:42am View

Means You want Files to Search .not Data .am I correct now?

Karwa_Vivek 11-Aug-11 8:09am View

what is your Database MS-Access or MS-Sql?

Karwa_Vivek 11-Aug-11 5:49am View

you want us to Post our error Code
but when asked for help
you don't write us any Code
u give links or ur Theories on the error.
Don't mind .

Karwa_Vivek 4-Aug-11 8:06am View

post your Code

Karwa_Vivek 4-Aug-11 7:58am View

this is an Issue which is under
test and review by Microsoft.
visit this site for more information
http://connect.microsoft.com/VisualStudio/feedback/details/433391/microsoft-visualstudio-datadesign-syncdesigner-syncfacade-syncmanager-error

Karwa_Vivek 24-Jun-11 8:56am View

Great Link !!

Karwa_Vivek 24-Jun-11 0:38am View

They have DownVoted my answer !!!
Really It's Fun Here.

Karwa_Vivek 20-Jun-11 6:03am View

Most probably It Seems Your
pdf file is not Closing
after you dispose the webbrowser..

Karwa_Vivek 20-Jun-11 5:58am View

great link..

Karwa_Vivek 17-Jun-11 7:19am View

no listview,no gridview,no controls
then Use Crystal Reports,or any other reporting controls.
And if you dont want to use these also.
Then I have no Idea..If you get any or Have any idea .
Please Post it Here.I too want to know this.
Good luck

Karwa_Vivek 15-Jun-11 3:42am View

Please Visit the Provided Link in my Answer
to know about this .Your Google yourself.
It provides some more tools like print Forms
and other more advanced controls

Karwa_Vivek 15-Jun-11 3:24am View

Have You tried the Visual Basic Power pack

Karwa_Vivek 14-Jun-11 0:56am View

what do you mean by BASIC AUTHENTICATION..
can you explain it please

Karwa_Vivek 13-Jun-11 5:53am View

Please Clarify in detail what the problem you are facing
now . I must suggest you to re-enter the data in the
associated tables and then Check the Output in CR

Karwa_Vivek 13-Jun-11 5:48am View

You must check your
saved data details
in the table.

Karwa_Vivek 13-Jun-11 5:36am View

Glad to help you..

Karwa_Vivek 13-Jun-11 1:40am View

VB.NET

Karwa_Vivek 13-Jun-11 1:38am View

Elaborate your Question little More.

Karwa_Vivek 11-Jun-11 9:37am View

you are using a long route

Karwa_Vivek 11-Jun-11 7:57am View

please post your code
what you have tried so far.
So that we could suggest you something

Karwa_Vivek 10-Jun-11 6:44am View

Maybe it can help if you understand the basics.

Karwa_Vivek 10-Jun-11 6:26am View

I just mean to say that calling a web service from a windows application is
Possible and it doesn't have any security issues also..am I Right ?

Karwa_Vivek 10-Jun-11 6:08am View

where as Reverse is Possible.

Karwa_Vivek 9-Jun-11 7:11am View

Deleted

where is the link between your city and Branch.
You have to re-think over
your table Structure

Karwa_Vivek 9-Jun-11 6:33am View

is there any one link,or say a common ID in between these three Tables.
means is there a cityID in tblBranch

Karwa_Vivek 9-Jun-11 6:20am View

Please post the table structure of your City table and Branch Table.Then only I can help you here.

Karwa_Vivek 3-Jun-11 5:41am View

If you Got it
here..Remember To
Mark Your Solution
So that it can help others
Also.it's Simple Just Click the Green
button.
Thanks

Karwa_Vivek 3-Jun-11 5:27am View

My 5
good Links

Karwa_Vivek 3-Jun-11 3:04am View

Please Mark Your Solution .It will Help Others Too.
Green Button.
have fun !

Karwa_Vivek 2-Jun-11 8:20am View

Can you elaborate Your Code
some more.Can you post The Total
block of code

Karwa_Vivek 1-Jun-11 5:32am View

when I am Trying to List all the databases
from the selected Server (LOADED IN THE FIRST COMBO)
it Says Failed to connect to the SERVER

Karwa_Vivek 1-Jun-11 5:32am View

Deleted

when I am Trying to List all the databases
from the selected Server (LOADED IN THE FIRST COMBO)
it Says Failed to connect to the SERVER

Karwa_Vivek 31-May-11 5:19am View

hi Joseph ..got the Solution ?

Karwa_Vivek 30-May-11 3:38am View

fetchDataSource() is Function I am calling this in Form's Load
to Fill the cmbDataSource(combobox)
I have managed to Get the Servernames on this Combo
cmbDatabase(combobox) in which I need the DatabaseNames on the Selection of Servernames.
Here I am getting The Error

Karwa_Vivek 30-May-11 3:26am View

I need this DataSource/ServerName: and Then List Of DataBases on the basis of Selected Servername
That's All...And It will Solve my Problem

Karwa_Vivek 27-May-11 8:49am View

Thanks a Ton
..I Got it working at The End of the Day

to avoid SQL Injection
I just Used
SET @Query = 'SELECT ' + @Select + ' FROM ' + @Table
thanks again

Karwa_Vivek 27-May-11 7:06am View

It can Be Done .but the requirement is
that user can select
the field according to there Need

Karwa_Vivek 27-May-11 7:03am View

Ok .I have managed to Store all the selected
Field in a single String separated by comma.
Now Got Stuck ..how to pass in the query

Karwa_Vivek 27-May-11 7:00am View

Is it Possible Like That ?

Karwa_Vivek 27-May-11 6:57am View

yes Exactly..
But later on I have also to Supply
the Table Name which I Selected from the comBobox

Karwa_Vivek 27-May-11 6:40am View

Thanks for the Help
it worked fine ,but i need to pass
these fields in a Sql Select Statment
in place of Field names.So that according
to the fields i can fetch the data stored in the
Table. Is Some How tricky but I think it is possible ..

Karwa_Vivek 24-May-11 9:36am View

but for your Info
it is Called as Group tree.Ask your question at a proper place.

Karwa_Vivek 24-May-11 9:31am View

Is this your Solution ?

Karwa_Vivek 24-May-11 9:08am View

Really !!!
Interesting..

Karwa_Vivek 24-May-11 9:05am View

Deleted

is your problem Solved..or
Give out your mail Id
I will try to send you
a Project file So that you can understand it more clearly

Karwa_Vivek 24-May-11 7:06am View

not Clear
Can you please Elaborate your problem little more

Karwa_Vivek 24-May-11 2:44am View

have you Designed your Crystal report

which you need to Show inside the CRviewer

Karwa_Vivek 24-May-11 2:37am View

Deleted

Reason for my vote of 5
may be is old but
the quickest One..my 5

Karwa_Vivek 24-May-11 1:43am View

some times, what you See
is not actually there......

Karwa_Vivek 23-May-11 8:09am View

you Can try This .
By putting the database
anywhere Else also.It will not work until you give the user Full Control Specially in windows-7 and Vista.
you must have to give the full control on the drive where the Database resides.If not Satisfied with my Comment Search Google..you will get the Answer.
visit- http://www.tekscan.com/updateable-query
or http://www.mindplay.com/KnowledgeBase/ViewArticle.aspx?id=31

Karwa_Vivek 23-May-11 7:49am View

I disagree.
I personally had passed through this problem
and finally I have to work on Permissions
Here it is nothing to do with codes.

Karwa_Vivek 23-May-11 7:39am View

Please Use Code Blocks to Post your Codes

Karwa_Vivek 23-May-11 7:21am View

glad to help you

Karwa_Vivek 23-May-11 6:24am View

What you really want to do with this code

Just want to Set the width of column or
whole of the DataGridView

Karwa_Vivek 23-May-11 5:17am View

that's fine ..after viewing the Pic
i can assure you..this will definitely
solve your Problem

Karwa_Vivek 23-May-11 2:59am View

Can you State the Error Message
while Saving in Win-7

Karwa_Vivek 21-May-11 1:32am View

next time I will take Care of this..

Karwa_Vivek 20-May-11 8:03am View

For this There must Be
a Common data Field or Primary
key in table_1
which must be the foreign key For table_2
Am I Correct ?

Karwa_Vivek 20-May-11 7:52am View

is this is in Windows Form or
Web application?

Karwa_Vivek 20-May-11 7:41am View

need Some more Explanation

Karwa_Vivek 20-May-11 7:22am View

Can you Please Post your
Code Sample

Karwa_Vivek 20-May-11 7:13am View

Can You Elaborate
you Question Little
More

Karwa_Vivek 20-May-11 5:39am View

The Above Procedure
is for Windows Form application.
Implement It as Per your need

Karwa_Vivek 20-May-11 3:07am View

Got the Answer !

Karwa_Vivek 19-May-11 8:48am View

Deleted

You Got It Right Sir !
but as per your Kind info
No laddie here

Karwa_Vivek 19-May-11 8:46am View

Deleted

I think The Answer
must be to
Provide
Link not links
and the Expert Should
Avoid Spreading Those
Word "Just Google It"
What you Think

Karwa_Vivek 19-May-11 7:53am View

Deleted

If Everytime We Need To
Google only
Than
Why We are Here.
And Why You are Here

Karwa_Vivek 19-May-11 5:29am View

hi TONY
is your problem solved
by the solution what is provided by Mr S Mewara.

Karwa_Vivek 19-May-11 2:47am View

I will suggest You to do
this Programmaticaly
Means Try to use Substring method to match
the Typed Word and the Database items.Try this
If you Can't .Get back to me
I think I can Provide you the
Solution

Karwa_Vivek 19-May-11 1:18am View

Really ! Quite Interesting
and Challenging

Karwa_Vivek 19-May-11 0:50am View

hi skunkhead
Are You Using Win-Form Application for Your
Development.
Or you you want it to be done in your Database
Please Clarify.. me this .
I think if you are using Form Application
I can help you around
Thanks

Comments by Karwa_Vivek (Top 174 by date)